CURRENT_TEST: galera_3nodes.galera_ssl_reload
$ /usr/sbin/mariadbd --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2023-11-10 20:55:02 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2023-11-10 20:55:02 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2023-11-10 20:55:02 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16031' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
2023-11-10 20:55:02 0 [Note] Starting MariaDB 10.5.23-MariaDB-log source revision 40c405d923d192119f8e7df2f00b7964bada9fdf as process 78587
2023-11-10 20:55:02 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:02 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
2023-11-10 20:55:02 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy <info@codership.com> loaded successfully.
2023-11-10 20:55:02 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2023-11-10 20:55:02 0 [Warning] WSREP: SSL compression is not effective. The option socket.ssl_compression is deprecated and will be removed in future releases.
2023-11-10 20:55:02 0 [Warning] WSREP: Parameter 'socket.ssl_compression' is deprecated and will be removed in future versions
2023-11-10 20:55:02 0 [Warning] WSREP: Could not open state file for reading: '/dev/shm/var/2/mysqld.3/data//grastate.dat'
2023-11-10 20:55:02 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2023-11-10 20:55:02 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 0
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 0
2023-11-10 20:55:02 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
2023-11-10 20:55:02 0 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/var/2/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16029; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/var/2/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor
2023-11-10 20:55:02 0 [Note] WSREP: Start replication
2023-11-10 20:55:02 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-11-10 20:55:02 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:02 0 [Note] WSREP: protonet asio version 0
2023-11-10 20:55:02 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-11-10 20:55:02 0 [Note] WSREP: backend: asio
2023-11-10 20:55:02 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2023-11-10 20:55:02 0 [Note] WSREP: access file(/dev/shm/var/2/mysqld.3/data//gvwstate.dat) failed(No such file or directory)
2023-11-10 20:55:02 0 [Note] WSREP: restore pc from disk failed
2023-11-10 20:55:02 0 [Note] WSREP: GMCast version 0
2023-11-10 20:55:02 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') listening at ssl://0.0.0.0:16029
2023-11-10 20:55:02 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') multicast: , ttl: 1
2023-11-10 20:55:02 0 [Note] WSREP: EVS version 1
2023-11-10 20:55:02 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16023'
2023-11-10 20:55:02 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6aced7f7-870d ssl://127.0.0.1:16023
2023-11-10 20:55:02 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: ssl://127.0.0.1:16026 
2023-11-10 20:55:02 0 [Warning] WSREP: Handshake failed: unexpected eof while reading
2023-11-10 20:55:02 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6af421d2-afbc ssl://127.0.0.1:16026
2023-11-10 20:55:03 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') reconnecting to 6aced7f7-870d (ssl://127.0.0.1:16023), attempt 0
2023-11-10 20:55:03 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6aced7f7-870d ssl://127.0.0.1:16023
2023-11-10 20:55:04 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') reconnecting to 6af421d2-afbc (ssl://127.0.0.1:16026), attempt 0
2023-11-10 20:55:04 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6af421d2-afbc ssl://127.0.0.1:16026
2023-11-10 20:55:05 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') reconnecting to 6aced7f7-870d (ssl://127.0.0.1:16023), attempt 0
2023-11-10 20:55:05 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6aced7f7-870d ssl://127.0.0.1:16023
2023-11-10 20:55:05 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') reconnecting to 6af421d2-afbc (ssl://127.0.0.1:16026), attempt 0
2023-11-10 20:55:05 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6af421d2-afbc ssl://127.0.0.1:16026
2023-11-10 20:55:06 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 6aced7f7-870d ssl://127.0.0.1:16023
2023-11-10 20:55:07 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-11-10 20:55:07 0 [Note] WSREP: declaring 6aced7f7-870d at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:07 0 [Note] WSREP: declaring 6af421d2-afbc at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:07 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-11-10 20:55:07 0 [Note] WSREP: Node 6aced7f7-870d state prim
2023-11-10 20:55:07 0 [Note] WSREP: view(view_id(PRIM,6aced7f7-870d,3) memb {
	6aced7f7-870d,0
	6af421d2-afbc,0
	6af6cb64-9f21,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:07 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:07 0 [Note] WSREP: gcomm: connected
2023-11-10 20:55:07 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-11-10 20:55:07 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-11-10 20:55:07 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
2023-11-10 20:55:07 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2023-11-10 20:55:07 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:07 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 6e3cc58c-800b-11ee-9f67-8eb79b5f238d
2023-11-10 20:55:07 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6e3cc58c-800b-11ee-9f67-8eb79b5f238d from 0 (rocky9-amd64)
2023-11-10 20:55:07 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6e3cc58c-800b-11ee-9f67-8eb79b5f238d from 1 (rocky9-amd64)
2023-11-10 20:55:07 2 [Note] WSREP: Starting applier thread 2
2023-11-10 20:55:07 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6e3cc58c-800b-11ee-9f67-8eb79b5f238d from 2 (rocky9-amd64)
2023-11-10 20:55:07 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 2,
	members    = 2/3 (joined/total),
	act_id     = 2,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:07 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:07 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3)
2023-11-10 20:55:07 2 [Note] WSREP: ####### processing CC 3, local, ordered
2023-11-10 20:55:07 2 [Note] WSREP: Process first view: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0 my uuid: 6af6cb64-800b-11ee-9f21-7222c1708563
2023-11-10 20:55:07 2 [Note] WSREP: Server rocky9-amd64 connected to cluster at position 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3 with ID 6af6cb64-800b-11ee-9f21-7222c1708563
2023-11-10 20:55:07 2 [Note] WSREP: Server status change disconnected -> connected
2023-11-10 20:55:07 2 [Note] WSREP: ####### My UUID: 6af6cb64-800b-11ee-9f21-7222c1708563
2023-11-10 20:55:07 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-11-10 20:55:07 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:07 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-11-10 20:55:07 2 [Note] WSREP: State transfer required: 
	Group state: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
	Local state: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:07 2 [Note] WSREP: Server status change connected -> joiner
2023-11-10 20:55:07 1 [Note] WSREP: Starting rollbacker thread 1
2023-11-10 20:55:07 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-11-10 20:55:07 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16031' --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --parent 78587 --progress 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300'
WSREP_SST: [INFO] rsync SST started on joiner (20231110 20:55:07.804)
2023-11-10 20:55:08 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 3, STRv: 3
2023-11-10 20:55:08 2 [Note] WSREP: IST receiver addr using ssl://127.0.0.1:16030
2023-11-10 20:55:08 2 [Note] WSREP: IST receiver using ssl
2023-11-10 20:55:08 2 [Note] WSREP: Prepared IST receiver for 0-3, listening at: ssl://127.0.0.1:16030
2023-11-10 20:55:08 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 0.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:08 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3)
2023-11-10 20:55:08 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2023-11-10 20:55:08 2 [Note] WSREP: Resetting GCache seqno map due to different histories.
2023-11-10 20:55:08 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:08 0 [Note] WSREP: 0.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:08 0 [Note] WSREP: Member 0.0 (rocky9-amd64) synced with group.
WSREP_SST: [INFO] Galera co-ords from recovery: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3 0 (20231110 20:55:09.096)
WSREP_SST: [INFO] rsync SST completed on joiner (20231110 20:55:09.099)
WSREP_SST: [INFO] Joiner cleanup: rsync PID=79099, stunnel PID=0 (20231110 20:55:09.102)
2023-11-10 20:55:09 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') turning message relay requesting off
WSREP_SST: [INFO] Joiner cleanup done. (20231110 20:55:09.631)
2023-11-10 20:55:09 3 [Note] WSREP: SST received
2023-11-10 20:55:09 3 [Note] WSREP: Server status change joiner -> initializing
2023-11-10 20:55:09 0 [Note] Plugin 'partition' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'SEQUENCE' is disabled.
2023-11-10 20:55:09 0 [Note] InnoDB: Uses event mutexes
2023-11-10 20:55:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-11-10 20:55:09 0 [Note] InnoDB: Number of pools: 1
2023-11-10 20:55:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-10 20:55:09 0 [Note] InnoDB: Using Linux native AIO
2023-11-10 20:55:09 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
2023-11-10 20:55:09 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-10 20:55:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58509,58509
2023-11-10 20:55:09 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-10 20:55:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-10 20:55:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-10 20:55:09 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-11-10 20:55:09 0 [Note] InnoDB: 10.5.23 started; log sequence number 58521; transaction id 46
2023-11-10 20:55:09 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_CMP' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'user_variables' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2023-11-10 20:55:09 0 [Note] Plugin 'unix_socket' is disabled.
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
2023-11-10 20:55:09 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
2023-11-10 20:55:09 0 [Note] InnoDB: Buffer pool(s) load completed at 231110 20:55:09
2023-11-10 20:55:09 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-11-10 20:55:09 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2023-11-10 20:55:09 0 [Note] WSREP: Server initialized
2023-11-10 20:55:09 0 [Note] WSREP: Server status change initializing -> initialized
2023-11-10 20:55:09 3 [Note] WSREP: Recovered position from storage: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:09 3 [Note] WSREP: Server status change initialized -> joined
2023-11-10 20:55:09 3 [Note] WSREP: Recovered view from SST:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
  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: 2
  members(3):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 6af421d2-800b-11ee-afbc-beedfaa46504, rocky9-amd64
	2: 6af6cb64-800b-11ee-9f21-7222c1708563, rocky9-amd64

2023-11-10 20:55:09 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:09 5 [Note] WSREP: Recovered cluster id 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:09 3 [Note] WSREP: SST received: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:09 3 [Note] WSREP: SST succeeded for position 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:09 2 [Note] WSREP: Installed new state from SST: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:09 2 [Note] WSREP: Cert. index preload up to 3
2023-11-10 20:55:09 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec
2023-11-10 20:55:09 0 [Note] WSREP: ####### IST applying starts with 4
2023-11-10 20:55:09 0 [Note] WSREP: ####### IST current seqno initialized to 3
2023-11-10 20:55:09 0 [Note] WSREP: Receiving IST...  0.0% (0/1 events) complete.
2023-11-10 20:55:09 0 [Note] WSREP: IST preload starting at 3
2023-11-10 20:55:09 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:09 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:09 0 [Note] WSREP: ####### Assign initial position for certification: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:2, protocol version: 5
2023-11-10 20:55:09 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:09 0 [Note] WSREP: ####### Adjusting cert position: 2 -> 3
2023-11-10 20:55:09 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:09 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 3
2023-11-10 20:55:09 0 [Note] WSREP: Min available from gcache for CC from preload: 3
2023-11-10 20:55:09 0 [Note] WSREP: Receiving IST...100.0% (1/1 events) complete.
2023-11-10 20:55:09 2 [Note] WSREP: IST received: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:09 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 3
2023-11-10 20:55:09 2 [Note] WSREP: Min available from gcache for CC from sst: 3
2023-11-10 20:55:09 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 0.0 (rocky9-amd64) complete.
2023-11-10 20:55:09 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3)
2023-11-10 20:55:09 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:09 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:09 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:09 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3)
2023-11-10 20:55:09 2 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:09 2 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:09 2 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:09 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:09 0 [Note] Reading of all Master_info entries succeeded
2023-11-10 20:55:09 0 [Note] Added new Master_info '' to hash table
2023-11-10 20:55:09 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.5.23-MariaDB-log'  socket: '/dev/shm/var/tmp/2/mysqld.3.sock'  port: 16022  MariaDB Server
2023-11-10 20:55:11 0 [Note] WSREP: declaring 6aced7f7-870d at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:11 0 [Note] WSREP: forgetting 6af421d2-afbc (ssl://127.0.0.1:16026)
2023-11-10 20:55:11 0 [Note] WSREP: Node 6aced7f7-870d state prim
2023-11-10 20:55:11 0 [Note] WSREP: view(view_id(PRIM,6aced7f7-870d,4) memb {
	6aced7f7-870d,0
	6af6cb64-9f21,0
} joined {
} left {
} partitioned {
	6af421d2-afbc,0
})
2023-11-10 20:55:11 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:11 0 [Note] WSREP: forgetting 6af421d2-afbc (ssl://127.0.0.1:16026)
2023-11-10 20:55:11 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2023-11-10 20:55:11 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:11 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 70a9a764-800b-11ee-9f0c-ab439f4b0a04
2023-11-10 20:55:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: 70a9a764-800b-11ee-9f0c-ab439f4b0a04 from 0 (rocky9-amd64)
2023-11-10 20:55:11 0 [Note] WSREP: STATE EXCHANGE: got state msg: 70a9a764-800b-11ee-9f0c-ab439f4b0a04 from 1 (rocky9-amd64)
2023-11-10 20:55:11 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 3,
	members    = 2/2 (joined/total),
	act_id     = 3,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:11 0 [Note] WSREP: Flow-control interval: [23, 23]
2023-11-10 20:55:11 2 [Note] WSREP: ####### processing CC 4, local, ordered
2023-11-10 20:55:11 2 [Note] WSREP: ####### My UUID: 6af6cb64-800b-11ee-9f21-7222c1708563
2023-11-10 20:55:11 2 [Note] WSREP: Skipping cert index reset
2023-11-10 20:55:11 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:11 2 [Note] WSREP: ####### Adjusting cert position: 3 -> 4
2023-11-10 20:55:11 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:11 2 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:4
  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: 1
  members(2):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 6af6cb64-800b-11ee-9f21-7222c1708563, rocky9-amd64
=================================================
2023-11-10 20:55:11 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:11 2 [Note] WSREP: Lowest cert index boundary for CC from group: 4
2023-11-10 20:55:11 2 [Note] WSREP: Min available from gcache for CC from group: 3
2023-11-10 20:55:13 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') connection established to 716d759e-a20b ssl://127.0.0.1:16026
2023-11-10 20:55:13 0 [Note] WSREP: remote endpoint ssl://127.0.0.1:16026 changed identity 6af421d2-800b-11ee-afbc-beedfaa46504 -> 716d759e-800b-11ee-a20b-66364d14098f
2023-11-10 20:55:13 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: 
2023-11-10 20:55:15 0 [Note] WSREP: declaring 6aced7f7-870d at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:15 0 [Note] WSREP: declaring 716d759e-a20b at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:15 0 [Note] WSREP: Node 6aced7f7-870d state prim
2023-11-10 20:55:15 0 [Note] WSREP: view(view_id(PRIM,6aced7f7-870d,5) memb {
	6aced7f7-870d,0
	6af6cb64-9f21,0
	716d759e-a20b,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:15 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:15 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2023-11-10 20:55:15 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:15 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 72ebf4ba-800b-11ee-8fa6-32c8bffb1166
2023-11-10 20:55:15 0 [Note] WSREP: STATE EXCHANGE: got state msg: 72ebf4ba-800b-11ee-8fa6-32c8bffb1166 from 0 (rocky9-amd64)
2023-11-10 20:55:15 0 [Note] WSREP: STATE EXCHANGE: got state msg: 72ebf4ba-800b-11ee-8fa6-32c8bffb1166 from 1 (rocky9-amd64)
2023-11-10 20:55:16 0 [Note] WSREP: STATE EXCHANGE: got state msg: 72ebf4ba-800b-11ee-8fa6-32c8bffb1166 from 2 (rocky9-amd64)
2023-11-10 20:55:16 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 4,
	members    = 2/3 (joined/total),
	act_id     = 4,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:16 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:16 2 [Note] WSREP: ####### processing CC 5, local, ordered
2023-11-10 20:55:16 2 [Note] WSREP: ####### My UUID: 6af6cb64-800b-11ee-9f21-7222c1708563
2023-11-10 20:55:16 2 [Note] WSREP: Skipping cert index reset
2023-11-10 20:55:16 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:16 2 [Note] WSREP: ####### Adjusting cert position: 4 -> 5
2023-11-10 20:55:16 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:16 2 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
  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: 1
  members(3):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 6af6cb64-800b-11ee-9f21-7222c1708563, rocky9-amd64
	2: 716d759e-800b-11ee-a20b-66364d14098f, rocky9-amd64
=================================================
2023-11-10 20:55:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:16 2 [Note] WSREP: Lowest cert index boundary for CC from group: 5
2023-11-10 20:55:16 2 [Note] WSREP: Min available from gcache for CC from group: 3
2023-11-10 20:55:16 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 1.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:16 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 5)
2023-11-10 20:55:16 2 [Note] WSREP: Detected STR version: 1, req_len: 109, req: STRv1
2023-11-10 20:55:16 2 [Note] WSREP: IST request: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3-5|ssl://127.0.0.1:16027
2023-11-10 20:55:16 2 [Note] WSREP: Server status change synced -> donor
2023-11-10 20:55:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:16 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16028/rsync_sst' --local-port 16022 --socket '/dev/shm/var/tmp/2/mysqld.3.sock' --progress 0 --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --gtid '6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3' --gtid-domain-id 0 --binlog-index 'mysqld-bin.index' --bypass --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300'
2023-11-10 20:55:16 0 [Note] WSREP: Donor monitor thread started to monitor
2023-11-10 20:55:16 2 [Note] WSREP: sst_donor_thread signaled with 0
2023-11-10 20:55:16 0 [Note] WSREP: async IST sender starting to serve ssl://127.0.0.1:16027 sending 4-5, preload starts from 5
2023-11-10 20:55:16 0 [Note] WSREP: IST sender 4 -> 5
WSREP_SST: [INFO] rsync IST started on donor (20231110 20:55:16.469)
WSREP_SST: [INFO] Bypassing state dump. (20231110 20:55:16.686)
WSREP_SST: [INFO] Sending continue to donor (20231110 20:55:16.691)
2023-11-10 20:55:16 0 [Note] WSREP: SST sent: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:3
2023-11-10 20:55:16 0 [Note] WSREP: Server status change donor -> joined
2023-11-10 20:55:16 0 [Note] WSREP: 1.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:16 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 5)
2023-11-10 20:55:16 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:16 0 [Note] WSREP: Member 1.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:16 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:16 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 5)
2023-11-10 20:55:16 2 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:16 2 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:16 2 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:16 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] rsync IST completed on donor (20231110 20:55:16.702)
2023-11-10 20:55:16 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec
2023-11-10 20:55:16 0 [Note] WSREP: (6af6cb64-9f21, 'ssl://0.0.0.0:16029') turning message relay requesting off
2023-11-10 20:55:18 0 [Note] WSREP: async IST sender served
2023-11-10 20:55:18 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 1.0 (rocky9-amd64) complete.
2023-11-10 20:55:18 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:18 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost [127.0.0.1]): Normal shutdown
2023-11-10 20:55:18 0 [Note] WSREP: Shutdown replication
2023-11-10 20:55:18 0 [Note] WSREP: Server status change synced -> disconnecting
2023-11-10 20:55:18 0 [Note] WSREP: Closing send monitor...
2023-11-10 20:55:18 0 [Note] WSREP: Closed send monitor.
2023-11-10 20:55:18 0 [Note] WSREP: gcomm: terminating thread
2023-11-10 20:55:18 0 [Note] WSREP: gcomm: joining thread
2023-11-10 20:55:18 0 [Note] WSREP: gcomm: closing backend
2023-11-10 20:55:18 0 [Note] WSREP: view(view_id(NON_PRIM,6aced7f7-870d,5) memb {
	6af6cb64-9f21,0
} joined {
} left {
} partitioned {
	6aced7f7-870d,0
	716d759e-a20b,0
})
2023-11-10 20:55:18 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2023-11-10 20:55:18 0 [Note] WSREP: view((empty))
2023-11-10 20:55:18 0 [Note] WSREP: gcomm: closed
2023-11-10 20:55:18 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2023-11-10 20:55:18 0 [Note] WSREP: Flow-control interval: [16, 16]
2023-11-10 20:55:18 0 [Note] WSREP: Received NON-PRIMARY.
2023-11-10 20:55:18 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 5)
2023-11-10 20:55:18 0 [Note] WSREP: New SELF-LEAVE.
2023-11-10 20:55:18 0 [Note] WSREP: Flow-control interval: [0, 0]
2023-11-10 20:55:18 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2023-11-10 20:55:18 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 5)
2023-11-10 20:55:18 0 [Note] WSREP: RECV thread exiting 0: Success
2023-11-10 20:55:18 0 [Note] WSREP: recv_thread() joined.
2023-11-10 20:55:18 0 [Note] WSREP: Closing replication queue.
2023-11-10 20:55:18 0 [Note] WSREP: Closing slave action queue.
2023-11-10 20:55:18 2 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 0
  members(1):
	0: 6af6cb64-800b-11ee-9f21-7222c1708563, rocky9-amd64
