'Unknown character set index' error thrown when upgrading
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
Upgrade fails with the following in atlassian-confluence.log:
1
2
3
4
5
6
7
8
9
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.
Solution
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/libfolderDelete the old .jar connector file
Was this helpful?