2025-08-07 13:17:39 0 [Warning] mariadbd: 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 2025-08-07 13:17:39 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. 250807 13:17:40 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql/ 2025-08-07 13:17:40 0 [Note] Starting MariaDB 10.11.14-MariaDB-ubu2404-log source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid Kq1m9b1QwfouSLYUB3/7bngiSHs= as process 258 2025-08-07 13:17:40 0 [Note] InnoDB: Compressed tables use zlib 1.3 2025-08-07 13:17:40 0 [Note] InnoDB: Number of transaction pools: 1 2025-08-07 13:17:40 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-08-07 13:17:40 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 2025-08-07 13:17:40 0 [Warning] mariadbd: 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 2025-08-07 13:17:40 0 [Note] InnoDB: Using Linux native AIO 2025-08-07 13:17:40 0 [Note] InnoDB: innodb_buffer_pool_size_max=3104m, innodb_buffer_pool_size=3100m 2025-08-07 13:17:40 0 [Note] InnoDB: Completed initialization of buffer pool 2025-08-07 13:17:40 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-08-07 13:17:40 0 [Note] InnoDB: End of log at LSN=45502 2025-08-07 13:17:40 0 [Note] InnoDB: 128 rollback segments are active. 2025-08-07 13:17:40 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-08-07 13:17:40 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-08-07 13:17:40 0 [Note] InnoDB: log sequence number 45502; transaction id 14 2025-08-07 13:17:40 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-08-07 13:17:40 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-08-07 13:17:41 0 [Note] InnoDB: Buffer pool(s) load completed at 250807 13:17:40 2025-08-07 13:17:41 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.11.14-MariaDB-ubu2404-log' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution 2025-08-07 13:17:41 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown 2025-08-07 13:17:41 0 [Note] InnoDB: FTS optimize thread exiting. 2025-08-07 13:17:41 0 [Note] InnoDB: Starting shutdown... 2025-08-07 13:17:41 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2025-08-07 13:17:41 0 [Note] InnoDB: Buffer pool(s) dump completed at 250807 13:17:41 2025-08-07 13:17:42 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2025-08-07 13:17:42 0 [Note] InnoDB: Shutdown completed; log sequence number 47008; transaction id 16 2025-08-07 13:17:42 0 [Note] /usr/sbin/mariadbd: Shutdown complete 250807 13:17:42 mysqld_safe mysqld from pid file /var/lib/mysql/mariadb.pid ended 250807 13:17:44 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql/ 250807 13:17:44 mysqld_safe WSREP: Running position recovery with --disable-log-error --pid-file='/var/lib/mysql//npbc62486a965f4-recover.pid' 250807 13:17:45 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 2025-08-07 13:17:45 0 [Note] Starting MariaDB 10.11.14-MariaDB-ubu2404-log source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid C9VBQ9mpcBodW9/m600DPyHpVQA= as process 225 2025-08-07 13:17:45 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2025-08-07 13:17:45 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 2025-08-07 13:17:45 0 [Note] WSREP: wsrep_load(): Galera 26.4.23(re792f3e4) by Codership Oy loaded successfully. 2025-08-07 13:17:45 0 [Note] WSREP: Initializing allowlist service v1 2025-08-07 13:17:45 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1' 2025-08-07 13:17:45 0 [Note] WSREP: Symbol 'wsrep_certify_v1' not found from provider 2025-08-07 13:17:45 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2025-08-07 13:17:45 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat' 2025-08-07 13:17:45 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2025-08-07 13:17:45 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2025-08-07 13:17:45 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2025-08-07 13:17:45 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.33.3; 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-08-07 13:17:45 0 [Note] WSREP: Start replication 2025-08-07 13:17:45 0 [Note] WSREP: Connecting with bootstrap option: 1 2025-08-07 13:17:45 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2025-08-07 13:17:45 0 [Note] WSREP: protonet asio version 0 2025-08-07 13:17:45 0 [Note] WSREP: Using CRC-32C for message checksums. 2025-08-07 13:17:45 0 [Note] WSREP: backend: asio 2025-08-07 13:17:45 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2025-08-07 13:17:45 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2025-08-07 13:17:45 0 [Note] WSREP: restore pc from disk failed 2025-08-07 13:17:45 0 [Note] WSREP: GMCast version 0 2025-08-07 13:17:45 0 [Note] WSREP: (e7ec34aa-a0c1, 'tcp://192.168.33.3:4567') listening at tcp://192.168.33.3:4567 2025-08-07 13:17:45 0 [Note] WSREP: (e7ec34aa-a0c1, 'tcp://192.168.33.3:4567') multicast: , ttl: 1 2025-08-07 13:17:45 0 [Note] WSREP: EVS version 1 2025-08-07 13:17:45 0 [Note] WSREP: gcomm: bootstrapping new group 'openstack' 2025-08-07 13:17:45 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2025-08-07 13:17:45 0 [Note] WSREP: EVS version upgrade 0 -> 1 2025-08-07 13:17:45 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2025-08-07 13:17:45 0 [Note] WSREP: Node e7ec34aa-a0c1 state prim 2025-08-07 13:17:45 0 [Note] WSREP: view(view_id(PRIM,e7ec34aa-a0c1,1) memb { e7ec34aa-a0c1,0 } joined { } left { } partitioned { }) 2025-08-07 13:17:45 0 [Note] WSREP: save pc into disk 2025-08-07 13:17:45 0 [Note] WSREP: gcomm: connected 2025-08-07 13:17:45 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2025-08-07 13:17:45 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2025-08-07 13:17:45 0 [Note] WSREP: Opened channel 'openstack' 2025-08-07 13:17:45 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2025-08-07 13:17:45 0 [Note] WSREP: Starting new group from scratch: e7eca07f-7390-11f0-8853-fbf51fa19cfe 2025-08-07 13:17:45 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e7eca1e3-7390-11f0-8aa2-23feece93dbc 2025-08-07 13:17:45 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e7eca1e3-7390-11f0-8aa2-23feece93dbc 2025-08-07 13:17:45 0 [Note] WSREP: STATE EXCHANGE: got state msg: e7eca1e3-7390-11f0-8aa2-23feece93dbc from 0 (npbc62486a965f4) 2025-08-07 13:17:45 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 = e7eca07f-7390-11f0-8853-fbf51fa19cfe 2025-08-07 13:17:45 0 [Note] WSREP: Flow-control interval: [16, 16] 2025-08-07 13:17:45 0 [Note] WSREP: Restored state OPEN -> JOINED (1) 2025-08-07 13:17:45 1 [Note] WSREP: Starting rollbacker thread 1 2025-08-07 13:17:45 0 [Note] WSREP: Member 0.0 (npbc62486a965f4) synced with group. 2025-08-07 13:17:45 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1) 2025-08-07 13:17:45 2 [Note] WSREP: Starting applier thread 2 2025-08-07 13:17:45 2 [Note] WSREP: ####### processing CC 1, local, ordered 2025-08-07 13:17:45 2 [Note] WSREP: Process first view: e7eca07f-7390-11f0-8853-fbf51fa19cfe my uuid: e7ec34aa-7390-11f0-a0c1-9326d45dc49a 2025-08-07 13:17:45 2 [Note] WSREP: Server npbc62486a965f4 connected to cluster at position e7eca07f-7390-11f0-8853-fbf51fa19cfe:1 with ID e7ec34aa-7390-11f0-a0c1-9326d45dc49a 2025-08-07 13:17:45 2 [Note] WSREP: Server status change disconnected -> connected 2025-08-07 13:17:45 2 [Note] WSREP: ####### My UUID: e7ec34aa-7390-11f0-a0c1-9326d45dc49a 2025-08-07 13:17:45 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: no 2025-08-07 13:17:45 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:45 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2025-08-07 13:17:45 2 [Note] WSREP: REPL Protocols: 11 (6) 2025-08-07 13:17:45 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 1 2025-08-07 13:17:45 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:45 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> e7eca07f-7390-11f0-8853-fbf51fa19cfe:0 2025-08-07 13:17:45 2 [Note] WSREP: ================================================ View: id: e7eca07f-7390-11f0-8853-fbf51fa19cfe: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: e7ec34aa-7390-11f0-a0c1-9326d45dc49a, npbc62486a965f4 ================================================= 2025-08-07 13:17:45 2 [Note] WSREP: Server status change connected -> joiner 2025-08-07 13:17:45 2 [Note] WSREP: Server status change joiner -> initializing 2025-08-07 13:17:45 0 [Note] InnoDB: Compressed tables use zlib 1.3 2025-08-07 13:17:45 0 [Note] InnoDB: Number of transaction pools: 1 2025-08-07 13:17:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-08-07 13:17:45 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 2025-08-07 13:17:45 0 [Warning] mariadbd: 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 2025-08-07 13:17:45 0 [Note] InnoDB: Using Linux native AIO 2025-08-07 13:17:45 0 [Note] InnoDB: innodb_buffer_pool_size_max=3104m, innodb_buffer_pool_size=3100m 2025-08-07 13:17:45 0 [Note] InnoDB: Completed initialization of buffer pool 2025-08-07 13:17:45 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-08-07 13:17:45 0 [Note] InnoDB: End of log at LSN=47008 2025-08-07 13:17:45 0 [Note] InnoDB: 128 rollback segments are active. 2025-08-07 13:17:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-08-07 13:17:45 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-08-07 13:17:45 0 [Note] InnoDB: log sequence number 47008; transaction id 16 2025-08-07 13:17:45 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-08-07 13:17:45 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-08-07 13:17:45 0 [Note] InnoDB: Buffer pool(s) load completed at 250807 13:17:45 2025-08-07 13:17:45 0 [Note] Server socket created on IP: '192.168.33.3', port: '3306'. 2025-08-07 13:17:45 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2025-08-07 13:17:45 0 [Note] WSREP: Server initialized 2025-08-07 13:17:45 0 [Note] WSREP: Server status change initializing -> initialized 2025-08-07 13:17:45 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2025-08-07 13:17:45 6 [Note] WSREP: Cluster table is empty, not recovering transactions 2025-08-07 13:17:45 2 [Note] WSREP: Server status change initialized -> joined 2025-08-07 13:17:45 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2025-08-07 13:17:45 7 [Note] WSREP: Starting applier thread 7 2025-08-07 13:17:45 9 [Note] WSREP: Starting applier thread 9 2025-08-07 13:17:45 10 [Note] WSREP: Starting applier thread 10 2025-08-07 13:17:45 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.11.14-MariaDB-ubu2404-log' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2025-08-07 13:17:45 2 [Note] WSREP: Lowest cert index boundary for CC from group: 1 2025-08-07 13:17:45 2 [Note] WSREP: Min available from gcache for CC from group: 1 2025-08-07 13:17:45 2 [Note] WSREP: Server npbc62486a965f4 synced with group 2025-08-07 13:17:45 2 [Note] WSREP: Server status change joined -> synced 2025-08-07 13:17:45 2 [Note] WSREP: Synchronized with group, ready for connections 2025-08-07 13:17:45 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2025-08-07 13:17:51 12 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:17:51 13 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:17:51 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: 'npbc62486a965f4' (This connection closed normally without authentication) 2025-08-07 13:17:53 15 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:17:54 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown 2025-08-07 13:17:54 0 [Note] WSREP: Shutdown replication 2025-08-07 13:17:54 0 [Note] WSREP: Server status change synced -> disconnecting 2025-08-07 13:17:54 0 [Note] WSREP: Closing send monitor... 2025-08-07 13:17:54 0 [Note] WSREP: Closed send monitor. 2025-08-07 13:17:54 0 [Note] WSREP: gcomm: terminating thread 2025-08-07 13:17:54 0 [Note] WSREP: gcomm: joining thread 2025-08-07 13:17:54 0 [Note] WSREP: gcomm: closing backend 2025-08-07 13:17:54 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2025-08-07 13:17:54 0 [Note] WSREP: view((empty)) 2025-08-07 13:17:54 0 [Note] WSREP: gcomm: closed 2025-08-07 13:17:54 0 [Note] WSREP: New SELF-LEAVE. 2025-08-07 13:17:54 0 [Note] WSREP: Flow-control interval: [0, 0] 2025-08-07 13:17:54 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2025-08-07 13:17:54 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 1) 2025-08-07 13:17:54 0 [Note] WSREP: RECV thread exiting 0: Success 2025-08-07 13:17:54 0 [Note] WSREP: recv_thread() joined. 2025-08-07 13:17:54 0 [Note] WSREP: Closing send queue. 2025-08-07 13:17:54 0 [Note] WSREP: Closing receive queue. 2025-08-07 13:17:54 2 [Note] WSREP: ================================================ View: id: e7eca07f-7390-11f0-8853-fbf51fa19cfe:1 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-08-07 13:17:54 2 [Note] WSREP: Non-primary view 2025-08-07 13:17:54 2 [Note] WSREP: Server status change disconnecting -> disconnected 2025-08-07 13:17:54 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2025-08-07 13:17:54 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2 2025-08-07 13:17:54 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2025-08-07 13:17:54 9 [Note] WSREP: Applier thread exiting ret: 6 thd: 9 2025-08-07 13:17:54 7 [Note] WSREP: Applier thread exiting ret: 6 thd: 7 2025-08-07 13:17:54 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2025-08-07 13:17:54 10 [Note] WSREP: Applier thread exiting ret: 6 thd: 10 2025-08-07 13:17:54 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2025-08-07 13:17:54 1 [Note] WSREP: rollbacker thread exiting 1 2025-08-07 13:17:54 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2025-08-07 13:17:54 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2025-08-07 13:17:54 0 [Note] WSREP: dtor state: CLOSED 2025-08-07 13:17:54 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2025-08-07 13:17:54 0 [Note] WSREP: apply mon: entered 0 2025-08-07 13:17:54 0 [Note] WSREP: apply mon: entered 0 2025-08-07 13:17:54 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 2025-08-07 13:17:54 0 [Note] WSREP: cert index usage at exit 0 2025-08-07 13:17:54 0 [Note] WSREP: cert trx map usage at exit 0 2025-08-07 13:17:54 0 [Note] WSREP: deps set usage at exit 0 2025-08-07 13:17:54 0 [Note] WSREP: avg deps dist 0 2025-08-07 13:17:54 0 [Note] WSREP: avg cert interval 0 2025-08-07 13:17:54 0 [Note] WSREP: cert index size 0 2025-08-07 13:17:54 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:54 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2025-08-07 13:17:54 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2025-08-07 13:17:54 0 [Note] WSREP: Flushing memory map to disk... 2025-08-07 13:17:54 0 [Note] WSREP: Deinitializing allowlist service v1 2025-08-07 13:17:54 0 [Note] InnoDB: FTS optimize thread exiting. 2025-08-07 13:17:54 0 [Note] InnoDB: Starting shutdown... 2025-08-07 13:17:54 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2025-08-07 13:17:54 0 [Note] InnoDB: Buffer pool(s) dump completed at 250807 13:17:54 2025-08-07 13:17:55 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2025-08-07 13:17:55 0 [Note] InnoDB: Shutdown completed; log sequence number 55482; transaction id 31 2025-08-07 13:17:55 0 [Note] /usr/sbin/mariadbd: Shutdown complete 250807 13:17:55 mysqld_safe mysqld from pid file /var/lib/mysql/mariadb.pid ended 250807 13:17:56 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql/ 250807 13:17:56 mysqld_safe WSREP: Running position recovery with --disable-log-error --pid-file='/var/lib/mysql//npbc62486a965f4-recover.pid' 250807 13:17:56 mysqld_safe WSREP: Recovered position e7eca07f-7390-11f0-8853-fbf51fa19cfe:1 2025-08-07 13:17:56 0 [Note] Starting MariaDB 10.11.14-MariaDB-ubu2404-log source revision 053f9bcb5b147bf00edb99e1310bae9125b7f125 server_uid C9VBQ9mpcBodW9/m600DPyHpVQA= as process 219 2025-08-07 13:17:56 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: e7eca07f-7390-11f0-8853-fbf51fa19cfe:1 2025-08-07 13:17:56 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 2025-08-07 13:17:56 0 [Note] WSREP: wsrep_load(): Galera 26.4.23(re792f3e4) by Codership Oy loaded successfully. 2025-08-07 13:17:56 0 [Note] WSREP: Initializing allowlist service v1 2025-08-07 13:17:56 0 [Note] WSREP: Resolved symbol 'wsrep_node_isolation_mode_set_v1' 2025-08-07 13:17:56 0 [Note] WSREP: Symbol 'wsrep_certify_v1' not found from provider 2025-08-07 13:17:56 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2025-08-07 13:17:56 0 [Note] WSREP: Found saved state: e7eca07f-7390-11f0-8853-fbf51fa19cfe:1, safe_to_bootstrap: 1 2025-08-07 13:17:56 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: e7eca07f-7390-11f0-8853-fbf51fa19cfe Seqno: 1 - 1 Offset: 1280 Synced: 1 2025-08-07 13:17:56 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: e7eca07f-7390-11f0-8853-fbf51fa19cfe, offset: 1280 2025-08-07 13:17:56 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% (0/134217752 bytes) complete. 2025-08-07 13:17:56 0 [Note] WSREP: GCache::RingBuffer initial scan... 100.0% (134217752/134217752 bytes) complete. 2025-08-07 13:17:56 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 1-1 2025-08-07 13:17:56 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% (0/168 bytes) complete. 2025-08-07 13:17:56 0 [Note] WSREP: Recovering GCache ring buffer: found 0/1 locked buffers 2025-08-07 13:17:56 0 [Note] WSREP: Recovering GCache ring buffer: free space: 134217560/134217728 2025-08-07 13:17:56 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 100.0% (168/168 bytes) complete. 2025-08-07 13:17:56 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.33.3; 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-08-07 13:17:56 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:56 0 [Note] WSREP: ####### Assign initial position for certification: e7eca07f-7390-11f0-8853-fbf51fa19cfe:1, protocol version: -1 2025-08-07 13:17:56 0 [Note] WSREP: Start replication 2025-08-07 13:17:56 0 [Note] WSREP: Connecting with bootstrap option: 1 2025-08-07 13:17:56 0 [Note] WSREP: Setting GCS initial position to e7eca07f-7390-11f0-8853-fbf51fa19cfe:1 2025-08-07 13:17:56 0 [Note] WSREP: protonet asio version 0 2025-08-07 13:17:56 0 [Note] WSREP: Using CRC-32C for message checksums. 2025-08-07 13:17:56 0 [Note] WSREP: backend: asio 2025-08-07 13:17:56 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2025-08-07 13:17:56 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2025-08-07 13:17:56 0 [Note] WSREP: restore pc from disk failed 2025-08-07 13:17:56 0 [Note] WSREP: GMCast version 0 2025-08-07 13:17:56 0 [Note] WSREP: (eeae816e-b8e5, 'tcp://192.168.33.3:4567') listening at tcp://192.168.33.3:4567 2025-08-07 13:17:56 0 [Note] WSREP: (eeae816e-b8e5, 'tcp://192.168.33.3:4567') multicast: , ttl: 1 2025-08-07 13:17:56 0 [Note] WSREP: EVS version 1 2025-08-07 13:17:56 0 [Note] WSREP: gcomm: bootstrapping new group 'openstack' 2025-08-07 13:17:56 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2025-08-07 13:17:56 0 [Note] WSREP: EVS version upgrade 0 -> 1 2025-08-07 13:17:56 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2025-08-07 13:17:56 0 [Note] WSREP: Node eeae816e-b8e5 state prim 2025-08-07 13:17:56 0 [Note] WSREP: view(view_id(PRIM,eeae816e-b8e5,1) memb { eeae816e-b8e5,0 } joined { } left { } partitioned { }) 2025-08-07 13:17:56 0 [Note] WSREP: save pc into disk 2025-08-07 13:17:56 0 [Note] WSREP: gcomm: connected 2025-08-07 13:17:56 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2025-08-07 13:17:56 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2025-08-07 13:17:56 0 [Note] WSREP: Opened channel 'openstack' 2025-08-07 13:17:56 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2025-08-07 13:17:56 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: eeaed88f-7390-11f0-8528-86fee9da2f44 2025-08-07 13:17:56 0 [Note] WSREP: STATE EXCHANGE: sent state msg: eeaed88f-7390-11f0-8528-86fee9da2f44 2025-08-07 13:17:56 0 [Note] WSREP: STATE EXCHANGE: got state msg: eeaed88f-7390-11f0-8528-86fee9da2f44 from 0 (npbc62486a965f4) 2025-08-07 13:17:56 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 1, last_appl. = 1, protocols = 5/11/4 (gcs/repl/appl), vote policy= 0, group UUID = e7eca07f-7390-11f0-8853-fbf51fa19cfe 2025-08-07 13:17:56 0 [Note] WSREP: Flow-control interval: [16, 16] 2025-08-07 13:17:56 0 [Note] WSREP: Restored state OPEN -> JOINED (2) 2025-08-07 13:17:56 1 [Note] WSREP: Starting rollbacker thread 1 2025-08-07 13:17:56 0 [Note] WSREP: Member 0.0 (npbc62486a965f4) synced with group. 2025-08-07 13:17:56 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2) 2025-08-07 13:17:56 2 [Note] WSREP: Starting applier thread 2 2025-08-07 13:17:56 2 [Note] WSREP: ####### processing CC 2, local, ordered 2025-08-07 13:17:56 2 [Note] WSREP: Process first view: e7eca07f-7390-11f0-8853-fbf51fa19cfe my uuid: eeae816e-7390-11f0-b8e5-7e2ef07a3bdc 2025-08-07 13:17:56 2 [Note] WSREP: Server npbc62486a965f4 connected to cluster at position e7eca07f-7390-11f0-8853-fbf51fa19cfe:2 with ID eeae816e-7390-11f0-b8e5-7e2ef07a3bdc 2025-08-07 13:17:56 2 [Note] WSREP: Server status change disconnected -> connected 2025-08-07 13:17:56 2 [Note] WSREP: ####### My UUID: eeae816e-7390-11f0-b8e5-7e2ef07a3bdc 2025-08-07 13:17:56 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: no 2025-08-07 13:17:56 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:56 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2025-08-07 13:17:56 2 [Note] WSREP: REPL Protocols: 11 (6) 2025-08-07 13:17:56 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 2 2025-08-07 13:17:56 0 [Note] WSREP: Service thread queue flushed. 2025-08-07 13:17:56 2 [Note] WSREP: ================================================ View: id: e7eca07f-7390-11f0-8853-fbf51fa19cfe: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(1): 0: eeae816e-7390-11f0-b8e5-7e2ef07a3bdc, npbc62486a965f4 ================================================= 2025-08-07 13:17:56 2 [Note] WSREP: Server status change connected -> joiner 2025-08-07 13:17:56 2 [Note] WSREP: Server status change joiner -> initializing 2025-08-07 13:17:56 0 [Note] InnoDB: Compressed tables use zlib 1.3 2025-08-07 13:17:56 0 [Note] InnoDB: Number of transaction pools: 1 2025-08-07 13:17:56 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-08-07 13:17:56 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 2025-08-07 13:17:56 0 [Warning] mariadbd: 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 2025-08-07 13:17:56 0 [Note] InnoDB: Using Linux native AIO 2025-08-07 13:17:56 0 [Note] InnoDB: innodb_buffer_pool_size_max=3104m, innodb_buffer_pool_size=3100m 2025-08-07 13:17:56 0 [Note] InnoDB: Completed initialization of buffer pool 2025-08-07 13:17:56 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-08-07 13:17:56 0 [Note] InnoDB: End of log at LSN=55482 2025-08-07 13:17:56 0 [Note] InnoDB: 128 rollback segments are active. 2025-08-07 13:17:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-08-07 13:17:56 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-08-07 13:17:56 0 [Note] InnoDB: log sequence number 55482; transaction id 32 2025-08-07 13:17:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-08-07 13:17:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-08-07 13:17:56 0 [Note] InnoDB: Buffer pool(s) load completed at 250807 13:17:56 2025-08-07 13:17:56 0 [Note] Server socket created on IP: '192.168.33.3', port: '3306'. 2025-08-07 13:17:56 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2025-08-07 13:17:56 0 [Note] WSREP: Server initialized 2025-08-07 13:17:56 0 [Note] WSREP: Server status change initializing -> initialized 2025-08-07 13:17:56 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2025-08-07 13:17:56 6 [Note] WSREP: Recovered cluster id e7eca07f-7390-11f0-8853-fbf51fa19cfe 2025-08-07 13:17:56 8 [Note] WSREP: Starting applier thread 8 2025-08-07 13:17:56 7 [Note] WSREP: Starting applier thread 7 2025-08-07 13:17:56 2 [Note] WSREP: Server status change initialized -> joined 2025-08-07 13:17:56 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2025-08-07 13:17:56 10 [Note] WSREP: Starting applier thread 10 2025-08-07 13:17:56 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.11.14-MariaDB-ubu2404-log' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2025-08-07 13:17:56 2 [Note] WSREP: Lowest cert index boundary for CC from group: 2 2025-08-07 13:17:56 2 [Note] WSREP: Min available from gcache for CC from group: 1 2025-08-07 13:17:56 2 [Note] WSREP: Server npbc62486a965f4 synced with group 2025-08-07 13:17:56 2 [Note] WSREP: Server status change joined -> synced 2025-08-07 13:17:56 2 [Note] WSREP: Synchronized with group, ready for connections 2025-08-07 13:17:56 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2025-08-07 13:17:57 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: 'npbc62486a965f4' (This connection closed normally without authentication) 2025-08-07 13:17:57 13 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:17:59 15 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:17:59 16 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:18:00 18 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:18:01 19 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:18:01 20 [Warning] Access denied for user 'monitor'@'npbc62486a965f4' (using password: YES) 2025-08-07 13:22:23 60 [Warning] WSREP: Ignoring error 'Can't DROP FOREIGN KEY `allocations_ibfk_1`; check that it exists' on query. Default database: 'ironic'. Query: 'ALTER TABLE allocations DROP FOREIGN KEY allocations_ibfk_1', Error_code: 1091 2025-08-07 13:52:43 1156 [Note] WSREP: Desyncing and pausing the provider 2025-08-07 13:52:43 0 [Note] WSREP: Member 0.0 (npbc62486a965f4) desyncs itself from group 2025-08-07 13:52:43 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 3610) 2025-08-07 13:52:43 1156 [Note] WSREP: pause 2025-08-07 13:52:43 1156 [Note] WSREP: Provider paused at e7eca07f-7390-11f0-8853-fbf51fa19cfe:3610 (3645) 2025-08-07 13:52:43 1156 [Note] WSREP: Provider paused at: 3610 2025-08-07 13:52:43 1156 [Note] WSREP: Server desynched from group during BACKUP STAGE BLOCK_DDL. 2025-08-07 13:52:49 1156 [Note] WSREP: Resuming and resyncing the provider 2025-08-07 13:52:49 1156 [Note] WSREP: resume 2025-08-07 13:52:49 1156 [Note] WSREP: resuming provider at 3645 2025-08-07 13:52:49 1156 [Note] WSREP: Provider resumed. 2025-08-07 13:52:49 0 [Note] WSREP: Member 0.0 (npbc62486a965f4) resyncs itself to group. 2025-08-07 13:52:49 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 3617) 2025-08-07 13:52:49 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete. 2025-08-07 13:52:49 0 [Note] WSREP: Member 0.0 (npbc62486a965f4) synced with group. 2025-08-07 13:52:49 0 [Note] WSREP: Processing event queue:... 100.0% (1/1 events) complete. 2025-08-07 13:52:49 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3617) 2025-08-07 13:52:49 7 [Note] WSREP: Server npbc62486a965f4 synced with group 2025-08-07 13:52:49 1156 [Warning] Aborted connection 1156 to db: 'unconnected' user: 'backup_shard_0' host: 'npbc62486a965f4' (Got an error reading communication packets) 2025-08-07 13:52:49 1157 [Warning] Aborted connection 1157 to db: 'unconnected' user: 'backup_shard_0' host: 'npbc62486a965f4' (Got an error reading communication packets) 2025-08-07 13:52:49 1155 [Warning] Aborted connection 1155 to db: 'unconnected' user: 'backup_shard_0' host: 'npbc62486a965f4' (Got an error reading communication packets)