Community resources
Community resources
Community resources
Restore Fail due to introduce roadmap table AO_A415DF_AODOOR_STOP fail
[c.a.j.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Advanced Roadmaps for Jira(com.radiantminds.roadmaps-jira) #8.20.6 (table AO_A415DF_AODOOR_STOP): at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26) at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:429) at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.close(DataImporter.java:434) at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:120) at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:41) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:71) at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:64) at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:29) at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:64) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:44) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:70) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:151) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:574) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:749) 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(Unknown Source) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.sql.BatchUpdateException: Duplicate entry '1' for key 'ao_a415df_aodoor_stop.PRIMARY' at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) at com.mysql.cj.util.Util.getInstance(Util.java:174) at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435) at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:795) at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) at com.atlassian.jira.ofbiz.sql.StatementWrapper.executeBatch(StatementWrapper.java:154) at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeBatch$17(DiagnosticPreparedStatement.java:146) at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:70) at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55) at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeBatch(DiagnosticPreparedStatement.java:146) at com.atlassian.dbexporter.importer.DataImporter$BatchInserter.flush(DataImporter.java:422) ... 24 more Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'ao_a415df_aodoor_stop.PRIMARY' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832) 2022-03-26 10:16:20,990+0800 JiraImportTaskExecutionThread-1 WARN admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !! 2022-03-26 10:16:20,990+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.c.e.c.a.j.p.d.d.impl.CachingOrganizationDaoImpl.organizationsCache] Cache com.atlassian.jira.plugins.dvcs.dao.impl.CachingOrganizationDaoImpl.organizationsCache was flushed 2022-03-26 10:16:20,990+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.index.ha.DefaultServerIndexRepairService] Restarting DefaultServerIndexRepairService 2022-03-26 10:16:21,044+0800 JiraImportTaskExecutionThread-1 WARN admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.opensymphony.module.propertyset.PropertyImplementationException - Failed operation: SetOperation[entityName=admin.message.manager,entityId=1,propertyKey=user,newType=5,newMapper=TypeMapper[handler=StringPropertyHandler,valueEntity=OSPropertyString]]'. 2022-03-26 10:16:21,075+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.c.e.c.a.j.config.DefaultReindexMessageManager.propertiesReference] Cache com.atlassian.jira.config.DefaultReindexMessageManager.propertiesReference was flushed 2022-03-26 10:16:21,090+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.c.e.c.a.j.config.DefaultReindexMessageManager.propertiesReference] Cache com.atlassian.jira.config.DefaultReindexMessageManager.propertiesReference was flushed 2022-03-26 10:16:21,106+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 100% complete... 2022-03-26 10:16:21,106+0800 JiraImportTaskExecutionThread-1 INFO admin 611x2099x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished. 2022-03-26 10:16:25,499+0800 http-nio-8080-exec-12 ERROR admin 616x2102x1 18scxs0 0:0:0:0:0:0:0:1 /secure/admin/XmlRestore!finish.jspa [c.a.plugin.web.DefaultWebInterfaceManager] Could not evaluate condition 'com.projectbalm.riskregister.admin.AdminSectionCondition@4c6fc401' for descriptor: com.projectbalm.riskregister.riskregister-jira:projectbalm-addons (null) com.opensymphony.module.propertyset.PropertyImplementationException: Failed operation:
