'Unknown character set index' error thrown when upgrading
Upgrade fails with the following in
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.
Check the MySQL JDBC driver version located here:
The MySQL JDBC driver might be outdated.
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
Delete the old .jar connector file