WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --move-back --no-version-check --log-bin='/data2/mysql/binlog/mysql-bin' --use-memory=190G --galera-info --force-non-empty-directories --target-dir='/data/mysql/data/.sst' --datadir='/data/mysql/data' > '/data/mysql/data/mariabackup.move.log' 2>&1 (20260430 08:39:48.085) WSREP_SST: [INFO] Move successful, removing /data/mysql/data/.sst (20260430 08:39:48.134) WSREP_SST: [INFO] Galera co-ords from donor: 17ae8609-4469-11f1-8697-df6547572222:4658437 0 (20260430 08:39:48.148) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20260430 08:39:48.153) WSREP_SST: [INFO] mariabackup SST completed on joiner (20260430 08:39:48.157) WSREP_SST: [INFO] Removing the sst_in_progress file (20260430 08:39:48.164) WSREP_SST: [INFO] Cleaning up temporary directories (20260430 08:39:48.171) 2026-04-30 8:39:48 0 [Note] WSREP: SST received 2026-04-30 8:39:48 0 [Note] WSREP: Server status change joiner -> initializing 2026-04-30 8:39:48 0 [Note] InnoDB: Compressed tables use zlib 1.3 2026-04-30 8:39:48 0 [Note] InnoDB: Number of transaction pools: 1 2026-04-30 8:39:48 0 [Note] InnoDB: Using AVX512 instructions 2026-04-30 8:39:48 0 [Warning] mysqld: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup). create_uring failed: falling back to libaio 2026-04-30 8:39:48 0 [Note] InnoDB: Using Linux native AIO 2026-04-30 8:39:48 0 [Note] InnoDB: innodb_buffer_pool_size_max=194560m, innodb_buffer_pool_size=194560m 2026-04-30 8:39:51 0 [Note] InnoDB: Completed initialization of buffer pool 2026-04-30 8:39:51 0 [Note] InnoDB: Buffered log writes (block size=4096 bytes) 2026-04-30 8:39:51 0 [Note] InnoDB: End of log at LSN=436445239905 2026-04-30 8:39:51 0 [Note] InnoDB: Transaction 1103120933 was in the XA prepared state. 2026-04-30 8:39:51 0 [Note] InnoDB: 24 transaction(s) which must be rolled back or cleaned up in total 111 row operations to undo 2026-04-30 8:39:51 0 [Note] InnoDB: Trx id counter is 1103120981 2026-04-30 8:39:51 0 [Note] InnoDB: Resizing redo log from 12.016KiB to 4.000GiB; LSN=436445239905 2026-04-30 8:39:51 0 [Note] InnoDB: Buffered log writes (block size=4096 bytes) 2026-04-30 8:39:51 0 [Note] InnoDB: Opened 3 undo tablespaces 2026-04-30 8:39:51 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. 2026-04-30 8:39:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2026-04-30 8:39:51 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2026-04-30 8:39:51 0 [Note] InnoDB: log sequence number 436445239905; transaction id 1103120982 2026-04-30 8:39:51 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool 2026-04-30 8:39:51 0 [Note] InnoDB: Cannot open '/data/mysql/data/ib_buffer_pool' for reading: No such file or directory 2026-04-30 8:39:51 server_audit: MariaDB Audit Plugin version 1.7.0 STARTED. 2026-04-30 8:39:51 0 [Warning] 'innodb-locks-unsafe-for-binlog' was removed. It does nothing now and exists only for compatibility with old my.cnf files. 2026-04-30 8:39:51 0 [Note] Recovering after a crash using /data2/mysql/binlog/mysql-bin 2026-04-30 8:39:51 0 [Note] Starting table crash recovery... 2026-04-30 8:39:51 0 [Note] InnoDB: Starting recovery for XA transactions... 2026-04-30 8:39:51 0 [Note] InnoDB: Transaction 1103120933 in prepared state after recovery 2026-04-30 8:39:51 0 [Note] InnoDB: Transaction contains changes to 2 rows 2026-04-30 8:39:51 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2026-04-30 8:39:51 0 [Note] Found 1 prepared transaction(s) in InnoDB 2026-04-30 8:39:51 0 [Note] WSREP: Last wsrep seqno to be recovered 4658395 2026-04-30 8:39:51 0 [Note] Crash table recovery finished. 2026-04-30 8:39:51 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120945 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120967 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120977 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120935 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103117893 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120951 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120953 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120937 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120975 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120943 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120969 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120959 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120939 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120949 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120963 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120971 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120957 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120955 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120947 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120979 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120965 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120941 2026-04-30 8:39:51 0 [Note] InnoDB: Rolled back recovered transaction 1103120973 2026-04-30 8:39:51 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2026-04-30 8:39:51 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'. 2026-04-30 8:39:51 0 [Note] Server socket created on IP: '::', port: '3306'. 2026-04-30 8:39:51 0 [Note] Server socket created on IP: '0.0.0.0', port: '3307'. 2026-04-30 8:39:51 0 [Note] Server socket created on IP: '::', port: '3307'. 2026-04-30 8:39:51 0 [Warning] 'proxies_priv' entry '@% mysql@16ae412226f5' ignored in --skip-name-resolve mode. 2026-04-30 8:39:51 0 [Note] mysqld: Event Scheduler: Loaded 0 events 2026-04-30 8:39:51 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0 2026-04-30 8:39:51 0 [Note] WSREP: Server initialized 2026-04-30 8:39:51 0 [Note] WSREP: Server status change initializing -> initialized 2026-04-30 8:39:51 0 [Note] WSREP: Recovered position from storage: 17ae8609-4469-11f1-8697-df6547572222:4658394 2026-04-30 8:39:51 0 [Note] WSREP: Server status change initialized -> joined 2026-04-30 8:39:51 0 [Note] WSREP: Recovered view from SST: id: 17ae8609-4469-11f1-8697-df6547572222:4095579 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: 0f45c8cf-446f-11f1-bdf3-0ba4366521b5, mariadb-kyc-0-17 1: 17ae3f6d-4469-11f1-a274-3bc502643727, mariadb-kyc-0-15 2: 8127e9b9-446c-11f1-8b0a-3656f935905a, mariadb-kyc-0-16 2026-04-30 8:39:51 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2026-04-30 8:39:51 35 [Note] WSREP: Recovered cluster id 17ae8609-4469-11f1-8697-df6547572222 2026-04-30 8:39:51 0 [Note] WSREP: SST received: 17ae8609-4469-11f1-8697-df6547572222:4658394 2026-04-30 8:39:51 0 [Note] WSREP: SST succeeded for position 17ae8609-4469-11f1-8697-df6547572222:4658437 2026-04-30 8:39:51 0 [Note] WSREP: Joiner monitor thread ended with total time 469 sec 2026-04-30 8:39:51 2 [Note] WSREP: Installed new state from SST: 17ae8609-4469-11f1-8697-df6547572222:4658394 2026-04-30 8:39:51 34 [Note] WSREP: Starting applier thread 34 2026-04-30 8:39:51 41 [Note] WSREP: Starting applier thread 41 2026-04-30 8:39:51 2 [Note] WSREP: Cert. index preload up to 4658394 2026-04-30 8:39:51 0 [Note] WSREP: ####### IST applying starts with 4658395 2026-04-30 8:39:51 0 [Note] WSREP: ####### IST current seqno initialized to 4095494 2026-04-30 8:39:51 0 [Note] WSREP: Receiving IST... 0.0% (0/86 events) complete. 2026-04-30 8:39:51 0 [Note] WSREP: IST preload starting at 4095494 2026-04-30 8:39:51 0 [Note] WSREP: Service thread queue flushed. 2026-04-30 8:39:51 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:4095493, protocol version: 6 2026-04-30 8:39:51 42 [Note] WSREP: Starting applier thread 42 2026-04-30 8:39:51 37 [Note] WSREP: Starting applier thread 37 2026-04-30 8:39:51 38 [Note] WSREP: Starting applier thread 38 2026-04-30 8:39:51 39 [Note] WSREP: Starting applier thread 39 2026-04-30 8:39:51 32 [Note] WSREP: Starting applier thread 32 2026-04-30 8:39:51 40 [Note] WSREP: Starting applier thread 40 2026-04-30 8:39:51 49 [Note] WSREP: Starting applier thread 49 2026-04-30 8:39:51 31 [Note] WSREP: Starting applier thread 31 2026-04-30 8:39:51 48 [Note] WSREP: Starting applier thread 48 2026-04-30 8:39:51 45 [Note] WSREP: Starting applier thread 45 2026-04-30 8:39:51 47 [Note] WSREP: Starting applier thread 47 2026-04-30 8:39:51 46 [Note] WSREP: Starting applier thread 46 2026-04-30 8:39:51 36 [Note] WSREP: Starting applier thread 36 2026-04-30 8:39:51 43 [Note] WSREP: Starting applier thread 43 2026-04-30 8:39:51 50 [Note] WSREP: Starting applier thread 50 2026-04-30 8:39:51 33 [Note] WSREP: Starting applier thread 33 2026-04-30 8:39:51 53 [Note] WSREP: Starting applier thread 53 2026-04-30 8:39:51 52 [Note] WSREP: Starting applier thread 52 2026-04-30 8:39:51 44 [Note] WSREP: Starting applier thread 44 2026-04-30 8:39:51 55 [Note] WSREP: Starting applier thread 55 2026-04-30 8:39:51 56 [Note] WSREP: Starting applier thread 56 2026-04-30 8:39:51 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '11.8.6-3-MariaDB-enterprise-log' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Enterprise Server 2026-04-30 8:39:51 0 [Note] WSREP: REPL Protocols: 11 (6) 2026-04-30 8:39:51 0 [Note] WSREP: ####### Adjusting cert position: 4095578 -> 4095579 2026-04-30 8:39:51 0 [Note] WSREP: Service thread queue flushed. 2026-04-30 8:39:51 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 4095494 2026-04-30 8:39:51 0 [Note] WSREP: Min available from gcache for CC from preload: 4095494 2026-04-30 8:39:51 0 [Note] WSREP: Receiving IST... 100.0% (86/86 events) complete. 2026-04-30 8:39:51 2 [Note] WSREP: Cert. index preloaded up to 4095579 2026-04-30 8:39:51 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 4095494 2026-04-30 8:39:51 2 [Note] WSREP: Min available from gcache for CC from sst: 4095494 2026-04-30 8:39:51 0 [Note] WSREP: 0.0 (mariadb-kyc-0-17): State transfer from 1.0 (mariadb-kyc-0-15) complete. 2026-04-30 8:39:51 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 4690860) 2026-04-30 8:39:51 0 [Note] WSREP: Processing event queue:... 0.0% (0/604497 events) complete. 2026-04-30 8:39:57 0 [Note] WSREP: Deleted page /data/mysql/data/gcache.page.000000 2026-04-30 8:39:58 38 [ERROR] mysqld: Error writing file '/data2/mysql/binlog/mysql-bin' (errno: 1950 "Unknown error 1950") 2026-04-30 8:39:58 41 [ERROR] WSREP: Failed to apply write set: gtid: 17ae8609-4469-11f1-8697-df6547572222:4658396 server_id: 17ae3f6d-4469-11f1-a274-3bc502643727 client_id: 29026 trx_id: 14037607 flags: 3 (start_transaction | commit) 2026-04-30 8:39:58 38 [ERROR] WSREP: Failed to apply write set: gtid: 17ae8609-4469-11f1-8697-df6547572222:4658395 server_id: 17ae3f6d-4469-11f1-a274-3bc502643727 client_id: 29024 trx_id: 14037605 flags: 3 (start_transaction | commit) 2026-04-30 8:39:58 41 [Note] WSREP: Closing send monitor... 2026-04-30 8:39:58 41 [Note] WSREP: Closed send monitor. 2026-04-30 8:39:58 41 [Note] WSREP: gcomm: terminating thread 2026-04-30 8:39:58 41 [Note] WSREP: gcomm: joining thread 2026-04-30 8:39:58 41 [Note] WSREP: gcomm: closing backend 2026-04-30 8:39:58 41 [Note] WSREP: view(view_id(NON_PRIM,0f45c8cf-bdf3,7) memb { 0f45c8cf-bdf3,0 } joined { } left { } partitioned { 17ae3f6d-a274,0 8127e9b9-8b0a,0 }) 2026-04-30 8:39:58 41 [Note] WSREP: PC protocol downgrade 1 -> 0 2026-04-30 8:39:58 41 [Note] WSREP: view((empty)) 2026-04-30 8:39:58 41 [Note] WSREP: gcomm: closed 2026-04-30 8:39:58 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2026-04-30 8:39:58 0 [Note] WSREP: Flow-control interval: [16, 16] 2026-04-30 8:39:58 0 [Note] WSREP: Received NON-PRIMARY. 2026-04-30 8:39:58 0 [Note] WSREP: Shifting JOINED -> OPEN (TO: 4700430) 2026-04-30 8:39:58 38 [Note] WSREP: Failed to send SYNC signal: -107 (Not in primary component) 2026-04-30 8:39:58 0 [Note] WSREP: New SELF-LEAVE. 2026-04-30 8:39:58 0 [Note] WSREP: Flow-control interval: [16, 16] 2026-04-30 8:39:58 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2026-04-30 8:39:58 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 4700430) 2026-04-30 8:39:58 38 [Note] WSREP: ================================================ View: id: 17ae8609-4469-11f1-8697-df6547572222:4700430 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: 0f45c8cf-446f-11f1-bdf3-0ba4366521b5, mariadb-kyc-0-17 ================================================= 2026-04-30 8:39:58 38 [Note] WSREP: Non-primary view 2026-04-30 8:39:58 38 [Note] WSREP: Server status change joined -> connected 2026-04-30 8:39:58 0 [Note] WSREP: RECV thread exiting 0: Success 2026-04-30 8:39:58 38 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2026-04-30 8:39:58 41 [Note] WSREP: recv_thread() joined. 2026-04-30 8:39:58 41 [Note] WSREP: Closing send queue. 2026-04-30 8:39:58 41 [Note] WSREP: Closing receive queue. 2026-04-30 8:39:58 41 [Note] WSREP: Processing event queue:... 100.0% (614219/614220 events) complete. 2026-04-30 8:39:58 38 [Note] WSREP: ================================================ View: id: 17ae8609-4469-11f1-8697-df6547572222:4700430 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): ================================================= 2026-04-30 8:39:58 38 [Note] WSREP: Non-primary view 2026-04-30 8:39:58 38 [Note] WSREP: Server status change connected -> disconnected 2026-04-30 8:39:58 38 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2026-04-30 8:39:58 41 [Note] WSREP: Applier thread exiting ret: 0 thd: 41 2026-04-30 08:41:04,060 INFO waiting for mariadb to stop 2026-04-30 8:41:04 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2026-04-30 8:41:04 0 [Note] WSREP: Shutdown replication 2026-04-30 08:41:04,074 INFO stopped: mariadb (exit status 0)