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

A node becomes inconsistent (WSREP_LOCAL_STATE = 5)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.4.14
    • N/A
    • Galera
    • None

    Description

      Sometimes (once a week), a node of our Galera Cluster ( 3 nodes) reaches an inconsistent state (WSREP_LOCAL_STATE = 5)

      The cluster continues to work on the 2 others nodes.

      In the log, I noticed these messages each time the problem occurs:

      2020-09-05  0:06:56 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
      2020-09-05  0:16:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
      2020-09-05  0:26:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
      2020-09-05  0:36:57 240929 [Warning] WSREP: TO isolation failed for: 1, schema: information_schema, sql: FLUSH STATUS. Check wsrep connection state and retry the query.
      .....
      

      Attachments

        Activity

          People

            ramesh Ramesh Sivaraman
            slevieux Levieux stéphane
            Votes:
            3 Vote for this issue
            Watchers:
            10 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.