| Bug #97455 | java.lang.ArrayIndexOutOfBoundsException ServerPreparedStatement.java:441 | ||
|---|---|---|---|
| Submitted: | 1 Nov 2019 9:41 | Modified: | 10 Dec 2019 11:53 |
| Reporter: | zhongxuchen chen | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 8.0.17 | OS: | Any |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[14 Nov 2019 7:20]
zhongxuchen chen
Does the problem have anything to do with character encoding in the database?
[14 Nov 2019 7:51]
MySQL Verification Team
Hi, I cannot reproduce this problem. Can you provide a test case to reproduce this problem?
[9 Dec 2019 8:09]
zhongxuchen chen
The reason for this problem has been！ example: select * from table where id=? Trigger condition: when add column for this table. This error will happen！
[10 Dec 2019 11:53]
MySQL Verification Team
Duplicate of #97924
Description: 参数: useServerPrepStmts=true;cachePrepStmts=true; sql is simply like: select t.* from OD_RESOURCE_BID_ORDER t where t.STATUS = '1' AND t.RESOURCE_ID IN (?) every few days mysql server throws exception: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 39 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:441) ~[mysql-connector-java-8.0.17.jar:8.0.17] at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql-connector-java-8.0.17.jar:8.0.17] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.7.0.jar:2.7.0] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.7.0.jar:2.7.0] How to repeat: Not necessarily！every few days mysql server throw this exception！ this bug mybe server preparedstatement cache logic bug！ Make people doubt the stability of MySQL database！ 不是必然出现，隔几天就有这样问题出现！过一阵子又正常了。