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

Unexpected internal state with ReadWriteSplit and proxy_protocol=true

    XMLWordPrintable

    Details

    • Sprint:
      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

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: