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

Closing slave connection due to inconsistent session state

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.15
    • Fix Version/s: 2.3.1
    • Component/s: readwritesplit
    • Labels:
      None

      Description

      Folks,

      Since older versions of Maxscale, we have been getting the below log entries:

      2018-10-04 07:00:38.382   warning: (452953) [readwritesplit] (discard_if_response_differs): 
      Slave server 'server-gal-a': response (0xff) differs from master's response (0x00) to 
      COM_QUERY: `SELECT DISTINCT ti.hdr_id,IF(ti.is_void AND void_bus_date<='2018-10-
      03',void_hdr_new_status_id,hdr_new_status_id) AS hdr_new_status_id, ti.hdr_new_sub_status_id As 
      hdr_new_sub_status_id INTO OUTFILE '/tmp/iecljfsjpe_6084_hdr.csv' FIELDS TERMINATED BY ',' 
      OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM trans_item AS ti INNER JOIN 
      _ti_ids_iecljfsjpe_6084 AS tmp ON ti.id=tmp.ti_id INNER JOIN trans_hdr AS th ON ti.hdr_id=th.id 
      HAVING hdr_new_status_id IN (1,4,5,18,19,20,21,27) `. Closing slave connection due to 
      inconsistent session state.
      

      All occurrences in the log file currently have only queries with SELECT INTO OUTFILE.

      Could you please have a look at that?

      Thanks!

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              wagnerbianchi Wagner Bianchi (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration