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

mariabackup failed

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.9
    • None
    • 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

        Activity

          People

            marko Marko Mäkelä
            shexphobos Xesh
            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.