Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9083

Slave IO thread does not handle autoreconnect to restarting Galera Cluster node

Details

    Description

      Hello,

      Considering the following architecture:

      • N-nodes MariaDB Galera Cluster
      • Standalone MariaDB server replicating from any above cluster node

      In the case where the master node is restarted, the slave stops with this error:
      1593 The slave I/O thread stops because a fatal error is encountered when it tried to SELECT @master_binlog_checksum. Error: WSREP has not yet prepared node for application use

      It has to be restarted manually (START SLAVE) in order to reconnect

      As Galera replication implies that, when a node is restarted, there is a short time when the node is available on port 3306, but the node cannot accept commands because it is processing an Incremental State Transfer request, I propose to have the slave thread autoreconnect instead of stopping when it encounters this particular error.

      Attachments

        Issue Links

          Activity

            A fix and a test for this issue are available in the following merge:

            https://github.com/codership/mysql-wsrep-bugs/commit/ec4a6fa61ca6be5424040048d0727ebadf271d00

            Note that the fix is (currently) wrapped in WITH_WSREP directives, so it will only take effect in binaries compiled with -DHAVE_WSREP=1

            philip-galera Philip Stoev (Inactive) added a comment - A fix and a test for this issue are available in the following merge: https://github.com/codership/mysql-wsrep-bugs/commit/ec4a6fa61ca6be5424040048d0727ebadf271d00 Note that the fix is (currently) wrapped in WITH_WSREP directives, so it will only take effect in binaries compiled with -DHAVE_WSREP=1

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              tanj Guillaume Lefranc
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.