Hi,
I using Jira Server 8.0.2 on CentOS 6 and try to migrate to MySQL 5.5 (innodb).
Used links:
Mysql installed, configurated and started. dbconfig.xml was builded with bin/config.sh -c utility, db-connection tested OK. After all I restarted Jira and it created all tables, and I saw introduction to load dump or configure new instance on the web page. I tried to load correct! dump (test import on h2 before and it was OK) and caught error "Error importing data: java.lang.RuntimeException: Could not read fields for table AO_0AC321_RECOMMENDATION_AO".
LOG:
2019-03-29 15:44:58,132 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Running JIRA Data Import...
2019-03-29 15:44:58,358 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing XML data...
2019-03-29 15:44:58,586 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 1% complete...
2019-03-29 15:44:58,642 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 2% complete...
2019-03-29 15:44:58,693 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 3% complete...
2019-03-29 15:44:58,790 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 4% complete...
2019-03-29 15:44:58,884 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 5% complete...
2019-03-29 15:44:58,915 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 6% complete...
2019-03-29 15:44:58,949 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 7% complete...
2019-03-29 15:44:58,982 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 8% complete...
2019-03-29 15:44:59,024 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 9% complete...
2019-03-29 15:44:59,054 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 10% complete...
2019-03-29 15:44:59,073 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 11% complete...
2019-03-29 15:44:59,096 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 12% complete...
2019-03-29 15:44:59,126 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 13% complete...
2019-03-29 15:44:59,173 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 14% complete...
2019-03-29 15:44:59,236 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 15% complete...
2019-03-29 15:44:59,294 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 16% complete...
2019-03-29 15:44:59,360 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 17% complete...
2019-03-29 15:44:59,415 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 18% complete...
2019-03-29 15:44:59,461 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 19% complete...
2019-03-29 15:44:59,505 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 20% complete...
2019-03-29 15:44:59,546 JiraImportTaskExecutionThread-1 DEBUG anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning
2019-03-29 15:44:59,587 JiraImportTaskExecutionThread-1 DEBUG anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] stopCleaning
2019-03-29 15:44:59,587 JiraImportTaskExecutionThread-1 ERROR anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.RuntimeException: Could not read fields for table AO_0AC321_RECOMMENDATION_AO
java.lang.RuntimeException: Could not read fields for table AO_0AC321_RECOMMENDATION_AO
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97)
at com.google.common.collect.Iterators$6.transform(Iterators.java:785)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47)
at com.google.common.collect.Iterators.addAll(Iterators.java:358)
at com.google.common.collect.Lists.newArrayList(Lists.java:147)
at com.google.common.collect.Lists.newArrayList(Lists.java:133)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:58)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:990)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:725)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
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:176)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:148)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_0AC321_RECOMMENDATION_AO' in information_schema
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2950)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2991)
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:480)
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:480)
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:129)
... 30 more
2019-03-29 15:44:59,589 JiraImportTaskExecutionThread-1 WARN anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2019-03-29 15:44:59,613 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
2019-03-29 15:44:59,613 JiraImportTaskExecutionThread-1 INFO anonymous 944x15x1 6izs6w 127.0.0.1 /secure/SetupImport.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
Checked directly in mysql, table AO_0AC321_RECOMMENDATION_AO exists in jiradb.
Need help with dump loading!
Hi Yury,
Jira Server 8.0.2 can't supported the MySQL 5.5
https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html
Thanks,
Mehmet Şirin
Hi Mehmet,
I didn`t find this doc early, thank you!
I updated mysql to 5.7 and tried restore again. Same error.
Thanks for help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yury,
Which mysql connector version are you trying?
Thanks,
Mehmet Şirin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, it works now! Thank you.
Bad link JDBC Connector/J 5.1 (URL http://dev.mysql.com/downloads/connector/j) on this page https://confluence.atlassian.com/adminjiraserver070/connecting-jira-applications-to-mysql-749382640.html
Correct link here https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html
Thanks a lot, Mehmet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.