+ trap exit SIGTERM + '[' m = - ']' + CFG=/etc/mysql/node.cnf + wantHelp= + for arg in "$@" + case "$arg" in ++ mysqld -V ++ awk '{print $3}' ++ awk -F. '{print $1"."$2}' + MYSQL_VERSION=8.0 ++ mysqld -V ++ awk '{print $3}' ++ awk -F. '{print $3}' ++ awk -F- '{print $1}' + MYSQL_PATCH_VERSION=42 + vault_secret=/etc/mysql/vault-keyring-secret/keyring_vault.conf + '[' -f /etc/mysql/vault-keyring-secret/keyring_vault.conf ']' + '[' 8.0 == 8.0 ']' + sed -i '/\[mysqld\]/a plugin_load="binlog_utils_udf=binlog_utils_udf.so"' /etc/mysql/node.cnf + [[ 8.0 =~ ^(8\.0|8\.4)$ ]] + sed -i '/\[mysqld\]/a gtid-mode=ON' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a enforce-gtid-consistency' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a wsrep_notify_cmd=/var/lib/mysql/wsrep_cmd_notify_handler.sh' /etc/mysql/node.cnf + grep -q '^progress=' /etc/mysql/node.cnf + sed -i 's|^progress=.*|progress=1|' /etc/mysql/node.cnf + grep -q '^\[sst\]' /etc/mysql/node.cnf + grep -q '^cpat=' /etc/mysql/node.cnf + sed '/^\[sst\]/a cpat=.*\\.pem$\\|.*init\\.ok$\\|.*galera\\.cache$\\|.*wsrep_recovery_verbose\\.log$\\|.*readiness-check\\.sh$\\|.*liveness-check\\.sh$\\|.*get-pxc-state$\\|.*sst_in_progress$\\|.*sleep-forever$\\|.*pmm-prerun\\.sh$\\|.*sst-xb-tmpdir$\\|.*\\.sst$\\|.*gvwstate\\.dat$\\|.*grastate\\.dat$\\|.*\\.err$\\|.*\\.log$\\|.*RPM_UPGRADE_MARKER$\\|.*RPM_UPGRADE_HISTORY$\\|.*pxc-entrypoint\\.sh$\\|.*unsafe-bootstrap\\.sh$\\|.*pxc-configure-pxc\\.sh\\|.*peer-list$\\|.*auth_plugin$\\|.*version_info$\\|.*mysql-state-monitor$\\|.*mysql-state-monitor\\.log$\\|.*notify\\.sock$\\|.*mysql\\.state$\\|.*wsrep_cmd_notify_handler\\.sh$' /etc/mysql/node.cnf + [[ 8.0 == \8\.\0 ]] + [[ 42 -ge 26 ]] + grep -q '^skip_replica_start=ON' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a skip_replica_start=ON' /etc/mysql/node.cnf + auth_plugin=caching_sha2_password + [[ -f /var/lib/mysql/auth_plugin ]] + [[ -z caching_sha2_password ]] + [[ 8.0 == \5\.\7 ]] + echo caching_sha2_password + sed -i /default_authentication_plugin/d /etc/mysql/node.cnf + [[ 8.0 == \8\.\0 ]] + [[ 42 -ge 27 ]] + sed -i '/\[mysqld\]/a authentication_policy=caching_sha2_password,,' /etc/mysql/node.cnf + file_env XTRABACKUP_PASSWORD xtrabackup xtrabackup Percona XtraDB Cluster: Finding peers 2026/05/14 05:05:23 Peer finder enter 2026/05/14 05:05:23 Determined Domain to be openstack.svc.cluster.local 2026/05/14 05:05:23 Peer list updated was [] now [10-0-0-217.percona-xtradb-pxc-unready.openstack.svc.cluster.local] 2026/05/14 05:05:23 execing: /var/lib/mysql/pxc-configure-pxc.sh with stdin: 10-0-0-217.percona-xtradb-pxc-unready.openstack.svc.cluster.local 2026/05/14 05:05:23 ++ hostname -I ++ awk ' { print $1 } ' + NODE_IP=10.0.0.217 ++ hostname -f ++ cut -d. -f2 + CLUSTER_NAME=percona-xtradb-pxc + SERVER_NUM=0 + SERVER_ID=19395750 ++ hostname -f + NODE_NAME=percona-xtradb-pxc-0.percona-xtradb-pxc.openstack.svc.cluster.local + NODE_PORT=3306 + read -ra LINE + echo 'read line 10-0-0-217.percona-xtradb-pxc-unready.openstack.svc.cluster.local' read line 10-0-0-217.percona-xtradb-pxc-unready.openstack.svc.cluster.local ++ getent hosts 10-0-0-217.percona-xtradb-pxc-unready.openstack.svc.cluster.local ++ awk '{ print $1 }' + LINE_IP=10.0.0.217 + '[' 10.0.0.217 '!=' 10.0.0.217 ']' + read -ra LINE + '[' 0 '!=' 0 ']' + '[' 0 '!=' 0 ']' + CFG=/etc/mysql/node.cnf ++ mysqld -V ++ awk '{print $3}' ++ awk -F. '{print $1"."$2}' + MYSQL_VERSION=8.0 + [[ 8.0 =~ ^(8\.0|8\.4)$ ]] + grep -E -q '^[#]?admin-address' /etc/mysql/node.cnf + sed '/^\[mysqld\]/a admin-address=\n' /etc/mysql/node.cnf + grep -E -q '^[#]?log_error_suppression_list' /etc/mysql/node.cnf + sed '/^\[mysqld\]/a log_error_suppression_list="MY-010055"\n' /etc/mysql/node.cnf + '[' '' == yes ']' + grep -E -q '^[#]?wsrep_sst_donor' /etc/mysql/node.cnf + sed '/^\[mysqld\]/a wsrep_sst_donor=\n' /etc/mysql/node.cnf + grep -E -q '^[#]?wsrep_node_incoming_address' /etc/mysql/node.cnf + grep -E -q '^[#]?wsrep_provider_options' /etc/mysql/node.cnf + sed '/^\[mysqld\]/a wsrep_provider_options="pc.weight=10"\n' /etc/mysql/node.cnf + sed -r 's|^[#]?server_id=.*$|server_id=19395750|' /etc/mysql/node.cnf + sed -r 's|^[#]?coredumper$|coredumper|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_node_address=.*$|wsrep_node_address=10.0.0.217|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_cluster_name=.*$|wsrep_cluster_name=percona-xtradb-pxc|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_sst_donor=.*$|wsrep_sst_donor=|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_cluster_address=.*$|wsrep_cluster_address=gcomm://|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_node_incoming_address=.*$|wsrep_node_incoming_address=percona-xtradb-pxc-0.percona-xtradb-pxc.openstack.svc.cluster.local:3306|' /etc/mysql/node.cnf + sed -r 's|^[#]?admin-address=.*$|admin-address=10.0.0.217|' /etc/mysql/node.cnf + sed -r 's|^[#]?extra_max_connections=.*$|extra_max_connections=100|' /etc/mysql/node.cnf + sed -r 's|^[#]?extra_port=.*$|extra_port=33062|' /etc/mysql/node.cnf + CA=/var/run/secrets/kubernetes.io/serviceaccount/ca.crt + '[' -f /var/run/secrets/kubernetes.io/serviceaccount/service-ca.crt ']' + SSL_DIR=/etc/mysql/ssl + '[' -f /etc/mysql/ssl/ca.crt ']' + SSL_INTERNAL_DIR=/etc/mysql/ssl-internal + '[' -f /etc/mysql/ssl-internal/ca.crt ']' + KEY=/etc/mysql/ssl/tls.key + CERT=/etc/mysql/ssl/tls.crt + '[' -f /etc/mysql/ssl-internal/tls.key -a -f /etc/mysql/ssl-internal/tls.crt ']' + '[' -f /var/run/secrets/kubernetes.io/serviceaccount/ca.crt -a -f /etc/mysql/ssl/tls.key -a -f /etc/mysql/ssl/tls.crt ']' + sed '/^\[mysqld\]/a pxc-encrypt-cluster-traffic=OFF' /etc/mysql/node.cnf 2026/05/14 05:05:24 Peer finder exiting Cluster address set to: + mkdir -p /var/lib/mysql/ ++ _get_cnf_config sst cpat ++ local group=sst ++ local var=cpat ++ local reval= +++ my_print_defaults sst +++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' +++ grep -- --cpat= +++ cut -d= -f2- +++ tail -1 ++ reval='.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$' ++ [[ -z .*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$ ]] ++ echo '.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$' + cpat='.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$' + find /var/lib/mysql/ -mindepth 1 -regex '.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$' -prune -o -exec rm -rfv '{}' + + echo 'Initializing database' + [[ 8.0 == \8\.\4 ]] + mysqld --initialize-insecure --skip-ssl --datadir=/var/lib/mysql//sst-xb-tmpdir Initializing database 2026-05-14T05:05:24.239573Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2026-05-14T05:05:24.239586Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2026-05-14T05:05:24.239604Z 0 [Warning] [MY-011068] [Server] The syntax 'wsrep_slave_threads' is deprecated and will be removed in a future release. Please use wsrep_applier_threads instead. 2026-05-14T05:05:24.239630Z 0 [Warning] [MY-011068] [Server] The syntax '--ssl=off' is deprecated and will be removed in a future release. Please use --tls-version='' instead. 2026-05-14T05:05:24.239690Z 0 [Warning] [MY-000000] [WSREP] Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks 2026-05-14T05:05:24.240536Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42-33.1) initializing of server in progress as process 132 2026-05-14T05:05:24.242423Z 0 [Note] [MY-000000] [Galera] Loading provider none initial position: 00000000-0000-0000-0000-000000000000:-1 2026-05-14T05:05:24.242441Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library 'none' 2026-05-14T05:05:24.242455Z 0 [Note] [MY-000000] [Galera] Symbol 'wsrep_node_isolation_mode_set_v1' not found from provider 2026-05-14T05:05:24.242463Z 0 [Note] [MY-000000] [Galera] Symbol 'wsrep_certify_v1' not found from provider 2026-05-14T05:05:24.302888Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-05-14T05:05:52.188909Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-05-14T05:05:58.549612Z 0 [Warning] [MY-013501] [Server] Ignoring --plugin-load[_add] list as the server is running with --initialize(-insecure). 2026-05-14T05:06:06.970748Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. + mv /var/lib/mysql//sst-xb-tmpdir/#ib_16384_0.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_1.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_10.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_11.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_12.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_13.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_14.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_15.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_2.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_3.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_4.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_5.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_6.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_7.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_8.dblwr /var/lib/mysql//sst-xb-tmpdir/#ib_16384_9.dblwr /var/lib/mysql//sst-xb-tmpdir/#innodb_redo /var/lib/mysql//sst-xb-tmpdir/#innodb_temp /var/lib/mysql//sst-xb-tmpdir/auto.cnf /var/lib/mysql//sst-xb-tmpdir/ib_buffer_pool /var/lib/mysql//sst-xb-tmpdir/ibdata1 /var/lib/mysql//sst-xb-tmpdir/mysql /var/lib/mysql//sst-xb-tmpdir/mysql.ibd /var/lib/mysql//sst-xb-tmpdir/performance_schema /var/lib/mysql//sst-xb-tmpdir/private_key.pem /var/lib/mysql//sst-xb-tmpdir/public_key.pem /var/lib/mysql//sst-xb-tmpdir/sys /var/lib/mysql//sst-xb-tmpdir/undo_001 /var/lib/mysql//sst-xb-tmpdir/undo_002 /var/lib/mysql// + rm -rfv /var/lib/mysql//sst-xb-tmpdir removed directory '/var/lib/mysql//sst-xb-tmpdir' Database initialized + echo 'Database initialized' + echo caching_sha2_password ++ _get_config socket mysqld ++ local conf=socket ++ shift ++ awk '$1 == "socket" && /^[^ \t]/ { sub(/^[^ \t]+[ \t]+/, ""); print; exit }' +++ mktemp -u ++ mysqld --verbose --help --wsrep-provider=none --log-bin-index=/tmp/tmp.ZlhDz7n5gG + SOCKET=/tmp/mysql.sock + pid=266 + mysql=(mysql --protocol=socket -uroot -hlocalhost --socket="${SOCKET}" --password="") + mysqld --skip-networking --socket=/tmp/mysql.sock + wsrep_local_state_select='SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 2026-05-14T05:06:27.797268Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2026-05-14T05:06:27.797282Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2026-05-14T05:06:27.797299Z 0 [Warning] [MY-011068] [Server] The syntax 'wsrep_slave_threads' is deprecated and will be removed in a future release. Please use wsrep_applier_threads instead. 2026-05-14T05:06:27.798237Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2026-05-14T05:06:27.798819Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.42-33.1) starting as process 266 2026-05-14T05:06:27.800390Z 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib64/galera4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2026-05-14T05:06:27.800407Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library '/usr/lib64/galera4/libgalera_smm.so' 2026-05-14T05:06:27.800918Z 0 [Note] [MY-000000] [Galera] wsrep_load(): Galera 4.22(f6c0465) by Codership Oy (modified by Percona ) loaded successfully. 2026-05-14T05:06:27.800935Z 0 [Note] [MY-000000] [Galera] Resolved symbol 'wsrep_node_isolation_mode_set_v1' 2026-05-14T05:06:27.800940Z 0 [Note] [MY-000000] [Galera] Resolved symbol 'wsrep_certify_v1' 2026-05-14T05:06:27.800958Z 0 [Note] [MY-000000] [Galera] CRC-32C: using 64-bit x86 acceleration. 2026-05-14T05:06:27.801146Z 0 [Warning] [MY-000000] [Galera] Could not open state file for reading: '/var/lib/mysql//grastate.dat' 2026-05-14T05:06:27.801162Z 0 [Warning] [MY-000000] [Galera] No persistent state found. Bootstraping with default state 2026-05-14T05:06:27.801190Z 0 [Note] [MY-000000] [Galera] Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2026-05-14T05:06:27.801428Z 0 [Note] [MY-000000] [Galera] Generated new GCache ID: a9b053f0-4f52-11f1-8ba1-a74bb536bd54 2026-05-14T05:06:27.801447Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 EncVersion: 0 Encrypted: 0 MasterKeyConst UUID: a9b053f0-4f52-11f1-8ba1-a74bb536bd54 MasterKey UUID: 00000000-0000-0000-0000-000000000000 MasterKey ID: 0 2026-05-14T05:06:27.801452Z 0 [Note] [MY-000000] [Galera] Skipped GCache ring buffer recovery: could not determine history UUID. 2026-05-14T05:06:28.012190Z 0 [Note] [MY-000000] [Galera] Passing config to GCS: allocator.disk_pages_encryption = no; allocator.encryption_cache_page_size = 32K; allocator.encryption_cache_size = 16777216; base_dir = /var/lib/mysql/; base_host = 10.0.0.217; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = no; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.encryption = no; gcache.encryption_cache_page_size = 32K; gcache.encryption_cache_size = 16777216; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_auto_evict_threshold = 0.75; gcs.fc_auto_evict_window = 0; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 100; 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.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.wait_restored_prim_timeout = PT0S; pc.weight = 10; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 11; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto; 2026-05-14T05:06:28.020923Z 0 [Note] [MY-000000] [WSREP] Starting replication 2026-05-14T05:06:28.021005Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 1 2026-05-14T05:06:28.021020Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2026-05-14T05:06:28.021066Z 0 [Note] [MY-000000] [Galera] protonet asio version 0 2026-05-14T05:06:28.021125Z 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2026-05-14T05:06:28.021141Z 0 [Note] [MY-000000] [Galera] backend: asio 2026-05-14T05:06:28.021234Z 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2026-05-14T05:06:28.021568Z 0 [Note] [MY-000000] [Galera] Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown 2026-05-14T05:06:28.021627Z 0 [Note] [MY-000000] [Galera] Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2026-05-14T05:06:28.021965Z 0 [Note] [MY-000000] [Galera] GMCast version 0 2026-05-14T05:06:28.022113Z 0 [Note] [MY-000000] [Galera] (a9d1f06e-9fe2, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2026-05-14T05:06:28.022133Z 0 [Note] [MY-000000] [Galera] (a9d1f06e-9fe2, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2026-05-14T05:06:28.022617Z 0 [Note] [MY-000000] [Galera] EVS version 1 2026-05-14T05:06:28.022721Z 0 [Note] [MY-000000] [Galera] gcomm: bootstrapping new group 'percona-xtradb-pxc' 2026-05-14T05:06:28.022833Z 0 [Note] [MY-000000] [Galera] start_prim is enabled, turn off pc_recovery 2026-05-14T05:06:28.023070Z 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 -> 1 2026-05-14T05:06:28.023117Z 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 -> 1 2026-05-14T05:06:28.023150Z 0 [Note] [MY-000000] [Galera] Node a9d1f06e-9fe2 state primary 2026-05-14T05:06:28.023190Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(PRIM,a9d1f06e-9fe2,1) memb { a9d1f06e-9fe2,0 } joined { } left { } partitioned { } ) 2026-05-14T05:06:28.023214Z 0 [Note] [MY-000000] [Galera] Save the discovered primary-component to disk 2026-05-14T05:06:28.029319Z 0 [Note] [MY-000000] [Galera] gcomm: connected 2026-05-14T05:06:28.029422Z 0 [Note] [MY-000000] [Galera] Changing maximum packet size to 64500, resulting msg size: 32636 2026-05-14T05:06:28.029546Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> OPEN (TO: 0) 2026-05-14T05:06:28.029557Z 0 [Note] [MY-000000] [Galera] Opened channel 'percona-xtradb-pxc' 2026-05-14T05:06:28.029648Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2026-05-14T05:06:28.029801Z 0 [Note] [MY-000000] [Galera] Starting new group from scratch: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d 2026-05-14T05:06:28.029869Z 0 [Note] [MY-000000] [Galera] STATE_EXCHANGE: sent state UUID: a9d32eaf-4f52-11f1-bb30-dfca253a350f 2026-05-14T05:06:28.029890Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: sent state msg: a9d32eaf-4f52-11f1-bb30-dfca253a350f 2026-05-14T05:06:28.029910Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: a9d32eaf-4f52-11f1-bb30-dfca253a350f from 0 (percona-xtradb-pxc-0) 2026-05-14T05:06:28.029933Z 0 [Note] [MY-000000] [Galera] Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (primary/total), act_id = 0, last_appl. = 0, protocols = 5/11/4 (gcs/repl/appl), vote policy= 0, group UUID = a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d 2026-05-14T05:06:28.029971Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100] 2026-05-14T05:06:28.029985Z 0 [Note] [MY-000000] [Galera] Restored state OPEN -> JOINED (1) 2026-05-14T05:06:28.030004Z 0 [Note] [MY-000000] [Galera] Member 0.0 (percona-xtradb-pxc-0) synced with group. 2026-05-14T05:06:28.030015Z 0 [Note] [MY-000000] [Galera] Shifting JOINED -> SYNCED (TO: 1) 2026-05-14T05:06:28.030026Z 2 [Note] [MY-000000] [WSREP] Starting rollbacker thread 2 2026-05-14T05:06:28.030103Z 1 [Note] [MY-000000] [WSREP] Starting applier thread 1 2026-05-14T05:06:28.030180Z 1 [Note] [MY-000000] [Galera] ####### processing CC 1, local, ordered 2026-05-14T05:06:28.030199Z 1 [Note] [MY-000000] [Galera] Maybe drain monitors from -1 upto current CC event 1 upto:-1 2026-05-14T05:06:28.030208Z 1 [Note] [MY-000000] [Galera] Drain monitors from -1 up to -1 2026-05-14T05:06:28.030225Z 1 [Note] [MY-000000] [Galera] Process first view: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d my uuid: a9d1f06e-4f52-11f1-9fe2-0259defc7f0a 2026-05-14T05:06:28.030244Z 1 [Note] [MY-000000] [Galera] Server percona-xtradb-pxc-0 connected to cluster at position a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:1 with ID a9d1f06e-4f52-11f1-9fe2-0259defc7f0a 2026-05-14T05:06:28.030253Z 1 [Note] [MY-000000] [WSREP] Server status change disconnected -> connected 2026-05-14T05:06:28.043003Z 1 [Note] [MY-000000] [Galera] ####### My UUID: a9d1f06e-4f52-11f1-9fe2-0259defc7f0a 2026-05-14T05:06:28.043043Z 1 [Note] [MY-000000] [Galera] Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: no 2026-05-14T05:06:28.043241Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:06:28.043305Z 1 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2026-05-14T05:06:28.043321Z 1 [Note] [MY-000000] [Galera] REPL Protocols: 11 (6) 2026-05-14T05:06:28.043330Z 1 [Note] [MY-000000] [Galera] ####### Adjusting cert position: -1 -> 1 2026-05-14T05:06:28.043403Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:06:28.051776Z 1 [Note] [MY-000000] [Galera] GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:0 2026-05-14T05:06:28.115151Z 1 [Note] [MY-000000] [Galera] ================================================ View: id: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d: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: a9d1f06e-4f52-11f1-9fe2-0259defc7f0a, percona-xtradb-pxc-0 ================================================= 2026-05-14T05:06:28.115195Z 1 [Note] [MY-000000] [WSREP] Server status change connected -> joiner 2026-05-14T05:06:28.134742Z 1 [Note] [MY-000000] [WSREP] Server status change joiner -> initializing 2026-05-14T05:06:28.210005Z 3 [System] [MY-013576] [InnoDB] InnoDB initialization has started. + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 2026-05-14T05:06:33.808256Z 3 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-05-14T05:06:34.585776Z 3 [Note] [MY-000000] [WSREP] wsrep_init_schema_and_SR (nil) + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 2026-05-14T05:06:36.275915Z 3 [System] [MY-000000] [WSREP] PXC upgrade completed successfully + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 2026-05-14T05:06:50.714241Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-05-14T05:06:50.714308Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-05-14T05:06:50.729048Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_admin. See below for the description of exact issue. 2026-05-14T05:06:50.729066Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2026-05-14T05:06:50.729072Z 0 [System] [MY-013603] [Server] No TLS configuration was given for channel mysql_admin; re-using TLS configuration of channel mysql_main. + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state= + true + '[' '' = Synced ']' + echo 'MySQL init process in progress...' MySQL init process in progress... + sleep 1 2026-05-14T05:06:51.006285Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/lib/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2026-05-14T05:06:51.115864Z 0 [Note] [MY-000000] [WSREP] Initialized wsrep sidno 2 2026-05-14T05:06:51.115909Z 0 [Note] [MY-000000] [Galera] Server initialized 2026-05-14T05:06:51.115921Z 0 [Note] [MY-000000] [WSREP] Server status change initializing -> initialized 2026-05-14T05:06:51.128009Z 1 [Note] [MY-000000] [Galera] Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2026-05-14T05:06:51.436803Z 11 [Note] [MY-000000] [WSREP] Starting applier thread 11 2026-05-14T05:06:51.439022Z 9 [Note] [MY-000000] [WSREP] Cluster table is empty, not recovering transactions 2026-05-14T05:06:51.439146Z 1 [Note] [MY-000000] [WSREP] Server status change initialized -> joined 2026-05-14T05:06:51.439656Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/lib/mysql/mysqlx.sock 2026-05-14T05:06:51.439824Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.42-33.1' socket: '/tmp/mysql.sock' port: 0 Percona XtraDB Cluster (GPL), Release rel33, Revision 6673f8e, WSREP version 26.1.4.3. 2026-05-14T05:06:51.882410Z 1 [Note] [MY-000000] [Galera] Recording CC from group: 1 2026-05-14T05:06:51.882507Z 1 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 1 2026-05-14T05:06:51.882534Z 1 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1 2026-05-14T05:06:51.882650Z 1 [Note] [MY-000000] [Galera] Server percona-xtradb-pxc-0 synced with group 2026-05-14T05:06:51.882675Z 1 [Note] [MY-000000] [WSREP] Server status change joined -> synced 2026-05-14T05:06:51.882685Z 1 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s + wsrep_local_state=Synced + '[' Synced = Synced ']' + break + '[' 96 = 0 ']' + '[' -z '' ']' + echo 'set wsrep_on=0;' + echo 'SET @@SESSION.SQL_LOG_BIN = off;' + mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= mysql + mysql_tzinfo_to_sql /usr/share/zoneinfo + sed 's/Local time zone must be set--see zic manual page/FCTY/' mysql: [Warning] Using a password on the command line interface can be insecure. 2026-05-14T05:06:51.943686Z 14 [Warning] [MY-000000] [WSREP] Toggling wsrep_on to OFF will affect sql_log_bin. Check manual for more details Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. + echo 'set wsrep_on=1;' 2026-05-14T05:06:56.161360Z 14 [Warning] [MY-000000] [WSREP] Toggling wsrep_on to ON will affect sql_log_bin. Check manual for more details mysql: [Warning] Using a password on the command line interface can be insecure. + file_env MYSQL_DATABASE + echo + ls /docker-entrypoint-initdb.d/ + kill -s TERM 266 2026-05-14T05:07:00.028448Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.42-33.1). 2026-05-14T05:07:00.028600Z 0 [Note] [MY-000000] [WSREP] Received shutdown signal. Will sleep for 10 secs before initiating shutdown. pxc_maint_mode switched to SHUTDOWN + wait 266 2026-05-14T05:07:10.030363Z 0 [Note] [MY-000000] [WSREP] Shutdown replication 2026-05-14T05:07:10.031643Z 0 [Note] [MY-000000] [WSREP] Server status change synced -> disconnecting 2026-05-14T05:07:10.043079Z 0 [Note] [MY-000000] [Galera] Closing send monitor... 2026-05-14T05:07:10.043287Z 0 [Note] [MY-000000] [Galera] Closed send monitor. 2026-05-14T05:07:10.043400Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread 2026-05-14T05:07:10.043457Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread 2026-05-14T05:07:10.043591Z 0 [Note] [MY-000000] [Galera] gcomm: closing backend 2026-05-14T05:07:10.043699Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 -> 0 2026-05-14T05:07:10.043761Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 2026-05-14T05:07:10.044053Z 0 [Note] [MY-000000] [Galera] gcomm: closed 2026-05-14T05:07:10.044191Z 0 [Note] [MY-000000] [Galera] New SELF-LEAVE. 2026-05-14T05:07:10.044284Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [0, 0] 2026-05-14T05:07:10.044335Z 0 [Note] [MY-000000] [Galera] Received SELF-LEAVE. Closing connection. 2026-05-14T05:07:10.044354Z 0 [Note] [MY-000000] [Galera] Shifting SYNCED -> CLOSED (TO: 20) 2026-05-14T05:07:10.044403Z 0 [Note] [MY-000000] [Galera] RECV thread exiting 0: Success 2026-05-14T05:07:10.044547Z 11 [Note] [MY-000000] [Galera] Maybe drain monitors from 20 upto current CC event 20 upto:20 2026-05-14T05:07:10.044626Z 11 [Note] [MY-000000] [Galera] Drain monitors from 20 up to 20 2026-05-14T05:07:10.044728Z 11 [Note] [MY-000000] [Galera] ================================================ View: id: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 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-05-14T05:07:10.044853Z 11 [Note] [MY-000000] [Galera] Non-primary view 2026-05-14T05:07:10.044958Z 11 [Note] [MY-000000] [WSREP] Server status change disconnecting -> disconnected 2026-05-14T05:07:10.045193Z 0 [Note] [MY-000000] [Galera] recv_thread() joined. 2026-05-14T05:07:10.045327Z 0 [Note] [MY-000000] [Galera] Closing send queue. 2026-05-14T05:07:10.045415Z 0 [Note] [MY-000000] [Galera] Closing receive queue. 2026-05-14T05:07:10.074788Z 1 [Note] [MY-000000] [Galera] Slave thread exit. Return code: 6 2026-05-14T05:07:10.074842Z 1 [Note] [MY-000000] [WSREP] Applier thread exiting ret: 6 thd: 1 2026-05-14T05:07:10.615134Z 11 [Note] [MY-000000] [Galera] Slave thread exit. Return code: 0 2026-05-14T05:07:10.615192Z 11 [Note] [MY-000000] [WSREP] Applier thread exiting ret: 0 thd: 11 2026-05-14T05:07:10.615446Z 0 [Note] [MY-000000] [WSREP] Waiting for active wsrep applier to exit 2026-05-14T05:07:10.615492Z 0 [Note] [MY-000000] [WSREP] All applier thread terminated. Will now terminate rollback thread 2026-05-14T05:07:10.615532Z 0 [Note] [MY-000000] [WSREP] Waiting for rollback thread to terminate 2026-05-14T05:07:10.615651Z 2 [Note] [MY-000000] [WSREP] rollbacker thread exiting 2 2026-05-14T05:07:11.615647Z 0 [Note] [MY-000000] [WSREP] Rollback thread terminated 2026-05-14T05:07:11.616453Z 0 [Note] [MY-000000] [Galera] dtor state: CLOSED 2026-05-14T05:07:11.616536Z 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 19, in use: 19, in pool: 0 2026-05-14T05:07:11.620557Z 0 [Note] [MY-000000] [Galera] mon: entered 19 oooe fraction 0 oool fraction 0 2026-05-14T05:07:11.623479Z 0 [Note] [MY-000000] [Galera] mon: entered 19 oooe fraction 0 oool fraction 0 2026-05-14T05:07:11.625010Z 0 [Note] [MY-000000] [Galera] mon: entered 22 oooe fraction 0 oool fraction 0 2026-05-14T05:07:11.625044Z 0 [Note] [MY-000000] [Galera] cert index usage at exit 5 2026-05-14T05:07:11.625060Z 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 19 2026-05-14T05:07:11.625075Z 0 [Note] [MY-000000] [Galera] deps set usage at exit 0 2026-05-14T05:07:11.625090Z 0 [Note] [MY-000000] [Galera] avg deps dist 1 2026-05-14T05:07:11.625104Z 0 [Note] [MY-000000] [Galera] avg cert interval 0 2026-05-14T05:07:11.625141Z 0 [Note] [MY-000000] [Galera] cert index size 5 2026-05-14T05:07:11.625268Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:07:11.625346Z 0 [Note] [MY-000000] [Galera] wsdb trx map usage 0 conn query map usage 0 2026-05-14T05:07:11.625370Z 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0.947368, misses: 1, in use: 0, in pool: 1 2026-05-14T05:07:11.675685Z 0 [Note] [MY-000000] [Galera] Flushing memory map to disk... 2026-05-14T05:07:14.614581Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42-33.1) Percona XtraDB Cluster (GPL), Release rel33, Revision 6673f8e, WSREP version 26.1.4.3. MySQL init process done. Ready for start up. + echo + echo 'MySQL init process done. Ready for start up.' + echo + '[' -n '' ']' + '[' mysqld = mysqld ']' + '[' -z '' ']' + _check_config mysqld + toRun=("$@" --verbose --help --wsrep-provider='none') ++ mysqld --verbose --help --wsrep-provider=none + errors= ++ _get_config datadir mysqld ++ local conf=datadir ++ shift ++ awk '$1 == "datadir" && /^[^ \t]/ { sub(/^[^ \t]+[ \t]+/, ""); print; exit }' +++ mktemp -u ++ mysqld --verbose --help --wsrep-provider=none --log-bin-index=/tmp/tmp.y6MbGnEjTv + DATADIR=/var/lib/mysql/ ++ _get_cnf_config sst tmpdir /var/lib/mysql//sst-xb-tmpdir ++ local group=sst ++ local var=tmpdir ++ local reval= +++ my_print_defaults sst +++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' +++ grep -- --tmpdir= +++ tail -1 +++ cut -d= -f2- ++ reval= ++ [[ -z '' ]] ++ reval=/var/lib/mysql//sst-xb-tmpdir ++ echo /var/lib/mysql//sst-xb-tmpdir + SST_DIR=/var/lib/mysql//sst-xb-tmpdir ++ _get_cnf_config sst progress /var/lib/mysql//sst_in_progress ++ local group=sst ++ local var=progress ++ local reval= +++ my_print_defaults sst +++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' +++ grep -- --progress= +++ cut -d= -f2- +++ tail -1 ++ reval=1 ++ [[ -z 1 ]] ++ echo 1 + SST_P_FILE=1 + rm -rvf /var/lib/mysql//sst-xb-tmpdir 1 + mysqld --version + sed s/-ps// + awk '{print $3}' + tee /tmp/version_info 8.0.42-33.1 + pxc_version_file= + pxc_version= + '[' -f /var/lib/mysql//version_info ']' + '[' -f /var/lib/mysql//xtrabackup_info ']' + [[ -f '' ]] + mysqld --version + sed s/-ps// + grep -v wsrep_sst_auth /etc/mysql/node.cnf [mysqld] pxc-encrypt-cluster-traffic=OFF wsrep_provider_options="pc.weight=10" wsrep_sst_donor= log_error_suppression_list="MY-010055" admin-address=10.0.0.217 authentication_policy=caching_sha2_password,, skip_replica_start=ON wsrep_notify_cmd=/var/lib/mysql/wsrep_cmd_notify_handler.sh enforce-gtid-consistency gtid-mode=ON plugin_load="binlog_utils_udf=binlog_utils_udf.so" datadir=/var/lib/mysql socket=/tmp/mysql.sock skip-host-cache coredumper server_id=19395750 binlog_format=ROW default_storage_engine=InnoDB innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_file_per_table = 1 innodb_autoinc_lock_mode=2 bind_address = 0.0.0.0 wsrep_slave_threads=2 wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib64/galera4/libgalera_smm.so wsrep_cluster_name=percona-xtradb-pxc wsrep_node_address=10.0.0.217 wsrep_node_incoming_address=percona-xtradb-pxc-0.percona-xtradb-pxc.openstack.svc.cluster.local:3306 wsrep_sst_method=xtrabackup-v2 [client] socket=/tmp/mysql.sock [sst] cpat=.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*sleep-forever$\|.*pmm-prerun\.sh$\|.*sst-xb-tmpdir$\|.*\.sst$\|.*gvwstate\.dat$\|.*grastate\.dat$\|.*\.err$\|.*\.log$\|.*RPM_UPGRADE_MARKER$\|.*RPM_UPGRADE_HISTORY$\|.*pxc-entrypoint\.sh$\|.*unsafe-bootstrap\.sh$\|.*pxc-configure-pxc\.sh\|.*peer-list$\|.*auth_plugin$\|.*version_info$\|.*mysql-state-monitor$\|.*mysql-state-monitor\.log$\|.*notify\.sock$\|.*mysql\.state$\|.*wsrep_cmd_notify_handler\.sh$ progress=1 ++ cat /var/run/secrets/kubernetes.io/serviceaccount/namespace + POD_NAMESPACE=openstack + wsrep_start_position_opt= + '[' mysqld = mysqld ']' + '[' -z '' ']' ++ _get_config datadir mysqld ++ local conf=datadir ++ shift ++ awk '$1 == "datadir" && /^[^ \t]/ { sub(/^[^ \t]+[ \t]+/, ""); print; exit }' +++ mktemp -u ++ mysqld --verbose --help --wsrep-provider=none --log-bin-index=/tmp/tmp.dfKwA2cENZ + DATADIR=/var/lib/mysql/ + grastate_loc=/var/lib/mysql//grastate.dat + wsrep_verbose_logfile=/var/lib/mysql//wsrep_recovery_verbose.log + '[' -f /var/lib/mysql//wsrep_recovery_verbose.log ']' + '[' -s /var/lib/mysql//grastate.dat ']' + '[' -d /var/lib/mysql//mysql ']' ++ grep uuid: /var/lib/mysql//grastate.dat ++ tr -d ' ' ++ cut -d: -f2 + uuid=a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d ++ grep seqno: /var/lib/mysql//grastate.dat ++ cut -d: -f2 ++ tr -d ' ' + seqno=20 ++ grep safe_to_bootstrap: /var/lib/mysql//grastate.dat ++ cut -d: -f2 ++ tr -d ' ' + safe_to_bootstrap=1 + '[' -n 20 ']' + '[' 20 -ne -1 ']' + echo 'Skipping wsrep-recover for a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 pair' + echo 'Assigning a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 to wsrep_start_position' + wsrep_start_position_opt=--wsrep_start_position=a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 + '[' -z --wsrep_start_position=a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 ']' + '[' -n percona-xtradb-pxc-unready ']' Skipping wsrep-recover for a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 pair Assigning a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 to wsrep_start_position ++ get_primary ++ /var/lib/mysql/peer-list -on-start=/var/lib/mysql/get-pxc-state -service=percona-xtradb-pxc-unready -protocol= ++ grep wsrep_ready:ON:wsrep_connected:ON:wsrep_local_state_comment:Synced:wsrep_cluster_status:Primary ++ sort ++ tail -1 ++ true + is_primary_exists= + is_manual_recovery + set +o xtrace + [[ -z '' ]] + [[ -f /var/lib/mysql//grastate.dat ]] + [[ 1 != 1 ]] + [[ -z '' ]] + [[ -f /var/lib/mysql//gvwstate.dat ]] + [[ -z '' ]] + [[ -f /var/lib/mysql//grastate.dat ]] + [[ 1 == 1 ]] + [[ -n '' ]] + test -e /opt/percona/hookscript/hook.sh + init_opt= + [[ -f /etc/mysql/init-file/init.sql ]] + exec mysqld --wsrep_start_position=a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 2026-05-14T05:07:26.292188Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2026-05-14T05:07:26.292201Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2026-05-14T05:07:26.292217Z 0 [Warning] [MY-011068] [Server] The syntax 'wsrep_slave_threads' is deprecated and will be removed in a future release. Please use wsrep_applier_threads instead. 2026-05-14T05:07:26.293140Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2026-05-14T05:07:26.293794Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.42-33.1) starting as process 1 2026-05-14T05:07:26.295695Z 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib64/galera4/libgalera_smm.so initial position: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 2026-05-14T05:07:26.295712Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library '/usr/lib64/galera4/libgalera_smm.so' 2026-05-14T05:07:26.296224Z 0 [Note] [MY-000000] [Galera] wsrep_load(): Galera 4.22(f6c0465) by Codership Oy (modified by Percona ) loaded successfully. 2026-05-14T05:07:26.296242Z 0 [Note] [MY-000000] [Galera] Resolved symbol 'wsrep_node_isolation_mode_set_v1' 2026-05-14T05:07:26.296247Z 0 [Note] [MY-000000] [Galera] Resolved symbol 'wsrep_certify_v1' 2026-05-14T05:07:26.296268Z 0 [Note] [MY-000000] [Galera] CRC-32C: using 64-bit x86 acceleration. 2026-05-14T05:07:26.296445Z 0 [Note] [MY-000000] [Galera] Found saved state: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20, safe_to_bootstrap: 1 2026-05-14T05:07:26.296519Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble: Version: 2 UUID: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d Seqno: 1 - 20 Offset: 1280 Synced: 1 EncVersion: 1 Encrypted: 0 MasterKeyConst UUID: a9b053f0-4f52-11f1-8ba1-a74bb536bd54 MasterKey UUID: 00000000-0000-0000-0000-000000000000 MasterKey ID: 0 2026-05-14T05:07:26.296531Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: version: 2, UUID: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d, offset: 1280 2026-05-14T05:07:26.296587Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan... 0.0% (0/134217752 bytes) complete. 2026-05-14T05:07:26.296633Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan... 100.0% (134217752/134217752 bytes) complete. 2026-05-14T05:07:26.296642Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: found gapless sequence 1-20 2026-05-14T05:07:26.296658Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer unused buffers scan... 0.0% (0/6560 bytes) complete. 2026-05-14T05:07:26.296674Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer unused buffers scan... 100.0% (6560/6560 bytes) complete. 2026-05-14T05:07:26.296682Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: found 0/20 locked buffers 2026-05-14T05:07:26.296687Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: free space: 134211168/134217728 2026-05-14T05:07:26.582099Z 0 [Note] [MY-000000] [Galera] Passing config to GCS: allocator.disk_pages_encryption = no; allocator.encryption_cache_page_size = 32K; allocator.encryption_cache_size = 16777216; base_dir = /var/lib/mysql/; base_host = 10.0.0.217; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = no; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.encryption = no; gcache.encryption_cache_page_size = 32K; gcache.encryption_cache_size = 16777216; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_auto_evict_threshold = 0.75; gcs.fc_auto_evict_window = 0; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 100; 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.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.wait_restored_prim_timeout = PT0S; pc.weight = 10; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 11; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto; 2026-05-14T05:07:26.590017Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:07:26.590106Z 0 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20, protocol version: -1 2026-05-14T05:07:26.590181Z 0 [Note] [MY-000000] [WSREP] Starting replication 2026-05-14T05:07:26.590200Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 1 2026-05-14T05:07:26.590210Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:20 2026-05-14T05:07:26.590254Z 0 [Note] [MY-000000] [Galera] protonet asio version 0 2026-05-14T05:07:26.590307Z 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2026-05-14T05:07:26.590323Z 0 [Note] [MY-000000] [Galera] backend: asio 2026-05-14T05:07:26.590391Z 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2026-05-14T05:07:26.590538Z 0 [Note] [MY-000000] [Galera] Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown 2026-05-14T05:07:26.590561Z 0 [Note] [MY-000000] [Galera] Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2026-05-14T05:07:26.590722Z 0 [Note] [MY-000000] [Galera] GMCast version 0 2026-05-14T05:07:26.590794Z 0 [Note] [MY-000000] [Galera] (ccbad867-991f, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2026-05-14T05:07:26.590807Z 0 [Note] [MY-000000] [Galera] (ccbad867-991f, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2026-05-14T05:07:26.591090Z 0 [Note] [MY-000000] [Galera] EVS version 1 2026-05-14T05:07:26.591157Z 0 [Note] [MY-000000] [Galera] gcomm: bootstrapping new group 'percona-xtradb-pxc' 2026-05-14T05:07:26.591195Z 0 [Note] [MY-000000] [Galera] start_prim is enabled, turn off pc_recovery 2026-05-14T05:07:26.591336Z 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 -> 1 2026-05-14T05:07:26.591358Z 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 -> 1 2026-05-14T05:07:26.591378Z 0 [Note] [MY-000000] [Galera] Node ccbad867-991f state primary 2026-05-14T05:07:26.591401Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(PRIM,ccbad867-991f,1) memb { ccbad867-991f,0 } joined { } left { } partitioned { } ) 2026-05-14T05:07:26.591409Z 0 [Note] [MY-000000] [Galera] Save the discovered primary-component to disk 2026-05-14T05:07:26.869674Z 0 [Note] [MY-000000] [Galera] gcomm: connected 2026-05-14T05:07:26.869753Z 0 [Note] [MY-000000] [Galera] Changing maximum packet size to 64500, resulting msg size: 32636 2026-05-14T05:07:26.869886Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> OPEN (TO: 0) 2026-05-14T05:07:26.869900Z 0 [Note] [MY-000000] [Galera] Opened channel 'percona-xtradb-pxc' 2026-05-14T05:07:26.870231Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2026-05-14T05:07:26.870429Z 2 [Note] [MY-000000] [WSREP] Starting rollbacker thread 2 2026-05-14T05:07:26.870513Z 0 [Note] [MY-000000] [Galera] STATE_EXCHANGE: sent state UUID: cce58b34-4f52-11f1-9226-267c3587024a 2026-05-14T05:07:26.870576Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: sent state msg: cce58b34-4f52-11f1-9226-267c3587024a 2026-05-14T05:07:26.870444Z 1 [Note] [MY-000000] [WSREP] Starting applier thread 1 2026-05-14T05:07:26.870653Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: cce58b34-4f52-11f1-9226-267c3587024a from 0 (percona-xtradb-pxc-0) 2026-05-14T05:07:26.870683Z 0 [Note] [MY-000000] [Galera] Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (primary/total), act_id = 20, last_appl. = 20, protocols = 5/11/4 (gcs/repl/appl), vote policy= 0, group UUID = a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d 2026-05-14T05:07:26.870761Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100] 2026-05-14T05:07:26.870781Z 0 [Note] [MY-000000] [Galera] Restored state OPEN -> JOINED (21) 2026-05-14T05:07:26.870866Z 0 [Note] [MY-000000] [Galera] Member 0.0 (percona-xtradb-pxc-0) synced with group. 2026-05-14T05:07:26.870885Z 0 [Note] [MY-000000] [Galera] Shifting JOINED -> SYNCED (TO: 21) 2026-05-14T05:07:26.870908Z 1 [Note] [MY-000000] [Galera] ####### processing CC 21, local, ordered 2026-05-14T05:07:26.870943Z 1 [Note] [MY-000000] [Galera] Maybe drain monitors from 20 upto current CC event 21 upto:20 2026-05-14T05:07:26.870958Z 1 [Note] [MY-000000] [Galera] Drain monitors from 20 up to 20 2026-05-14T05:07:26.870979Z 1 [Note] [MY-000000] [Galera] Process first view: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d my uuid: ccbad867-4f52-11f1-991f-926a242168b1 2026-05-14T05:07:26.871003Z 1 [Note] [MY-000000] [Galera] Server percona-xtradb-pxc-0 connected to cluster at position a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:21 with ID ccbad867-4f52-11f1-991f-926a242168b1 2026-05-14T05:07:26.871016Z 1 [Note] [MY-000000] [WSREP] Server status change disconnected -> connected 2026-05-14T05:07:26.882692Z 1 [Note] [MY-000000] [Galera] ####### My UUID: ccbad867-4f52-11f1-991f-926a242168b1 2026-05-14T05:07:26.882736Z 1 [Note] [MY-000000] [Galera] Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 11), state transfer needed: no 2026-05-14T05:07:26.882790Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:07:26.882835Z 1 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2026-05-14T05:07:26.882851Z 1 [Note] [MY-000000] [Galera] REPL Protocols: 11 (6) 2026-05-14T05:07:26.882859Z 1 [Note] [MY-000000] [Galera] ####### Adjusting cert position: -1 -> 21 2026-05-14T05:07:26.882877Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2026-05-14T05:07:26.945387Z 1 [Note] [MY-000000] [Galera] ================================================ View: id: a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d:21 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: ccbad867-4f52-11f1-991f-926a242168b1, percona-xtradb-pxc-0 ================================================= 2026-05-14T05:07:26.945458Z 1 [Note] [MY-000000] [WSREP] Server status change connected -> joiner 2026-05-14T05:07:26.964520Z 1 [Note] [MY-000000] [WSREP] Server status change joiner -> initializing 2026-05-14T05:07:26.993858Z 3 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-05-14T05:07:32.421283Z 3 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-05-14T05:07:32.848579Z 3 [Note] [MY-000000] [WSREP] wsrep_init_schema_and_SR (nil) 2026-05-14T05:07:32.907064Z 3 [System] [MY-000000] [WSREP] PXC upgrade completed successfully 2026-05-14T05:07:33.126524Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-05-14T05:07:33.126570Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-05-14T05:07:33.139288Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_admin. See below for the description of exact issue. 2026-05-14T05:07:33.139305Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2026-05-14T05:07:33.139310Z 0 [System] [MY-013603] [Server] No TLS configuration was given for channel mysql_admin; re-using TLS configuration of channel mysql_main. 2026-05-14T05:07:33.224132Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/lib/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2026-05-14T05:07:33.264661Z 0 [Note] [MY-000000] [WSREP] Initialized wsrep sidno 2 2026-05-14T05:07:33.264697Z 0 [Note] [MY-000000] [Galera] Server initialized 2026-05-14T05:07:33.264709Z 0 [Note] [MY-000000] [WSREP] Server status change initializing -> initialized 2026-05-14T05:07:33.276207Z 1 [Note] [MY-000000] [Galera] Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2026-05-14T05:07:33.340524Z 11 [Note] [MY-000000] [WSREP] Starting applier thread 11 2026-05-14T05:07:33.343832Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2026-05-14T05:07:33.343995Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.42-33.1' socket: '/tmp/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel33, Revision 6673f8e, WSREP version 26.1.4.3. 2026-05-14T05:07:33.344034Z 0 [System] [MY-013292] [Server] Admin interface ready for connections, address: '10.0.0.217' port: 33062 2026-05-14T05:07:33.344633Z 9 [Note] [MY-000000] [WSREP] Recovered cluster id a9d32cf6-4f52-11f1-b8b1-56d9e6c93b4d 2026-05-14T05:07:33.348630Z 1 [Note] [MY-000000] [WSREP] Server status change initialized -> joined 2026-05-14T05:07:33.385347Z 1 [Note] [MY-000000] [Galera] Recording CC from group: 21 2026-05-14T05:07:33.385420Z 1 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 21 2026-05-14T05:07:33.385438Z 1 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1 2026-05-14T05:07:33.385477Z 1 [Note] [MY-000000] [Galera] Server percona-xtradb-pxc-0 synced with group 2026-05-14T05:07:33.385497Z 1 [Note] [MY-000000] [WSREP] Server status change joined -> synced 2026-05-14T05:07:33.385514Z 1 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections 2026-05-14T05:07:53.119967Z 17 [Warning] [MY-010235] [Server] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'caching_sha2_password' to rewrite authentication information (if any) for them: 'monitor'@'%' 2026-05-14T05:07:59.570168Z 20 [Warning] [MY-010235] [Server] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'caching_sha2_password' to rewrite authentication information (if any) for them: 'xtrabackup'@'%' 2026-05-14T05:11:38.349980Z 432 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2026-05-14T05:15:13.276998Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE 2026-05-14T05:15:15.794332Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE 2026-05-14T05:16:45.606014Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE 2026-05-14T05:16:46.924177Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE 2026-05-14T05:18:30.774295Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE 2026-05-14T05:18:31.252470Z 432 [Warning] [MY-000000] [WSREP] Percona-XtraDB-Cluster doesn't recommend use of DML command on a table (keycloak.DATABASECHANGELOG) without an explicit primary key with pxc_strict_mode = PERMISSIVE