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

Unexpected internal state with ReadWriteSplit and proxy_protocol=true

    XMLWordPrintable

Details

    • MXS-SPRINT-82, MXS-SPRINT-83, MXS-SPRINT-84

    Description

      A user started seeing periodic errors like the following in MaxScale 2.3.4:

      2019-04-26 07:30:00   error  : (7395) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-26 19:00:00   error  : (12174) Unexpected internal state: received response 0x2c from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-26 19:00:00   error  : (12174) Unexpected internal state: received response 0x03 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-29 01:07:46   error  : (33679) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      ...
      		 
      2019-04-29 13:00:00   error  : (38409) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: select * from ...
      		 
      2019-04-29 13:00:00   error  : (38409) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: select * from ...
      		 
      2019-04-29 18:08:08   error  : (40715) Unexpected internal state: received response 0x09 from server 'mariadb2' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-29 18:32:44   error  : (40212) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-29 18:32:44   error  : (40212) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>
      		 
      2019-04-29 18:32:44   error  : (40212) Unexpected internal state: received response 0x00 from server 'mariadb1' when no response was expected. Command: 0x03 Query: <not available>

      The user is using ReadWriteSplit with GaleraMon:

      [Galera-Monitor]
      		 
      type=monitor
      		 
      module=galeramon
      		 
      servers=mariadb1,mariadb2,mariadb3
      		 
      user=mariadb
      		 
      password=[redacted]
      		 
      available_when_donor=true
      		 
      monitor_interval=100
      		 
       
      		 
      [Galera-Service]
      		 
      type=service
      		 
      router=readwritesplit
      		 
      servers=mariadb1,mariadb2,mariadb3
      		 
      user=mariadb
      		 
      password=[redacted]
      		 
      master_accept_reads=true
      		 
      master_failure_mode=fail_on_write
      		 
      master_reconnection=true
      		 
      delayed_retry=true
      		 
      delayed_retry_timeout=1
      		 
      max_sescmd_history=200
      		 
      prune_sescmd_history=true
      		 
       
      		 
      [Galera-Listener]
      		 
      type=listener
      		 
      service=Galera-Service
      		 
      protocol=MariaDBClient
      		 
      port=3306

      And the servers have proxy_protocol=true set:

      [mariadb1]
      		 
      type=server
      		 
      address=mariadb1.domain.com
      		 
      port=3306
      		 
      protocol=MariaDBBackend
      		 
      proxy_protocol=true

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MXS-2563 Failing debug assertion at rwsplitsession.cc:1129 : m_expected_responses == 0

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-2464 Crash in route_stored_query with ReadWriteSplit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. 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"

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MXS-2066 Result buffering is not always disabled

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MXS-2072 [readwritesplit] Unexpected internal state

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MXS-2311 connection_keepalive and error : (4852) Unexpected internal state: received response 0x00 from server

          • Major - Major loss of function.
          • Closed

          Activity

            People

              markus makela markus makela
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 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.