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

Unknown prepared statement handler (31) given to mysqld_stmt_execute

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.0-RC
    • 2.1.0, 1.6.3
    • Other
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.