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