=================================================
2023-11-10 20:55:18 2 [Note] WSREP: Non-primary view
2023-11-10 20:55:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:18 2 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
  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-11-10 20:55:18 2 [Note] WSREP: Non-primary view
2023-11-10 20:55:18 2 [Note] WSREP: Server status change disconnecting -> disconnected
2023-11-10 20:55:18 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:18 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2
2023-11-10 20:55:18 1 [Note] WSREP: rollbacker thread exiting 1
2023-11-10 20:55:18 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-11-10 20:55:18 0 [Note] WSREP: dtor state: CLOSED
2023-11-10 20:55:18 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:18 0 [Note] WSREP: apply mon: entered 0
2023-11-10 20:55:18 0 [Note] WSREP: apply mon: entered 0
2023-11-10 20:55:18 0 [Note] WSREP: mon: entered 10 oooe fraction 0 oool fraction 0.1
2023-11-10 20:55:18 0 [Note] WSREP: cert index usage at exit 0
2023-11-10 20:55:18 0 [Note] WSREP: cert trx map usage at exit 0
2023-11-10 20:55:18 0 [Note] WSREP: deps set usage at exit 0
2023-11-10 20:55:18 0 [Note] WSREP: avg deps dist 0
2023-11-10 20:55:18 0 [Note] WSREP: avg cert interval 0
2023-11-10 20:55:18 0 [Note] WSREP: cert index size 0
2023-11-10 20:55:18 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:18 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2023-11-10 20:55:18 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:18 0 [Note] WSREP: Flushing memory map to disk...
2023-11-10 20:55:18 0 [Note] InnoDB: FTS optimize thread exiting.
2023-11-10 20:55:18 0 [Note] InnoDB: Starting shutdown...
2023-11-10 20:55:18 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:18 0 [Note] InnoDB: Restricted to 125 pages due to innodb_buf_pool_dump_pct=25
2023-11-10 20:55:18 0 [Note] InnoDB: Buffer pool(s) dump completed at 231110 20:55:18
2023-11-10 20:55:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-10 20:55:18 0 [Note] InnoDB: Shutdown completed; log sequence number 61210; transaction id 57
2023-11-10 20:55:18 0 [Note] /usr/sbin/mariadbd: Shutdown complete

$ /usr/sbin/mariadbd --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --wsrep_cluster_address=gcomm://127.0.0.1:16026 --core-file --loose-debug-sync-timeout=300
2023-11-10 20:55:19 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2023-11-10 20:55:19 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2023-11-10 20:55:19 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16031' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
2023-11-10 20:55:19 0 [Note] Starting MariaDB 10.5.23-MariaDB-log source revision 40c405d923d192119f8e7df2f00b7964bada9fdf as process 80503
2023-11-10 20:55:19 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:19 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
2023-11-10 20:55:19 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy <info@codership.com> loaded successfully.
2023-11-10 20:55:19 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2023-11-10 20:55:19 0 [Warning] WSREP: SSL compression is not effective. The option socket.ssl_compression is deprecated and will be removed in future releases.
2023-11-10 20:55:19 0 [Warning] WSREP: Parameter 'socket.ssl_compression' is deprecated and will be removed in future versions
2023-11-10 20:55:19 0 [Note] WSREP: Found saved state: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5, safe_to_bootstrap: 0
2023-11-10 20:55:19 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
Seqno: 3 - 5
Offset: 1280
Synced: 1
2023-11-10 20:55:19 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0, offset: 1280
2023-11-10 20:55:19 0 [Note] WSREP: GCache::RingBuffer initial scan...  0.0% (        0/134217752 bytes) complete.
2023-11-10 20:55:19 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2023-11-10 20:55:19 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 3-5
2023-11-10 20:55:19 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...  0.0% (  0/880 bytes) complete.
2023-11-10 20:55:19 0 [Note] WSREP: Recovering GCache ring buffer: found 0/3 locked buffers
2023-11-10 20:55:19 0 [Note] WSREP: Recovering GCache ring buffer: free space: 134216848/134217728
2023-11-10 20:55:19 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (880/880 bytes) complete.
2023-11-10 20:55:19 0 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/var/2/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16029; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/var/2/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor
2023-11-10 20:55:19 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:19 0 [Note] WSREP: ####### Assign initial position for certification: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5, protocol version: -1
2023-11-10 20:55:19 0 [Note] WSREP: Start replication
2023-11-10 20:55:19 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-11-10 20:55:19 0 [Note] WSREP: Setting GCS initial position to 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:19 0 [Note] WSREP: protonet asio version 0
2023-11-10 20:55:19 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-11-10 20:55:19 0 [Note] WSREP: backend: asio
2023-11-10 20:55:19 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2023-11-10 20:55:19 0 [Note] WSREP: access file(/dev/shm/var/2/mysqld.3/data//gvwstate.dat) failed(No such file or directory)
2023-11-10 20:55:19 0 [Note] WSREP: restore pc from disk failed
2023-11-10 20:55:19 0 [Note] WSREP: GMCast version 0
2023-11-10 20:55:19 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') listening at ssl://0.0.0.0:16029
2023-11-10 20:55:19 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') multicast: , ttl: 1
2023-11-10 20:55:19 0 [Note] WSREP: EVS version 1
2023-11-10 20:55:19 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16026'
2023-11-10 20:55:19 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') connection established to 716d759e-a20b ssl://127.0.0.1:16026
2023-11-10 20:55:19 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: ssl://127.0.0.1:16023 
2023-11-10 20:55:20 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') connection established to 6aced7f7-870d ssl://127.0.0.1:16023
2023-11-10 20:55:22 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-11-10 20:55:22 0 [Note] WSREP: declaring 6aced7f7-870d at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:22 0 [Note] WSREP: declaring 716d759e-a20b at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:22 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-11-10 20:55:22 0 [Note] WSREP: Node 6aced7f7-870d state prim
2023-11-10 20:55:22 0 [Note] WSREP: view(view_id(PRIM,6aced7f7-870d,7) memb {
	6aced7f7-870d,0
	716d759e-a20b,0
	75486779-b798,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:22 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:22 0 [Note] WSREP: gcomm: connected
2023-11-10 20:55:22 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-11-10 20:55:22 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-11-10 20:55:22 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
2023-11-10 20:55:22 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2023-11-10 20:55:22 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:22 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 76c6c860-800b-11ee-8d66-9e47fb9b861f
2023-11-10 20:55:22 0 [Note] WSREP: STATE EXCHANGE: got state msg: 76c6c860-800b-11ee-8d66-9e47fb9b861f from 0 (rocky9-amd64)
2023-11-10 20:55:22 0 [Note] WSREP: STATE EXCHANGE: got state msg: 76c6c860-800b-11ee-8d66-9e47fb9b861f from 1 (rocky9-amd64)
2023-11-10 20:55:22 2 [Note] WSREP: Starting rollbacker thread 2
2023-11-10 20:55:22 0 [Note] WSREP: STATE EXCHANGE: got state msg: 76c6c860-800b-11ee-8d66-9e47fb9b861f from 2 (rocky9-amd64)
2023-11-10 20:55:22 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 6,
	members    = 2/3 (joined/total),
	act_id     = 6,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:22 1 [Note] WSREP: Starting applier thread 1
2023-11-10 20:55:22 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:22 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 7)
2023-11-10 20:55:22 1 [Note] WSREP: ####### processing CC 7, local, ordered
2023-11-10 20:55:22 1 [Note] WSREP: Process first view: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0 my uuid: 75486779-800b-11ee-b798-63b6e69c651d
2023-11-10 20:55:22 1 [Note] WSREP: Server rocky9-amd64 connected to cluster at position 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7 with ID 75486779-800b-11ee-b798-63b6e69c651d
2023-11-10 20:55:22 1 [Note] WSREP: Server status change disconnected -> connected
2023-11-10 20:55:22 1 [Note] WSREP: ####### My UUID: 75486779-800b-11ee-b798-63b6e69c651d
2023-11-10 20:55:22 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-11-10 20:55:22 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:22 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-11-10 20:55:22 1 [Note] WSREP: State transfer required: 
	Group state: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7
	Local state: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:22 1 [Note] WSREP: Server status change connected -> joiner
2023-11-10 20:55:22 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-11-10 20:55:22 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16031' --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --parent 80503 --progress 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --wsrep_cluster_address=gcomm://127.0.0.1:16026 --core-file --loose-debug-sync-timeout=300'
WSREP_SST: [INFO] rsync SST started on joiner (20231110 20:55:22.626)
2023-11-10 20:55:22 1 [Note] WSREP: ####### IST uuid:6acf0bb7-800b-11ee-aa82-3f173e7e64b0 f: 6, l: 7, STRv: 3
2023-11-10 20:55:22 1 [Note] WSREP: IST receiver addr using ssl://127.0.0.1:16030
2023-11-10 20:55:22 1 [Note] WSREP: IST receiver using ssl
2023-11-10 20:55:22 1 [Note] WSREP: Prepared IST receiver for 6-7, listening at: ssl://127.0.0.1:16030
2023-11-10 20:55:22 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 1.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:22 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 7)
2023-11-10 20:55:22 1 [Note] WSREP: Requesting state transfer: success, donor: 1
2023-11-10 20:55:23 0 [Note] WSREP: 1.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:23 0 [Note] WSREP: Member 1.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:23 0 [Note] WSREP: (75486779-b798, 'ssl://0.0.0.0:16029') turning message relay requesting off
WSREP_SST: [INFO] Galera co-ords from recovery: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5 0 (20231110 20:55:23.943)
WSREP_SST: [INFO] rsync IST completed on joiner (20231110 20:55:23.947)
WSREP_SST: [INFO] Joiner cleanup: rsync PID=80762, stunnel PID=0 (20231110 20:55:23.951)
WSREP_SST: [INFO] Joiner cleanup done. (20231110 20:55:24.487)
2023-11-10 20:55:24 3 [Note] WSREP: SST received
2023-11-10 20:55:24 3 [Note] WSREP: Server status change joiner -> initializing
2023-11-10 20:55:24 0 [Note] Plugin 'partition' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'SEQUENCE' is disabled.
2023-11-10 20:55:24 0 [Note] InnoDB: Uses event mutexes
2023-11-10 20:55:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-11-10 20:55:24 0 [Note] InnoDB: Number of pools: 1
2023-11-10 20:55:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-10 20:55:24 0 [Note] InnoDB: Using Linux native AIO
2023-11-10 20:55:24 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
2023-11-10 20:55:24 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-10 20:55:24 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-10 20:55:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-10 20:55:24 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-10 20:55:24 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-11-10 20:55:24 0 [Note] InnoDB: 10.5.23 started; log sequence number 61210; transaction id 58
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2023-11-10 20:55:24 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_CMP' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'user_variables' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2023-11-10 20:55:24 0 [Note] Plugin 'unix_socket' is disabled.
2023-11-10 20:55:24 0 [Note] InnoDB: Buffer pool(s) load completed at 231110 20:55:24
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
2023-11-10 20:55:24 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
2023-11-10 20:55:24 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-11-10 20:55:24 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2023-11-10 20:55:24 0 [Note] WSREP: Server initialized
2023-11-10 20:55:24 0 [Note] WSREP: Server status change initializing -> initialized
2023-11-10 20:55:24 3 [Note] WSREP: Recovered position from storage: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:24 3 [Note] WSREP: Recovered view from SST:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
  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: -1
  members(3):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 6af6cb64-800b-11ee-9f21-7222c1708563, rocky9-amd64
	2: 716d759e-800b-11ee-a20b-66364d14098f, rocky9-amd64

2023-11-10 20:55:24 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:24 5 [Note] WSREP: Recovered cluster id 6acf0bb7-800b-11ee-aa82-3f173e7e64b0
2023-11-10 20:55:24 3 [Note] WSREP: SST received: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:24 3 [Note] WSREP: SST succeeded for position 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:24 1 [Note] WSREP: Installed new state from SST: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5
2023-11-10 20:55:24 1 [Note] WSREP: Receiving IST: 2 writesets, seqnos 6-7
2023-11-10 20:55:24 0 [Note] WSREP: ####### IST applying starts with 6
2023-11-10 20:55:24 0 [Note] WSREP: ####### IST current seqno initialized to 6
2023-11-10 20:55:24 0 [Note] WSREP: Receiving IST...  0.0% (0/2 events) complete.
2023-11-10 20:55:24 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:24 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:24 0 [Note] WSREP: ####### Assign initial position for certification: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:5, protocol version: 5
2023-11-10 20:55:24 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:24 0 [Note] WSREP: ####### Adjusting cert position: 5 -> 6
2023-11-10 20:55:24 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:24 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 6
2023-11-10 20:55:24 0 [Note] WSREP: Min available from gcache for CC from ist: 3
2023-11-10 20:55:24 0 [Note] WSREP: IST preload starting at 7
2023-11-10 20:55:24 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec
2023-11-10 20:55:24 1 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:6
  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: -1
  members(2):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 716d759e-800b-11ee-a20b-66364d14098f, rocky9-amd64
=================================================
2023-11-10 20:55:24 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:24 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:24 0 [Note] WSREP: ####### Adjusting cert position: 6 -> 7
2023-11-10 20:55:24 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:24 0 [Note] Reading of all Master_info entries succeeded
2023-11-10 20:55:24 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 7
2023-11-10 20:55:24 0 [Note] WSREP: Min available from gcache for CC from ist: 3
2023-11-10 20:55:24 0 [Note] Added new Master_info '' to hash table
2023-11-10 20:55:24 0 [Note] WSREP: Receiving IST...100.0% (2/2 events) complete.
2023-11-10 20:55:24 1 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7
  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: 2
  members(3):
	0: 6aced7f7-800b-11ee-870d-628c54cd7fd1, rocky9-amd64
	1: 716d759e-800b-11ee-a20b-66364d14098f, rocky9-amd64
	2: 75486779-800b-11ee-b798-63b6e69c651d, rocky9-amd64
=================================================
2023-11-10 20:55:24 1 [Note] WSREP: Server status change initialized -> joined
2023-11-10 20:55:24 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:24 1 [Note] WSREP: Draining apply monitors after IST up to 7
2023-11-10 20:55:24 1 [Note] WSREP: IST received: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7
2023-11-10 20:55:24 1 [Note] WSREP: Lowest cert index boundary for CC from sst: 7
2023-11-10 20:55:24 1 [Note] WSREP: Min available from gcache for CC from sst: 3
2023-11-10 20:55:24 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 1.0 (rocky9-amd64) complete.
2023-11-10 20:55:24 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 7)
2023-11-10 20:55:24 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:24 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.5.23-MariaDB-log'  socket: '/dev/shm/var/tmp/2/mysqld.3.sock'  port: 16022  MariaDB Server
2023-11-10 20:55:24 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:24 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:24 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 7)
2023-11-10 20:55:24 1 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:24 1 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:24 1 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:24 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:25 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2023-11-10 20:55:25 0 [Note] WSREP: Shutdown replication
2023-11-10 20:55:25 0 [Note] WSREP: Server status change synced -> disconnecting
2023-11-10 20:55:25 0 [Note] WSREP: Closing send monitor...
2023-11-10 20:55:25 0 [Note] WSREP: Closed send monitor.
2023-11-10 20:55:25 0 [Note] WSREP: gcomm: terminating thread
2023-11-10 20:55:25 0 [Note] WSREP: gcomm: joining thread
2023-11-10 20:55:25 0 [Note] WSREP: gcomm: closing backend
2023-11-10 20:55:30 0 [Note] WSREP: evs::proto(75486779-b798, LEAVING, view_id(REG,6aced7f7-870d,7)) suspecting node: 6aced7f7-870d
2023-11-10 20:55:30 0 [Note] WSREP: evs::proto(75486779-b798, LEAVING, view_id(REG,6aced7f7-870d,7)) suspecting node: 716d759e-a20b
2023-11-10 20:55:30 0 [Note] WSREP: view(view_id(NON_PRIM,6aced7f7-870d,7) memb {
	75486779-b798,0
} joined {
} left {
} partitioned {
	6aced7f7-870d,0
	716d759e-a20b,0
})
2023-11-10 20:55:30 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2023-11-10 20:55:30 0 [Note] WSREP: view((empty))
2023-11-10 20:55:30 0 [Note] WSREP: gcomm: closed
2023-11-10 20:55:30 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2023-11-10 20:55:30 0 [Note] WSREP: Flow-control interval: [16, 16]
2023-11-10 20:55:30 0 [Note] WSREP: Received NON-PRIMARY.
2023-11-10 20:55:30 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 7)
2023-11-10 20:55:30 0 [Note] WSREP: New SELF-LEAVE.
2023-11-10 20:55:30 0 [Note] WSREP: Flow-control interval: [0, 0]
2023-11-10 20:55:30 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2023-11-10 20:55:30 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 7)
2023-11-10 20:55:30 0 [Note] WSREP: RECV thread exiting 0: Success
2023-11-10 20:55:30 0 [Note] WSREP: recv_thread() joined.
2023-11-10 20:55:30 0 [Note] WSREP: Closing replication queue.
2023-11-10 20:55:30 0 [Note] WSREP: Closing slave action queue.
2023-11-10 20:55:30 1 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 0
  members(1):
	0: 75486779-800b-11ee-b798-63b6e69c651d, rocky9-amd64
