Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1760

Adding use_sql_variables_in=master resulted in error "Client requests unknown prepared statement ID '0' that does not map to an internal ID"

    XMLWordPrintable

    Details

    • Sprint:
      MXS-SPRINT-56, MXS-SPRINT-57

      Description

      Customer is getting an below error after adding use_sql_variables_in=master

      2018-04-05 05:42:44 warning: (14) [readwritesplit] Client requests unknown prepared statement ID '0' that does not map to an internal ID
      2018-04-05 05:42:44 warning: (14) [readwritesplit] Using unknown prepared statement with ID 0
      2018-04-05 05:42:45 warning: (15) [readwritesplit] Client requests unknown prepared statement ID '0' that does not map to an internal ID (subsequent similar messages suppressed for 10000 milliseconds)
      2018-04-05 05:42:45 warning: (15) [readwritesplit] Using unknown prepared statement with ID 0 (subsequent similar messages suppressed for 10000 milliseconds)
      2018-04-05 05:49:43 error : (19) [readwritesplit] Unexpected internal state: received response 0x01 from server 'prod_mariadb01' when no response was expected
      2018-04-05 05:52:14 error : (19) [readwritesplit] Unexpected internal state: received response 0x01 from server 'prod_mariadb01' when no response was expected
      

      If they use_sql_variables_in=all then one of the output parameter variable p_out in one of their SP is returing null values.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: