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

Maxscale tries to execute write statement on slave

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.11
    • Fix Version/s: 2.5.13
    • Component/s: qc_sqlite
    • Labels:
      None
    • Environment:
      Debian duster, backend 10.4.19, 10.5.10

      Description

      From the log:

      2021-06-01 16:13:51   warning: (4637894) [readwritesplit] (Read-Write-Service) Slave server 
      cannot execute this statement) differs from master's response (OK) to COM_QUERY: `SET STATEMENT max_statement_time = 60 FOR 
            INSERT INTO maillog5
            ( 
              to_email,
              c_d,
              sent,
              text,
              html,
              urgent,
              comment,
              subject,
              thread,
              from_name,
              from_domain,
              source,
              next_try ......
      

      Config: https://jira.mariadb.org/browse/MXS-3578?focusedCommentId=190701&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-190701

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              johan.wikman Johan Wikman
              Reporter:
              alexcool Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration