Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-475

Unknown prepared statement handler (31) given to mysqld_stmt_execute

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-RC
    • Fix Version/s: 2.1.0, 1.6.3
    • Component/s: Other
    • Labels:
      None
    • Environment:
      payara as

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                diego dupin Diego Dupin
                Reporter:
                cghislai charly
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: