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

Borken consistency on Galera

    XMLWordPrintable

Details

    Description

      We have three nodes MariaDB-Galera-Cluster 10.0.30
      Today one of nodes (Node Number 2) disconnected from group.
      After reviewing error log, I saw an error happened:
      This was error:
      170418 18:11:48 [ERROR] WSREP: Local state seqno (3472060319) is greater than group seqno (3472057835): states diverged. Aborting to avoid potential data loss. Remove '/home/mysql//grastate.dat' file and restart if you wish to continue. (FATAL).
      So after review all three servers log, I think in the interval 18:06:58 to 18:11:50 The internet connection of node 2 have been disorder, and in the meantime (When it was Non-primary) several query could be executed and commited.
      I've attached my error logs to see.
      Node 1 IP : ..*.35
      Node 2 IP : ..*.60 (Impacted)
      Node 3 IP : ..*.206
      Sorry for my bad English.

      Attachments

        1. node1.log
          21 kB
        2. node2.log
          27 kB
        3. node3.log
          22 kB

        Activity

          People

            jplindst Jan Lindström (Inactive)
            HamoonDBA Hamoon Mohammadian Pour
            Votes:
            0 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.