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
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 ; 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.
- Shutdown Confluence
- Download the latest compatible version of MySQL driver recommended at our list of supported Database JDBC Drivers
- Remove the current MySQL driver from
- Unzip and copy the new driver to
- Start Confluence.