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

Malformed packet SQL=LOAD DATA LOCAL INFILE... ERROR 2027

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.9
    • Fix Version/s: 2.5.11
    • Component/s: readwritesplit
    • Labels:
      None
    • Environment:
      UBUNTU 18.04.5 & RHEL 8.3, MariaDB 10.4.18

      Description

      LOAD DATA LOCAL INFILE causing error 2027 Malformed packet for one of ours php application.
      Application works without any problem directly connected to MariaDB master server.
      Maxscale log has warning entries about "unknown prepared statement" but we don`t use any prepared statements at all.

      I tryed disable use_sql_variables_in=master or route all queries directly to master using Hintfilter and Consistent Critical Read Filter but with same result. I also run in same issue with maxscale 2.4.17

      Log entries(at same time):
      warning: (1) (Splitter-Service) Client requests unknown prepared statement ID '1654551140' that does not map to an internal ID
      warning: (1) (Splitter-Service) Using unknown prepared statement with ID 0
      error : (1) (master) Write to Backend DCB 10.1.1.121 in state DCB::State::POLLING failed: 104, Connection reset by peer
      warning: (1) (Splitter-Service) Client requests unknown prepared statement ID '539915370' that does not map to an internal ID
      warning: (1) (Splitter-Service) Using unknown prepared statement with ID 0
      error : (1) [readwritesplit] (Splitter-Service) Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 0 seconds. Error caused by: #HY000: Lost connection to backend server: connection closed by peer (master). Last close reason: <none>. Last error: Got packets out of order

      conf:
      [maxscale]
      threads=8
      syslog=1
      maxlog=0
      log_notice=1
      load_persisted_configs=false
      local_address=10.1.1.23
      auth_connect_timeout=20s
      users_refresh_time=10s
      max_auth_errors_until_block=100
      admin_gui=0

      [master]
      type=server
      address=10.1.1.121
      port=3306
      protocol=MariaDBBackend

      [slave-1]
      type=server
      address=10.1.1.14
      port=3306
      protocol=MariaDBBackend

      [Monitor]
      type=monitor
      module=mariadbmon
      servers=master,slave-1
      user=xxx
      password=xxx
      monitor_interval=3s
      assume_unique_hostnames=OFF
      master_conditions=none
      slave_conditions=linked_master
      ignore_external_masters=ON

      [Splitter-Service]
      type=service
      router=readwritesplit
      servers=master,slave-1
      user=xxx
      password=xxx
      #session_track_trx_state=1
      max_slave_replication_lag=5s
      max_sescmd_history=500
      slave_connections=1
      master_accept_reads=true
      use_sql_variables_in=master
      causal_reads=local
      causal_reads_timeout=1s

      [ReadWrite-Listener]
      type=listener
      service=Splitter-Service
      protocol=MariaDBClient
      socket=/run/maxscale/maxscale.sock

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            lathander Jozef Kováč
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: