Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.11.9
    • N/A
    • mariabackup
    • Centos 9 Stream

    Description

      Hi,

      The mariabackup failed and this message appeared.

      FATAL ERROR: 2024-11-19 09:24:51 Was only able to copy log from 1986198832189 to 1986466251940, not 1986466252474; try increasing innodb_log_file_size

      My innodb_log_file_size=4G

      After this message, the node desynced itself from the group

      2024-11-19 9:24:45 27129026 [Note] WSREP: Desyncing and pausing the provider
      2024-11-19 9:24:45 0 [Note] WSREP: Member 5.0 (Node-1) desyncs itself from group
      2024-11-19 9:24:45 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 17682829)
      2024-11-19 9:24:45 27129026 [Note] WSREP: pause
      2024-11-19 9:24:45 27129026 [Note] WSREP: Provider paused at e424d1d9-a4ef-11ef-b5e1-76a93350b8e5:17682829 (18515772)
      2024-11-19 9:24:45 27129026 [Note] WSREP: Provider paused at: 17682829
      2024-11-19 9:24:45 27129026 [Note] WSREP: Server desynched from group during BACKUP STAGE BLOCK_DDL.
      2024-11-19 9:24:51 27129026 [Note] WSREP: Resuming and resyncing the provider
      2024-11-19 9:24:51 27129026 [Note] WSREP: resume
      2024-11-19 9:24:51 27129026 [Note] WSREP: resuming provider at 18515772
      2024-11-19 9:24:51 27129026 [Note] WSREP: Provider resumed.
      2024-11-19 9:24:51 0 [Note] WSREP: Member 5.0 (Node-1) resyncs itself to the group.
      2024-11-19 9:24:51 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 17682829)
      2024-11-19 9:24:51 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
      2024-11-19 9:24:51 0 [Note] WSREP: Member 5.0 (Node-1) synced with group.
      2024-11-19 9:24:51 0 [Note] WSREP: Processing event queue:... 100.0% (1/1 events) complete.
      2024-11-19 9:24:51 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 17682829)
      2024-11-19 9:24:51 58 [Note] WSREP: Server Node-1synced with group

      After restart it worked, but the db was desynced from the cluster every time.
      2024-11-19 10:22:55 27137310 [Note] WSREP: Desyncing and pausing the provider
      2024-11-19 10:22:55 0 [Note] WSREP: Member 5.0 (Node-1) desyncs itself from group
      2024-11-19 10:22:55 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 17684672)
      2024-11-19 10:22:55 27137310 [Note] WSREP: pause
      2024-11-19 10:22:55 27137310 [Note] WSREP: Provider paused at e424d1d9-a4ef-11ef-b5e1-76a93350b8e5:17684672 (18517647)
      2024-11-19 10:22:55 27137310 [Note] WSREP: Provider paused at: 17684672
      2024-11-19 10:22:55 27137310 [Note] WSREP: Server desynched from group during BACKUP STAGE BLOCK_DDL.
      2024-11-19 10:22:56 27137310 [Note] WSREP: Resuming and resyncing the provider
      2024-11-19 10:22:56 27137310 [Note] WSREP: resume
      2024-11-19 10:22:56 27137310 [Note] WSREP: resuming provider at 18517647
      2024-11-19 10:22:56 27137310 [Note] WSREP: Provider resumed.
      2024-11-19 10:22:56 0 [Note] WSREP: Member 5.0 (Node-1) resyncs itself to group.
      2024-11-19 10:22:56 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 17684672)
      2024-11-19 10:22:56 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
      2024-11-19 10:22:56 0 [Note] WSREP: Member 5.0 (Node-1) synced with group.
      2024-11-19 10:22:56 0 [Note] WSREP: Processing event queue:... 100.0% (1/1 events) complete.
      2024-11-19 10:22:56 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 17684672)
      2024-11-19 10:22:56 89 [Note] WSREP: Server Node-1 synced with group

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Needs Feedback
            16m 35s 1
            Julien Fritsch made transition -
            Needs Feedback Closed
            33d 23h 40m 1

            People

              marko Marko Mäkelä
              shexphobos Xesh
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.