Details
-
Bug
-
Resolution: Fixed
-
Highest
-
None
-
None
-
None
Description
Issue Summary
Using an JNDI Connector in CMAC causes a read only SQL error.
Environment
- Confluence and latest CMAC
- JNDI Datasource Connector configured as per Configuring a datasource connection
Steps to Reproduce
- Set up and configure Confluence with a JNDI Database Connector
- Run CMAC with a Space Export
Expected Results
No errors
Actual Results
The below exception is thrown in the atlassian-confluence.log file:
2019-05-02 13:45:39,591 WARN [Caesium-1-1] [impl.schedule.caesium.SchedulerClusteredJobDaoProxyWrapper] delete Could not delete clustered job 'migration-plugin:dc44954a-ad3d-48e3-abe6-aacb66063cc6' -- cloudId: 290255e0-b297-4cf3-9943-cd7eee7568bb | planName: My Plan | stepType: USERS_MIGRATION | stepId: 72ea83ed-12fb-4b7b-bda8-4cc3a646d30c | planId: db966719-ecc8-4eda-a21b-e0b37bf732b2 | cloudUrl: https://myconfluencecloud.atlassian.net | taskName: Migrate users and groups | taskId: c9b18840-a4fa-488c-8b8b-a107c30fd6b7 org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [DELETE FROM scheduler_clustered_jobs where job_id = ?]; 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 ... Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
Workaround
Change to using a direct connection in confluence.cfg.xml. See