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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.12
    • Fix Version/s: None
    • Component/s: Galera, Server
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            frelist William Wong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration