After migration to Jira 8 error on Table: cannot read field

Samuele Pretini_tmc4jy

After migration to Jira 8, I have obtained this error when click on Issue menu:

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.plugins.base-hipchat-integration-plugin-api]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:106) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:97) [?:?]
	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
Caused by: java.lang.RuntimeException: Could not read fields for table AO_5FB9D7_AOHIP_CHAT_LINK
	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) [guava-26.0-jre.jar:?]

 

And:

Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_5FB9D7_AOHIP_CHAT_LINK' in information_schema
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2950) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2938) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56) [mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2991) [mysql-connector-java-8.0.15.jar:8.0.15]
	at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:480) [commons-dbcp2-2.1.jar:2.1]
	at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:480) [commons-dbcp2-2.1.jar:2.1]
	at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:129) [?:?]

 I have followed the upgrade guide:

https://confluence.atlassian.com/adminjiraserver/upgrading-jira-server-manual-938846939.html

and I have linked Jira 8 to the DB that I have used for Jira 7.13.

 

Anyone know the cause?

 

Thanks

Andy Heinzer

The problem here is that you're using a database driver that is not supported for Jira yet.

mysql-connector-java-8.0.15.jar

Jira doesn't support MySQL 8 yet, nor can you use the jdbc v8 drivers to connect jira to mysql here.   However, from looking at our documentation, I can see that the page you cited https://confluence.atlassian.com/adminjiraserver/upgrading-jira-server-manual-938846939.html

Is currently incorrectly recommending the latest driver for Mysql.   Sorry about that.  I will work to correct that page right away.

 

To get past this problem, I would recommend following the steps in Connecting Jira applications to MySQL 5.7 closely if you want to use MySQL.

From that guide:

Download the recommended MySQL driver JDBC Connector/J 5.1. 

Using the latest 5.1.x version of that database driver is also information is also echoed in the Supported Platforms documentation.  I will update that other document right away.