解决方案：JDBC MySQL8.x 驱动报错 ArrayIndexOutOfBoundsException

问题现象

今天进行数据库的升级，从 MySQL 8.0.28 升级到 MySQL 8.0.34，结果启动时去连接数据库报错数组下标越界异常，而且数据库版本降回去之后又能正常启动…

使用 MySQL JDBC 8.0.26+ 驱动报错如下（我当前的驱动是 8.0.28）：

java.sql.SQLNonTransientConnectionException: Could not create connection to database server.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) 
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) 
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1002) 
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819) 
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:449) 
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:242) 
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) 
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1657)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) 
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838)
// 这里    
Caused by: java.lang.ArrayIndexOutOfBoundsException: 8
	at com.mysql.cj.protocol.a.NativePacketPayload.readInteger(NativePacketPayload.java:398) 
	at com.mysql.cj.protocol.a.NativeServerSessionStateController$NativeServerSessionStateChanges.init(NativeServerSessionStateController.java:103) 
	at com.mysql.cj.protocol.a.result.OkPacket.parse(OkPacket.java:66) 
	at com.mysql.cj.protocol.a.NativeProtocol.readServerStatusForResultSets(NativeProtocol.java:1691) 
	at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:83) 
	at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42) 
	at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1587) 
	at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:87) 
	at com.mysql.cj.protocol.a.TextResultsetReader.read(TextResultsetReader.java:48) 
	at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1600) 
	at com.mysql.cj.protocol.a.NativeProtocol.readAllResults(NativeProtocol.java:1654) 
	at com.mysql.cj.NativeSession.loadServerVariables(NativeSession.java:458) 
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1299) 
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:960) 

问题原因

根据 MySQL 文档，对于 MySQL JDBC 8.0.26+ 驱动，需要增加 JDBC url 参数 trackSessionState=true。

其实我也没搞懂为啥数组下标越界和这个问题有关系，依我看来 JDBC 驱动抛出个数组下标越界异常时很不合理的，完全可以转换成一种更友好的提示错误…

MySQL :: MySQL Connector/J Developer Guide :: 6.15 Client Session State Tracker

For Connection/J 8.0.26 and later:
Connector/J can receive information on client session state changes tracked by the server if the tracking has been enabled on the server.

The reception of the information is enabled by
setting the Connector/J connection property trackSessionState to true
(default value is false for the property).

解决方法

方法一: 使用 MySQL JDBC 8.0.25 版本的驱动。

方法二: 对于 MySQL JDBC 8.0.26+ 驱动，需要增加 JDBC url 参数 trackSessionState=true。