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

Re-linking a cloud site causes ConstraintViolationException

    XMLWordPrintable

    Details

    • Symptom Severity:
      Severity 2 - Major

      Description

      Issue Summary

      Re-linking a cloud site causes ConstraintViolationException

      Environment

      • Latest Cloud Migration Assistant for Confluence (CMAC)

      Steps to Reproduce

      1. Link cloud site https://aaa.atlassian.net in CMAC and perform a test migration
      2. After some time https://aaa.atlassian.net expires and is removed
      3. Provision a new cloud site with the same name https://aaa.atlassian.net (cloudId is changed at this stage; it is basically a new site but with the same hostname)
      4. Re-link https://aaa.atlassian.net in CMAC

      Expected Results

      Cloud site can be re-linked and migration can continue.

      Actual Results

      The below exception is thrown in the atlassian-confluence.log file:

      javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
          at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
      
      caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
          at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
      
      caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "mig_cloud_site_cloudurl_key" Detail: Key (cloudurl)=(https://aaa.atlassian.net) already exists.
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
      

      and

      2019-07-23 17:10:40,459 ERROR [http-nio-8090-exec-7] [engine.jdbc.spi.SqlExceptionHelper] doLog ERROR: duplicate key value violates unique constraint "mig_cloud_site_cloudurl_key"
        Detail: Key (cloudurl)=(https://aaa.atlassian.net) already exists.
       -- url: /confluence/admin/save-cloud-site.action | traceId: 645a7762af5960c7 | userName: admin | action: save-cloud-site
      2019-07-23 17:10:40,462 ERROR [http-nio-8090-exec-7] [org.hibernate.internal.ExceptionMapperStandardImpl] doLogf HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViol
      ationException: could not execute statement]
       -- url: /confluence/admin/save-cloud-site.action | traceId: 645a7762af5960c7 | userName: admin | action: save-cloud-site
      2019-07-23 17:10:40,467 WARN [http-nio-8090-exec-7] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
        ->[null]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #2077325595)
       -- url: /confluence/admin/save-cloud-site.action | traceId: 645a7762af5960c7 | userName: admin
      2019-07-23 17:10:40,468 ERROR [http-nio-8090-exec-7] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
       -- url: /confluence/admin/save-cloud-site.action | traceId: 645a7762af5960c7 | userName: admin
      javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
              at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
              at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
              at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:164)
              at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)
              at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)
              at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)
      

      Workaround

      Follow the steps in Restore the Cloud Migration Assistant for Confluence to the default version and reinstall latest CMAC.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: