Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-17

Using a JNDI Connector causes java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

    XMLWordPrintable

    Details

      Description

      Issue Summary

      Using an JNDI Connector in CMAC causes a read only SQL error.

      Environment

      Steps to Reproduce

      1. Set up and configure Confluence with a JNDI Database Connector
      2. 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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jrichards@atlassian.com James Richards
              Reporter:
              jrichards@atlassian.com James Richards
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: