[CONJ-475] Unknown prepared statement handler (31) given to mysqld_stmt_execute Created: 2017-05-19  Updated: 2017-07-18  Resolved: 2017-07-18

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: 2.0.0-RC
Fix Version/s: 2.1.0, 1.6.3

Type: Bug Priority: Major
Reporter: charly Assignee: Diego Dupin
Resolution: Fixed Votes: 1
Labels: None
Environment:

payara as


Issue Links:
Duplicate
duplicates CONJ-505 Unknown prepared statement Closed
Relates
relates to CONJ-259 Prepare statement cache race condition Closed

 Description   

Some user of my application are experiencing the following exceptions:
Caused by: java.sql.SQLException: (conn:10672) Unknown prepared statement handler (31) given to mysqld_stmt_execute
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:179)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:229)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeInternal(MariaDbPreparedStatementServer.java:360)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.execute(MariaDbPreparedStatementServer.java:313)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeQuery(MariaDbPreparedStatementServer.java:292)
at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
... 145 more
Caused by: java.sql.SQLException: Unknown prepared statement handler (31) given to mysqld_stmt_execute
Query is: SELECT id, ANNEE, debut, fin, nom, PLAINE_ID FROM periode WHERE (((PLAINE_ID = ?) AND (fin > ?)) AND (debut < ?)) ORDER BY debut DESC, fin DESC, parameters [982353,'2017-07-10 00:00:00.0','2017-09-01 00:00:00.0']
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:143)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:695)
at org.mariadb.jdbc.MariaDbPreparedStatementServer.executeInternal(MariaDbPreparedStatementServer.java:350)
... 150 more


Generated at Thu Feb 08 03:15:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.