=================================================
2023-11-10 20:55:30 1 [Note] WSREP: Non-primary view
2023-11-10 20:55:30 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:30 1 [Note] WSREP: ================================================
View:
  id: 6acf0bb7-800b-11ee-aa82-3f173e7e64b0:7
  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-11-10 20:55:30 1 [Note] WSREP: Non-primary view
2023-11-10 20:55:30 1 [Note] WSREP: Server status change disconnecting -> disconnected
2023-11-10 20:55:30 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:30 1 [Note] WSREP: Applier thread exiting ret: 0 thd: 1
2023-11-10 20:55:30 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2023-11-10 20:55:30 2 [Note] WSREP: rollbacker thread exiting 2
2023-11-10 20:55:30 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2023-11-10 20:55:30 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-11-10 20:55:30 0 [Note] WSREP: dtor state: CLOSED
2023-11-10 20:55:30 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:30 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2023-11-10 20:55:30 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2023-11-10 20:55:30 0 [Note] WSREP: mon: entered 5 oooe fraction 0 oool fraction 0.2
2023-11-10 20:55:30 0 [Note] WSREP: cert index usage at exit 0
2023-11-10 20:55:30 0 [Note] WSREP: cert trx map usage at exit 0
2023-11-10 20:55:30 0 [Note] WSREP: deps set usage at exit 0
2023-11-10 20:55:30 0 [Note] WSREP: avg deps dist 0
2023-11-10 20:55:30 0 [Note] WSREP: avg cert interval 0
2023-11-10 20:55:30 0 [Note] WSREP: cert index size 0
2023-11-10 20:55:30 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:30 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2023-11-10 20:55:30 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:30 0 [Note] WSREP: Flushing memory map to disk...
2023-11-10 20:55:30 0 [Note] InnoDB: FTS optimize thread exiting.
2023-11-10 20:55:30 0 [Note] InnoDB: Starting shutdown...
2023-11-10 20:55:30 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:30 0 [Note] InnoDB: Restricted to 125 pages due to innodb_buf_pool_dump_pct=25
2023-11-10 20:55:30 0 [Note] InnoDB: Buffer pool(s) dump completed at 231110 20:55:30
2023-11-10 20:55:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-10 20:55:30 0 [Note] InnoDB: Shutdown completed; log sequence number 63547; transaction id 69
2023-11-10 20:55:30 0 [Note] /usr/sbin/mariadbd: Shutdown complete

