Database connection issues due to "Queries leading to data modification are not allowed"

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

When performing action that depend on saving data into the database, the following appears in the atlassian-confluence.log:

2013-10-04 10:00:30,018 ERROR [DefaultQuartzScheduler_Worker-2] [org.quartz.core.JobRunShell] run Job DEFAULT.ClusterSafetyJob threw an unhandled Exception: 
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.confluence.cluster.safety.ClusterSafetyNumber#18907137]; uncategorized SQLException for SQL []; SQL state [S1009]; error code [0]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

原因

This is a known issue in versions of the MySql driver prior to 5.1.7. See MySQL Bugs: #38747: java.sql.SQLException: Connection is read-only for more details.

ソリューション

  1. Confluence をシャットダウンします。
  2. Download the latest compatible version of MySQL driver recommended at our list of supported Database JDBC Drivers
  3. Remove the current MySQL driver from <confluence-install>/confluence/WEB-INF/lib
  4. Unzip and copy the new driver to <confluence-install>/confluence/WEB-INF/lib
  5. Confluence を起動します。

最終更新日 2019 年 5 月 1 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.