2025-01-22 14:16:21 0 [Note] WSREP: 2.166 (e2.p1.mariadb.mydomain.lan): State transfer to 0.166 (e1.p1.mariadb.mydomain.lan) complete.
2025-01-22 14:16:21 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 221918733)
2025-01-22 14:16:21 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2025-01-22 14:16:21 0 [Note] WSREP: Donor monitor thread ended with total time 41 sec
2025-01-22 14:16:21 0 [Note] WSREP: Member 2.166 (e2.p1.mariadb.mydomain.lan) synced with group.
2025-01-22 14:16:21 0 [Note] WSREP: Processing event queue:... 100.0% (2/2 events) complete.
2025-01-22 14:16:21 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 221918734)
2025-01-22 14:16:21 2 [Note] WSREP: Server e2.p1.mariadb.mydomain.lan synced with group
2025-01-22 14:16:21 2 [Note] WSREP: Server status change joined -> synced
2025-01-22 14:16:21 2 [Note] WSREP: Synchronized with group, ready for connections
2025-01-22 14:16:21 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-01-22 14:16:29 0 [Note] WSREP: async IST sender served
2025-01-22 14:16:29 0 [Note] WSREP: 0.166 (e1.p1.mariadb.mydomain.lan): State transfer from 2.166 (e2.p1.mariadb.mydomain.lan) complete.
2025-01-22 14:16:30 0 [Note] WSREP: Member 0.166 (e1.p1.mariadb.mydomain.lan) synced with group.
2025-01-22 14:20:17 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2025-01-22 14:20:17 0 [Note] WSREP: Shutdown replication
2025-01-22 14:20:17 0 [Note] WSREP: Server status change synced -> disconnecting
2025-01-22 14:20:17 0 [Note] WSREP: Closing send monitor...
2025-01-22 14:20:17 0 [Note] WSREP: Closed send monitor.
2025-01-22 14:20:17 0 [Note] WSREP: gcomm: terminating thread
2025-01-22 14:20:17 0 [Note] WSREP: gcomm: joining thread
2025-01-22 14:20:17 0 [Note] WSREP: gcomm: closing backend
2025-01-22 14:20:18 0 [Note] WSREP: view(view_id(NON_PRIM,5a3b8a7c-9987,62) memb {
64c9d619-a560,166
} joined {
} left {
} partitioned {
5a3b8a7c-9987,166
5cdb8792-a224,167
99ec24fd-acb2,160
b0953aee-b9aa,167
e5540730-9745,167
})
2025-01-22 14:20:18 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2025-01-22 14:20:18 0 [Note] WSREP: view((empty))
2025-01-22 14:20:18 0 [Note] WSREP: gcomm: closed
2025-01-22 14:20:18 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2025-01-22 14:20:18 0 [Note] WSREP: Flow-control interval: [16, 16]
2025-01-22 14:20:18 0 [Note] WSREP: Received NON-PRIMARY.
2025-01-22 14:20:18 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 221931435)
2025-01-22 14:20:18 0 [Note] WSREP: New SELF-LEAVE.
2025-01-22 14:20:18 0 [Note] WSREP: Flow-control interval: [0, 0]
2025-01-22 14:20:18 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2025-01-22 14:20:18 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 221931435)
2025-01-22 14:20:18 0 [Note] WSREP: RECV thread exiting 0: Success
2025-01-22 14:20:18 2 [Note] WSREP: ================================================
View:
id: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
status: non-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: 64c9d619-c1eb-11ef-a560-d65137a34863, e2.p1.mariadb.mydomain.lan
=================================================
2025-01-22 14:20:18 2 [Note] WSREP: Non-primary view
2025-01-22 14:20:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-01-22 14:20:18 0 [Note] WSREP: recv_thread() joined.
2025-01-22 14:20:18 0 [Note] WSREP: Closing send queue.
2025-01-22 14:20:18 0 [Note] WSREP: Closing receive queue.
2025-01-22 14:20:18 2 [Note] WSREP: ================================================
View:
id: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
status: non-primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: yes
own_index: -1
members(0):
=================================================
2025-01-22 14:20:18 2 [Note] WSREP: Non-primary view
2025-01-22 14:20:18 2 [Note] WSREP: Server status change disconnecting -> disconnected
2025-01-22 14:20:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-01-22 14:20:18 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2
2025-01-22 14:20:18 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2025-01-22 14:20:18 1 [Note] WSREP: rollbacker thread exiting 1
2025-01-22 14:20:18 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2025-01-22 14:20:18 0 [Note] WSREP: dtor state: CLOSED
2025-01-22 14:20:18 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.999982, misses: 2047, in use: 42, in pool: 2005
2025-01-22 14:20:18 0 [Note] WSREP: mon: entered 115927371 oooe fraction 0 oool fraction 0
2025-01-22 14:20:18 0 [Note] WSREP: mon: entered 115927371 oooe fraction 0.000110845 oool fraction 3.9335e-06
2025-01-22 14:20:18 0 [Note] WSREP: mon: entered 117700545 oooe fraction 0 oool fraction 8.49614e-09
2025-01-22 14:20:18 0 [Note] WSREP: cert index usage at exit 45
2025-01-22 14:20:18 0 [Note] WSREP: cert trx map usage at exit 42
2025-01-22 14:20:18 0 [Note] WSREP: deps set usage at exit 0
2025-01-22 14:20:18 0 [Note] WSREP: avg deps dist 68.4722
2025-01-22 14:20:18 0 [Note] WSREP: avg cert interval 87.4315
2025-01-22 14:20:18 0 [Note] WSREP: cert index size 45
2025-01-22 14:20:18 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:20:18 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2025-01-22 14:20:18 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.999968, misses: 2, in use: 0, in pool: 2
2025-01-22 14:20:18 0 [Note] WSREP: Flushing memory map to disk...
2025-01-22 14:20:18 0 [Note] WSREP: Deinitializing event service v1
2025-01-22 14:20:18 0 [Note] WSREP: Deinitializing allowlist service v1
2025-01-22 14:20:18 0 [Note] InnoDB: FTS optimize thread exiting.
2025-01-22 14:20:18 0 [Note] InnoDB: Starting shutdown...
2025-01-22 14:20:18 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2025-01-22 14:20:18 0 [Note] InnoDB: Buffer pool(s) dump completed at 250122 14:20:18
2025-01-22 14:20:18 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2025-01-22 14:20:18 0 [Note] InnoDB: Shutdown completed; log sequence number 218845491452; transaction id 444930557
2025-01-22 14:20:18 0 [Note] /usr/sbin/mariadbd: Shutdown complete
2025-01-22 14:20:21 0 [Note] Starting MariaDB 11.4.3-MariaDB-ubu2204-log source revision 5ab81ffe0097a22a774957df28c5223cf0201de3 server_uid 2kvendvuwn01ONhSSO3NiOJPVyM= as process 1342496
2025-01-22 14:20:21 0 [Note] WSREP: Loading provider /usr/lib/libgalera_smm.so initial position: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
2025-01-22 14:20:21 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2025-01-22 14:20:21 0 [Note] WSREP: wsrep_load(): Galera 26.4.19(r5db72dad) by Codership Oy <info@codership.com> loaded successfully.
2025-01-22 14:20:21 0 [Note] WSREP: Initializing allowlist service v1
2025-01-22 14:20:21 0 [Note] WSREP: Initializing event service v1
2025-01-22 14:20:21 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1'
2025-01-22 14:20:21 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2025-01-22 14:20:21 0 [Note] WSREP: Found saved state: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435, safe_to_bootstrap: 0
2025-01-22 14:20:21 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
Seqno: 215285920 - 221931435
Offset: 358688104
Synced: 1
2025-01-22 14:20:21 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b, offset: 358688104
2025-01-22 14:20:21 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% (0/4294967320 bytes) complete.
2025-01-22 14:20:31 0 [Note] WSREP: GCache::RingBuffer initial scan... 70.8% (3042569136/4294967320 bytes) complete.
2025-01-22 14:20:34 0 [Note] WSREP: GCache::RingBuffer initial scan... 100.0% (4294967320/4294967320 bytes) complete.
2025-01-22 14:20:37 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 215285920-221931435
2025-01-22 14:20:37 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% (0/4231195040 bytes) complete.
2025-01-22 14:20:40 0 [Note] WSREP: Recovering GCache ring buffer: found 58/6645574 locked buffers
2025-01-22 14:20:40 0 [Note] WSREP: Recovering GCache ring buffer: free space: 63776176/4294967296
2025-01-22 14:20:40 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 100.0% (4231195040/4231195040 bytes) complete.
2025-01-22 14:20:40 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.166.2.15; 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 = PT1S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M; evs.join_retrans_period = PT1S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT30S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 4G; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 4G; 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_l
2025-01-22 14:20:40 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:20:40 0 [Note] WSREP: ####### Assign initial position for certification: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435, protocol version: -1
2025-01-22 14:20:40 0 [Note] WSREP: Start replication
2025-01-22 14:20:40 0 [Note] WSREP: Connecting with bootstrap option: 0
2025-01-22 14:20:40 0 [Note] WSREP: Setting GCS initial position to 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
2025-01-22 14:20:40 0 [Note] WSREP: protonet asio version 0
2025-01-22 14:20:40 0 [Note] WSREP: Using CRC-32C for message checksums.
2025-01-22 14:20:40 0 [Note] WSREP: backend: asio
2025-01-22 14:20:40 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2025-01-22 14:20:40 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2025-01-22 14:20:40 0 [Note] WSREP: restore pc from disk failed
2025-01-22 14:20:40 0 [Note] WSREP: GMCast version 0
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') listening at tcp://10.166.2.15:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') multicast: , ttl: 1
2025-01-22 14:20:40 0 [Note] WSREP: EVS version 1
2025-01-22 14:20:40 0 [Note] WSREP: gcomm: connecting to group 'mydomain_production', peer 'e1.p1.mariadb.mydomain.com:,e2.p1.mariadb.mydomain.com:,e1.p2.mariadb.mydomain.com:,e2.p2.mariadb.mydomain.com:,e3.p2.mariadb.mydomain.com:,e3.p1.mariadb.mydomain.com:'
2025-01-22 14:20:40 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') connection established to 5a3b8a7c-9987 tcp://10.166.2.14:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') turning message relay requesting on, nonlive peers: tcp://10.160.252.1:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') connection established to b0953aee-b9aa tcp://10.167.2.13:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') connection established to 5cdb8792-a224 tcp://10.167.2.11:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') connection established to e5540730-9745 tcp://10.167.2.4:4567
2025-01-22 14:20:40 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') connection established to 99ec24fd-acb2 tcp://10.160.252.1:4567
2025-01-22 14:20:41 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:20:42 0 [Note] WSREP: EVS version upgrade 0 -> 1
2025-01-22 14:20:42 0 [Note] WSREP: declaring 5a3b8a7c-9987 at tcp://10.166.2.14:4567 stable
2025-01-22 14:20:42 0 [Note] WSREP: declaring 5cdb8792-a224 at tcp://10.167.2.11:4567 stable
2025-01-22 14:20:42 0 [Note] WSREP: declaring 99ec24fd-acb2 at tcp://10.160.252.1:4567 stable
2025-01-22 14:20:42 0 [Note] WSREP: declaring b0953aee-b9aa at tcp://10.167.2.13:4567 stable
2025-01-22 14:20:42 0 [Note] WSREP: declaring e5540730-9745 at tcp://10.167.2.4:4567 stable
2025-01-22 14:20:42 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2025-01-22 14:20:43 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:20:43 0 [Note] WSREP: (0ea01742-8de0, 'tcp://10.166.2.15:4567') turning message relay requesting off
2025-01-22 14:20:44 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:20:45 0 [Note] WSREP: Node 5a3b8a7c-9987 state prim
2025-01-22 14:20:45 0 [Note] WSREP: view(view_id(PRIM,0ea01742-8de0,64) memb {
0ea01742-8de0,166
5a3b8a7c-9987,166
5cdb8792-a224,167
99ec24fd-acb2,160
b0953aee-b9aa,167
e5540730-9745,167
} joined {
} left {
} partitioned {
})
2025-01-22 14:20:45 0 [Note] WSREP: save pc into disk
2025-01-22 14:20:45 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.166.2.7:4567
2025-01-22 14:20:46 0 [Note] WSREP: gcomm: connected
2025-01-22 14:20:46 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2025-01-22 14:20:46 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2025-01-22 14:20:46 0 [Note] WSREP: Opened channel 'mydomain_production'
2025-01-22 14:20:46 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 6
2025-01-22 14:20:46 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35
2025-01-22 14:20:46 0 [Note] WSREP: Initializing config service v1
2025-01-22 14:20:46 0 [Note] WSREP: Deinitializing config service v1
2025-01-22 14:20:46 2 [Note] WSREP: Starting rollbacker thread 2
2025-01-22 14:20:46 1 [Note] WSREP: Starting applier thread 1
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 0 (e2.p1.mariadb.mydomain.lan)
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 1 (e1.p1.mariadb.mydomain.lan)
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 3 (garb)
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 4 (e3.p2.mariadb.mydomain.lan)
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 5 (e1.p2.mariadb.mydomain.lan)
2025-01-22 14:20:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 12361e33-d8cc-11ef-bd39-aeaa4cd12f35 from 2 (e2.p2.mariadb.mydomain.lan)
2025-01-22 14:20:46 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 59,
members = 5/6 (joined/total),
act_id = 221932481,
last_appl. = 221932418,
protocols = 4/11/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
2025-01-22 14:20:46 0 [Note] WSREP: Flow-control interval: [39, 39]
2025-01-22 14:20:46 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 221932482)
2025-01-22 14:20:46 1 [Note] WSREP: ####### processing CC 221932482, local, ordered
2025-01-22 14:20:46 1 [Note] WSREP: Process first view: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b my uuid: 0ea01742-d8cc-11ef-8de0-3f3c5cf67225
2025-01-22 14:20:46 1 [Note] WSREP: Server e2.p1.mariadb.mydomain.lan connected to cluster at position 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221932482 with ID 0ea01742-d8cc-11ef-8de0-3f3c5cf67225
2025-01-22 14:20:46 1 [Note] WSREP: Server status change disconnected -> connected
2025-01-22 14:20:46 1 [Note] WSREP: ####### My UUID: 0ea01742-d8cc-11ef-8de0-3f3c5cf67225
2025-01-22 14:20:46 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: yes
2025-01-22 14:20:46 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:20:46 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2025-01-22 14:20:46 1 [Note] WSREP: State transfer required:
Group state: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221932482
Local state: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
2025-01-22 14:20:46 1 [Note] WSREP: Server status change connected -> joiner
2025-01-22 14:20:46 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.166.2.15' --datadir '/var/lib/mysql/' --parent 1342496 --progress 0 --binlog 'mysqld-bin' --binlog-index 'mysqld-bin.index' --mysqld-args --wsrep_start_position=15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435'
2025-01-22 14:20:46 0 [Note] WSREP: Joiner monitor thread started to monitor
WSREP_SST: [INFO] mariabackup SST started on joiner (20250122 14:20:46.317)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20250122 14:20:46.388)
WSREP_SST: [INFO] Moving '/var/lib/mysql/mariabackup.backup.log' to '/tmp/sst_log_archive/mariabackup.backup.log.2025.01.22-14.20.46.608038459' (20250122 14:20:46.613)
WSREP_SST: [INFO] Streaming with mbstream (20250122 14:20:46.628)
WSREP_SST: [INFO] Using socat as streamer (20250122 14:20:46.632)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20250122 14:20:46.685)
2025-01-22 14:20:46 1 [Note] WSREP: ####### IST uuid:15a3cde4-8d25-11ef-9e70-87f74cf82f0b f: 221931436, l: 221932482, STRv: 3
2025-01-22 14:20:46 1 [Note] WSREP: IST receiver addr using tcp://10.166.2.15:4568
2025-01-22 14:20:46 1 [Note] WSREP: Prepared IST receiver for 221931436-221932482, listening at: tcp://10.166.2.15:4568
2025-01-22 14:20:46 0 [Note] WSREP: Member 0.166 (e2.p1.mariadb.mydomain.lan) requested state transfer from '*any*'. Selected 1.166 (e1.p1.mariadb.mydomain.lan)(SYNCED) as donor.
2025-01-22 14:20:46 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 221932521)
2025-01-22 14:20:46 1 [Note] WSREP: Requesting state transfer: success, donor: 1
WSREP_SST: [INFO] 'xtrabackup_ist' received from donor: Running IST (20250122 14:20:47.318)
2025-01-22 14:20:47 0 [Note] WSREP: 1.166 (e1.p1.mariadb.mydomain.lan): State transfer to 0.166 (e2.p1.mariadb.mydomain.lan) complete.
WSREP_SST: [INFO] Galera co-ords from recovery: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435 0 (20250122 14:20:47.326)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20250122 14:20:47.329)
WSREP_SST: [INFO] mariabackup IST completed on joiner (20250122 14:20:47.332)
WSREP_SST: [INFO] Removing the sst_in_progress file (20250122 14:20:47.337)
WSREP_SST: [INFO] Cleaning up temporary directories (20250122 14:20:47.342)
2025-01-22 14:20:47 0 [Note] WSREP: Member 1.166 (e1.p1.mariadb.mydomain.lan) synced with group.
2025-01-22 14:20:47 3 [Note] WSREP: SST received
2025-01-22 14:20:47 3 [Note] WSREP: Server status change joiner -> initializing
2025-01-22 14:20:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-01-22 14:20:47 0 [Note] InnoDB: Number of transaction pools: 1
2025-01-22 14:20:47 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-22 14:20:47 0 [Note] InnoDB: Initializing buffer pool, total size = 2.864GiB, chunk size = 45.828MiB
2025-01-22 14:20:47 0 [Note] InnoDB: Initialized memory pressure event listener
2025-01-22 14:20:47 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-22 14:20:47 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2025-01-22 14:20:47 0 [Warning] InnoDB: Retry attempts for reading partial data failed.
2025-01-22 14:20:47 0 [ERROR] InnoDB: Failed to read log at 40964608: I/O error
2025-01-22 14:20:47 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2025-01-22 14:20:47 0 [Note] InnoDB: Starting shutdown...
2025-01-22 14:20:47 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2025-01-22 14:20:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-22 14:20:47 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2025-01-22 14:20:47 0 [ERROR] Aborting
2025-01-22 14:20:47 3 [ERROR] WSREP: sst_received failed: State wait was interrupted
2025-01-22 14:20:47 1 [ERROR] WSREP: Application received wrong state:
Received: 00000000-0000-0000-0000-000000000000
Required: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
2025-01-22 14:20:47 1 [ERROR] WSREP: Application state transfer failed. This is unrecoverable condition, restart required.
2025-01-22 14:21:23 0 [Note] Starting MariaDB 11.4.3-MariaDB-ubu2204-log source revision 5ab81ffe0097a22a774957df28c5223cf0201de3 server_uid 2kvendvuwn01ONhSSO3NiOJPVyM= as process 1343190
2025-01-22 14:21:23 0 [Note] WSREP: Loading provider /usr/lib/libgalera_smm.so initial position: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435
2025-01-22 14:21:23 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2025-01-22 14:21:23 0 [Note] WSREP: wsrep_load(): Galera 26.4.19(r5db72dad) by Codership Oy <info@codership.com> loaded successfully.
2025-01-22 14:21:23 0 [Note] WSREP: Initializing allowlist service v1
2025-01-22 14:21:23 0 [Note] WSREP: Initializing event service v1
2025-01-22 14:21:23 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1'
2025-01-22 14:21:23 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2025-01-22 14:21:23 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0
2025-01-22 14:21:23 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
Seqno: -1 - -1
Offset: -1
Synced: 0
2025-01-22 14:21:23 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b, offset: -1
2025-01-22 14:21:23 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% (0/4294967320 bytes) complete.
2025-01-22 14:21:33 0 [Note] WSREP: GCache::RingBuffer initial scan... 91.4% (3926485992/4294967320 bytes) complete.
2025-01-22 14:21:34 0 [Note] WSREP: GCache::RingBuffer initial scan... 100.0% (4294967320/4294967320 bytes) complete.
2025-01-22 14:21:36 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 215285920-221931435
2025-01-22 14:21:36 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% (0/4231195040 bytes) complete.
2025-01-22 14:21:37 0 [Note] WSREP: Recovering GCache ring buffer: found 58/6645574 locked buffers
2025-01-22 14:21:37 0 [Note] WSREP: Recovering GCache ring buffer: free space: 63776176/4294967296
2025-01-22 14:21:37 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 100.0% (4231195040/4231195040 bytes) complete.
2025-01-22 14:21:37 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.166.2.15; 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 = PT1S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M; evs.join_retrans_period = PT1S; evs.keepalive_period = PT3S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT30S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 4G; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 4G; 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_l
2025-01-22 14:21:37 0 [Note] WSREP: Start replication
2025-01-22 14:21:37 0 [Note] WSREP: Connecting with bootstrap option: 0
2025-01-22 14:21:37 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2025-01-22 14:21:37 0 [Note] WSREP: protonet asio version 0
2025-01-22 14:21:37 0 [Note] WSREP: Using CRC-32C for message checksums.
2025-01-22 14:21:37 0 [Note] WSREP: backend: asio
2025-01-22 14:21:37 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2025-01-22 14:21:37 0 [Note] WSREP: restore pc from disk successfully
2025-01-22 14:21:37 0 [Note] WSREP: GMCast version 0
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') listening at tcp://10.166.2.15:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') multicast: , ttl: 1
2025-01-22 14:21:37 0 [Note] WSREP: EVS version 1
2025-01-22 14:21:37 0 [Note] WSREP: gcomm: connecting to group 'mydomain_production', peer 'e1.p1.mariadb.mydomain.com:,e2.p1.mariadb.mydomain.com:,e1.p2.mariadb.mydomain.com:,e2.p2.mariadb.mydomain.com:,e3.p2.mariadb.mydomain.com:,e3.p1.mariadb.mydomain.com:'
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to 5a3b8a7c-9987 tcp://10.166.2.14:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') turning message relay requesting on, nonlive peers: tcp://10.160.252.1:4567
2025-01-22 14:21:37 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to b0953aee-b9aa tcp://10.167.2.13:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to 5cdb8792-a224 tcp://10.167.2.11:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to e5540730-9745 tcp://10.167.2.4:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to 99ec24fd-acb2 tcp://10.160.252.1:4567
2025-01-22 14:21:37 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') connection established to 99ec24fd-acb2 tcp://10.160.252.1:4567
2025-01-22 14:21:38 0 [Note] WSREP: gcomm: connected
2025-01-22 14:21:38 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2025-01-22 14:21:38 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2025-01-22 14:21:38 0 [Note] WSREP: Opened channel 'mydomain_production'
2025-01-22 14:21:38 0 [Note] WSREP: Initializing config service v1
2025-01-22 14:21:38 0 [Note] WSREP: Deinitializing config service v1
2025-01-22 14:21:38 1 [Note] WSREP: Starting rollbacker thread 1
2025-01-22 14:21:38 2 [Note] WSREP: Starting applier thread 2
2025-01-22 14:21:39 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:21:40 0 [Note] WSREP: EVS version upgrade 0 -> 1
2025-01-22 14:21:40 0 [Note] WSREP: declaring 5a3b8a7c-9987 at tcp://10.166.2.14:4567 stable
2025-01-22 14:21:40 0 [Note] WSREP: declaring 5cdb8792-a224 at tcp://10.167.2.11:4567 stable
2025-01-22 14:21:40 0 [Note] WSREP: declaring 99ec24fd-acb2 at tcp://10.160.252.1:4567 stable
2025-01-22 14:21:40 0 [Note] WSREP: declaring b0953aee-b9aa at tcp://10.167.2.13:4567 stable
2025-01-22 14:21:40 0 [Note] WSREP: declaring e5540730-9745 at tcp://10.167.2.4:4567 stable
2025-01-22 14:21:40 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2025-01-22 14:21:40 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:21:41 0 [Note] WSREP: (0ea01742-8de1, 'tcp://10.166.2.15:4567') turning message relay requesting off
2025-01-22 14:21:42 0 [Note] WSREP: Failed to establish connection: Connection refused
2025-01-22 14:21:43 0 [Note] WSREP: Node 5a3b8a7c-9987 state prim
2025-01-22 14:21:43 0 [Note] WSREP: view(view_id(PRIM,0ea01742-8de1,66) memb {
0ea01742-8de1,166
5a3b8a7c-9987,166
5cdb8792-a224,167
99ec24fd-acb2,160
b0953aee-b9aa,167
e5540730-9745,167
} joined {
} left {
} partitioned {
})
2025-01-22 14:21:43 0 [Note] WSREP: save pc into disk
2025-01-22 14:21:43 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.166.2.7:4567
2025-01-22 14:21:43 0 [Note] WSREP: clear restored view
2025-01-22 14:21:43 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 6
2025-01-22 14:21:43 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 0 (e2.p1.mariadb.mydomain.lan)
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 3 (garb)
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 5 (e1.p2.mariadb.mydomain.lan)
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 1 (e1.p1.mariadb.mydomain.lan)
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 2 (e2.p2.mariadb.mydomain.lan)
2025-01-22 14:21:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: 343d089d-d8cc-11ef-9ae7-820d2ded4f2e from 4 (e3.p2.mariadb.mydomain.lan)
2025-01-22 14:21:43 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 61,
members = 5/6 (joined/total),
act_id = 221933516,
last_appl. = 221933439,
protocols = 4/11/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
2025-01-22 14:21:43 0 [Note] WSREP: Flow-control interval: [39, 39]
2025-01-22 14:21:43 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 221933517)
2025-01-22 14:21:43 2 [Note] WSREP: ####### processing CC 221933517, local, ordered
2025-01-22 14:21:43 2 [Note] WSREP: Process first view: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b my uuid: 0ea01742-d8cc-11ef-8de1-3f3c5cf67225
2025-01-22 14:21:43 2 [Note] WSREP: Server e2.p1.mariadb.mydomain.lan connected to cluster at position 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221933517 with ID 0ea01742-d8cc-11ef-8de1-3f3c5cf67225
2025-01-22 14:21:43 2 [Note] WSREP: Server status change disconnected -> connected
2025-01-22 14:21:43 2 [Note] WSREP: ####### My UUID: 0ea01742-d8cc-11ef-8de1-3f3c5cf67225
2025-01-22 14:21:43 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: yes
2025-01-22 14:21:43 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:21:43 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2025-01-22 14:21:43 2 [Note] WSREP: State transfer required:
Group state: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221933517
Local state: 00000000-0000-0000-0000-000000000000:-1
2025-01-22 14:21:43 2 [Note] WSREP: Server status change connected -> joiner
2025-01-22 14:21:43 0 [Note] WSREP: Joiner monitor thread started to monitor
2025-01-22 14:21:43 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.166.2.15' --datadir '/var/lib/mysql/' --parent 1343190 --progress 0 --binlog 'mysqld-bin' --binlog-index 'mysqld-bin.index' --mysqld-args --wsrep_start_position=15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435'
WSREP_SST: [INFO] mariabackup SST started on joiner (20250122 14:21:43.400)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20250122 14:21:43.456)
WSREP_SST: [INFO] Streaming with mbstream (20250122 14:21:43.634)
WSREP_SST: [INFO] Using socat as streamer (20250122 14:21:43.637)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20250122 14:21:43.691)
2025-01-22 14:21:43 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 221933517, STRv: 3
2025-01-22 14:21:43 2 [Note] WSREP: IST receiver addr using tcp://10.166.2.15:4568
2025-01-22 14:21:43 2 [Note] WSREP: Prepared IST receiver for 0-221933517, listening at: tcp://10.166.2.15:4568
2025-01-22 14:21:43 0 [Note] WSREP: Member 0.166 (e2.p1.mariadb.mydomain.lan) requested state transfer from '*any*'. Selected 1.166 (e1.p1.mariadb.mydomain.lan)(SYNCED) as donor.
2025-01-22 14:21:43 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 221933543)
2025-01-22 14:21:43 2 [Note] WSREP: Requesting state transfer: success, donor: 1
2025-01-22 14:21:43 2 [Note] WSREP: Resetting GCache seqno map due to different histories.
2025-01-22 14:21:43 2 [Note] WSREP: GCache history reset: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435 -> 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221933517
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20250122 14:21:44.548)
WSREP_SST: [INFO] Proceeding with SST (20250122 14:21:44.548)
WSREP_SST: [INFO] Cleaning the old binary logs (20250122 14:21:44.625)
WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20250122 14:21:45.851)
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20250122 14:21:46.257)
2025-01-22 14:21:52 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 4231190928 bytes
2025-01-22 14:21:52 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 1/29 locked buffers
2025-01-22 14:22:09 0 [Note] WSREP: 1.166 (e1.p1.mariadb.mydomain.lan): State transfer to 0.166 (e2.p1.mariadb.mydomain.lan) complete.
2025-01-22 14:22:09 0 [Note] WSREP: Member 1.166 (e1.p1.mariadb.mydomain.lan) synced with group.
WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql/.sst (20250122 14:22:09.850)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --prepare --no-version-check --log-bin='mysqld-bin' --target-dir='/var/lib/mysql/.sst' --datadir='/var/lib/mysql/.sst' --mysqld-args --log-bin-index='mysqld-bin.index' '--wsrep_start_position=15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221931435' > '/var/lib/mysql/mariabackup.prepare.log' 2>&1 (20250122 14:22:09.854)
WSREP_SST: [INFO] Moving binary logs to . (20250122 14:22:10.414)
WSREP_SST: [INFO] Moving the backup to /var/lib/mysql (20250122 14:22:10.425)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --move-back --no-version-check --log-bin='mysqld-bin' --galera-info --force-non-empty-directories --target-dir='/var/lib/mysql/.sst' --datadir='/var/lib/mysql' > '/var/lib/mysql/mariabackup.move.log' 2>&1 (20250122 14:22:10.428)
WSREP_SST: [INFO] Move successful, removing /var/lib/mysql/.sst (20250122 14:22:10.463)
WSREP_SST: [INFO] Galera co-ords from donor: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221934959 0 (20250122 14:22:10.472)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20250122 14:22:10.475)
WSREP_SST: [INFO] mariabackup SST completed on joiner (20250122 14:22:10.479)
WSREP_SST: [INFO] Removing the sst_in_progress file (20250122 14:22:10.485)
WSREP_SST: [INFO] Cleaning up temporary directories (20250122 14:22:10.490)
2025-01-22 14:22:10 3 [Note] WSREP: SST received
2025-01-22 14:22:10 3 [Note] WSREP: Server status change joiner -> initializing
2025-01-22 14:22:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-01-22 14:22:10 0 [Note] InnoDB: Number of transaction pools: 1
2025-01-22 14:22:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2025-01-22 14:22:10 0 [Note] InnoDB: Initializing buffer pool, total size = 2.864GiB, chunk size = 45.828MiB
2025-01-22 14:22:10 0 [Note] InnoDB: Initialized memory pressure event listener
2025-01-22 14:22:10 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-22 14:22:10 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2025-01-22 14:22:10 0 [Note] InnoDB: End of log at LSN=218848317553
2025-01-22 14:22:10 0 [Note] InnoDB: Resizing redo log from 12.016KiB to 96.000MiB; LSN=218848317553
2025-01-22 14:22:10 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2025-01-22 14:22:10 0 [Note] InnoDB: Opened 3 undo tablespaces
2025-01-22 14:22:10 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2025-01-22 14:22:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2025-01-22 14:22:10 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2025-01-22 14:22:10 0 [Note] InnoDB: log sequence number 218848317553; transaction id 444937670
2025-01-22 14:22:10 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-01-22 14:22:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-01-22 14:22:10 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2025-01-22 14:22:10 0 [Note] Recovering after a crash using mysqld-bin
2025-01-22 14:22:10 0 [Note] Starting table crash recovery...
2025-01-22 14:22:10 0 [Note] Crash table recovery finished.
2025-01-22 14:22:18 0 [Note] Server socket created on IP: '10.166.2.15'.
2025-01-22 14:22:18 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2025-01-22 14:22:18 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2025-01-22 14:22:18 0 [Note] WSREP: Server initialized
2025-01-22 14:22:18 0 [Note] WSREP: Server status change initializing -> initialized
2025-01-22 14:22:18 3 [Note] WSREP: Recovered position from storage: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221934981
2025-01-22 14:22:18 3 [Note] WSREP: Server status change initialized -> joined
2025-01-22 14:22:18 3 [Note] WSREP: Recovered view from SST:
id: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221933517
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(6):
0: 0ea01742-d8cc-11ef-8de1-3f3c5cf67225, e2.p1.mariadb.mydomain.lan
1: 5a3b8a7c-d8cb-11ef-9987-56529fc167e4, e1.p1.mariadb.mydomain.lan
2: 5cdb8792-c1ed-11ef-a224-ce63893ef726, e2.p2.mariadb.mydomain.lan
3: 99ec24fd-d8c9-11ef-acb2-43a00ea3fb7a, garb
4: b0953aee-c1ee-11ef-b9aa-c78b4096a121, e3.p2.mariadb.mydomain.lan
5: e5540730-c1ec-11ef-9745-026111c75ca3, e1.p2.mariadb.mydomain.lan
2025-01-22 14:22:18 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-01-22 14:22:18 6 [Note] WSREP: Recovered cluster id 15a3cde4-8d25-11ef-9e70-87f74cf82f0b
2025-01-22 14:22:18 3 [Note] WSREP: SST received: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221934981
2025-01-22 14:22:18 3 [Note] WSREP: SST succeeded for position 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221934959
2025-01-22 14:22:18 2 [Note] WSREP: Installed new state from SST: 15a3cde4-8d25-11ef-9e70-87f74cf82f0b:221934981
2025-01-22 14:22:18 0 [Note] WSREP: Joiner monitor thread ended with total time 35 sec
2025-01-22 14:22:18 2 [Note] WSREP: Cert. index preload up to 221934981
2025-01-22 14:22:18 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '11.4.3-MariaDB-ubu2204-log' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2025-01-22 14:22:18 0 [Note] WSREP: ####### IST applying starts with 221934982
2025-01-22 14:22:18 0 [Note] WSREP: ####### IST current seqno initialized to 221933440
2025-01-22 14:22:18 0 [Note] WSREP: Receiving IST... 0.0% (0/78 events) complete.
2025-01-22 14:22:18 0 [Note] WSREP: IST preload starting at 221933440
2025-01-22 14:22:18 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:22:18 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:221933439, protocol version: 6
2025-01-22 14:22:18 0 [Note] WSREP: REPL Protocols: 11 (6)
2025-01-22 14:22:18 0 [Note] WSREP: ####### Adjusting cert position: 221933516 -> 221933517
2025-01-22 14:22:18 0 [Note] WSREP: Service thread queue flushed.
2025-01-22 14:22:18 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 221933440
2025-01-22 14:22:18 0 [Note] WSREP: Min available from gcache for CC from preload: 221933440
2025-01-22 14:22:18 0 [Note] WSREP: Receiving IST... 100.0% (78/78 events) complete.
2025-01-22 14:22:18 2 [Note] WSREP: Cert. index preloaded up to 221933517
2025-01-22 14:22:18 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 221933440
2025-01-22 14:22:18 2 [Note] WSREP: Min available from gcache for CC from sst: 221933440
2025-01-22 14:22:18 0 [Note] WSREP: 0.166 (e2.p1.mariadb.mydomain.lan): State transfer from 1.166 (e1.p1.mariadb.mydomain.lan) complete.
2025-01-22 14:22:18 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 221935383)
2025-01-22 14:22:18 0 [Note] WSREP: Processing event queue:... 0.0% (0/409 events) complete.
2025-01-22 14:22:19 0 [Note] WSREP: Member 0.166 (e2.p1.mariadb.mydomain.lan) synced with group.
2025-01-22 14:22:19 0 [Note] WSREP: Processing event queue:... 100.0% (460/460 events) complete.
2025-01-22 14:22:19 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 221935433)
2025-01-22 14:22:19 2 [Note] WSREP: Server e2.p1.mariadb.mydomain.lan synced with group
2025-01-22 14:22:19 2 [Note] WSREP: Server status change joined -> synced
2025-01-22 14:22:19 2 [Note] WSREP: Synchronized with group, ready for connections
2025-01-22 14:22:19 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2025-01-22 14:22:20 14 [Note] WSREP: MDL conflict db=mysql table=event ticket=9 solved by abort
2025-01-22 14:22:22 14 [Note] WSREP: MDL conflict db=sys table=x$innodb_buffer_stats_by_schema ticket=9 solved by abort
2025-01-22 14:22:22 14 [Note] WSREP: MDL conflict db=sys table=x$innodb_buffer_stats_by_table ticket=9 solved by abort
2025-01-22 14:35:38 0 [Note] WSREP: Member 1.166 (e1.p1.mariadb.mydomain.lan) desyncs itself from group
2025-01-22 14:35:40 0 [Note] WSREP: Member 1.166 (e1.p1.mariadb.mydomain.lan) resyncs itself to group.
2025-01-22 14:35:40 0 [Note] WSREP: Member 1.166 (e1.p1.mariadb.mydomain.lan) synced with group.