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

Import Backup for Server from Cloud fails

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • 9.15.0, 9.15.1, 9.15.2, 9.16.0, 9.16.1, 9.17.0
    • Data Center - Database

      Issue Summary

      Importing the Backup for Server created in a Cloud instance fails.

      Expected Results

      Export is successfully imported.

      Actual Results

      System produces a page with *Jira had problems starting up.
      An error occurred performing JIRA upgrade task

      We get the following error in the atlassian-jira.log

      2024-07-18 12:29:29,203-0300 JiraImportTaskExecutionThread-1 ERROR      [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [host,buildNumber=76001] failed
      java.lang.RuntimeException: Error running original upgrade task
      	at com.atlassian.jira.upgrade.AbstractUpgradeTask.runUpgrade(AbstractUpgradeTask.java:63)
      	at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.runOneUpgradeTask(DefaultUpgradeTaskFactoryProcessor.java:109)
      	at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.lambda$performUpgradesUnsafe$13(DefaultUpgradeTaskFactoryProcessor.java:80)
      	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:176)
      	at java.base/java.util.stream.SortedOps$RefSortingSink.end(SortedOps.java:400)
      	at java.base/java.util.stream.Sink$ChainedReference.end(Sink.java:258)
      	at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:503)
      	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:488)
      	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
      	at java.base/java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:150)
      	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      	at java.base/java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:543)
      	at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.performUpgradesUnsafe(DefaultUpgradeTaskFactoryProcessor.java:81)
      	at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.performUpgrades(DefaultUpgradeTaskFactoryProcessor.java:46)
      	at com.atlassian.upgrade.core.DefaultUpgradeTaskManager.upgradeHostApp(DefaultUpgradeTaskManager.java:41)
      	at com.atlassian.jira.upgrade.LicenseCheckingUpgradeService.executeUpgrades(LicenseCheckingUpgradeService.java:134)
      	at com.atlassian.jira.upgrade.LicenseCheckingUpgradeService.runUpgrades(LicenseCheckingUpgradeService.java:97)
      	at com.atlassian.jira.upgrade.ClusterLockingUpgradeService.runUpgrades(ClusterLockingUpgradeService.java:35)
      	at com.atlassian.jira.upgrade.LoggingUpgradeService.lambda$runUpgradesWithLogging$0(LoggingUpgradeService.java:28)
      	at com.atlassian.jira.upgrade.LoggingUpgradeService.runWithTaskLogging(LoggingUpgradeService.java:43)
      	at com.atlassian.jira.upgrade.LoggingUpgradeService.runUpgradesWithLogging(LoggingUpgradeService.java:28)
      	at com.atlassian.jira.upgrade.DataImportUpgradeService.runUpgrades(DataImportUpgradeService.java:20)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:842)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:756)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:323)
      	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.unsafeCall(DataImportAsyncCommand.java:82)
      	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:64)
      	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:30)
      	at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:177)
      	at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:149)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
      	at java.base/java.lang.Thread.run(Thread.java:829)
      Caused by: com.querydsl.core.QueryException: Caught JdbcSQLIntegrityConstraintViolationException for insert into PUBLIC.propertyentry (entity_id, entity_name, property_key, propertytype, id)
      values (?, ?, ?, ?, ?)
      	at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
      	at com.querydsl.sql.Configuration.translate(Configuration.java:459)
      	at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:445)
      	at com.atlassian.jira.database.IdGeneratingSQLInsertClause.executeWithId(IdGeneratingSQLInsertClause.java:72)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build76001.setSchemeAsDefault(UpgradeTask_Build76001.java:184)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build76001.lambda$doUpgrade$0(UpgradeTask_Build76001.java:122)
      	at com.atlassian.jira.database.DefaultQueryDslAccessor.lambda$execute$1(DefaultQueryDslAccessor.java:70)
      	at com.atlassian.jira.database.DatabaseAccessorImpl.lambda$runInTransaction$0(DatabaseAccessorImpl.java:108)
      	at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:77)
      	at com.atlassian.jira.database.DatabaseAccessorImpl.runInTransaction(DatabaseAccessorImpl.java:103)
      	at com.atlassian.jira.database.DefaultQueryDslAccessor.execute(DefaultQueryDslAccessor.java:69)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build76001.doUpgrade(UpgradeTask_Build76001.java:83)
      	at com.atlassian.jira.upgrade.AbstractUpgradeTask.runUpgrade(AbstractUpgradeTask.java:61)
      	... 35 more
      Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.OSPROPERTY_ENTID_NAME_PROPKEY ON PUBLIC.PROPERTYENTRY(ENTITY_ID NULLS FIRST, ENTITY_NAME NULLS FIRST, PROPERTY_KEY NULLS FIRST) VALUES ( /* key:10421 */ CAST(1 AS BIGINT), 'jira.properties', 'jira.scheme.default.priority')"; SQL statement:
      insert into PUBLIC.propertyentry (entity_id, entity_name, property_key, propertytype, id)
      values (?, ?, ?, ?, ?) [23505-214]
      	at org.h2.message.DbException.getJdbcSQLException(DbException.java:508)
      	at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
      	at org.h2.message.DbException.get(DbException.java:223)
      	at org.h2.message.DbException.get(DbException.java:199)
      	at org.h2.index.Index.getDuplicateKeyException(Index.java:525)
      	at org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:223)
      	at org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:184)
      	at org.h2.mvstore.db.MVTable.addRow(MVTable.java:519)
      	at org.h2.command.dml.Insert.insertRows(Insert.java:174)
      	at org.h2.command.dml.Insert.update(Insert.java:135)
      	at org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74)
      	at org.h2.command.CommandContainer.update(CommandContainer.java:169)
      	at org.h2.command.Command.executeUpdate(Command.java:252)
      	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:209)
      	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:169)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
      	at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:47)
      	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeUpdate$7(DiagnosticPreparedStatement.java:69)
      	at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:91)
      	at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:62)
      	at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeUpdate(DiagnosticPreparedStatement.java:69)
      	at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:423)
      	... 45 more
      2024-07-18 12:29:29,204-0300 JiraImportTaskExecutionThread-1 WARN      [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Failed to complete upgrade task [factory=host,buildNumber=76001]
      2024-07-18 12:29:29,204-0300 JiraImportTaskExecutionThread-1 INFO      [c.a.j.upgrade.util.BuildNumberDao] Setting current build number to 75005
      2024-07-18 12:29:29,204-0300 JiraImportTaskExecutionThread-1 ERROR      [c.a.jira.upgrade.LicenseCheckingUpgradeService] There was an error running the upgrades
      

      Workaround

      Import the backup into any version before 9.15.0, such as the latest LTS 9.12.5.

              Unassigned Unassigned
              2bc7c297d2fe Artur Licks (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: