'Unknown character set index' error thrown when upgrading
Problem
Upgrade fails with the following in atlassian-confluence.log:
2015-01-03 11:30:21,469 INFO [localhost-startStop-1] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [BODYCONTENT]
2015-01-03 11:30:42,304 WARN [localhost-startStop-1] [confluence.upgrade.impl.DefaultUpgradeManager] beforeUpgrade Pre-upgrade recovery file generation failed: Unexpected exception encountered during query.
com.atlassian.confluence.upgrade.recovery.DbDumpException: Unexpected exception encountered during query.
....
Caused by: java.sql.SQLException: Unexpected exception encountered during query.
...
Caused by: java.lang.ArrayIndexOutOfBoundsException: 3284
...
2015-01-03 11:30:42,775 ERROR [localhost-startStop-1] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Unknown character set index for field '28788' received from server.Diagnosis
Check the MySQL JDBC driver version located here: <Confluence installation>/confluence/WEB-INF/lib.
Cause
The MySQL JDBC driver might be outdated.
Resolution
Upgrade the connector to the connector specified on Database JDBC Drivers.
- Go to http://dev.mysql.com/downloads/connector/j/ and download the connector specified on Database JDBC Drivers
- Extract the driver JAR file
Copy the driver JAR file to the
<Confluence installation>/confluence/WEB-INF/libDelete the old .jar connector file
Last modified on Apr 26, 2016
Powered by Confluence and Scroll Viewport.