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.
ソリューション
- Confluence をシャットダウンします。
- Download the latest compatible version of MySQL driver recommended at our list of supported Database JDBC Drivers
- Remove the current MySQL driver from
<confluence-install>/confluence/WEB-INF/lib
- Unzip and copy the new driver to
<confluence-install>/confluence/WEB-INF/lib
- Confluence を起動します。
最終更新日 2019 年 5 月 1 日
Powered by Confluence and Scroll Viewport.