Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-45027

Studio Import fails with SQL error when importing large number of statuses

    XMLWordPrintable

Details

    • Severity 3 - Minor
    • Hide
      Atlassian Update – 3 November 2017

      Hi everyone,

      The issue has not get additional interest since the time it has been reported. Additionally it lacks important information as an affected version, etc.

      Therefore I'm resolving the issue as Timed out.

      Atlassian will continue to watch issue for the further updates, so please don't hesitate to share your feedback in the issue comments.

      Cheers,
      Ignat Alexeyenko
      Jira bugmaster.

      Show
      Atlassian Update – 3 November 2017 Hi everyone, The issue has not get additional interest since the time it has been reported. Additionally it lacks important information as an affected version, etc. Therefore I'm resolving the issue as Timed out . Atlassian will continue to watch issue for the further updates, so please don't hesitate to share your feedback in the issue comments. Cheers, Ignat Alexeyenko Jira bugmaster.

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      When trying to import the attached 6.4 backup with 5000 users which data created from multiple data generator runs, this error was encountered.

        [c.a.s.core.upgrade.PluginUpgrader] Upgraded plugin com.pyxis.greenhopper.jira to version 48 - Add reindex required message for Epic Label field searching
      @4000000055cc3e8d2cc59dd4 2015-08-13 16:51:47,751 localhost-startStop-1 INFO      [c.a.s.core.upgrade.PluginUpgrader] Plugin com.pyxis.greenhopper.jira upgrade completed. Current version is: 48
      @4000000055cc3e8d2d0ff8fc 2015-08-13 16:51:47,755 localhost-startStop-1 INFO      [c.a.s.core.upgrade.PluginUpgrader] Upgrading plugin com.atlassian.studio.theme.jira
      @4000000055cc3e8d2e881a0c 2015-08-13 16:51:47,775 localhost-startStop-1 ERROR      [c.a.s.core.upgrade.PluginUpgrader] Upgrade failed: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,557][name,Building][iconurl,/images/icons/bamboo.png][description,Source code has been committed, and JIRA is waiting for the code to be built before moving to the next status.][id,400] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
      @4000000055cc3e8d2e883d34 com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Status][sequence,557][name,Building][iconurl,/images/icons/bamboo.png][description,Source code has been committed, and JIRA is waiting for the code to be built before moving to the next status.][id,400] (SQL Exception while executing the following:INSERT INTO public.issuestatus (ID, SEQUENCE, pname, DESCRIPTION, ICONURL, STATUSCATEGORY) VALUES (?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_issuestatus"))
      @4000000055cc3e8d2e884cd4       at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:398)
      @4000000055cc3e8d2e8850bc       at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219)
      @4000000055cc3e8d2e8850bc       at com.atlassian.jira.entity.EntityUtils.createValue(EntityUtils.java:39)
      @4000000055cc3e8d2e8854a4       at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.createNewStatus(UpgradeTo_v45.java:69)
      @4000000055cc3e8d2e8854a4       at com.atlassian.studio.jira.upgrade.UpgradeTo_v45.doUpgrade(UpgradeTo_v45.java:47)
      @4000000055cc3e8d2e885c74       ... 3 filtered
      @4000000055cc3e8d2e885c74       at java.lang.reflect.Method.invoke(Method.java:497)
      @4000000055cc3e8d2e885c74       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      @4000000055cc3e8d2e88605c       at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
      @4000000055cc3e8d2e88605c       at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
      @4000000055cc3e8d2e8873e4       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      @4000000055cc3e8d2e887bb4       at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
      @4000000055cc3e8d2e887f9c       at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
      @4000000055cc3e8d2e888384       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      @4000000055cc3e8d2e88876c       at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
      @4000000055cc3e8d2e888b54       at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
      @4000000055cc3e8d2e888b54       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      @4000000055cc3e8d2e888f3c       at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
      @4000000055cc3e8d2e889324       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      @4000000055cc3e8d2e889af4       at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
      @4000000055cc3e8d2e889edc       at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
      @4000000055cc3e8d2e889edc       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      @4000000055cc3e8d2e88a6ac       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
      @4000000055cc3e8d2e88a6ac       at com.sun.proxy.$Proxy732.doUpgrade(Unknown Source)
      @4000000055cc3e8d2e88aa94       at com.atlassian.sal.core.upgrade.PluginUpgrader.doUpgrade(PluginUpgrader.java:85)
      @4000000055cc3e8d2e88aa94       at com.atlassian.sal.core.upgrade.PluginUpgrader.upgrade(PluginUpgrader.java:66)
      @4000000055cc3e8d2e88ae7c       at com.atlassian.sal.core.upgrade.DefaultPluginUpgradeManager$1.doInTransaction(DefaultPluginUpgradeManager.java:229)
      @4000000055cc3e8d2e88b264       at com.atlassian.sal.core.upgrade.DefaultPluginUpgradeManager$1.doInTransaction(DefaultPluginUpgradeManager.java:197)
      @4000000055cc3e8d2e88b264       at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)
      @4000000055cc3e8d2e88be1c       at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:38)
      @4000000055cc3e8d2e88be1c       ... 2 filtered
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              pobara Peter Obara
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: