Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-455

Unknown prepared statement handler given to mysqld_stmt_execute

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.20
    • None
    • N/A
    • None
    • WIndows Server 2019

    Description

      After updating ODBC connector to 3.1.20 following errors started to appear:

      [ma-3.1.20][11.4.5-MariaDB] Unknown prepared statement handler (4076929023) given to mysqld_stmt_execute

      It happens only for one database with quite heavy load...
      After downgrade to ODBC 3.1.11 problem disappeared.

      We do not use prepared statements at all, but I found in change logs that since ODBC version 3.1.18 it started to send:
      SET STATEMENT max_statement_time=3600 FOR SELECT ....
      (We access database through ADODB.Connection with set CommandTimeout)

      So I guess it could be related...

      Unfortunately I'm not able to reproduce it, as it seems to be related to some concurrent requests...
      Tested with MariaDB server 11.4.4 and 11.4.5...
      I may try versions 3.1.17 and 3.1.18 if the problem really came with this version...

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            marek.srom Marek Šrom
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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