Importing a backup from Jira Cloud into another Jira Cloud is failing due to a SQL exception

XMLWordPrintable

    • 26
    • Minor

      Issue Summary

      When importing a Jira Software cloud backup into another Jira Software cloud instance the import breaks with the following message on the UI:

      There was a problem configuring the database for import. Please contact Atlassian support. Caught PSQLException for select 1 from "public"."fieldlayoutitem" "FIELD_LAYOUT_ITEM" where "FIELD_LAYOUT_ITEM"."id" in (select "fieldlayoutitemA"."id" from "public"."fieldlayoutitem" "fieldlayoutitemA", "public"."fieldlayoutitem" "fieldlayoutitemB" where "fieldlayoutitemA"."id" < "fieldlayoutitemB"."id" and "fieldlayoutitemA"."fieldlayout" = "fieldlayoutitemB"."fieldlayout" and "fieldlayoutitemA"."fieldidentifier" = "fieldlayoutitemB"."fieldidentifier") FOR UPDATE OF "FIELD_LAYOUT_ITEM"
      

      Steps to Reproduce

      1. Create a backup from a Jira Software cloud instance with a few projects on it
      2. Start an import on another Jira Software Cloud instance

      Expected Results

      The import would go on with success

      Actual Results

      The import will be hung at 90% for several minutes until finally fails with the following error at the logs:

           msg: Import task failed: [There was a problem configuring the database for import. Please contact Atlassian support. Caught PSQLException for select 1
      from "public"."fieldlayoutitem" "FIELD_LAYOUT_ITEM"
      where "FIELD_LAYOUT_ITEM"."id" in (select "fieldlayoutitemA"."id"
      from "public"."fieldlayoutitem" "fieldlayoutitemA", "public"."fieldlayoutitem" "fieldlayoutitemB"
      where "fieldlayoutitemA"."id" < "fieldlayoutitemB"."id" and "fieldlayoutitemA"."fieldlayout" = "fieldlayoutitemB"."fieldlayout" and "fieldlayoutitemA"."fieldidentifier" = "fieldlayoutitemB"."fieldidentifier")
      FOR UPDATE OF "FIELD_LAYOUT_ITEM"]
           stack: cloud.atlassian.provisioning.exception.PermanentProvisioningFailureException: Import task failed: [There was a problem configuring the database for import. Please contact Atlassian support. Caught PSQLException for select 1
      from "public"."fieldlayoutitem" "FIELD_LAYOUT_ITEM"
      where "FIELD_LAYOUT_ITEM"."id" in (select "fieldlayoutitemA"."id"
      from "public"."fieldlayoutitem" "fieldlayoutitemA", "public"."fieldlayoutitem" "fieldlayoutitemB"
      where "fieldlayoutitemA"."id" < "fieldlayoutitemB"."id" and "fieldlayoutitemA"."fieldlayout" = "fieldlayoutitemB"."fieldlayout" and "fieldlayoutitemA"."fieldidentifier" = "fieldlayoutitemB"."fieldidentifier")
      FOR UPDATE OF "FIELD_LAYOUT_ITEM"]
      	at com.atlassian.jira.internal.rest.CloudBackupManager.startImport(CloudBackupManager.java:110)
      	at com.atlassian.jira.internal.rest.ImportResource.lambda$importArchive$1(ImportResource.java:79)
      	at com.atlassian.jira.internal.rest.AbstractCloudProvisionerResource.lambda$withTenantedWorkContext$0(AbstractCloudProvisionerResource.java:107)
      	at com.atlassian.jira.internal.filter.InternalResource.withWorkContext(InternalResource.java:105)
      	at com.atlassian.jira.internal.rest.AbstractCloudProvisionerResource.withTenantedWorkContext(AbstractCloudProvisionerResource.java:94)
      	at com.atlassian.jira.internal.rest.ImportResource.importArchive(ImportResource.java:78)
      	at com.atlassian.jira.internal.rest.ImportResource.lambda$post$0(ImportResource.java:71)
      	at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner$AsyncCloudProvisionerHelper.wrapTask(AsyncCloudTaskRunner.java:164)
      	at com.atlassian.jira.internal.rest.AsyncCloudTaskRunner$AsyncCloudProvisionerHelper.lambda$runAsync$0(AsyncCloudTaskRunner.java:142)
      	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
      	at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1596)
      	at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
      	at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
      	at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
      	at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
      
         }
         ext: { [+]
         }
         hostname: 3a9f837e4007
         level: ERROR
         logger: com.atlassian.jira.internal.rest.AsyncCloudTaskRunner.privacy-safe
         m: { [+]
         }
         message: Non recoverable error occurred during cloudImport.
      

      Workaround

      Currently, there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Vinod Rao
            Reporter:
            Charles Meireles
            Votes:
            4 Vote for this issue
            Watchers:
            21 Start watching this issue

              Created:
              Updated:
              Resolved: