Can't migrate to Mysql 5.5

[bykov-yury]

Hi,

I using Jira Server 8.0.2 on CentOS 6 and try to migrate to MySQL 5.5 (innodb).

Used links:

• https://confluence.atlassian.com/jirakb/jira-how-to-migrate-from-hsql-database-to-an-external-database-295308246.html
• https://confluence.atlassian.com/adminjiraserver070/supported-platforms-749382629.html
• https://confluence.atlassian.com/adminjiraserver070/connecting-jira-applications-to-mysql-749382640.html

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!

[Mehmet Şirin Usanmaz · Accepted solution]

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

[bykov-yury]

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

[Mehmet Şirin Usanmaz]

Hi Yury,

Which mysql connector version are you trying?

• Supported MySQL databases use the MySQL Connector/J 5.1 driver.

Thanks,

Mehmet Şirin

[bykov-yury]

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