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
          Hamoon Mohammadian Pour
        2. node2.log
          27 kB
          Hamoon Mohammadian Pour
        3. node3.log
          22 kB
          Hamoon Mohammadian Pour

        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.