Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-67644

JIRA import fails due to clusteredjob ID already exists

    XMLWordPrintable

Details

    Description

      Summary

      JIRA import fails if the backup file contains a clusteredjob with ID 10000 with below error:

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ClusteredJob][cronExpression,0 0 4/12 * * ?][jobId,com.atlassian.jira.service.JiraService:10001][jobRunnerKey,com.atlassian.jira.service.DefaultServiceManager][id,10000][schedType,C][version,297][parameters,[B@5258e5b][nextRun,1506693600000] (SQL Exception while executing the following:INSERT INTO public.clusteredjob (ID, JOB_ID, JOB_RUNNER_KEY, SCHED_TYPE, INTERVAL_MILLIS, FIRST_RUN, CRON_EXPRESSION, TIME_ZONE, NEXT_RUN, VERSION, PARAMETERS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_clusteredjob" Detail: Key (id)=(10000) already exists.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:219) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:177) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:89) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:584) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:114) at com.atlassian.jira.bc.dataimport.OfbizImportHandler.createWithRetry(OfbizImportHandler.java:692) at com.atlassian.jira.bc.dataimport.OfbizImportHandler.lambda$createValue$6(OfbizImportHandler.java:663) at 

      Steps to reproduce

      Import a JIRA backup

      Actual result

      JIRA import fails with below error on the UI:

      Error importing data: {0}

      Expected result

      JIRA import completes with no error

      Notes: It occurs on both backups generated from JIRA Server and Cloud.

      Attachments

        Issue Links

          Activity

            People

              edalgliesh Eric Dalgliesh
              nhassan Nur Asnida Hassan (Inactive)
              Votes:
              9 Vote for this issue
              Watchers:
              43 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: