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

Maxscale tries to execute write statement on slave

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.5.11
    • 2.5.13
    • qc_sqlite
    • None
    • 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

              johan.wikman Johan Wikman
              alexcool Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.