+ 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=29 + vault_secret=/etc/mysql/vault-keyring-secret/keyring_vault.conf + '[' -f /etc/mysql/vault-keyring-secret/keyring_vault.conf ']' + '[' -f /usr/lib64/mysql/plugin/binlog_utils_udf.so ']' + sed -i '/\[mysqld\]/a plugin_load="binlog_utils_udf=binlog_utils_udf.so"' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a gtid-mode=ON' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a enforce-gtid-consistency' /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$\\|.*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$' /etc/mysql/node.cnf + [[ 8.0 == \8\.\0 ]] + [[ 29 -ge 26 ]] + grep -q '^skip_replica_start=ON' /etc/mysql/node.cnf + sed -i '/\[mysqld\]/a skip_replica_start=ON' /etc/mysql/node.cnf + file_env XTRABACKUP_PASSWORD xtrabackup xtrabackup + set +o xtrace + file_env CLUSTERCHECK_PASSWORD '' clustercheck + set +o xtrace ++ hostname -f + NODE_NAME=minimal-cluster-pxc-0.minimal-cluster-pxc.default.svc.cluster.local + NODE_PORT=3306 + '[' -n minimal-cluster-pxc-unready ']' + echo 'Percona XtraDB Cluster: Finding peers' Percona XtraDB Cluster: Finding peers + /var/lib/mysql/peer-list -on-start=/var/lib/mysql/pxc-configure-pxc.sh -service=minimal-cluster-pxc-unready 2023/02/19 20:50:20 Peer finder enter 2023/02/19 20:50:20 Determined Domain to be default.svc.cluster.local 2023/02/19 20:50:20 Peer list updated was [] now [10-244-0-5.minimal-cluster-pxc-unready.default.svc.cluster.local] 2023/02/19 20:50:20 execing: /var/lib/mysql/pxc-configure-pxc.sh with stdin: 10-244-0-5.minimal-cluster-pxc-unready.default.svc.cluster.local 2023/02/19 20:50:21 ++ hostname -I ++ awk ' { print $1 } ' + NODE_IP=10.244.0.5 ++ hostname -f ++ cut -d. -f2 + CLUSTER_NAME=minimal-cluster-pxc + SERVER_NUM=0 + SERVER_ID=23352460 ++ hostname -f + NODE_NAME=minimal-cluster-pxc-0.minimal-cluster-pxc.default.svc.cluster.local + NODE_PORT=3306 + read -ra LINE + echo 'read line 10-244-0-5.minimal-cluster-pxc-unready.default.svc.cluster.local' read line 10-244-0-5.minimal-cluster-pxc-unready.default.svc.cluster.local ++ getent hosts 10-244-0-5.minimal-cluster-pxc-unready.default.svc.cluster.local ++ awk '{ print $1 }' + LINE_IP=10.244.0.5 + '[' 10.244.0.5 '!=' 10.244.0.5 ']' + 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 ']' + 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=23352460|' /etc/mysql/node.cnf + sed -r 's|^[#]?coredumper$|coredumper|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_node_address=.*$|wsrep_node_address=10.244.0.5|' /etc/mysql/node.cnf + sed -r 's|^[#]?wsrep_cluster_name=.*$|wsrep_cluster_name=minimal-cluster-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=minimal-cluster-pxc-0.minimal-cluster-pxc.default.svc.cluster.local:3306|' /etc/mysql/node.cnf + sed -r 's|^[#]?admin-address=.*$|admin-address=10.244.0.5|' /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 2023/02/19 20:50:22 Peer finder exiting ++ grep '^wsrep_cluster_address=' /etc/mysql/node.cnf ++ cut -d = -f 2 ++ sed -e 's^.*gcomm://^^' + CLUSTER_JOIN= Cluster address set to: + echo 'Cluster address set to: ' ++ grep wsrep_cluster_name /etc/mysql/node.cnf ++ cut -d = -f 2 ++ tr -d ' ' + WSREP_CLUSTER_NAME=minimal-cluster-pxc + [[ -z minimal-cluster-pxc ]] + [[ minimal-cluster-pxc == \n\o\n\a\m\e ]] + '[' -z '' ']' + '[' mysqld = mysqld -a -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.xef6Gn3hwO + DATADIR=/var/lib/mysql/ ++ _get_tmpdir /var/lib/mysql//sst-xb-tmpdir ++ local defaul_value=/var/lib/mysql//sst-xb-tmpdir ++ local tmpdir_path= +++ _get_cnf_config sst tmpdir '' +++ local group=sst +++ local var=tmpdir +++ local reval= ++++ my_print_defaults sst ++++ grep -- --tmpdir= ++++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' ++++ cut -d= -f2- ++++ tail -1 +++ reval= +++ [[ -z '' ]] +++ reval= +++ echo '' ++ tmpdir_path= ++ [[ -z '' ]] +++ _get_cnf_config xtrabackup tmpdir '' +++ local group=xtrabackup +++ local var=tmpdir +++ local reval= ++++ my_print_defaults xtrabackup ++++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' ++++ cut -d= -f2- ++++ grep -- --tmpdir= ++++ tail -1 +++ reval= +++ [[ -z '' ]] +++ reval= +++ echo '' ++ tmpdir_path= ++ [[ -z '' ]] +++ _get_cnf_config mysqld tmpdir '' +++ local group=mysqld +++ local var=tmpdir +++ local reval= ++++ my_print_defaults mysqld ++++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' ++++ cut -d= -f2- ++++ tail -1 ++++ grep -- --tmpdir= +++ reval= +++ [[ -z '' ]] +++ reval= +++ echo '' ++ tmpdir_path= ++ [[ -z '' ]] ++ tmpdir_path=/var/lib/mysql//sst-xb-tmpdir ++ echo /var/lib/mysql//sst-xb-tmpdir + TMPDIR=/var/lib/mysql//sst-xb-tmpdir + rm -rfv /var/lib/mysql//sst-xb-tmpdir + '[' '!' -d /var/lib/mysql//mysql ']' + file_env MYSQL_ROOT_PASSWORD '' root + set +o xtrace + 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$\|.*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$' ++ [[ -z .*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*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$ ]] ++ echo '.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*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$' + cpat='.*\.pem$\|.*init\.ok$\|.*galera\.cache$\|.*wsrep_recovery_verbose\.log$\|.*readiness-check\.sh$\|.*liveness-check\.sh$\|.*get-pxc-state$\|.*sst_in_progress$\|.*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$' + 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$\|.*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$' -prune -o -exec rm -rfv '{}' + Initializing database + echo 'Initializing database' + mysqld --initialize-insecure --skip-ssl --datadir=/var/lib/mysql//sst-xb-tmpdir 2023-02-19T20:50:23.532442Z 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. 2023-02-19T20:50:23.532744Z 0 [Warning] [MY-011068] [Server] The syntax '--ssl=off' is deprecated and will be removed in a future release. Please use --tls-version=invalid instead. 2023-02-19T20:50:23.534383Z 0 [Warning] [MY-000000] [WSREP] Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks 2023-02-19T20:50:23.544471Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-02-19T20:50:23.544741Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.29-21.1) initializing of server in progress as process 321 2023-02-19T20:50:23.567403Z 0 [Note] [MY-000000] [Galera] Loading provider none initial position: 00000000-0000-0000-0000-000000000000:-1 2023-02-19T20:50:23.569598Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library 'none' 2023-02-19T20:50:23.639539Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-19T20:50:23.663185Z 1 [ERROR] [MY-012585] [InnoDB] Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB. 2023-02-19T20:50:23.663541Z 1 [Warning] [MY-012654] [InnoDB] Linux Native AIO disabled. 2023-02-19T20:50:24.097981Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-02-19T20:50:25.334919Z 0 [Warning] [MY-013501] [Server] Ignoring --plugin-load[_add] list as the server is running with --initialize(-insecure). 2023-02-19T20:50:26.667016Z 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/#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/ib_logfile0 /var/lib/mysql//sst-xb-tmpdir/ib_logfile1 /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' ++ _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.RYdi2puvTG + SOCKET=/tmp/mysql.sock + pid=390 + mysql=(mysql --protocol=socket -uroot -hlocalhost --socket="${SOCKET}" --password="") + wsrep_local_state_select='SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' + mysqld --skip-networking --socket=/tmp/mysql.sock + 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 ']' MySQL init process in progress... + echo 'MySQL init process in progress...' + sleep 1 2023-02-19T20:50:33.127636Z 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. 2023-02-19T20:50:33.133680Z 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. 2023-02-19T20:50:33.143846Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-02-19T20:50:33.144112Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-21.1) starting as process 390 2023-02-19T20:50:33.170414Z 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib64/galera4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 2023-02-19T20:50:33.172400Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library '/usr/lib64/galera4/libgalera_smm.so' 2023-02-19T20:50:33.183626Z 0 [Note] [MY-000000] [Galera] wsrep_load(): Galera 4.12(04bfb95) by Codership Oy (modified by Percona ) loaded successfully. 2023-02-19T20:50:33.184250Z 0 [Note] [MY-000000] [Galera] CRC-32C: using 64-bit x86 acceleration. 2023-02-19T20:50:33.198631Z 0 [Warning] [MY-000000] [Galera] Could not open state file for reading: '/var/lib/mysql//grastate.dat' 2023-02-19T20:50:33.198877Z 0 [Warning] [MY-000000] [Galera] No persistent state found. Bootstraping with default state 2023-02-19T20:50:33.199412Z 0 [Note] [MY-000000] [Galera] Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2023-02-19T20:50:33.208010Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2023-02-19T20:50:33.210369Z 0 [Note] [MY-000000] [Galera] Skipped GCache ring buffer recovery: could not determine history UUID. 2023-02-19T20:50:33.217956Z 0 [Note] [MY-000000] [Galera] Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.244.0.5; 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.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_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.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 = 10; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto; 2023-02-19T20:50:33.256780Z 0 [Note] [MY-000000] [WSREP] Starting replication 2023-02-19T20:50:33.257306Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 1 2023-02-19T20:50:33.257733Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2023-02-19T20:50:33.258652Z 0 [Note] [MY-000000] [Galera] protonet asio version 0 2023-02-19T20:50:33.259494Z 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2023-02-19T20:50:33.260005Z 0 [Note] [MY-000000] [Galera] backend: asio 2023-02-19T20:50:33.260973Z 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2023-02-19T20:50:33.263352Z 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 2023-02-19T20:50:33.263552Z 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 2023-02-19T20:50:33.267152Z 0 [Note] [MY-000000] [Galera] GMCast version 0 2023-02-19T20:50:33.269884Z 0 [Note] [MY-000000] [Galera] (0d9302a1-a9e7, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2023-02-19T20:50:33.270094Z 0 [Note] [MY-000000] [Galera] (0d9302a1-a9e7, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2023-02-19T20:50:33.275262Z 0 [Note] [MY-000000] [Galera] EVS version 1 2023-02-19T20:50:33.278380Z 0 [Note] [MY-000000] [Galera] gcomm: bootstrapping new group 'minimal-cluster-pxc' 2023-02-19T20:50:33.278668Z 0 [Note] [MY-000000] [Galera] start_prim is enabled, turn off pc_recovery 2023-02-19T20:50:33.287324Z 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 -> 1 2023-02-19T20:50:33.288093Z 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 -> 1 2023-02-19T20:50:33.290835Z 0 [Note] [MY-000000] [Galera] Node 0d9302a1-a9e7 state primary 2023-02-19T20:50:33.292416Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(PRIM,0d9302a1-a9e7,1) memb { 0d9302a1-a9e7,0 } joined { } left { } partitioned { } ) 2023-02-19T20:50:33.292655Z 0 [Note] [MY-000000] [Galera] Save the discovered primary-component to disk 2023-02-19T20:50:33.296441Z 0 [Note] [MY-000000] [Galera] gcomm: connected 2023-02-19T20:50:33.296894Z 0 [Note] [MY-000000] [Galera] Changing maximum packet size to 64500, resulting msg size: 32636 2023-02-19T20:50:33.297949Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> OPEN (TO: 0) 2023-02-19T20:50:33.298140Z 0 [Note] [MY-000000] [Galera] Opened channel 'minimal-cluster-pxc' 2023-02-19T20:50:33.306283Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2023-02-19T20:50:33.308669Z 0 [Note] [MY-000000] [Galera] Starting new group from scratch: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f 2023-02-19T20:50:33.313224Z 0 [Note] [MY-000000] [Galera] STATE_EXCHANGE: sent state UUID: 0d99feaa-b097-11ed-ad0a-df5560f0becf 2023-02-19T20:50:33.316126Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: sent state msg: 0d99feaa-b097-11ed-ad0a-df5560f0becf 2023-02-19T20:50:33.318130Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: 0d99feaa-b097-11ed-ad0a-df5560f0becf from 0 (minimal-cluster-pxc-0) 2023-02-19T20:50:33.318540Z 1 [Note] [MY-000000] [WSREP] Starting rollbacker thread 1 2023-02-19T20:50:33.320340Z 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 = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 0d99c4f6-b097-11ed-8a6a-d28ba293a07f 2023-02-19T20:50:33.324375Z 2 [Note] [MY-000000] [WSREP] Starting applier thread 2 2023-02-19T20:50:33.325560Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100] 2023-02-19T20:50:33.325708Z 0 [Note] [MY-000000] [Galera] Restored state OPEN -> JOINED (1) 2023-02-19T20:50:33.326445Z 0 [Note] [MY-000000] [Galera] Member 0.0 (minimal-cluster-pxc-0) synced with group. 2023-02-19T20:50:33.326942Z 0 [Note] [MY-000000] [Galera] Shifting JOINED -> SYNCED (TO: 1) 2023-02-19T20:50:33.327365Z 2 [Note] [MY-000000] [Galera] ####### processing CC 1, local, ordered 2023-02-19T20:50:33.327511Z 2 [Note] [MY-000000] [Galera] Maybe drain monitors from -1 upto current CC event 1 upto:-1 2023-02-19T20:50:33.327652Z 2 [Note] [MY-000000] [Galera] Drain monitors from -1 up to -1 2023-02-19T20:50:33.328009Z 2 [Note] [MY-000000] [Galera] Process first view: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f my uuid: 0d9302a1-b097-11ed-a9e7-5eb869e9819a 2023-02-19T20:50:33.328662Z 2 [Note] [MY-000000] [Galera] Server minimal-cluster-pxc-0 connected to cluster at position 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:1 with ID 0d9302a1-b097-11ed-a9e7-5eb869e9819a 2023-02-19T20:50:33.328922Z 2 [Note] [MY-000000] [WSREP] Server status change disconnected -> connected 2023-02-19T20:50:33.329150Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:33.329646Z 2 [Note] [MY-000000] [Galera] ####### My UUID: 0d9302a1-b097-11ed-a9e7-5eb869e9819a 2023-02-19T20:50:33.330023Z 2 [Note] [MY-000000] [Galera] Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no 2023-02-19T20:50:33.331276Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:50:33.331672Z 2 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2023-02-19T20:50:33.331845Z 2 [Note] [MY-000000] [Galera] REPL Protocols: 10 (5) 2023-02-19T20:50:33.332035Z 2 [Note] [MY-000000] [Galera] ####### Adjusting cert position: -1 -> 1 2023-02-19T20:50:33.332171Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:50:33.334105Z 2 [Note] [MY-000000] [Galera] GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:0 2023-02-19T20:50:33.336161Z 2 [Note] [MY-000000] [Galera] ================================================ View: id: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f: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: 0d9302a1-b097-11ed-a9e7-5eb869e9819a, minimal-cluster-pxc-0 ================================================= 2023-02-19T20:50:33.336435Z 2 [Note] [MY-000000] [WSREP] Server status change connected -> joiner 2023-02-19T20:50:33.336510Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:33.336636Z 2 [Note] [MY-000000] [WSREP] Server status change joiner -> initializing 2023-02-19T20:50:33.336713Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:33.406421Z 3 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-19T20:50:33.427977Z 3 [ERROR] [MY-012585] [InnoDB] Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB. 2023-02-19T20:50:33.428249Z 3 [Warning] [MY-012654] [InnoDB] Linux Native AIO disabled. 2023-02-19T20:50:33.697527Z 3 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. + 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 2023-02-19T20:50:34.295642Z 3 [Note] [MY-000000] [WSREP] wsrep_init_schema_and_SR (nil) 2023-02-19T20:50:34.430323Z 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 2023-02-19T20:50:35.772158Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-02-19T20:50:35.772451Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-02-19T20:50:35.834346Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_admin. See below for the description of exact issue. 2023-02-19T20:50:35.834550Z 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 2023-02-19T20:50:35.834736Z 0 [System] [MY-013603] [Server] No TLS configuration was given for channel mysql_admin; re-using TLS configuration of channel mysql_main. 2023-02-19T20:50:35.838962Z 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. 2023-02-19T20:50:35.948954Z 0 [Note] [MY-000000] [WSREP] Initialized wsrep sidno 2 2023-02-19T20:50:35.949456Z 0 [Note] [MY-000000] [Galera] Server initialized 2023-02-19T20:50:35.949683Z 0 [Note] [MY-000000] [WSREP] Server status change initializing -> initialized 2023-02-19T20:50:35.949782Z 0 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:35.950037Z 2 [Note] [MY-000000] [Galera] Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2023-02-19T20:50:35.963657Z 10 [Note] [MY-000000] [WSREP] Starting applier thread 10 2023-02-19T20:50:35.965274Z 8 [Note] [MY-000000] [WSREP] Cluster table is empty, not recovering transactions 2023-02-19T20:50:35.966062Z 2 [Note] [MY-000000] [WSREP] Server status change initialized -> joined 2023-02-19T20:50:35.966120Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:35.966446Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. + for i in {120..0} ++ echo 'SELECT variable_value FROM performance_schema.global_status WHERE variable_name='\''wsrep_local_state_comment'\''' 2023-02-19T20:50:35.974698Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/lib/mysql/mysqlx.sock ++ mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= -s 2023-02-19T20:50:35.977115Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.29-21.1' socket: '/tmp/mysql.sock' port: 0 Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3. 2023-02-19T20:50:35.984944Z 2 [Note] [MY-000000] [Galera] Recording CC from group: 1 2023-02-19T20:50:35.985129Z 2 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 1 2023-02-19T20:50:35.985241Z 2 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1 2023-02-19T20:50:35.986088Z 2 [Note] [MY-000000] [Galera] Server minimal-cluster-pxc-0 synced with group 2023-02-19T20:50:35.986186Z 2 [Note] [MY-000000] [WSREP] Server status change joined -> synced 2023-02-19T20:50:35.986290Z 2 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections 2023-02-19T20:50:35.986337Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. + wsrep_local_state=Synced + '[' Synced = Synced ']' + break + '[' 117 = 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. 2023-02-19T20:50:36.192457Z 13 [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/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;' 2023-02-19T20:50:42.959546Z 13 [Warning] [MY-000000] [WSREP] Toggling wsrep_on to ON will affect sql_log_bin. Check manual for more details + rootCreate= + file_env MYSQL_ROOT_HOST % + set +o xtrace + '[' '!' -z % -a % '!=' localhost ']' + read -r -d '' rootCreate ++ escape_special '9+ydhGei@qj>C$>uf' ++ echo '9+ydhGei@qj>C$>uf' ++ sed 's/\\/\\\\/g' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' + true + file_env MONITOR_HOST localhost + set +o xtrace + file_env MONITOR_PASSWORD monitor monitor + set +o xtrace + file_env REPLICATION_PASSWORD replication replication + set +o xtrace + '[' 8.0 == 8.0 ']' + read -r -d '' monitorConnectGrant + true + [[ 8.0 == \8\.\0 ]] + (( MYSQL_PATCH_VERSION >= 16 )) + read -r -d '' systemUserGrant + true + mysql --protocol=socket -uroot -hlocalhost --socket=/tmp/mysql.sock --password= ++ escape_special '9+ydhGei@qj>C$>uf' ++ echo '9+ydhGei@qj>C$>uf' ++ sed 's/\\/\\\\/g' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' ++ escape_special '(Mm0~MSDQb5U>IT?J' ++ echo '(Mm0~MSDQb5U>IT?J' ++ sed 's/\\/\\\\/g' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' ++ escape_special 'Ol)h,&g!#R7tbAs^9' ++ echo 'Ol)h,&g!#R7tbAs^9' ++ sed 's/\\/\\\\/g' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' ++ escape_special '^x~}~,wrc}>QwED[j' ++ echo '^x~}~,wrc}>QwED[j' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' ++ sed 's/\\/\\\\/g' ++ escape_special 'w4coiUrdT?y*plA3' ++ echo 'w4coiUrdT?y*plA3' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' ++ sed 's/\\/\\\\/g' ++ escape_special 'u9<%urD[mh]M?b7100' ++ echo 'u9<%urD[mh]M?b7100' ++ sed 's/\\/\\\\/g' ++ sed 's/'\''/\\'\''/g' ++ sed 's/"/\\\"/g' mysql: [Warning] Using a password on the command line interface can be insecure. + file_env MYSQL_DATABASE + set +o xtrace + '[' '' ']' + file_env MYSQL_USER + set +o xtrace + file_env MYSQL_PASSWORD + set +o xtrace + echo + ls /docker-entrypoint-initdb.d/ + kill -s TERM 390 + wait 390 2023-02-19T20:50:43.531208Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.29-21.1). 2023-02-19T20:50:43.531458Z 0 [Note] [MY-000000] [WSREP] Received shutdown signal. Will sleep for 10 secs before initiating shutdown. pxc_maint_mode switched to SHUTDOWN 2023-02-19T20:50:53.542049Z 0 [Note] [MY-000000] [WSREP] Shutdown replication 2023-02-19T20:50:53.542335Z 0 [Note] [MY-000000] [WSREP] Server status change synced -> disconnecting 2023-02-19T20:50:53.542463Z 0 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:53.542829Z 0 [Note] [MY-000000] [Galera] Closing send monitor... 2023-02-19T20:50:53.543030Z 0 [Note] [MY-000000] [Galera] Closed send monitor. 2023-02-19T20:50:53.543351Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread 2023-02-19T20:50:53.543883Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread 2023-02-19T20:50:53.544166Z 0 [Note] [MY-000000] [Galera] gcomm: closing backend 2023-02-19T20:50:53.546670Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 -> 0 2023-02-19T20:50:53.546951Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 2023-02-19T20:50:53.550994Z 0 [Note] [MY-000000] [Galera] gcomm: closed 2023-02-19T20:50:53.551431Z 0 [Note] [MY-000000] [Galera] New SELF-LEAVE. 2023-02-19T20:50:53.552087Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [0, 0] 2023-02-19T20:50:53.552181Z 0 [Note] [MY-000000] [Galera] Received SELF-LEAVE. Closing connection. 2023-02-19T20:50:53.552374Z 0 [Note] [MY-000000] [Galera] Shifting SYNCED -> CLOSED (TO: 22) 2023-02-19T20:50:53.552509Z 0 [Note] [MY-000000] [Galera] RECV thread exiting 0: Success 2023-02-19T20:50:53.552813Z 2 [Note] [MY-000000] [Galera] Maybe drain monitors from 22 upto current CC event 22 upto:22 2023-02-19T20:50:53.553093Z 2 [Note] [MY-000000] [Galera] Drain monitors from 22 up to 22 2023-02-19T20:50:53.553389Z 2 [Note] [MY-000000] [Galera] ================================================ View: id: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 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): ================================================= 2023-02-19T20:50:53.553648Z 2 [Note] [MY-000000] [Galera] Non-primary view 2023-02-19T20:50:53.553767Z 2 [Note] [MY-000000] [WSREP] Server status change disconnecting -> disconnected 2023-02-19T20:50:53.553830Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:53.553999Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:50:53.554140Z 0 [Note] [MY-000000] [Galera] recv_thread() joined. 2023-02-19T20:50:53.554220Z 0 [Note] [MY-000000] [Galera] Closing replication queue. 2023-02-19T20:50:53.554304Z 0 [Note] [MY-000000] [Galera] Closing slave action queue. 2023-02-19T20:50:53.557286Z 2 [Note] [MY-000000] [WSREP] Applier thread exiting ret: 0 thd: 2 2023-02-19T20:50:53.559175Z 0 [Note] [MY-000000] [WSREP] Waiting for active wsrep applier to exit 2023-02-19T20:50:53.559507Z 0 [Note] [MY-000000] [WSREP] All applier thread terminated. Will now terminate rollback thread 2023-02-19T20:50:53.560146Z 0 [Note] [MY-000000] [WSREP] Waiting for rollback thread to terminate 2023-02-19T20:50:53.560366Z 1 [Note] [MY-000000] [WSREP] rollbacker thread exiting 1 2023-02-19T20:50:53.562947Z 10 [Note] [MY-000000] [WSREP] Applier thread exiting ret: 6 thd: 10 2023-02-19T20:50:54.561012Z 0 [Note] [MY-000000] [WSREP] Rollback thread terminated 2023-02-19T20:50:54.568303Z 0 [Note] [MY-000000] [Galera] dtor state: CLOSED 2023-02-19T20:50:54.568900Z 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 21, in use: 21, in pool: 0 2023-02-19T20:50:54.582046Z 0 [Note] [MY-000000] [Galera] mon: entered 21 oooe fraction 0 oool fraction 0 2023-02-19T20:50:54.593049Z 0 [Note] [MY-000000] [Galera] mon: entered 21 oooe fraction 0 oool fraction 0 2023-02-19T20:50:54.602583Z 0 [Note] [MY-000000] [Galera] mon: entered 24 oooe fraction 0 oool fraction 0 2023-02-19T20:50:54.602821Z 0 [Note] [MY-000000] [Galera] cert index usage at exit 2 2023-02-19T20:50:54.602904Z 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 21 2023-02-19T20:50:54.603007Z 0 [Note] [MY-000000] [Galera] deps set usage at exit 0 2023-02-19T20:50:54.603133Z 0 [Note] [MY-000000] [Galera] avg deps dist 1 2023-02-19T20:50:54.603222Z 0 [Note] [MY-000000] [Galera] avg cert interval 0 2023-02-19T20:50:54.603360Z 0 [Note] [MY-000000] [Galera] cert index size 2 2023-02-19T20:50:54.604373Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:50:54.604846Z 0 [Note] [MY-000000] [Galera] wsdb trx map usage 0 conn query map usage 0 2023-02-19T20:50:54.605151Z 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0.952381, misses: 1, in use: 0, in pool: 1 2023-02-19T20:50:54.608920Z 0 [Note] [MY-000000] [Galera] Flushing memory map to disk... 2023-02-19T20:50:55.556613Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-21.1) Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3. + echo + echo 'MySQL init process done. Ready for start up.' + echo + '[' '!' -z '' ']' MySQL init process done. Ready for start up. + '[' mysqld = mysqld -a -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.shA3QvThLd + 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 +++ grep -- --tmpdir= +++ awk -F= '{st=index($0,"="); cur=$0; if ($1 ~ /_/) { gsub(/_/,"-",$1);} if (st != 0) { print $1"="substr(cur,st+1) } else { print cur }}' +++ cut -d= -f2- +++ tail -1 ++ 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 }}' +++ tail -1 +++ cut -d= -f2- +++ grep -- --progress= ++ reval=1 ++ [[ -z 1 ]] ++ echo 1 + SST_P_FILE=1 + rm -rvf /var/lib/mysql//sst-xb-tmpdir 1 + mysqld --version + sed s/-ps// + tee /tmp/version_info /usr/sbin/mysqld Ver 8.0.29-21.1 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3) + '[' -f /var/lib/mysql//version_info ']' + 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.244.0.5 skip_replica_start=ON enforce-gtid-consistency gtid-mode=ON plugin_load="binlog_utils_udf=binlog_utils_udf.so" default_authentication_plugin=mysql_native_password datadir=/var/lib/mysql socket=/tmp/mysql.sock skip-host-cache coredumper server_id=23352460 binlog_format=ROW default_storage_engine=InnoDB innodb_flush_log_at_trx_commit = 0 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=minimal-cluster-pxc wsrep_node_address=10.244.0.5 wsrep_node_incoming_address=minimal-cluster-pxc-0.minimal-cluster-pxc.default.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$\|.*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$ progress=1 ++ cat /var/run/secrets/kubernetes.io/serviceaccount/namespace + POD_NAMESPACE=default + wsrep_start_position_opt= + '[' mysqld = mysqld -a -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.M5lIA0wvwy + 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 -a -d /var/lib/mysql//mysql ']' ++ grep uuid: /var/lib/mysql//grastate.dat ++ tr -d ' ' ++ cut -d: -f2 + uuid=0d99c4f6-b097-11ed-8a6a-d28ba293a07f ++ grep seqno: /var/lib/mysql//grastate.dat ++ cut -d: -f2 ++ tr -d ' ' + seqno=22 ++ grep safe_to_bootstrap: /var/lib/mysql//grastate.dat ++ tr -d ' ' ++ cut -d: -f2 + safe_to_bootstrap=1 + '[' -n 22 ']' + '[' 22 -ne -1 ']' Skipping wsrep-recover for 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 pair + echo 'Skipping wsrep-recover for 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 pair' + echo 'Assigning 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 to wsrep_start_position' Assigning 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 to wsrep_start_position + wsrep_start_position_opt=--wsrep_start_position=0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 + '[' -z --wsrep_start_position=0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 -a -d /var/lib/mysql//mysql ']' + '[' -n minimal-cluster-pxc-unready ']' ++ get_primary ++ peer-list -on-start=/var/lib/mysql/get-pxc-state -service=minimal-cluster-pxc-unready ++ sort ++ grep wsrep_ready:ON:wsrep_connected:ON:wsrep_local_state_comment:Synced:wsrep_cluster_status:Primary ++ 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 + exec mysqld --wsrep_start_position=0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 2023-02-19T20:51:10.768291Z 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. 2023-02-19T20:51:10.775357Z 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. 2023-02-19T20:51:10.784743Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2023-02-19T20:51:10.784997Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-21.1) starting as process 1 2023-02-19T20:51:10.811514Z 0 [Note] [MY-000000] [Galera] Loading provider /usr/lib64/galera4/libgalera_smm.so initial position: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 2023-02-19T20:51:10.813340Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library '/usr/lib64/galera4/libgalera_smm.so' 2023-02-19T20:51:10.826788Z 0 [Note] [MY-000000] [Galera] wsrep_load(): Galera 4.12(04bfb95) by Codership Oy (modified by Percona ) loaded successfully. 2023-02-19T20:51:10.827365Z 0 [Note] [MY-000000] [Galera] CRC-32C: using 64-bit x86 acceleration. 2023-02-19T20:51:10.840428Z 0 [Note] [MY-000000] [Galera] Found saved state: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22, safe_to_bootstrap: 1 2023-02-19T20:51:10.850165Z 0 [Note] [MY-000000] [Galera] GCache DEBUG: opened preamble: Version: 2 UUID: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f Seqno: 1 - 22 Offset: 1280 Synced: 1 2023-02-19T20:51:10.852868Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: version: 2, UUID: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f, offset: 1280 2023-02-19T20:51:10.858751Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2023-02-19T20:51:10.860616Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2023-02-19T20:51:10.860830Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: found gapless sequence 1-22 2023-02-19T20:51:10.861519Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer unused buffers scan... 0.0% ( 0/6552 bytes) complete. 2023-02-19T20:51:10.861813Z 0 [Note] [MY-000000] [Galera] GCache::RingBuffer unused buffers scan...100.0% (6552/6552 bytes) complete. 2023-02-19T20:51:10.861967Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: found 0/22 locked buffers 2023-02-19T20:51:10.862094Z 0 [Note] [MY-000000] [Galera] Recovering GCache ring buffer: free space: 134211176/134217728 2023-02-19T20:51:10.869042Z 0 [Note] [MY-000000] [Galera] Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.244.0.5; 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.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_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.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 = 10; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto; 2023-02-19T20:51:10.903739Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:51:10.904429Z 0 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22, protocol version: -1 2023-02-19T20:51:10.907439Z 0 [Note] [MY-000000] [WSREP] Starting replication 2023-02-19T20:51:10.907811Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 1 2023-02-19T20:51:10.908169Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:22 2023-02-19T20:51:10.909129Z 0 [Note] [MY-000000] [Galera] protonet asio version 0 2023-02-19T20:51:10.910039Z 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2023-02-19T20:51:10.910569Z 0 [Note] [MY-000000] [Galera] backend: asio 2023-02-19T20:51:10.911764Z 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2023-02-19T20:51:10.914036Z 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 2023-02-19T20:51:10.914235Z 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 2023-02-19T20:51:10.916904Z 0 [Note] [MY-000000] [Galera] GMCast version 0 2023-02-19T20:51:10.919093Z 0 [Note] [MY-000000] [Galera] (24040259-a933, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2023-02-19T20:51:10.919245Z 0 [Note] [MY-000000] [Galera] (24040259-a933, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2023-02-19T20:51:10.923287Z 0 [Note] [MY-000000] [Galera] EVS version 1 2023-02-19T20:51:10.925657Z 0 [Note] [MY-000000] [Galera] gcomm: bootstrapping new group 'minimal-cluster-pxc' 2023-02-19T20:51:10.925889Z 0 [Note] [MY-000000] [Galera] start_prim is enabled, turn off pc_recovery 2023-02-19T20:51:10.934120Z 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 -> 1 2023-02-19T20:51:10.934943Z 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 -> 1 2023-02-19T20:51:10.937838Z 0 [Note] [MY-000000] [Galera] Node 24040259-a933 state primary 2023-02-19T20:51:10.939402Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(PRIM,24040259-a933,1) memb { 24040259-a933,0 } joined { } left { } partitioned { } ) 2023-02-19T20:51:10.939628Z 0 [Note] [MY-000000] [Galera] Save the discovered primary-component to disk 2023-02-19T20:51:10.944165Z 0 [Note] [MY-000000] [Galera] gcomm: connected 2023-02-19T20:51:10.946301Z 0 [Note] [MY-000000] [Galera] Changing maximum packet size to 64500, resulting msg size: 32636 2023-02-19T20:51:10.947340Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> OPEN (TO: 0) 2023-02-19T20:51:10.947460Z 0 [Note] [MY-000000] [Galera] Opened channel 'minimal-cluster-pxc' 2023-02-19T20:51:10.950531Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2023-02-19T20:51:10.958385Z 0 [Note] [MY-000000] [Galera] STATE_EXCHANGE: sent state UUID: 240a29e0-b097-11ed-a94f-d7989a9b0c17 2023-02-19T20:51:10.961589Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: sent state msg: 240a29e0-b097-11ed-a94f-d7989a9b0c17 2023-02-19T20:51:10.963452Z 1 [Note] [MY-000000] [WSREP] Starting rollbacker thread 1 2023-02-19T20:51:10.964280Z 0 [Note] [MY-000000] [Galera] STATE EXCHANGE: got state msg: 240a29e0-b097-11ed-a94f-d7989a9b0c17 from 0 (minimal-cluster-pxc-0) 2023-02-19T20:51:10.964836Z 0 [Note] [MY-000000] [Galera] Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (primary/total), act_id = 22, last_appl. = 22, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 0d99c4f6-b097-11ed-8a6a-d28ba293a07f 2023-02-19T20:51:10.966758Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100] 2023-02-19T20:51:10.966933Z 0 [Note] [MY-000000] [Galera] Restored state OPEN -> JOINED (23) 2023-02-19T20:51:10.967450Z 0 [Note] [MY-000000] [Galera] Member 0.0 (minimal-cluster-pxc-0) synced with group. 2023-02-19T20:51:10.969974Z 0 [Note] [MY-000000] [Galera] Shifting JOINED -> SYNCED (TO: 23) 2023-02-19T20:51:10.970094Z 2 [Note] [MY-000000] [WSREP] Starting applier thread 2 2023-02-19T20:51:10.970894Z 2 [Note] [MY-000000] [Galera] ####### processing CC 23, local, ordered 2023-02-19T20:51:10.971045Z 2 [Note] [MY-000000] [Galera] Maybe drain monitors from 22 upto current CC event 23 upto:22 2023-02-19T20:51:10.971161Z 2 [Note] [MY-000000] [Galera] Drain monitors from 22 up to 22 2023-02-19T20:51:10.971514Z 2 [Note] [MY-000000] [Galera] Process first view: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f my uuid: 24040259-b097-11ed-a933-170736a634c0 2023-02-19T20:51:10.972171Z 2 [Note] [MY-000000] [Galera] Server minimal-cluster-pxc-0 connected to cluster at position 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:23 with ID 24040259-b097-11ed-a933-170736a634c0 2023-02-19T20:51:10.972414Z 2 [Note] [MY-000000] [WSREP] Server status change disconnected -> connected 2023-02-19T20:51:10.972626Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:10.973075Z 2 [Note] [MY-000000] [Galera] ####### My UUID: 24040259-b097-11ed-a933-170736a634c0 2023-02-19T20:51:10.973465Z 2 [Note] [MY-000000] [Galera] Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no 2023-02-19T20:51:10.973824Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:51:10.973977Z 2 [Note] [MY-000000] [Galera] ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2023-02-19T20:51:10.974269Z 2 [Note] [MY-000000] [Galera] REPL Protocols: 10 (5) 2023-02-19T20:51:10.974503Z 2 [Note] [MY-000000] [Galera] ####### Adjusting cert position: -1 -> 23 2023-02-19T20:51:10.974687Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2023-02-19T20:51:10.977079Z 2 [Note] [MY-000000] [Galera] ================================================ View: id: 0d99c4f6-b097-11ed-8a6a-d28ba293a07f:23 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: 24040259-b097-11ed-a933-170736a634c0, minimal-cluster-pxc-0 ================================================= 2023-02-19T20:51:10.977365Z 2 [Note] [MY-000000] [WSREP] Server status change connected -> joiner 2023-02-19T20:51:10.977442Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:10.977534Z 2 [Note] [MY-000000] [WSREP] Server status change joiner -> initializing 2023-02-19T20:51:10.977598Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:11.051317Z 3 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-19T20:51:11.074601Z 3 [ERROR] [MY-012585] [InnoDB] Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB. 2023-02-19T20:51:11.074913Z 3 [Warning] [MY-012654] [InnoDB] Linux Native AIO disabled. 2023-02-19T20:51:11.344574Z 3 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-02-19T20:51:11.913716Z 3 [Note] [MY-000000] [WSREP] wsrep_init_schema_and_SR (nil) 2023-02-19T20:51:11.969327Z 3 [System] [MY-000000] [WSREP] PXC upgrade completed successfully 2023-02-19T20:51:12.346119Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-02-19T20:51:12.346692Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-02-19T20:51:12.405624Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_admin. See below for the description of exact issue. 2023-02-19T20:51:12.405835Z 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 2023-02-19T20:51:12.406054Z 0 [System] [MY-013603] [Server] No TLS configuration was given for channel mysql_admin; re-using TLS configuration of channel mysql_main. 2023-02-19T20:51:12.412149Z 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. 2023-02-19T20:51:12.528350Z 0 [Note] [MY-000000] [WSREP] Initialized wsrep sidno 2 2023-02-19T20:51:12.528749Z 0 [Note] [MY-000000] [Galera] Server initialized 2023-02-19T20:51:12.528900Z 0 [Note] [MY-000000] [WSREP] Server status change initializing -> initialized 2023-02-19T20:51:12.529025Z 0 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:12.529391Z 2 [Note] [MY-000000] [Galera] Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2023-02-19T20:51:12.543506Z 10 [Note] [MY-000000] [WSREP] Starting applier thread 10 2023-02-19T20:51:12.546038Z 8 [Note] [MY-000000] [WSREP] Recovered cluster id 0d99c4f6-b097-11ed-8a6a-d28ba293a07f 2023-02-19T20:51:12.552152Z 2 [Note] [MY-000000] [WSREP] Server status change initialized -> joined 2023-02-19T20:51:12.552296Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:12.555317Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2023-02-19T20:51:12.555401Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:12.559182Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.29-21.1' socket: '/tmp/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3. 2023-02-19T20:51:12.559507Z 0 [System] [MY-013292] [Server] Admin interface ready for connections, address: '10.244.0.5' port: 33062 2023-02-19T20:51:12.582185Z 2 [Note] [MY-000000] [Galera] Recording CC from group: 23 2023-02-19T20:51:12.583549Z 2 [Note] [MY-000000] [Galera] Lowest cert index boundary for CC from group: 23 2023-02-19T20:51:12.584814Z 2 [Note] [MY-000000] [Galera] Min available from gcache for CC from group: 1 2023-02-19T20:51:12.585963Z 2 [Note] [MY-000000] [Galera] Server minimal-cluster-pxc-0 synced with group 2023-02-19T20:51:12.586090Z 2 [Note] [MY-000000] [WSREP] Server status change joined -> synced 2023-02-19T20:51:12.586199Z 2 [Note] [MY-000000] [WSREP] Synchronized with group, ready for connections 2023-02-19T20:51:12.586255Z 2 [Note] [MY-000000] [WSREP] wsrep_notify_cmd is not defined, skipping notification. 2023-02-19T20:51:16.573069Z 14 [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 'mysql_native_password' to rewrite authentication information (if any) for them: 'monitor'@'%' 2023-02-19T20:51:16.635112Z 16 [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 'mysql_native_password' to rewrite authentication information (if any) for them: 'xtrabackup'@'%'