-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
None
-
Affects Version/s: None
-
Component/s: Jira - Site Import - From Server
-
None
-
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
- Create a backup from a Jira Software cloud instance with a few projects on it
- 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