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

    • 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

        1. maxscale.cnf
          0.7 kB
          Pramod Mahto
        2. MaxScale Valgrind.txt
          11 kB
          Assen Totin

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-2461 Unexpected internal state with ReadWriteSplit and proxy_protocol=true

          • Major - Major loss of function.
          • Closed

          Activity

            People

              markus makela markus makela
              pramod.mahto@mariadb.com Pramod Mahto
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.