CURRENT_TEST: galera_3nodes.galera_ssl_reload
$ /usr/sbin/mariadbd --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2023-11-10 20:55:30 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2023-11-10 20:55:30 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2023-11-10 20:55:30 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16031' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
2023-11-10 20:55:30 0 [Note] Starting MariaDB 10.5.23-MariaDB-log source revision 40c405d923d192119f8e7df2f00b7964bada9fdf as process 81211
2023-11-10 20:55:30 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:30 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
2023-11-10 20:55:30 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy <info@codership.com> loaded successfully.
2023-11-10 20:55:30 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2023-11-10 20:55:30 0 [Warning] WSREP: SSL compression is not effective. The option socket.ssl_compression is deprecated and will be removed in future releases.
2023-11-10 20:55:30 0 [Warning] WSREP: Parameter 'socket.ssl_compression' is deprecated and will be removed in future versions
2023-11-10 20:55:30 0 [Warning] WSREP: Could not open state file for reading: '/dev/shm/var/2/mysqld.3/data//grastate.dat'
2023-11-10 20:55:30 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2023-11-10 20:55:30 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 0
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 0
2023-11-10 20:55:30 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
2023-11-10 20:55:30 0 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/var/2/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16029; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/var/2/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor
2023-11-10 20:55:30 0 [Note] WSREP: Start replication
2023-11-10 20:55:30 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-11-10 20:55:30 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:30 0 [Note] WSREP: protonet asio version 0
2023-11-10 20:55:30 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-11-10 20:55:30 0 [Note] WSREP: backend: asio
2023-11-10 20:55:30 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2023-11-10 20:55:30 0 [Note] WSREP: access file(/dev/shm/var/2/mysqld.3/data//gvwstate.dat) failed(No such file or directory)
2023-11-10 20:55:30 0 [Note] WSREP: restore pc from disk failed
2023-11-10 20:55:30 0 [Note] WSREP: GMCast version 0
2023-11-10 20:55:30 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') listening at ssl://0.0.0.0:16029
2023-11-10 20:55:30 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') multicast: , ttl: 1
2023-11-10 20:55:30 0 [Note] WSREP: EVS version 1
2023-11-10 20:55:30 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16023'
2023-11-10 20:55:30 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') connection established to 7bc65b97-84a7 ssl://127.0.0.1:16023
2023-11-10 20:55:30 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: 
2023-11-10 20:55:31 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-11-10 20:55:31 0 [Note] WSREP: declaring 7bc65b97-84a7 at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:31 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-11-10 20:55:31 0 [Note] WSREP: Node 7bc65b97-84a7 state prim
2023-11-10 20:55:31 0 [Note] WSREP: view(view_id(PRIM,7bc65b97-84a7,2) memb {
	7bc65b97-84a7,0
	7be87480-8308,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:31 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:31 0 [Note] WSREP: forgetting 7beabfb8-aa16 (ssl://127.0.0.1:16026)
2023-11-10 20:55:31 0 [Note] WSREP: deleting entry ssl://127.0.0.1:16026
2023-11-10 20:55:31 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') connection established to 7beabfb8-aa16 ssl://127.0.0.1:16026
2023-11-10 20:55:31 0 [Warning] WSREP: discarding established (time wait) 7beabfb8-aa16 (ssl://127.0.0.1:16026) 
2023-11-10 20:55:31 0 [Note] WSREP: gcomm: connected
2023-11-10 20:55:31 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-11-10 20:55:31 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-11-10 20:55:31 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
2023-11-10 20:55:31 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2023-11-10 20:55:31 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:31 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 7c357828-800b-11ee-944b-ebb7e7f76895
2023-11-10 20:55:31 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7c357828-800b-11ee-944b-ebb7e7f76895 from 0 (rocky9-amd64)
2023-11-10 20:55:31 1 [Note] WSREP: Starting rollbacker thread 1
2023-11-10 20:55:31 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7c357828-800b-11ee-944b-ebb7e7f76895 from 1 (rocky9-amd64)
2023-11-10 20:55:31 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 1,
	members    = 1/2 (joined/total),
	act_id     = 1,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:31 0 [Note] WSREP: Flow-control interval: [23, 23]
2023-11-10 20:55:31 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2)
2023-11-10 20:55:31 2 [Note] WSREP: Starting applier thread 2
2023-11-10 20:55:31 2 [Note] WSREP: ####### processing CC 2, local, ordered
2023-11-10 20:55:31 2 [Note] WSREP: Process first view: 7bc693b1-800b-11ee-88d1-1bc961972f17 my uuid: 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:31 2 [Note] WSREP: Server rocky9-amd64 connected to cluster at position 7bc693b1-800b-11ee-88d1-1bc961972f17:2 with ID 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:31 2 [Note] WSREP: Server status change disconnected -> connected
2023-11-10 20:55:31 2 [Note] WSREP: ####### My UUID: 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:31 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-11-10 20:55:31 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:31 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-11-10 20:55:31 2 [Note] WSREP: State transfer required: 
	Group state: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
	Local state: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:31 2 [Note] WSREP: Server status change connected -> joiner
2023-11-10 20:55:31 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-11-10 20:55:31 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16031' --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --parent 81211 --progress 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300'
WSREP_SST: [INFO] rsync SST started on joiner (20231110 20:55:31.733)
2023-11-10 20:55:31 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 2, STRv: 3
2023-11-10 20:55:31 2 [Note] WSREP: IST receiver addr using ssl://127.0.0.1:16030
2023-11-10 20:55:31 2 [Note] WSREP: IST receiver using ssl
2023-11-10 20:55:31 2 [Note] WSREP: Prepared IST receiver for 0-2, listening at: ssl://127.0.0.1:16030
2023-11-10 20:55:31 0 [Note] WSREP: Member 1.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 0.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:31 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2)
2023-11-10 20:55:31 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2023-11-10 20:55:31 2 [Note] WSREP: Resetting GCache seqno map due to different histories.
2023-11-10 20:55:31 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:32 0 [Note] WSREP: 0.0 (rocky9-amd64): State transfer to 1.0 (rocky9-amd64) complete.
2023-11-10 20:55:32 0 [Note] WSREP: Member 0.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:32 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') connection established to 7beabfb8-aa16 ssl://127.0.0.1:16026
2023-11-10 20:55:32 0 [Warning] WSREP: discarding established (time wait) 7beabfb8-aa16 (ssl://127.0.0.1:16026) 
WSREP_SST: [INFO] Galera co-ords from recovery: 7bc693b1-800b-11ee-88d1-1bc961972f17:2 0 (20231110 20:55:33.033)
WSREP_SST: [INFO] rsync SST completed on joiner (20231110 20:55:33.037)
WSREP_SST: [INFO] Joiner cleanup: rsync PID=81346, stunnel PID=0 (20231110 20:55:33.041)
WSREP_SST: [INFO] Joiner cleanup done. (20231110 20:55:33.577)
2023-11-10 20:55:33 3 [Note] WSREP: SST received
2023-11-10 20:55:33 3 [Note] WSREP: Server status change joiner -> initializing
2023-11-10 20:55:33 0 [Note] Plugin 'partition' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'SEQUENCE' is disabled.
2023-11-10 20:55:33 0 [Note] InnoDB: Uses event mutexes
2023-11-10 20:55:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-11-10 20:55:33 0 [Note] InnoDB: Number of pools: 1
2023-11-10 20:55:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-10 20:55:33 0 [Note] InnoDB: Using Linux native AIO
2023-11-10 20:55:33 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
2023-11-10 20:55:33 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-10 20:55:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56057,56057
2023-11-10 20:55:33 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-10 20:55:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-10 20:55:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-10 20:55:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-11-10 20:55:33 0 [Note] InnoDB: 10.5.23 started; log sequence number 56069; transaction id 44
2023-11-10 20:55:33 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_CMP' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'user_variables' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2023-11-10 20:55:33 0 [Note] Plugin 'unix_socket' is disabled.
2023-11-10 20:55:33 0 [Note] InnoDB: Buffer pool(s) load completed at 231110 20:55:33
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
2023-11-10 20:55:33 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
2023-11-10 20:55:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-11-10 20:55:33 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2023-11-10 20:55:33 0 [Note] WSREP: Server initialized
2023-11-10 20:55:33 0 [Note] WSREP: Server status change initializing -> initialized
2023-11-10 20:55:33 3 [Note] WSREP: Recovered position from storage: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:33 3 [Note] WSREP: Server status change initialized -> joined
2023-11-10 20:55:33 3 [Note] WSREP: Recovered view from SST:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
  status: primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 1
  members(2):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64

2023-11-10 20:55:33 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:33 6 [Note] WSREP: Recovered cluster id 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:33 0 [Note] Reading of all Master_info entries succeeded
2023-11-10 20:55:33 0 [Note] Added new Master_info '' to hash table
2023-11-10 20:55:33 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.5.23-MariaDB-log'  socket: '/dev/shm/var/tmp/2/mysqld.3.sock'  port: 16022  MariaDB Server
2023-11-10 20:55:33 3 [Note] WSREP: SST received: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:33 3 [Note] WSREP: SST succeeded for position 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:33 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec
2023-11-10 20:55:33 2 [Note] WSREP: Installed new state from SST: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:33 2 [Note] WSREP: Cert. index preload up to 2
2023-11-10 20:55:33 0 [Note] WSREP: ####### IST applying starts with 3
2023-11-10 20:55:33 0 [Note] WSREP: ####### IST current seqno initialized to 2
2023-11-10 20:55:33 0 [Note] WSREP: Receiving IST...  0.0% (0/1 events) complete.
2023-11-10 20:55:33 0 [Note] WSREP: IST preload starting at 2
2023-11-10 20:55:33 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:33 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:33 0 [Note] WSREP: ####### Assign initial position for certification: 7bc693b1-800b-11ee-88d1-1bc961972f17:1, protocol version: 5
2023-11-10 20:55:33 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:33 0 [Note] WSREP: ####### Adjusting cert position: 1 -> 2
2023-11-10 20:55:33 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:33 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2
2023-11-10 20:55:33 0 [Note] WSREP: Min available from gcache for CC from preload: 2
2023-11-10 20:55:33 0 [Note] WSREP: Receiving IST...100.0% (1/1 events) complete.
2023-11-10 20:55:33 2 [Note] WSREP: IST received: 7bc693b1-800b-11ee-88d1-1bc961972f17:2
2023-11-10 20:55:33 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 2
2023-11-10 20:55:33 2 [Note] WSREP: Min available from gcache for CC from sst: 2
2023-11-10 20:55:33 0 [Note] WSREP: 1.0 (rocky9-amd64): State transfer from 0.0 (rocky9-amd64) complete.
2023-11-10 20:55:33 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 2)
2023-11-10 20:55:33 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:33 0 [Note] WSREP: Member 1.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:33 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:33 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
2023-11-10 20:55:33 2 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:33 2 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:33 2 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:33 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:34 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting off
2023-11-10 20:55:34 0 [Note] WSREP:  cleaning up 7beabfb8-aa16 (ssl://127.0.0.1:16026)
2023-11-10 20:55:34 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') connection established to 7beabfb8-aa16 ssl://127.0.0.1:16026
2023-11-10 20:55:34 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: 
2023-11-10 20:55:36 0 [Note] WSREP: declaring 7bc65b97-84a7 at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:36 0 [Note] WSREP: declaring 7beabfb8-aa16 at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:36 0 [Note] WSREP: Node 7bc65b97-84a7 state prim
2023-11-10 20:55:36 0 [Note] WSREP: view(view_id(PRIM,7bc65b97-84a7,3) memb {
	7bc65b97-84a7,0
	7be87480-8308,0
	7beabfb8-aa16,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:36 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:36 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2023-11-10 20:55:36 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:36 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 7f313024-800b-11ee-95e4-7acbf0d9f8c0
2023-11-10 20:55:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7f313024-800b-11ee-95e4-7acbf0d9f8c0 from 0 (rocky9-amd64)
2023-11-10 20:55:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7f313024-800b-11ee-95e4-7acbf0d9f8c0 from 1 (rocky9-amd64)
2023-11-10 20:55:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 7f313024-800b-11ee-95e4-7acbf0d9f8c0 from 2 (rocky9-amd64)
2023-11-10 20:55:36 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 2,
	members    = 2/3 (joined/total),
	act_id     = 2,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:36 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:36 2 [Note] WSREP: ####### processing CC 3, local, ordered
2023-11-10 20:55:36 2 [Note] WSREP: ####### My UUID: 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:36 2 [Note] WSREP: Skipping cert index reset
2023-11-10 20:55:36 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:36 2 [Note] WSREP: ####### Adjusting cert position: 2 -> 3
2023-11-10 20:55:36 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:36 2 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:3
  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: 1
  members(3):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64
	2: 7beabfb8-800b-11ee-aa16-025dff1879f0, rocky9-amd64
=================================================
2023-11-10 20:55:36 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:36 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3
2023-11-10 20:55:36 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-11-10 20:55:36 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 0.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:37 0 [Note] WSREP: 0.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:37 0 [Note] WSREP: Member 0.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:37 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting off
2023-11-10 20:55:38 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 0.0 (rocky9-amd64) complete.
2023-11-10 20:55:38 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:40 0 [Note] WSREP: declaring 7bc65b97-84a7 at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:40 0 [Note] WSREP: forgetting 7beabfb8-aa16 (ssl://127.0.0.1:16026)
2023-11-10 20:55:40 0 [Note] WSREP: Node 7bc65b97-84a7 state prim
2023-11-10 20:55:40 0 [Note] WSREP: view(view_id(PRIM,7bc65b97-84a7,4) memb {
	7bc65b97-84a7,0
	7be87480-8308,0
} joined {
} left {
} partitioned {
	7beabfb8-aa16,0
})
2023-11-10 20:55:40 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:40 0 [Note] WSREP: forgetting 7beabfb8-aa16 (ssl://127.0.0.1:16026)
2023-11-10 20:55:40 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2023-11-10 20:55:40 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:40 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 81a20119-800b-11ee-9735-0ffbaf6b67ad
2023-11-10 20:55:40 0 [Note] WSREP: STATE EXCHANGE: got state msg: 81a20119-800b-11ee-9735-0ffbaf6b67ad from 0 (rocky9-amd64)
2023-11-10 20:55:40 0 [Note] WSREP: STATE EXCHANGE: got state msg: 81a20119-800b-11ee-9735-0ffbaf6b67ad from 1 (rocky9-amd64)
2023-11-10 20:55:40 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 3,
	members    = 2/2 (joined/total),
	act_id     = 3,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:40 0 [Note] WSREP: Flow-control interval: [23, 23]
2023-11-10 20:55:40 2 [Note] WSREP: ####### processing CC 4, local, ordered
2023-11-10 20:55:40 2 [Note] WSREP: ####### My UUID: 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:40 2 [Note] WSREP: Skipping cert index reset
2023-11-10 20:55:40 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:40 2 [Note] WSREP: ####### Adjusting cert position: 3 -> 4
2023-11-10 20:55:40 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:40 2 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:4
  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: 1
  members(2):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64
=================================================
2023-11-10 20:55:40 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:40 2 [Note] WSREP: Lowest cert index boundary for CC from group: 4
2023-11-10 20:55:40 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-11-10 20:55:42 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') connection established to 82657d2a-93ce ssl://127.0.0.1:16026
2023-11-10 20:55:42 0 [Note] WSREP: remote endpoint ssl://127.0.0.1:16026 changed identity 7beabfb8-800b-11ee-aa16-025dff1879f0 -> 82657d2a-800b-11ee-93ce-ee65bf7bb1e3
2023-11-10 20:55:42 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: 
2023-11-10 20:55:44 0 [Note] WSREP: declaring 7bc65b97-84a7 at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:44 0 [Note] WSREP: declaring 82657d2a-93ce at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:44 0 [Note] WSREP: Node 7bc65b97-84a7 state prim
2023-11-10 20:55:44 0 [Note] WSREP: view(view_id(PRIM,7bc65b97-84a7,5) memb {
	7bc65b97-84a7,0
	7be87480-8308,0
	82657d2a-93ce,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:44 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:44 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2023-11-10 20:55:44 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:44 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 83e3d12e-800b-11ee-b4f8-67cd0d0af3e3
2023-11-10 20:55:44 0 [Note] WSREP: STATE EXCHANGE: got state msg: 83e3d12e-800b-11ee-b4f8-67cd0d0af3e3 from 0 (rocky9-amd64)
2023-11-10 20:55:44 0 [Note] WSREP: STATE EXCHANGE: got state msg: 83e3d12e-800b-11ee-b4f8-67cd0d0af3e3 from 1 (rocky9-amd64)
2023-11-10 20:55:44 0 [Note] WSREP: STATE EXCHANGE: got state msg: 83e3d12e-800b-11ee-b4f8-67cd0d0af3e3 from 2 (rocky9-amd64)
2023-11-10 20:55:44 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 4,
	members    = 2/3 (joined/total),
	act_id     = 4,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:44 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:44 2 [Note] WSREP: ####### processing CC 5, local, ordered
2023-11-10 20:55:44 2 [Note] WSREP: ####### My UUID: 7be87480-800b-11ee-8308-d6d747717630
2023-11-10 20:55:44 2 [Note] WSREP: Skipping cert index reset
2023-11-10 20:55:44 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:44 2 [Note] WSREP: ####### Adjusting cert position: 4 -> 5
2023-11-10 20:55:44 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:44 2 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
  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: 1
  members(3):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64
	2: 82657d2a-800b-11ee-93ce-ee65bf7bb1e3, rocky9-amd64
=================================================
2023-11-10 20:55:44 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:44 2 [Note] WSREP: Lowest cert index boundary for CC from group: 5
2023-11-10 20:55:44 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-11-10 20:55:44 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 1.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:44 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 5)
2023-11-10 20:55:44 2 [Note] WSREP: Detected STR version: 1, req_len: 109, req: STRv1
2023-11-10 20:55:44 2 [Note] WSREP: IST request: 7bc693b1-800b-11ee-88d1-1bc961972f17:3-5|ssl://127.0.0.1:16027
2023-11-10 20:55:44 2 [Note] WSREP: Server status change synced -> donor
2023-11-10 20:55:44 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:44 0 [Note] WSREP: Donor monitor thread started to monitor
2023-11-10 20:55:44 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16028/rsync_sst' --local-port 16022 --socket '/dev/shm/var/tmp/2/mysqld.3.sock' --progress 0 --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --gtid '7bc693b1-800b-11ee-88d1-1bc961972f17:3' --gtid-domain-id 0 --binlog-index 'mysqld-bin.index' --bypass --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300'
2023-11-10 20:55:44 2 [Note] WSREP: sst_donor_thread signaled with 0
2023-11-10 20:55:44 0 [Note] WSREP: async IST sender starting to serve ssl://127.0.0.1:16027 sending 4-5, preload starts from 5
2023-11-10 20:55:44 0 [Note] WSREP: IST sender 4 -> 5
WSREP_SST: [INFO] rsync IST started on donor (20231110 20:55:44.917)
WSREP_SST: [INFO] Bypassing state dump. (20231110 20:55:45.118)
WSREP_SST: [INFO] Sending continue to donor (20231110 20:55:45.121)
2023-11-10 20:55:45 0 [Note] WSREP: SST sent: 7bc693b1-800b-11ee-88d1-1bc961972f17:3
2023-11-10 20:55:45 0 [Note] WSREP: Server status change donor -> joined
2023-11-10 20:55:45 0 [Note] WSREP: 1.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:45 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 5)
2023-11-10 20:55:45 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:45 0 [Note] WSREP: Member 1.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:45 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:45 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 5)
2023-11-10 20:55:45 2 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:45 2 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:45 2 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:45 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] rsync IST completed on donor (20231110 20:55:45.134)
2023-11-10 20:55:45 0 [Note] WSREP: Donor monitor thread ended with total time 1 sec
2023-11-10 20:55:45 0 [Note] WSREP: (7be87480-8308, 'ssl://0.0.0.0:16029') turning message relay requesting off
2023-11-10 20:55:46 0 [Note] WSREP: async IST sender served
2023-11-10 20:55:46 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 1.0 (rocky9-amd64) complete.
2023-11-10 20:55:46 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:46 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost [127.0.0.1]): Normal shutdown
2023-11-10 20:55:46 0 [Note] WSREP: Shutdown replication
2023-11-10 20:55:46 0 [Note] WSREP: Server status change synced -> disconnecting
2023-11-10 20:55:46 0 [Note] WSREP: Closing send monitor...
2023-11-10 20:55:46 0 [Note] WSREP: Closed send monitor.
2023-11-10 20:55:46 0 [Note] WSREP: gcomm: terminating thread
2023-11-10 20:55:46 0 [Note] WSREP: gcomm: joining thread
2023-11-10 20:55:46 0 [Note] WSREP: gcomm: closing backend
2023-11-10 20:55:46 0 [Note] WSREP: view(view_id(NON_PRIM,7bc65b97-84a7,5) memb {
	7be87480-8308,0
} joined {
} left {
} partitioned {
	7bc65b97-84a7,0
	82657d2a-93ce,0
})
2023-11-10 20:55:46 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2023-11-10 20:55:46 0 [Note] WSREP: view((empty))
2023-11-10 20:55:46 0 [Note] WSREP: gcomm: closed
2023-11-10 20:55:46 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2023-11-10 20:55:46 0 [Note] WSREP: Flow-control interval: [16, 16]
2023-11-10 20:55:46 0 [Note] WSREP: Received NON-PRIMARY.
2023-11-10 20:55:46 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 5)
2023-11-10 20:55:46 0 [Note] WSREP: New SELF-LEAVE.
2023-11-10 20:55:46 0 [Note] WSREP: Flow-control interval: [0, 0]
2023-11-10 20:55:46 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2023-11-10 20:55:46 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 5)
2023-11-10 20:55:46 0 [Note] WSREP: RECV thread exiting 0: Success
2023-11-10 20:55:46 2 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
  status: non-primary
  protocol_version: 4
  capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
  final: no
  own_index: 0
  members(1):
	0: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64
=================================================
2023-11-10 20:55:46 0 [Note] WSREP: recv_thread() joined.
2023-11-10 20:55:46 2 [Note] WSREP: Non-primary view
2023-11-10 20:55:46 0 [Note] WSREP: Closing replication queue.
2023-11-10 20:55:46 0 [Note] WSREP: Closing slave action queue.
2023-11-10 20:55:46 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:46 2 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
  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-11-10 20:55:46 2 [Note] WSREP: Non-primary view
2023-11-10 20:55:46 2 [Note] WSREP: Server status change disconnecting -> disconnected
2023-11-10 20:55:46 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:46 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2
2023-11-10 20:55:46 1 [Note] WSREP: rollbacker thread exiting 1
2023-11-10 20:55:46 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-11-10 20:55:46 0 [Note] WSREP: dtor state: CLOSED
2023-11-10 20:55:46 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:46 0 [Note] WSREP: apply mon: entered 0
2023-11-10 20:55:46 0 [Note] WSREP: apply mon: entered 0
2023-11-10 20:55:46 0 [Note] WSREP: mon: entered 11 oooe fraction 0 oool fraction 0.0909091
2023-11-10 20:55:46 0 [Note] WSREP: cert index usage at exit 0
2023-11-10 20:55:46 0 [Note] WSREP: cert trx map usage at exit 0
2023-11-10 20:55:46 0 [Note] WSREP: deps set usage at exit 0
2023-11-10 20:55:46 0 [Note] WSREP: avg deps dist 0
2023-11-10 20:55:46 0 [Note] WSREP: avg cert interval 0
2023-11-10 20:55:46 0 [Note] WSREP: cert index size 0
2023-11-10 20:55:46 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:46 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2023-11-10 20:55:46 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:46 0 [Note] WSREP: Flushing memory map to disk...
2023-11-10 20:55:46 0 [Note] InnoDB: FTS optimize thread exiting.
2023-11-10 20:55:46 0 [Note] InnoDB: Starting shutdown...
2023-11-10 20:55:46 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:46 0 [Note] InnoDB: Restricted to 125 pages due to innodb_buf_pool_dump_pct=25
2023-11-10 20:55:46 0 [Note] InnoDB: Buffer pool(s) dump completed at 231110 20:55:46
2023-11-10 20:55:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-10 20:55:46 0 [Note] InnoDB: Shutdown completed; log sequence number 59890; transaction id 57
2023-11-10 20:55:46 0 [Note] /usr/sbin/mariadbd: Shutdown complete

$ /usr/sbin/mariadbd --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --wsrep_cluster_address=gcomm://127.0.0.1:16026 --core-file --loose-debug-sync-timeout=300
2023-11-10 20:55:47 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
2023-11-10 20:55:47 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2023-11-10 20:55:47 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16031' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
2023-11-10 20:55:47 0 [Note] Starting MariaDB 10.5.23-MariaDB-log source revision 40c405d923d192119f8e7df2f00b7964bada9fdf as process 82433
2023-11-10 20:55:47 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2023-11-10 20:55:47 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
2023-11-10 20:55:47 0 [Note] WSREP: wsrep_load(): Galera 26.4.16(r7dce5149) by Codership Oy <info@codership.com> loaded successfully.
2023-11-10 20:55:47 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2023-11-10 20:55:47 0 [Warning] WSREP: SSL compression is not effective. The option socket.ssl_compression is deprecated and will be removed in future releases.
2023-11-10 20:55:47 0 [Warning] WSREP: Parameter 'socket.ssl_compression' is deprecated and will be removed in future versions
2023-11-10 20:55:47 0 [Note] WSREP: Found saved state: 7bc693b1-800b-11ee-88d1-1bc961972f17:5, safe_to_bootstrap: 0
2023-11-10 20:55:47 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 7bc693b1-800b-11ee-88d1-1bc961972f17
Seqno: 2 - 5
Offset: 1280
Synced: 1
2023-11-10 20:55:47 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 7bc693b1-800b-11ee-88d1-1bc961972f17, offset: 1280
2023-11-10 20:55:47 0 [Note] WSREP: GCache::RingBuffer initial scan...  0.0% (        0/134217752 bytes) complete.
2023-11-10 20:55:47 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2023-11-10 20:55:47 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 2-5
2023-11-10 20:55:47 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...  0.0% (   0/1288 bytes) complete.
2023-11-10 20:55:47 0 [Note] WSREP: Recovering GCache ring buffer: found 1/5 locked buffers
2023-11-10 20:55:47 0 [Note] WSREP: Recovering GCache ring buffer: free space: 134216608/134217728
2023-11-10 20:55:47 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (1288/1288 bytes) complete.
2023-11-10 20:55:47 0 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/var/2/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16029; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/var/2/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor
2023-11-10 20:55:47 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:47 0 [Note] WSREP: ####### Assign initial position for certification: 7bc693b1-800b-11ee-88d1-1bc961972f17:5, protocol version: -1
2023-11-10 20:55:47 0 [Note] WSREP: Start replication
2023-11-10 20:55:47 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-11-10 20:55:47 0 [Note] WSREP: Setting GCS initial position to 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:47 0 [Note] WSREP: protonet asio version 0
2023-11-10 20:55:47 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-11-10 20:55:47 0 [Note] WSREP: backend: asio
2023-11-10 20:55:47 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2023-11-10 20:55:47 0 [Note] WSREP: access file(/dev/shm/var/2/mysqld.3/data//gvwstate.dat) failed(No such file or directory)
2023-11-10 20:55:47 0 [Note] WSREP: restore pc from disk failed
2023-11-10 20:55:47 0 [Note] WSREP: GMCast version 0
2023-11-10 20:55:47 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') listening at ssl://0.0.0.0:16029
2023-11-10 20:55:47 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') multicast: , ttl: 1
2023-11-10 20:55:47 0 [Note] WSREP: EVS version 1
2023-11-10 20:55:47 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16026'
2023-11-10 20:55:47 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') connection established to 82657d2a-93ce ssl://127.0.0.1:16026
2023-11-10 20:55:47 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') turning message relay requesting on, nonlive peers: ssl://127.0.0.1:16023 
2023-11-10 20:55:48 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') connection established to 7bc65b97-84a7 ssl://127.0.0.1:16023
2023-11-10 20:55:50 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-11-10 20:55:50 0 [Note] WSREP: declaring 7bc65b97-84a7 at ssl://127.0.0.1:16023 stable
2023-11-10 20:55:50 0 [Note] WSREP: declaring 82657d2a-93ce at ssl://127.0.0.1:16026 stable
2023-11-10 20:55:50 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-11-10 20:55:50 0 [Note] WSREP: Node 7bc65b97-84a7 state prim
2023-11-10 20:55:50 0 [Note] WSREP: view(view_id(PRIM,7bc65b97-84a7,7) memb {
	7bc65b97-84a7,0
	82657d2a-93ce,0
	862e6353-a934,0
} joined {
} left {
} partitioned {
})
2023-11-10 20:55:50 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:50 0 [Note] WSREP: gcomm: connected
2023-11-10 20:55:50 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-11-10 20:55:50 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-11-10 20:55:50 0 [Note] WSREP: Opened channel 'my_wsrep_cluster'
2023-11-10 20:55:50 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3
2023-11-10 20:55:50 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-11-10 20:55:50 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 87accfd9-800b-11ee-b473-7b17acf59f83
2023-11-10 20:55:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 87accfd9-800b-11ee-b473-7b17acf59f83 from 0 (rocky9-amd64)
2023-11-10 20:55:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 87accfd9-800b-11ee-b473-7b17acf59f83 from 1 (rocky9-amd64)
2023-11-10 20:55:50 1 [Note] WSREP: Starting applier thread 1
2023-11-10 20:55:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: 87accfd9-800b-11ee-b473-7b17acf59f83 from 2 (rocky9-amd64)
2023-11-10 20:55:50 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 6,
	members    = 2/3 (joined/total),
	act_id     = 6,
	last_appl. = 0,
	protocols  = 2/10/4 (gcs/repl/appl),
	vote policy= 0,
	group UUID = 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:50 2 [Note] WSREP: Starting rollbacker thread 2
2023-11-10 20:55:50 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-11-10 20:55:50 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 7)
2023-11-10 20:55:50 1 [Note] WSREP: ####### processing CC 7, local, ordered
2023-11-10 20:55:50 1 [Note] WSREP: Process first view: 7bc693b1-800b-11ee-88d1-1bc961972f17 my uuid: 862e6353-800b-11ee-a934-621342f9acbf
2023-11-10 20:55:50 1 [Note] WSREP: Server rocky9-amd64 connected to cluster at position 7bc693b1-800b-11ee-88d1-1bc961972f17:7 with ID 862e6353-800b-11ee-a934-621342f9acbf
2023-11-10 20:55:50 1 [Note] WSREP: Server status change disconnected -> connected
2023-11-10 20:55:50 1 [Note] WSREP: ####### My UUID: 862e6353-800b-11ee-a934-621342f9acbf
2023-11-10 20:55:50 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-11-10 20:55:50 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:50 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-11-10 20:55:50 1 [Note] WSREP: State transfer required: 
	Group state: 7bc693b1-800b-11ee-88d1-1bc961972f17:7
	Local state: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:50 1 [Note] WSREP: Server status change connected -> joiner
2023-11-10 20:55:50 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-11-10 20:55:50 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16031' --datadir '/dev/shm/var/2/mysqld.3/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.3' --parent 82433 --progress 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.3 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --wsrep_cluster_address=gcomm://127.0.0.1:16026 --core-file --loose-debug-sync-timeout=300'
WSREP_SST: [INFO] rsync SST started on joiner (20231110 20:55:50.968)
2023-11-10 20:55:51 1 [Note] WSREP: ####### IST uuid:7bc693b1-800b-11ee-88d1-1bc961972f17 f: 6, l: 7, STRv: 3
2023-11-10 20:55:51 1 [Note] WSREP: IST receiver addr using ssl://127.0.0.1:16030
2023-11-10 20:55:51 1 [Note] WSREP: IST receiver using ssl
2023-11-10 20:55:51 1 [Note] WSREP: Prepared IST receiver for 6-7, listening at: ssl://127.0.0.1:16030
2023-11-10 20:55:51 0 [Note] WSREP: Member 2.0 (rocky9-amd64) requested state transfer from '*any*'. Selected 1.0 (rocky9-amd64)(SYNCED) as donor.
2023-11-10 20:55:51 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 7)
2023-11-10 20:55:51 1 [Note] WSREP: Requesting state transfer: success, donor: 1
2023-11-10 20:55:51 0 [Note] WSREP: 1.0 (rocky9-amd64): State transfer to 2.0 (rocky9-amd64) complete.
2023-11-10 20:55:51 0 [Note] WSREP: Member 1.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:51 0 [Note] WSREP: (862e6353-a934, 'ssl://0.0.0.0:16029') turning message relay requesting off
WSREP_SST: [INFO] Galera co-ords from recovery: 7bc693b1-800b-11ee-88d1-1bc961972f17:5 0 (20231110 20:55:52.219)
WSREP_SST: [INFO] rsync IST completed on joiner (20231110 20:55:52.225)
WSREP_SST: [INFO] Joiner cleanup: rsync PID=82973, stunnel PID=0 (20231110 20:55:52.227)
WSREP_SST: [INFO] Joiner cleanup done. (20231110 20:55:52.758)
2023-11-10 20:55:52 3 [Note] WSREP: SST received
2023-11-10 20:55:52 3 [Note] WSREP: Server status change joiner -> initializing
2023-11-10 20:55:52 0 [Note] Plugin 'partition' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'SEQUENCE' is disabled.
2023-11-10 20:55:52 0 [Note] InnoDB: Uses event mutexes
2023-11-10 20:55:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-11-10 20:55:52 0 [Note] InnoDB: Number of pools: 1
2023-11-10 20:55:52 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-11-10 20:55:52 0 [Note] InnoDB: Using Linux native AIO
2023-11-10 20:55:52 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
2023-11-10 20:55:52 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-10 20:55:52 0 [Note] InnoDB: 128 rollback segments are active.
2023-11-10 20:55:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-10 20:55:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-10 20:55:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-11-10 20:55:52 0 [Note] InnoDB: 10.5.23 started; log sequence number 59890; transaction id 58
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_CMP' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'user_variables' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2023-11-10 20:55:52 0 [Note] Plugin 'unix_socket' is disabled.
2023-11-10 20:55:52 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:52 0 [Note] InnoDB: Buffer pool(s) load completed at 231110 20:55:52
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
2023-11-10 20:55:52 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
2023-11-10 20:55:52 0 [Note] Server socket created on IP: '127.0.0.1'.
2023-11-10 20:55:52 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2023-11-10 20:55:52 0 [Note] WSREP: Server initialized
2023-11-10 20:55:52 0 [Note] WSREP: Server status change initializing -> initialized
2023-11-10 20:55:52 3 [Note] WSREP: Recovered position from storage: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:52 3 [Note] WSREP: Recovered view from SST:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
  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: -1
  members(3):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 7be87480-800b-11ee-8308-d6d747717630, rocky9-amd64
	2: 82657d2a-800b-11ee-93ce-ee65bf7bb1e3, rocky9-amd64

2023-11-10 20:55:52 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:52 0 [Note] Reading of all Master_info entries succeeded
2023-11-10 20:55:52 6 [Note] WSREP: Recovered cluster id 7bc693b1-800b-11ee-88d1-1bc961972f17
2023-11-10 20:55:52 0 [Note] Added new Master_info '' to hash table
2023-11-10 20:55:52 0 [Note] /usr/sbin/mariadbd: ready for connections.
Version: '10.5.23-MariaDB-log'  socket: '/dev/shm/var/tmp/2/mysqld.3.sock'  port: 16022  MariaDB Server
2023-11-10 20:55:52 3 [Note] WSREP: SST received: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:52 3 [Note] WSREP: SST succeeded for position 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:52 0 [Note] WSREP: Joiner monitor thread ended with total time 2 sec
2023-11-10 20:55:52 1 [Note] WSREP: Installed new state from SST: 7bc693b1-800b-11ee-88d1-1bc961972f17:5
2023-11-10 20:55:52 1 [Note] WSREP: Receiving IST: 2 writesets, seqnos 6-7
2023-11-10 20:55:52 0 [Note] WSREP: ####### IST applying starts with 6
2023-11-10 20:55:52 0 [Note] WSREP: ####### IST current seqno initialized to 6
2023-11-10 20:55:52 0 [Note] WSREP: Receiving IST...  0.0% (0/2 events) complete.
2023-11-10 20:55:52 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:52 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:52 0 [Note] WSREP: ####### Assign initial position for certification: 7bc693b1-800b-11ee-88d1-1bc961972f17:5, protocol version: 5
2023-11-10 20:55:52 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:52 0 [Note] WSREP: ####### Adjusting cert position: 5 -> 6
2023-11-10 20:55:52 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:52 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 6
2023-11-10 20:55:52 0 [Note] WSREP: Min available from gcache for CC from ist: 2
2023-11-10 20:55:52 1 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:6
  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: -1
  members(2):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 82657d2a-800b-11ee-93ce-ee65bf7bb1e3, rocky9-amd64
=================================================
2023-11-10 20:55:52 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:52 0 [Note] WSREP: IST preload starting at 7
2023-11-10 20:55:52 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-11-10 20:55:52 0 [Note] WSREP: ####### Adjusting cert position: 6 -> 7
2023-11-10 20:55:52 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:52 0 [Note] WSREP: Lowest cert index boundary for CC from ist: 7
2023-11-10 20:55:52 0 [Note] WSREP: Min available from gcache for CC from ist: 2
2023-11-10 20:55:52 0 [Note] WSREP: Receiving IST...100.0% (2/2 events) complete.
2023-11-10 20:55:52 1 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:7
  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: 2
  members(3):
	0: 7bc65b97-800b-11ee-84a7-be0f4ea572ac, rocky9-amd64
	1: 82657d2a-800b-11ee-93ce-ee65bf7bb1e3, rocky9-amd64
	2: 862e6353-800b-11ee-a934-621342f9acbf, rocky9-amd64
=================================================
2023-11-10 20:55:52 1 [Note] WSREP: Server status change initialized -> joined
2023-11-10 20:55:52 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:52 1 [Note] WSREP: Draining apply monitors after IST up to 7
2023-11-10 20:55:52 1 [Note] WSREP: IST received: 7bc693b1-800b-11ee-88d1-1bc961972f17:7
2023-11-10 20:55:52 1 [Note] WSREP: Lowest cert index boundary for CC from sst: 7
2023-11-10 20:55:52 1 [Note] WSREP: Min available from gcache for CC from sst: 2
2023-11-10 20:55:52 0 [Note] WSREP: 2.0 (rocky9-amd64): State transfer from 1.0 (rocky9-amd64) complete.
2023-11-10 20:55:52 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 7)
2023-11-10 20:55:52 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-11-10 20:55:52 0 [Note] WSREP: Member 2.0 (rocky9-amd64) synced with group.
2023-11-10 20:55:52 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-11-10 20:55:52 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 7)
2023-11-10 20:55:52 1 [Note] WSREP: Server rocky9-amd64 synced with group
2023-11-10 20:55:52 1 [Note] WSREP: Server status change joined -> synced
2023-11-10 20:55:52 1 [Note] WSREP: Synchronized with group, ready for connections
2023-11-10 20:55:52 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:53 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
2023-11-10 20:55:53 0 [Note] WSREP: Shutdown replication
2023-11-10 20:55:53 0 [Note] WSREP: Server status change synced -> disconnecting
2023-11-10 20:55:53 0 [Note] WSREP: Closing send monitor...
2023-11-10 20:55:53 0 [Note] WSREP: Closed send monitor.
2023-11-10 20:55:53 0 [Note] WSREP: gcomm: terminating thread
2023-11-10 20:55:53 0 [Note] WSREP: gcomm: joining thread
2023-11-10 20:55:53 0 [Note] WSREP: gcomm: closing backend
2023-11-10 20:55:54 0 [Note] WSREP: forgetting 7bc65b97-84a7 (ssl://127.0.0.1:16023)
2023-11-10 20:55:54 0 [Note] WSREP: forgetting 82657d2a-93ce (ssl://127.0.0.1:16026)
2023-11-10 20:55:54 0 [Note] WSREP: Node 862e6353-a934 state prim
2023-11-10 20:55:54 0 [Note] WSREP: view(view_id(PRIM,862e6353-a934,8) memb {
	862e6353-a934,0
} joined {
} left {
} partitioned {
	7bc65b97-84a7,0
	82657d2a-93ce,0
})
2023-11-10 20:55:54 0 [Note] WSREP: save pc into disk
2023-11-10 20:55:54 0 [Note] WSREP: forgetting 7bc65b97-84a7 (ssl://127.0.0.1:16023)
2023-11-10 20:55:54 0 [Note] WSREP: forgetting 82657d2a-93ce (ssl://127.0.0.1:16026)
2023-11-10 20:55:54 0 [Note] WSREP: PC protocol downgrade 1 -> 0
2023-11-10 20:55:54 0 [Note] WSREP: view((empty))
2023-11-10 20:55:54 0 [Note] WSREP: gcomm: closed
2023-11-10 20:55:54 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2023-11-10 20:55:54 0 [Warning] WSREP: 0x55b4214cf268 down context(s) not set
2023-11-10 20:55:54 0 [Warning] WSREP: Failed to send state UUID: -107 (Transport endpoint is not connected)
2023-11-10 20:55:54 0 [Note] WSREP: New SELF-LEAVE.
2023-11-10 20:55:54 0 [Note] WSREP: Flow-control interval: [0, 0]
2023-11-10 20:55:54 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2023-11-10 20:55:54 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 7)
2023-11-10 20:55:54 0 [Note] WSREP: RECV thread exiting 0: Success
2023-11-10 20:55:54 0 [Note] WSREP: recv_thread() joined.
2023-11-10 20:55:54 0 [Note] WSREP: Closing replication queue.
2023-11-10 20:55:54 0 [Note] WSREP: Closing slave action queue.
2023-11-10 20:55:54 1 [Note] WSREP: ================================================
View:
  id: 7bc693b1-800b-11ee-88d1-1bc961972f17:7
  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-11-10 20:55:54 1 [Note] WSREP: Non-primary view
2023-11-10 20:55:54 1 [Note] WSREP: Server status change disconnecting -> disconnected
2023-11-10 20:55:54 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-11-10 20:55:54 1 [Note] WSREP: Applier thread exiting ret: 0 thd: 1
2023-11-10 20:55:54 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2023-11-10 20:55:54 2 [Note] WSREP: rollbacker thread exiting 2
2023-11-10 20:55:54 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2023-11-10 20:55:54 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-11-10 20:55:54 0 [Note] WSREP: dtor state: CLOSED
2023-11-10 20:55:54 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:54 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2023-11-10 20:55:54 0 [Note] WSREP: mon: entered 2 oooe fraction 0 oool fraction 0
2023-11-10 20:55:54 0 [Note] WSREP: mon: entered 4 oooe fraction 0 oool fraction 0.25
2023-11-10 20:55:54 0 [Note] WSREP: cert index usage at exit 0
2023-11-10 20:55:54 0 [Note] WSREP: cert trx map usage at exit 0
2023-11-10 20:55:54 0 [Note] WSREP: deps set usage at exit 0
2023-11-10 20:55:54 0 [Note] WSREP: avg deps dist 0
2023-11-10 20:55:54 0 [Note] WSREP: avg cert interval 0
2023-11-10 20:55:54 0 [Note] WSREP: cert index size 0
2023-11-10 20:55:54 0 [Note] WSREP: Service thread queue flushed.
2023-11-10 20:55:54 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2023-11-10 20:55:54 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2023-11-10 20:55:54 0 [Note] WSREP: Flushing memory map to disk...
2023-11-10 20:55:54 0 [Note] InnoDB: FTS optimize thread exiting.
2023-11-10 20:55:54 0 [Note] InnoDB: Starting shutdown...
2023-11-10 20:55:54 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var/2/mysqld.3/data/ib_buffer_pool
2023-11-10 20:55:54 0 [Note] InnoDB: Restricted to 126 pages due to innodb_buf_pool_dump_pct=25
2023-11-10 20:55:54 0 [Note] InnoDB: Buffer pool(s) dump completed at 231110 20:55:54
2023-11-10 20:55:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-10 20:55:54 0 [Note] InnoDB: Shutdown completed; log sequence number 62231; transaction id 69
2023-11-10 20:55:54 0 [Note] /usr/sbin/mariadbd: Shutdown complete