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

unexpected Galera desync when running backup stage block_commit at MariaDB 10.5.12

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5.12
    • None
    • Galera, Server
    • None
    • redhat 7

    Description

      Hi,

      We just upgrade our DB cluster to MariaDB 10.5.12. Found below unexpected Galera desync when using "backup stage block_commit" command. We leverage storage technology for backup. Backup stage commands are used to ensure data consistency in snapshot.

      Rejoin cluster when running "backup stage end".

      mysql> backup stage start ;

      <<no message in error log which is normal>>

      mysql> backup stage block_commit ;

      2021-09-30 11:59:16 7 [Note] WSREP: Desyncing and pausing the provider
      2021-09-30 11:59:16 0 [Note] WSREP: Member 0.0 (node1) desyncs itself from group
      2021-09-30 11:59:16 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 51)
      2021-09-30 11:59:16 7 [Note] WSREP: pause
      2021-09-30 11:59:16 7 [Note] WSREP: Provider paused at b738a6ce-081b-11ec-86f1-ba40f7f51758:51 (8)
      2021-09-30 11:59:16 7 [Note] WSREP: Provider paused at: 51

      mysql> backup stage end ;

      2021-09-30 11:59:16 7 [Note] WSREP: Resuming and resyncing the provider
      2021-09-30 11:59:16 7 [Note] WSREP: resume
      2021-09-30 11:59:16 7 [Note] WSREP: resuming provider at 8
      2021-09-30 11:59:16 7 [Note] WSREP: Provider resumed.
      2021-09-30 11:59:16 0 [Note] WSREP: Member 0.0 (node1) resyncs itself to group.
      2021-09-30 11:59:16 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 51)
      2021-09-30 11:59:16 0 [Note] WSREP: Member 0.0 (node1) synced with group.
      2021-09-30 11:59:16 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 51)
      2021-09-30 11:59:16 2 [Note] WSREP: Server node1 synced with group

      Attachments

        Activity

          People

            Unassigned Unassigned
            frelist William Wong
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.