By type
2025-06-30 14:49:01+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.7.2+maria~ubu2404 started.
2025-06-30 14:49:02+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2025-06-30 14:49:02 0 [Warning] --temp-pool is deprecated and will be removed in a future release
2025-06-30 14:49:02 0 [Note] slave_connections_needed_for_purge changed to 0 because of Galera. Change it to 1 or higher if this Galera node is also Master in a normal replication setup
2025-06-30 14:49:02 0 [Note] Starting MariaDB 11.7.2-MariaDB-ubu2404 source revision 80067a69feaeb5df30abb1bfaf7d4e713ccbf027 server_uid x2aVGf7TWEeyI5xYb2LriBq/4HY= as process 1
2025-06-30 14:49:02 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2025-06-30 14:49:02 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2025-06-30 14:49:02 0 [Note] WSREP: wsrep_load(): Galera 26.4.21(rbf2cb1c3) by Codership Oy loaded successfully.
2025-06-30 14:49:02 0 [Note] WSREP: Initializing allowlist service v1
2025-06-30 14:49:02 0 [Note] WSREP: Initializing event service v1
2025-06-30 14:49:02 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1'
2025-06-30 14:49:02 0 [Note] WSREP: Symbol 'wsrep_certify_v1' not found from provider
2025-06-30 14:49:02 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2025-06-30 14:49:02 0 [Note] WSREP: not using SSL compression
2025-06-30 14:49:02 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2025-06-30 14:49:02 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2025-06-30 14:49:02 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 0
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 0
2025-06-30 14:49:02 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
2025-06-30 14:49:02 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.233.67.241; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr
2025-06-30 14:49:02 0 [Note] WSREP: Start replication
2025-06-30 14:49:02 0 [Note] WSREP: Connecting with bootstrap option: 1
2025-06-30 14:49:02 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2025-06-30 14:49:02 0 [Note] WSREP: protonet asio version 0
2025-06-30 14:49:02 0 [Note] WSREP: Using CRC-32C for message checksums.
2025-06-30 14:49:02 0 [Note] WSREP: backend: asio
2025-06-30 14:49:02 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2025-06-30 14:49:02 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2025-06-30 14:49:02 0 [Note] WSREP: restore pc from disk failed
2025-06-30 14:49:02 0 [Note] WSREP: GMCast version 0
2025-06-30 14:49:02 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2025-06-30 14:49:02 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2025-06-30 14:49:02 0 [Note] WSREP: EVS version 1
2025-06-30 14:49:02 0 [Note] WSREP: gcomm: bootstrapping new group 'mariadb-operator'
2025-06-30 14:49:02 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2025-06-30 14:49:02 0 [Note] WSREP: EVS version upgrade 0 -> 1
2025-06-30 14:49:02 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2025-06-30 14:49:02 0 [Note] WSREP: Node 5cbc9f3a-a1d9 state prim
2025-06-30 14:49:02 0 [Note] WSREP: view(view_id(PRIM,5cbc9f3a-a1d9,1) memb {
5cbc9f3a-a1d9,0
} joined {
} left {
} partitioned {
})
2025-06-30 14:49:02 0 [Note] WSREP: save pc into disk
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.233.65.53:4567
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr proto entry 0x7f6de0009590
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.233.67.241:4567
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr proto entry 0x7f6de0009aa0
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.233.72.220:4567
2025-06-30 14:49:02 0 [Note] WSREP: discarding pending addr proto entry 0x7f6de0008b60
2025-06-30 14:49:02 0 [Note] WSREP: gcomm: connected
2025-06-30 14:49:02 0 [Note] WSREP: Failed to establish connection: Operation aborted.
2025-06-30 14:49:02 0 [Note] WSREP: Failed to establish connection: Operation aborted.
2025-06-30 14:49:02 0 [Note] WSREP: Failed to establish connection: Operation aborted.
2025-06-30 14:49:02 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2025-06-30 14:49:02 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2025-06-30 14:49:02 0 [Note] WSREP: Opened channel 'mariadb-operator'
2025-06-30 14:49:02 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2025-06-30 14:49:02 0 [Note] WSREP: Initializing config service v1
2025-06-30 14:49:02 0 [Note] WSREP: Starting new group from scratch: 5cc08d85-55c1-11f0-b29f-dffb95a71a92
2025-06-30 14:49:02 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 5cc09092-55c1-11f0-ba47-068a0da8b4a1
2025-06-30 14:49:02 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 5cc09092-55c1-11f0-ba47-068a0da8b4a1
2025-06-30 14:49:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5cc09092-55c1-11f0-ba47-068a0da8b4a1 from 0 (mariadb-galera-0)
2025-06-30 14:49:02 0 [Note] WSREP: Deinitializing config service v1
2025-06-30 14:49:02 2 [Note] WSREP: Starting rollbacker thread 2
2025-06-30 14:49:02 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 5/11/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 5cc08d85-55c1-11f0-b29f-dffb95a71a92
2025-06-30 14:49:02 0 [Note] WSREP: Flow-control interval: [16, 16]
2025-06-30 14:49:02 0 [Note] WSREP: Restored state OPEN -> JOINED (1)
2025-06-30 14:49:02 1 [Note] WSREP: Starting applier thread 1
2025-06-30 14:49:02 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2025-06-30 14:49:02 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1)
2025-06-30 14:49:02 1 [Note] WSREP: ####### processing CC 1, local, ordered
2025-06-30 14:49:02 1 [Note] WSREP: Process first view: 5cc08d85-55c1-11f0-b29f-dffb95a71a92 my uuid: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c
2025-06-30 14:49:02 1 [Note] WSREP: Server mariadb-galera-0 connected to cluster at position 5cc08d85-55c1-11f0-b29f-dffb95a71a92:1 with ID 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c
2025-06-30 14:49:02 1 [Note] WSREP: Server status change disconnected -> connected
2025-06-30 14:49:02 1 [Note] WSREP: ####### My UUID: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c
2025-06-30 14:49:02 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: no
2025-06-30 14:49:02 0 [Note] WSREP: Service thread queue flushed.
2025-06-30 14:49:02 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2025-06-30 14:49:02 1 [Note] WSREP: REPL Protocols: 11 (6)
2025-06-30 14:49:02 1 [Note] WSREP: ####### Adjusting cert position: -1 -> 1
2025-06-30 14:49:02 0 [Note] WSREP: Service thread queue flushed.
2025-06-30 14:49:02 1 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 5cc08d85-55c1-11f0-b29f-dffb95a71a92:0
2025-06-30 14:49:02 1 [Note] WSREP: ================================================
View:
id: 5cc08d85-55c1-11f0-b29f-dffb95a71a92:1
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(1):
0: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c, mariadb-galera-0
=================================================
2025-06-30 14:49:02 1 [Note] WSREP: Server status change connected -> joiner
2025-06-30 14:49:02 1 [Note] WSREP: Server status change joiner -> initializing
2025-06-30 14:49:02 0 [Warning] --innodb-flush-method is deprecated and will be removed in a future release
2025-06-30 14:49:02 0 [Warning] --innodb-file-per-table is deprecated and will be removed in a future release
2025-06-30 14:49:02 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-06-30 14:49:02 0 [Note] InnoDB: Number of transaction pools: 1
2025-06-30 14:49:02 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-06-30 14:49:02 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 0
2025-06-30 14:49:02 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2025-06-30 14:49:02 0 [Note] InnoDB: Initializing buffer pool, total size = 2.000GiB, chunk size = 32.000MiB
2025-06-30 14:49:02 0 [Note] InnoDB: Completed initialization of buffer pool
2025-06-30 14:49:02 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-06-30 14:49:02 0 [Note] InnoDB: End of log at LSN=47629
2025-06-30 14:49:02 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-06-30 14:49:02 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-06-30 14:49:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-06-30 14:49:02 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-06-30 14:49:02 0 [Note] InnoDB: log sequence number 47629; transaction id 14
2025-06-30 14:49:02 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-06-30 14:49:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-06-30 14:49:02 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2025-06-30 14:49:02 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2025-06-30 14:49:02 0 [Note] InnoDB: Buffer pool(s) load completed at 250630 14:49:02
2025-06-30 14:49:02 0 [Note] Server socket created on IP: '0.0.0.0'.
2025-06-30 14:49:02 0 [Note] Server socket created on IP: '::'.
2025-06-30 14:49:02 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2025-06-30 14:49:02 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2025-06-30 14:49:03 0 [Note] WSREP: Server initialized
2025-06-30 14:49:03 0 [Note] WSREP: Server status change initializing -> initialized
2025-06-30 14:49:03 1 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
2025-06-30 14:49:03 5 [Note] WSREP: Cluster table is empty, not recovering transactions
2025-06-30 14:49:03 1 [Note] WSREP: Server status change initialized -> joined
2025-06-30 14:49:03 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:49:03 0 [Note] mariadbd: ready for connections.
Version: '11.7.2-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2025-06-30 14:49:03 1 [Note] WSREP: Lowest cert index boundary for CC from group: 1
2025-06-30 14:49:03 1 [Note] WSREP: Min available from gcache for CC from group: 1
2025-06-30 14:49:03 1 [Note] WSREP: Server mariadb-galera-0 synced with group
2025-06-30 14:49:03 1 [Note] WSREP: Server status change joined -> synced
2025-06-30 14:49:03 1 [Note] WSREP: Synchronized with group, ready for connections
2025-06-30 14:49:03 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:49:43 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') connection established to 72c4c17f-8657 tcp://10.233.65.53:4567
2025-06-30 14:49:44 0 [Note] WSREP: declaring 72c4c17f-8657 at tcp://10.233.65.53:4567 stable
2025-06-30 14:49:44 0 [Note] WSREP: Node 5cbc9f3a-a1d9 state prim
2025-06-30 14:49:44 0 [Note] WSREP: view(view_id(PRIM,5cbc9f3a-a1d9,2) memb {
5cbc9f3a-a1d9,0
72c4c17f-8657,0
} joined {
} left {
} partitioned {
})
2025-06-30 14:49:44 0 [Note] WSREP: save pc into disk
2025-06-30 14:49:44 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2025-06-30 14:49:44 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 75fc786f-55c1-11f0-b31f-fff6222363ee
2025-06-30 14:49:44 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 75fc786f-55c1-11f0-b31f-fff6222363ee
2025-06-30 14:49:44 0 [Note] WSREP: STATE EXCHANGE: got state msg: 75fc786f-55c1-11f0-b31f-fff6222363ee from 0 (mariadb-galera-0)
2025-06-30 14:49:44 0 [Note] WSREP: STATE EXCHANGE: got state msg: 75fc786f-55c1-11f0-b31f-fff6222363ee from 1 (mariadb-galera-1)
2025-06-30 14:49:44 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 1,
last_appl. = 0,
protocols = 5/11/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 5cc08d85-55c1-11f0-b29f-dffb95a71a92
2025-06-30 14:49:44 0 [Note] WSREP: Flow-control interval: [23, 23]
2025-06-30 14:49:44 1 [Note] WSREP: ####### processing CC 2, local, ordered
2025-06-30 14:49:44 1 [Note] WSREP: ####### My UUID: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c
2025-06-30 14:49:44 1 [Note] WSREP: Skipping cert index reset
2025-06-30 14:49:44 1 [Note] WSREP: REPL Protocols: 11 (6)
2025-06-30 14:49:44 1 [Note] WSREP: ####### Adjusting cert position: 1 -> 2
2025-06-30 14:49:44 0 [Note] WSREP: Service thread queue flushed.
2025-06-30 14:49:45 1 [Note] WSREP: ================================================
View:
id: 5cc08d85-55c1-11f0-b29f-dffb95a71a92:2
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(2):
0: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c, mariadb-galera-0
1: 72c4c17f-55c1-11f0-8657-d7eb3974d096, mariadb-galera-1
=================================================
2025-06-30 14:49:45 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:49:45 1 [Note] WSREP: Lowest cert index boundary for CC from group: 2
2025-06-30 14:49:45 1 [Note] WSREP: Min available from gcache for CC from group: 1
2025-06-30 14:49:45 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2025-06-30 14:49:45 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 2)
2025-06-30 14:49:45 1 [Note] WSREP: Detected STR version: 1, req_len: 128, req: STRv1
2025-06-30 14:49:45 1 [Note] WSREP: Cert index preload: 2 -> 2
2025-06-30 14:49:46 1 [Note] WSREP: Server status change synced -> donor
2025-06-30 14:49:46 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:49:46 0 [Note] WSREP: Donor monitor thread started to monitor
2025-06-30 14:49:46 0 [Note] WSREP: async IST sender starting to serve tcp://10.233.65.53:4568 sending 2-2, preload starts from 2
2025-06-30 14:49:46 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_mariabackup --role 'donor' --address '10.233.65.53:4444/xtrabackup_sst//1' --local-port 3306 --socket '/run/mysqld/mysqld.sock' --progress 0 --datadir '/var/lib/mysql/' --gtid '5cc08d85-55c1-11f0-b29f-dffb95a71a92:2' --gtid-domain-id 0)
2025-06-30 14:49:46 1 [Note] WSREP: sst_donor_thread signaled with 0
2025-06-30 14:49:46 0 [Note] WSREP: IST sender 2 -> 2
WSREP_SST: [INFO] mariabackup SST started on donor (20250630 14:49:46.094)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20250630 14:49:46.142)
WSREP_SST: [INFO] Progress reporting tool pv not found in path: /usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin (20250630 14:49:46.305)
WSREP_SST: [INFO] Disabling all progress/rate-limiting (20250630 14:49:46.308)
WSREP_SST: [INFO] Streaming with mbstream (20250630 14:49:46.323)
WSREP_SST: [INFO] Using socat as streamer (20250630 14:49:46.326)
WSREP_SST: [INFO] Using '/tmp/tmp.9Up8MDz4cz' as mariadb-backup temporary directory (20250630 14:49:46.352)
WSREP_SST: [INFO] Using '/tmp/tmp.xvXgVWYFr7' as mariadb-backup working directory (20250630 14:49:46.355)
WSREP_SST: [INFO] Estimating total transfer size (20250630 14:49:46.357)
WSREP_SST: [INFO] SST footprint estimate: data: 44613632, undo: 0 (20250630 14:49:46.362)
WSREP_SST: [INFO] To transfer: 44613632 (20250630 14:49:46.364)
WSREP_SST: [INFO] Streaming GTID file before SST (20250630 14:49:46.366)
WSREP_SST: [INFO] Evaluating '/usr//bin/mbstream' -c 'mariadb_backup_galera_info' 'donor_galera_info' | socat -u stdio TCP:10.233.65.53:4444; RC=( ${PIPESTATUS[@]} ) (20250630 14:49:46.368)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20250630 14:49:46.374)
2025-06-30 14:49:46 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') turning message relay requesting off
WSREP_SST: [INFO] Streaming the backup to joiner at 10.233.65.53:4444 (20250630 14:49:56.380)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --backup --no-version-check --databases-exclude='lost+found' --tmpdir='/tmp/tmp.9Up8MDz4cz' --innodb-data-home-dir='.' --user='root' --socket='/run/mysqld/mysqld.sock' --use-memory=2G --galera-info --stream=mbstream --target-dir='/tmp/tmp.xvXgVWYFr7' --datadir='/var/lib/mysql' 2> '/var/lib/mysql/mariabackup.backup.log' | socat -u stdio TCP:10.233.65.53:4444; RC=( ${PIPESTATUS[@]} ) (20250630 14:49:56.383)
2025-06-30 14:49:57 15 [Note] WSREP: Server not desynched from group at BLOCK_DDL because mariabackup is used.
2025-06-30 14:50:02 0 [Note] WSREP: SST sent: 5cc08d85-55c1-11f0-b29f-dffb95a71a92:2
2025-06-30 14:50:02 0 [Note] WSREP: Server status change donor -> joined
WSREP_SST: [INFO] Total time on donor: 0 seconds (20250630 14:50:02.720)
2025-06-30 14:50:02 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 1.0 (mariadb-galera-1) complete.
2025-06-30 14:50:02 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 2)
2025-06-30 14:50:02 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
WSREP_SST: [INFO] mariabackup SST completed on donor (20250630 14:50:02.725)
2025-06-30 14:50:02 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2025-06-30 14:50:02 0 [Note] WSREP: Processing event queue:... 100.0% (1/1 events) complete.
2025-06-30 14:50:02 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
2025-06-30 14:50:02 1 [Note] WSREP: Server mariadb-galera-0 synced with group
2025-06-30 14:50:02 1 [Note] WSREP: Server status change joined -> synced
2025-06-30 14:50:02 1 [Note] WSREP: Synchronized with group, ready for connections
2025-06-30 14:50:02 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] Cleaning up temporary directories (20250630 14:50:02.732)
2025-06-30 14:50:02 0 [Note] WSREP: Cleaning up SST user.
2025-06-30 14:50:02 0 [Note] WSREP: Donor monitor thread ended with total time 16 sec
2025-06-30 14:50:04 0 [Note] WSREP: async IST sender served
2025-06-30 14:50:04 0 [Note] WSREP: 1.0 (mariadb-galera-1): State transfer from 0.0 (mariadb-galera-0) complete.
2025-06-30 14:50:04 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) synced with group.
2025-06-30 14:50:30 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') connection established to 911c6d22-9845 tcp://10.233.72.220:4567
2025-06-30 14:50:31 0 [Note] WSREP: declaring 72c4c17f-8657 at tcp://10.233.65.53:4567 stable
2025-06-30 14:50:31 0 [Note] WSREP: declaring 911c6d22-9845 at tcp://10.233.72.220:4567 stable
2025-06-30 14:50:32 0 [Note] WSREP: Node 5cbc9f3a-a1d9 state prim
2025-06-30 14:50:32 0 [Note] WSREP: view(view_id(PRIM,5cbc9f3a-a1d9,3) memb {
5cbc9f3a-a1d9,0
72c4c17f-8657,0
911c6d22-9845,0
} joined {
} left {
} partitioned {
})
2025-06-30 14:50:32 0 [Note] WSREP: save pc into disk
2025-06-30 14:50:32 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2025-06-30 14:50:32 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 92ad76e1-55c1-11f0-9f3e-c358a74227e4
2025-06-30 14:50:32 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 92ad76e1-55c1-11f0-9f3e-c358a74227e4
2025-06-30 14:50:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: 92ad76e1-55c1-11f0-9f3e-c358a74227e4 from 1 (mariadb-galera-1)
2025-06-30 14:50:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: 92ad76e1-55c1-11f0-9f3e-c358a74227e4 from 0 (mariadb-galera-0)
2025-06-30 14:50:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 92ad76e1-55c1-11f0-9f3e-c358a74227e4 from 2 (mariadb-galera-2)
2025-06-30 14:50:33 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 2,
members = 2/3 (joined/total),
act_id = 2,
last_appl. = 0,
protocols = 5/11/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 5cc08d85-55c1-11f0-b29f-dffb95a71a92
2025-06-30 14:50:33 0 [Note] WSREP: Flow-control interval: [28, 28]
2025-06-30 14:50:33 1 [Note] WSREP: ####### processing CC 3, local, ordered
2025-06-30 14:50:33 1 [Note] WSREP: ####### My UUID: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c
2025-06-30 14:50:33 1 [Note] WSREP: Skipping cert index reset
2025-06-30 14:50:33 1 [Note] WSREP: REPL Protocols: 11 (6)
2025-06-30 14:50:33 1 [Note] WSREP: ####### Adjusting cert position: 2 -> 3
2025-06-30 14:50:33 0 [Note] WSREP: Service thread queue flushed.
2025-06-30 14:50:33 1 [Note] WSREP: ================================================
View:
id: 5cc08d85-55c1-11f0-b29f-dffb95a71a92:3
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(3):
0: 5cbc9f3a-55c1-11f0-a1d9-1f29bfbad07c, mariadb-galera-0
1: 72c4c17f-55c1-11f0-8657-d7eb3974d096, mariadb-galera-1
2: 911c6d22-55c1-11f0-9845-d29133e42047, mariadb-galera-2
=================================================
2025-06-30 14:50:33 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:50:33 1 [Note] WSREP: Lowest cert index boundary for CC from group: 3
2025-06-30 14:50:33 1 [Note] WSREP: Min available from gcache for CC from group: 1
2025-06-30 14:50:33 0 [Note] WSREP: (5cbc9f3a-a1d9, 'tcp://0.0.0.0:4567') turning message relay requesting off
2025-06-30 14:50:34 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2025-06-30 14:50:34 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 3)
2025-06-30 14:50:34 1 [Note] WSREP: Detected STR version: 1, req_len: 130, req: STRv1
2025-06-30 14:50:34 1 [Note] WSREP: Cert index preload: 3 -> 3
2025-06-30 14:50:34 1 [Note] WSREP: Server status change synced -> donor
2025-06-30 14:50:34 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-06-30 14:50:34 0 [Note] WSREP: async IST sender starting to serve tcp://10.233.72.220:4568 sending 3-3, preload starts from 3
2025-06-30 14:50:34 0 [Note] WSREP: Donor monitor thread started to monitor
2025-06-30 14:50:34 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_mariabackup --role 'donor' --address '10.233.72.220:4444/xtrabackup_sst//1' --local-port 3306 --socket '/run/mysqld/mysqld.sock' --progress 0 --datadir '/var/lib/mysql/' --gtid '5cc08d85-55c1-11f0-b29f-dffb95a71a92:3' --gtid-domain-id 0)
2025-06-30 14:50:34 1 [Note] WSREP: sst_donor_thread signaled with 0
2025-06-30 14:50:34 0 [Note] WSREP: IST sender 3 -> 3
WSREP_SST: [INFO] mariabackup SST started on donor (20250630 14:50:34.828)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20250630 14:50:34.878)
WSREP_SST: [INFO] Progress reporting tool pv not found in path: /usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin (20250630 14:50:35.031)
WSREP_SST: [INFO] Disabling all progress/rate-limiting (20250630 14:50:35.033)
WSREP_SST: [INFO] Streaming with mbstream (20250630 14:50:35.045)
WSREP_SST: [INFO] Using socat as streamer (20250630 14:50:35.047)
WSREP_SST: [INFO] Moving '/var/lib/mysql/mariabackup.backup.log' to '/tmp/sst_log_archive/mariabackup.backup.log.2025.06.30-14.50.35.050464101' (20250630 14:50:35.054)
WSREP_SST: [INFO] Using '/tmp/tmp.TUFlLbvjSE' as mariadb-backup temporary directory (20250630 14:50:35.081)
WSREP_SST: [INFO] Using '/tmp/tmp.kvMPWvg1Qn' as mariadb-backup working directory (20250630 14:50:35.083)
WSREP_SST: [INFO] Estimating total transfer size (20250630 14:50:35.085)
WSREP_SST: [INFO] SST footprint estimate: data: 44613632, undo: 0 (20250630 14:50:35.091)
WSREP_SST: [INFO] To transfer: 44613632 (20250630 14:50:35.093)
WSREP_SST: [INFO] Streaming GTID file before SST (20250630 14:50:35.095)
WSREP_SST: [INFO] Evaluating '/usr//bin/mbstream' -c 'mariadb_backup_galera_info' 'donor_galera_info' | socat -u stdio TCP:10.233.72.220:4444; RC=( ${PIPESTATUS[@]} ) (20250630 14:50:35.097)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20250630 14:50:35.104)
WSREP_SST: [INFO] Streaming the backup to joiner at 10.233.72.220:4444 (20250630 14:50:45.109)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --backup --no-version-check --databases-exclude='lost+found' --tmpdir='/tmp/tmp.TUFlLbvjSE' --innodb-data-home-dir='.' --user='root' --socket='/run/mysqld/mysqld.sock' --use-memory=2G --galera-info --stream=mbstream --target-dir='/tmp/tmp.kvMPWvg1Qn' --datadir='/var/lib/mysql' 2> '/var/lib/mysql/mariabackup.backup.log' | socat -u stdio TCP:10.233.72.220:4444; RC=( ${PIPESTATUS[@]} ) (20250630 14:50:45.116)
2025-06-30 14:50:46 28 [Note] WSREP: Server not desynched from group at BLOCK_DDL because mariabackup is used.
2025-06-30 14:50:52 0 [Note] WSREP: SST sent: 5cc08d85-55c1-11f0-b29f-dffb95a71a92:3
2025-06-30 14:50:52 0 [Note] WSREP: Server status change donor -> joined
2025-06-30 14:50:52 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 2.0 (mariadb-galera-2) complete.
2025-06-30 14:50:52 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 3)
2025-06-30 14:50:52 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
WSREP_SST: [INFO] Total time on donor: 0 seconds (20250630 14:50:52.290)
2025-06-30 14:50:52 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2025-06-30 14:50:52 0 [Note] WSREP: Processing event queue:... 100.0% (1/1 events) complete.
2025-06-30 14:50:52 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3)
2025-06-30 14:50:52 1 [Note] WSREP: Server mariadb-galera-0 synced with group
2025-06-30 14:50:52 1 [Note] WSREP: Server status change joined -> synced
2025-06-30 14:50:52 1 [Note] WSREP: Synchronized with group, ready for connections
2025-06-30 14:50:52 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] mariabackup SST completed on donor (20250630 14:50:52.293)
WSREP_SST: [INFO] Cleaning up temporary directories (20250630 14:50:52.301)
2025-06-30 14:50:52 0 [Note] WSREP: Cleaning up SST user.
2025-06-30 14:50:52 0 [Note] WSREP: Donor monitor thread ended with total time 18 sec
2025-06-30 14:50:56 0 [Note] WSREP: async IST sender served
2025-06-30 14:50:56 0 [Note] WSREP: 2.0 (mariadb-galera-2): State transfer from 0.0 (mariadb-galera-0) complete.
2025-06-30 14:50:56 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) synced with group.