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

Galera Node missing binlog entries from other nodes dispite log_slave_updates=ON

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.21
    • 10.4
    • Galera
    • None
    • CentOS Linux release 7.7.1908 (Core)

    Description

      I am using one node of a 3-node-Clusters as Master for a slave. On all node log_slave_updates is set to ON. Still we occasionaly encounter missing records when processing updates from the binary logs on the slave. Analyzing the binary logs on the cluster nodes I found that most of the changes applied on other nodes are reflected on the node serving as master but some are not. And it is unpredectable when this happens.

      This problem is a real blocker because the result is that the replication breaks whenever such a problem occurs and the binary logs are not usable for point in time recovery.

      Attachments

        1. log-node1.log
          22 kB
        2. log-node2.log
          1 kB
        3. log-node3.log
          13 kB

        Activity

          People

            seppo Seppo Jaakola
            umoser Ulrich Moser (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.