By type
2024-12-17 09:22:35+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.2.2+maria~ubu2204 started.
2024-12-17 09:22:35+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2024-12-17 9:22:35 0 [Note] Starting MariaDB 11.2.2-MariaDB-1:11.2.2+maria~ubu2204 source revision 929532a9426d085111c24c63de9c23cc54382259 as process 1
2024-12-17 9:22:35 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2024-12-17 9:22:35 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2024-12-17 9:22:35 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy loaded successfully.
2024-12-17 9:22:35 0 [Note] WSREP: Initializing allowlist service v1
2024-12-17 9:22:35 0 [Note] WSREP: Initializing event service v1
2024-12-17 9:22:35 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2024-12-17 9:22:35 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2024-12-17 9:22:35 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2024-12-17 9:22:35 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 0
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 0
2024-12-17 9:22:35 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
2024-12-17 9:22:35 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.233.71.107; 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
2024-12-17 9:22:35 0 [Note] WSREP: Start replication
2024-12-17 9:22:35 0 [Note] WSREP: Connecting with bootstrap option: 1
2024-12-17 9:22:35 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2024-12-17 9:22:35 0 [Note] WSREP: protonet asio version 0
2024-12-17 9:22:35 0 [Note] WSREP: Using CRC-32C for message checksums.
2024-12-17 9:22:35 0 [Note] WSREP: backend: asio
2024-12-17 9:22:35 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2024-12-17 9:22:35 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2024-12-17 9:22:35 0 [Note] WSREP: restore pc from disk failed
2024-12-17 9:22:35 0 [Note] WSREP: GMCast version 0
2024-12-17 9:22:35 0 [Warning] WSREP: Failed to resolve tcp://mariadb-galera-1.mariadb-galera-internal.onap.svc.cluster.local:4567
2024-12-17 9:22:35 0 [Warning] WSREP: Failed to resolve tcp://mariadb-galera-2.mariadb-galera-internal.onap.svc.cluster.local:4567
2024-12-17 9:22:35 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2024-12-17 9:22:35 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2024-12-17 9:22:35 0 [Note] WSREP: EVS version 1
2024-12-17 9:22:35 0 [Note] WSREP: gcomm: bootstrapping new group 'mariadb-operator'
2024-12-17 9:22:35 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2024-12-17 9:22:35 0 [Note] WSREP: EVS version upgrade 0 -> 1
2024-12-17 9:22:35 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2024-12-17 9:22:35 0 [Note] WSREP: Node 73ceebfc-a574 state prim
2024-12-17 9:22:35 0 [Note] WSREP: view(view_id(PRIM,73ceebfc-a574,1) memb {
73ceebfc-a574,0
} joined {
} left {
} partitioned {
})
2024-12-17 9:22:35 0 [Note] WSREP: save pc into disk
2024-12-17 9:22:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.233.71.107:4567
2024-12-17 9:22:35 0 [Note] WSREP: discarding pending addr proto entry 0x56193ac0ebe0
2024-12-17 9:22:35 0 [Note] WSREP: gcomm: connected
2024-12-17 9:22:35 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2024-12-17 9:22:35 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2024-12-17 9:22:35 0 [Note] WSREP: Opened channel 'mariadb-operator'
2024-12-17 9:22:35 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2024-12-17 9:22:35 0 [Note] WSREP: Starting new group from scratch: 73d4bcca-bc58-11ef-8921-caa164531c10
2024-12-17 9:22:35 0 [Note] WSREP: Initializing config service v1
2024-12-17 9:22:35 1 [Note] WSREP: Starting rollbacker thread 1
2024-12-17 9:22:35 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 73d4c219-bc58-11ef-be10-535f3bed5242
2024-12-17 9:22:35 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 73d4c219-bc58-11ef-be10-535f3bed5242
2024-12-17 9:22:35 0 [Note] WSREP: STATE EXCHANGE: got state msg: 73d4c219-bc58-11ef-be10-535f3bed5242 from 0 (mariadb-galera-0)
2024-12-17 9:22:35 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 73d4bcca-bc58-11ef-8921-caa164531c10
2024-12-17 9:22:35 2 [Note] WSREP: Starting applier thread 2
2024-12-17 9:22:35 0 [Note] WSREP: Flow-control interval: [16, 16]
2024-12-17 9:22:35 0 [Note] WSREP: Restored state OPEN -> JOINED (1)
2024-12-17 9:22:35 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2024-12-17 9:22:35 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1)
2024-12-17 9:22:35 2 [Note] WSREP: ####### processing CC 1, local, ordered
2024-12-17 9:22:35 2 [Note] WSREP: Process first view: 73d4bcca-bc58-11ef-8921-caa164531c10 my uuid: 73ceebfc-bc58-11ef-a574-d2a601613b74
2024-12-17 9:22:35 0 [Note] WSREP: Deinitializing config service v1
2024-12-17 9:22:35 2 [Note] WSREP: Server mariadb-galera-0 connected to cluster at position 73d4bcca-bc58-11ef-8921-caa164531c10:1 with ID 73ceebfc-bc58-11ef-a574-d2a601613b74
2024-12-17 9:22:35 2 [Note] WSREP: Server status change disconnected -> connected
2024-12-17 9:22:35 2 [Note] WSREP: ####### My UUID: 73ceebfc-bc58-11ef-a574-d2a601613b74
2024-12-17 9:22:35 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no
2024-12-17 9:22:35 0 [Note] WSREP: Service thread queue flushed.
2024-12-17 9:22:35 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2024-12-17 9:22:35 2 [Note] WSREP: REPL Protocols: 10 (5)
2024-12-17 9:22:35 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 1
2024-12-17 9:22:35 0 [Note] WSREP: Service thread queue flushed.
2024-12-17 9:22:35 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 73d4bcca-bc58-11ef-8921-caa164531c10:0
2024-12-17 9:22:35 2 [Note] WSREP: ================================================
View:
id: 73d4bcca-bc58-11ef-8921-caa164531c10: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: 73ceebfc-bc58-11ef-a574-d2a601613b74, mariadb-galera-0
=================================================
2024-12-17 9:22:35 2 [Note] WSREP: Server status change connected -> joiner
2024-12-17 9:22:35 2 [Note] WSREP: Server status change joiner -> initializing
2024-12-17 9:22:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-12-17 9:22:35 0 [Note] InnoDB: Number of transaction pools: 1
2024-12-17 9:22:35 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-12-17 9:22:35 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
2024-12-17 9:22:35 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-12-17 9:22:35 0 [Note] InnoDB: Initializing buffer pool, total size = 2.000GiB, chunk size = 32.000MiB
2024-12-17 9:22:35 0 [Note] InnoDB: Completed initialization of buffer pool
2024-12-17 9:22:35 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-12-17 9:22:36 0 [Note] InnoDB: End of log at LSN=47763
2024-12-17 9:22:36 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-12-17 9:22:36 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-12-17 9:22:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-12-17 9:22:36 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-12-17 9:22:36 0 [Note] InnoDB: log sequence number 47763; transaction id 14
2024-12-17 9:22:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-12-17 9:22:36 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-12-17 9:22:36 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-12-17 9:22:36 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-12-17 9:22:36 0 [Note] InnoDB: Buffer pool(s) load completed at 241217 9:22:36
2024-12-17 9:22:36 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-12-17 9:22:36 0 [Note] Server socket created on IP: '::'.
2024-12-17 9:22:36 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-12-17 9:22:36 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2024-12-17 9:22:36 0 [Note] WSREP: Server initialized
2024-12-17 9:22:36 0 [Note] WSREP: Server status change initializing -> initialized
2024-12-17 9:22:36 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
2024-12-17 9:22:36 5 [Note] WSREP: Cluster table is empty, not recovering transactions
2024-12-17 9:22:36 2 [Note] WSREP: Server status change initialized -> joined
2024-12-17 9:22:36 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:22:36 0 [Note] mariadbd: ready for connections.
Version: '11.2.2-MariaDB-1:11.2.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-12-17 9:22:36 2 [Note] WSREP: Lowest cert index boundary for CC from group: 1
2024-12-17 9:22:36 2 [Note] WSREP: Min available from gcache for CC from group: 1
2024-12-17 9:22:36 2 [Note] WSREP: Server mariadb-galera-0 synced with group
2024-12-17 9:22:36 2 [Note] WSREP: Server status change joined -> synced
2024-12-17 9:22:36 2 [Note] WSREP: Synchronized with group, ready for connections
2024-12-17 9:22:36 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:23:18 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') connection established to 8c46a245-83dd tcp://10.233.68.223:4567
2024-12-17 9:23:18 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2024-12-17 9:23:18 0 [Note] WSREP: declaring 8c46a245-83dd at tcp://10.233.68.223:4567 stable
2024-12-17 9:23:18 0 [Note] WSREP: Node 73ceebfc-a574 state prim
2024-12-17 9:23:18 0 [Note] WSREP: view(view_id(PRIM,73ceebfc-a574,2) memb {
73ceebfc-a574,0
8c46a245-83dd,0
} joined {
} left {
} partitioned {
})
2024-12-17 9:23:18 0 [Note] WSREP: save pc into disk
2024-12-17 9:23:18 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2024-12-17 9:23:18 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 8d51f1fa-bc58-11ef-9b37-773bc852b734
2024-12-17 9:23:18 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 8d51f1fa-bc58-11ef-9b37-773bc852b734
2024-12-17 9:23:18 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8d51f1fa-bc58-11ef-9b37-773bc852b734 from 0 (mariadb-galera-0)
2024-12-17 9:23:19 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8d51f1fa-bc58-11ef-9b37-773bc852b734 from 1 (mariadb-galera-1)
2024-12-17 9:23:19 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 1,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 73d4bcca-bc58-11ef-8921-caa164531c10
2024-12-17 9:23:19 0 [Note] WSREP: Flow-control interval: [23, 23]
2024-12-17 9:23:19 2 [Note] WSREP: ####### processing CC 2, local, ordered
2024-12-17 9:23:19 2 [Note] WSREP: ####### My UUID: 73ceebfc-bc58-11ef-a574-d2a601613b74
2024-12-17 9:23:19 2 [Note] WSREP: Skipping cert index reset
2024-12-17 9:23:19 2 [Note] WSREP: REPL Protocols: 10 (5)
2024-12-17 9:23:19 2 [Note] WSREP: ####### Adjusting cert position: 1 -> 2
2024-12-17 9:23:19 0 [Note] WSREP: Service thread queue flushed.
2024-12-17 9:23:19 2 [Note] WSREP: ================================================
View:
id: 73d4bcca-bc58-11ef-8921-caa164531c10: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: 73ceebfc-bc58-11ef-a574-d2a601613b74, mariadb-galera-0
1: 8c46a245-bc58-11ef-83dd-4e8515e831f8, mariadb-galera-1
=================================================
2024-12-17 9:23:19 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:23:19 2 [Note] WSREP: Lowest cert index boundary for CC from group: 2
2024-12-17 9:23:19 2 [Note] WSREP: Min available from gcache for CC from group: 1
2024-12-17 9:23:20 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2024-12-17 9:23:20 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 2)
2024-12-17 9:23:20 2 [Note] WSREP: Detected STR version: 1, req_len: 130, req: STRv1
2024-12-17 9:23:20 2 [Note] WSREP: Cert index preload: 2 -> 2
2024-12-17 9:23:20 2 [Note] WSREP: Server status change synced -> donor
2024-12-17 9:23:20 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:23:20 0 [Note] WSREP: async IST sender starting to serve tcp://10.233.68.223:4568 sending 2-2, preload starts from 2
2024-12-17 9:23:20 0 [Note] WSREP: Donor monitor thread started to monitor
2024-12-17 9:23:20 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '10.233.68.223:4444/xtrabackup_sst//1' --local-port 3306 --socket '/run/mysqld/mysqld.sock' --progress 0 --datadir '/var/lib/mysql/' --gtid '73d4bcca-bc58-11ef-8921-caa164531c10:2' --gtid-domain-id 0'
2024-12-17 9:23:20 0 [Note] WSREP: IST sender 2 -> 2
2024-12-17 9:23:20 2 [Note] WSREP: sst_donor_thread signaled with 0
WSREP_SST: [INFO] mariabackup SST started on donor (20241217 09:23:20.423)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20241217 09:23:20.483)
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/sbin:/usr/bin:/sbin:/bin (20241217 09:23:20.676)
WSREP_SST: [INFO] Disabling all progress/rate-limiting (20241217 09:23:20.681)
WSREP_SST: [INFO] Streaming with mbstream (20241217 09:23:20.711)
WSREP_SST: [INFO] Using socat as streamer (20241217 09:23:20.716)
WSREP_SST: [INFO] Using '/tmp/tmp.bPiso5ZMT9' as mariadb-backup temporary directory (20241217 09:23:20.744)
WSREP_SST: [INFO] Using '/tmp/tmp.J6sBtfJIHh' as mariadb-abackup working directory (20241217 09:23:20.752)
WSREP_SST: [INFO] Estimating total transfer size (20241217 09:23:20.755)
WSREP_SST: [INFO] SST footprint estimate: data: 44613632, undo: 0 (20241217 09:23:20.765)
WSREP_SST: [INFO] To transfer: 44613632 (20241217 09:23:20.770)
WSREP_SST: [INFO] Streaming GTID file before SST (20241217 09:23:20.774)
WSREP_SST: [INFO] Evaluating '/usr//bin/mbstream' -c 'mariadb_backup_galera_info' | socat -u stdio TCP:10.233.68.223:4444; RC=( ${PIPESTATUS[@]} ) (20241217 09:23:20.779)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20241217 09:23:20.791)
2024-12-17 9:23:21 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') turning message relay requesting off
WSREP_SST: [INFO] Streaming the backup to joiner at 10.233.68.223:4444 (20241217 09:23:30.798)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --backup --no-version-check --databases-exclude='lost+found' --tmpdir='/tmp/tmp.bPiso5ZMT9' --innodb-data-home-dir='.' --user='root' --socket='/run/mysqld/mysqld.sock' --galera-info --stream=mbstream --target-dir='/tmp/tmp.J6sBtfJIHh' --datadir='/var/lib/mysql' 2> '/var/lib/mysql/mariabackup.backup.log' | socat -u stdio TCP:10.233.68.223:4444; RC=( ${PIPESTATUS[@]} ) (20241217 09:23:30.805)
2024-12-17 9:23:31 16 [Note] WSREP: Desyncing and pausing the provider
2024-12-17 9:23:31 16 [Note] WSREP: pause
2024-12-17 9:23:31 16 [Note] WSREP: Provider paused at 73d4bcca-bc58-11ef-8921-caa164531c10:2 (6)
2024-12-17 9:23:31 16 [Note] WSREP: Provider paused at: 2
2024-12-17 9:23:32 16 [Note] WSREP: Resuming and resyncing the provider
2024-12-17 9:23:32 16 [Note] WSREP: resume
2024-12-17 9:23:32 16 [Note] WSREP: resuming provider at 6
2024-12-17 9:23:32 16 [Note] WSREP: Provider resumed.
2024-12-17 9:23:32 0 [Note] WSREP: SST sent: 73d4bcca-bc58-11ef-8921-caa164531c10:2
2024-12-17 9:23:32 0 [Note] WSREP: Server status change donor -> joined
2024-12-17 9:23:32 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 1.0 (mariadb-galera-1) complete.
2024-12-17 9:23:32 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 2)
2024-12-17 9:23:32 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2024-12-17 9:23:32 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2024-12-17 9:23:32 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2024-12-17 9:23:32 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
2024-12-17 9:23:32 2 [Note] WSREP: Server mariadb-galera-0 synced with group
2024-12-17 9:23:32 2 [Note] WSREP: Server status change joined -> synced
2024-12-17 9:23:32 2 [Note] WSREP: Synchronized with group, ready for connections
2024-12-17 9:23:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] Total time on donor: 0 seconds (20241217 09:23:32.148)
WSREP_SST: [INFO] mariabackup SST completed on donor (20241217 09:23:32.153)
WSREP_SST: [INFO] Cleaning up temporary directories (20241217 09:23:32.158)
2024-12-17 9:23:32 0 [Note] WSREP: Donor monitor thread ended with total time 12 sec
2024-12-17 9:23:33 0 [Note] WSREP: async IST sender served
2024-12-17 9:23:33 0 [Note] WSREP: 1.0 (mariadb-galera-1): State transfer from 0.0 (mariadb-galera-0) complete.
2024-12-17 9:23:33 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) synced with group.
2024-12-17 9:23:53 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') connection established to a1ce0b08-9c20 tcp://10.233.64.148:4567
2024-12-17 9:23:53 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2024-12-17 9:23:54 0 [Note] WSREP: declaring 8c46a245-83dd at tcp://10.233.68.223:4567 stable
2024-12-17 9:23:54 0 [Note] WSREP: declaring a1ce0b08-9c20 at tcp://10.233.64.148:4567 stable
2024-12-17 9:23:55 0 [Note] WSREP: Node 73ceebfc-a574 state prim
2024-12-17 9:23:55 0 [Note] WSREP: view(view_id(PRIM,73ceebfc-a574,3) memb {
73ceebfc-a574,0
8c46a245-83dd,0
a1ce0b08-9c20,0
} joined {
} left {
} partitioned {
})
2024-12-17 9:23:55 0 [Note] WSREP: save pc into disk
2024-12-17 9:23:55 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2024-12-17 9:23:55 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a32862e7-bc58-11ef-847f-a7e5578e19d5
2024-12-17 9:23:55 0 [Note] WSREP: STATE EXCHANGE: sent state msg: a32862e7-bc58-11ef-847f-a7e5578e19d5
2024-12-17 9:23:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: a32862e7-bc58-11ef-847f-a7e5578e19d5 from 0 (mariadb-galera-0)
2024-12-17 9:23:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: a32862e7-bc58-11ef-847f-a7e5578e19d5 from 1 (mariadb-galera-1)
2024-12-17 9:23:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: a32862e7-bc58-11ef-847f-a7e5578e19d5 from 2 (mariadb-galera-2)
2024-12-17 9:23:55 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 2,
members = 2/3 (joined/total),
act_id = 2,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 73d4bcca-bc58-11ef-8921-caa164531c10
2024-12-17 9:23:55 0 [Note] WSREP: Flow-control interval: [28, 28]
2024-12-17 9:23:55 2 [Note] WSREP: ####### processing CC 3, local, ordered
2024-12-17 9:23:55 2 [Note] WSREP: ####### My UUID: 73ceebfc-bc58-11ef-a574-d2a601613b74
2024-12-17 9:23:55 2 [Note] WSREP: Skipping cert index reset
2024-12-17 9:23:55 2 [Note] WSREP: REPL Protocols: 10 (5)
2024-12-17 9:23:55 2 [Note] WSREP: ####### Adjusting cert position: 2 -> 3
2024-12-17 9:23:55 0 [Note] WSREP: Service thread queue flushed.
2024-12-17 9:23:55 2 [Note] WSREP: ================================================
View:
id: 73d4bcca-bc58-11ef-8921-caa164531c10: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: 73ceebfc-bc58-11ef-a574-d2a601613b74, mariadb-galera-0
1: 8c46a245-bc58-11ef-83dd-4e8515e831f8, mariadb-galera-1
2: a1ce0b08-bc58-11ef-9c20-872ec57106fc, mariadb-galera-2
=================================================
2024-12-17 9:23:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:23:55 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3
2024-12-17 9:23:55 2 [Note] WSREP: Min available from gcache for CC from group: 1
2024-12-17 9:23:56 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2024-12-17 9:23:56 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 3)
2024-12-17 9:23:56 2 [Note] WSREP: Detected STR version: 1, req_len: 130, req: STRv1
2024-12-17 9:23:56 2 [Note] WSREP: Cert index preload: 3 -> 3
2024-12-17 9:23:56 2 [Note] WSREP: Server status change synced -> donor
2024-12-17 9:23:56 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2024-12-17 9:23:56 0 [Note] WSREP: async IST sender starting to serve tcp://10.233.64.148:4568 sending 3-3, preload starts from 3
2024-12-17 9:23:56 0 [Note] WSREP: Donor monitor thread started to monitor
2024-12-17 9:23:56 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '10.233.64.148:4444/xtrabackup_sst//1' --local-port 3306 --socket '/run/mysqld/mysqld.sock' --progress 0 --datadir '/var/lib/mysql/' --gtid '73d4bcca-bc58-11ef-8921-caa164531c10:3' --gtid-domain-id 0'
2024-12-17 9:23:56 0 [Note] WSREP: IST sender 3 -> 3
2024-12-17 9:23:56 2 [Note] WSREP: sst_donor_thread signaled with 0
WSREP_SST: [INFO] mariabackup SST started on donor (20241217 09:23:56.709)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20241217 09:23:56.781)
2024-12-17 9:23:56 0 [Note] WSREP: (73ceebfc-a574, 'tcp://0.0.0.0:4567') turning message relay requesting off
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/sbin:/usr/bin:/sbin:/bin (20241217 09:23:56.950)
WSREP_SST: [INFO] Disabling all progress/rate-limiting (20241217 09:23:56.955)
WSREP_SST: [INFO] Moving '/var/lib/mysql/mariabackup.backup.log' to '/tmp/sst_log_archive/mariabackup.backup.log.2024.12.17-09.23.56.975175860' (20241217 09:23:56.980)
WSREP_SST: [INFO] Streaming with mbstream (20241217 09:23:56.991)
WSREP_SST: [INFO] Using socat as streamer (20241217 09:23:56.995)
WSREP_SST: [INFO] Using '/tmp/tmp.VGFV2jxSc0' as mariadb-backup temporary directory (20241217 09:23:57.023)
WSREP_SST: [INFO] Using '/tmp/tmp.18IN79fl62' as mariadb-abackup working directory (20241217 09:23:57.029)
WSREP_SST: [INFO] Estimating total transfer size (20241217 09:23:57.033)
WSREP_SST: [INFO] SST footprint estimate: data: 44613632, undo: 0 (20241217 09:23:57.045)
WSREP_SST: [INFO] To transfer: 44613632 (20241217 09:23:57.049)
WSREP_SST: [INFO] Streaming GTID file before SST (20241217 09:23:57.053)
WSREP_SST: [INFO] Evaluating '/usr//bin/mbstream' -c 'mariadb_backup_galera_info' | socat -u stdio TCP:10.233.64.148:4444; RC=( ${PIPESTATUS[@]} ) (20241217 09:23:57.057)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20241217 09:23:57.067)
WSREP_SST: [INFO] Streaming the backup to joiner at 10.233.64.148:4444 (20241217 09:24:07.074)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --backup --no-version-check --databases-exclude='lost+found' --tmpdir='/tmp/tmp.VGFV2jxSc0' --innodb-data-home-dir='.' --user='root' --socket='/run/mysqld/mysqld.sock' --galera-info --stream=mbstream --target-dir='/tmp/tmp.18IN79fl62' --datadir='/var/lib/mysql' 2> '/var/lib/mysql/mariabackup.backup.log' | socat -u stdio TCP:10.233.64.148:4444; RC=( ${PIPESTATUS[@]} ) (20241217 09:24:07.077)
2024-12-17 9:24:08 23 [Note] WSREP: Desyncing and pausing the provider
2024-12-17 9:24:08 23 [Note] WSREP: pause
2024-12-17 9:24:08 23 [Note] WSREP: Provider paused at 73d4bcca-bc58-11ef-8921-caa164531c10:3 (12)
2024-12-17 9:24:08 23 [Note] WSREP: Provider paused at: 3
2024-12-17 9:24:08 23 [Note] WSREP: Resuming and resyncing the provider
2024-12-17 9:24:08 23 [Note] WSREP: resume
2024-12-17 9:24:08 23 [Note] WSREP: resuming provider at 12
2024-12-17 9:24:08 23 [Note] WSREP: Provider resumed.
2024-12-17 9:24:08 0 [Note] WSREP: SST sent: 73d4bcca-bc58-11ef-8921-caa164531c10:3
2024-12-17 9:24:08 0 [Note] WSREP: Server status change donor -> joined
2024-12-17 9:24:08 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 2.0 (mariadb-galera-2) complete.
2024-12-17 9:24:08 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 3)
2024-12-17 9:24:08 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2024-12-17 9:24:08 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2024-12-17 9:24:08 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2024-12-17 9:24:08 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3)
2024-12-17 9:24:08 2 [Note] WSREP: Server mariadb-galera-0 synced with group
2024-12-17 9:24:08 2 [Note] WSREP: Server status change joined -> synced
2024-12-17 9:24:08 2 [Note] WSREP: Synchronized with group, ready for connections
2024-12-17 9:24:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] Total time on donor: 0 seconds (20241217 09:24:08.621)
WSREP_SST: [INFO] mariabackup SST completed on donor (20241217 09:24:08.627)
WSREP_SST: [INFO] Cleaning up temporary directories (20241217 09:24:08.633)
2024-12-17 9:24:08 0 [Note] WSREP: Donor monitor thread ended with total time 12 sec
2024-12-17 9:24:09 0 [Note] WSREP: async IST sender served
2024-12-17 9:24:09 0 [Note] WSREP: 2.0 (mariadb-galera-2): State transfer from 0.0 (mariadb-galera-0) complete.
2024-12-17 9:24:09 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) synced with group.