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

Semi-sync replication through MaxScale causes errors on STOP SLAVE

    XMLWordPrintable

Details

    • MXS-SPRINT-192

    Description

      Executing a STOP SLAVE on a replicating server which uses semi-sync causes an error to be logged on the server.

      server4  | 2023-10-05  7:37:32 34 [Note] Error reading relay log event: slave SQL thread was killed
      server4  | 2023-10-05  7:37:32 34 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.000002' at position 684; GTID position '0-3000-11', master: 127.0.0.1:4006
      server4  | 2023-10-05  7:37:32 33 [Note] Slave I/O thread exiting, read up to log 'binlog.000002', position 684; GTID position 0-3000-11, master 127.0.0.1:4006
      server1  | 2023-10-05  7:37:32 13 [ERROR] Read semi-sync reply magic number error
      

      This happens because the COM_QUIT packet sent by MaxScale is unconditionally sent when the connections are terminating and the replication protocol does not normally send it.

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              markus makela markus makela
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.