Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] /usr/sbin/mysqld (mysqld 10.4.20-MariaDB) starting as process 3327 ...
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 67571)
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: wsrep_load(): Galera 26.4.8(r902dd26) by Codership Oy <info@codership.com> loaded successfully.
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA'
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: GCache DEBUG: opened preamble:
Jun 24 19:34:31 sv2010023 mysqld: Version: 2
Jun 24 19:34:31 sv2010023 mysqld: UUID: 00000000-0000-0000-0000-000000000000
Jun 24 19:34:31 sv2010023 mysqld: Seqno: -1 - -1
Jun 24 19:34:31 sv2010023 mysqld: Offset: -1
Jun 24 19:34:31 sv2010023 mysqld: Synced: 0
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Passing config to GCS: base_dir = /apps/database/mariadb/; base_host = sv2010023.example.org; base_port = 4567; cert.log_conflicts = YES; 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 = /apps/database/mariadb/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 1G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 1; gmcast.version = 0; pc.announce_time
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA'
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Start replication
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Connecting with bootstrap option: 0
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: protonet asio version 0
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA'
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: Using CRC-32C for message checksums.
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: backend: asio
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Warning] WSREP: access file(/apps/database/mariadb//gvwstate.dat) failed(No such file or directory)
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: restore pc from disk failed
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: GMCast version 0
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') multicast: , ttl: 1
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: EVS version 1
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: gcomm: connecting to group 'mariadb_cluster_productie_2', peer 'sv2010021.example.org:,sv2010022.example.org:,sv2010023.example.org:'
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address ssl://1.1.1.149:4567
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') connection established to 1f23bb88-8d9b ssl://1.1.1.150:4567
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
Jun 24 19:34:31 sv2010023 mysqld: 2021-06-24 19:34:31 0 [Note] WSREP: (32cf458a-88d7, 'ssl://0.0.0.0:4567') connection established to a942f9fc-b31d ssl://1.1.1.151:4567
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: EVS version upgrade 0 -> 1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: declaring 1f23bb88-8d9b at ssl://1.1.1.150:4567 stable
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: declaring a942f9fc-b31d at ssl://1.1.1.151:4567 stable
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: PC protocol upgrade 0 -> 1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Node 1f23bb88-8d9b state prim
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: view(view_id(PRIM,1f23bb88-8d9b,53) memb {
Jun 24 19:34:32 sv2010023 mysqld: 1f23bb88-8d9b,1
Jun 24 19:34:32 sv2010023 mysqld: 32cf458a-88d7,1
Jun 24 19:34:32 sv2010023 mysqld: a942f9fc-b31d,1
Jun 24 19:34:32 sv2010023 mysqld: } joined {
Jun 24 19:34:32 sv2010023 mysqld: } left {
Jun 24 19:34:32 sv2010023 mysqld: } partitioned {
Jun 24 19:34:32 sv2010023 mysqld: })
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: save pc into disk
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: gcomm: connected
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Opened channel 'mariadb_cluster_productie_2'
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 331d2d31-d523-11eb-ac4e-9fd7325b077b
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: 331d2d31-d523-11eb-ac4e-9fd7325b077b from 0 (sv2010022)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: 331d2d31-d523-11eb-ac4e-9fd7325b077b from 2 (sv2010021)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 1 [Note] WSREP: Starting rollbacker thread 1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Starting applier thread 2
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: 331d2d31-d523-11eb-ac4e-9fd7325b077b from 1 (sv2010023)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Quorum results:
Jun 24 19:34:32 sv2010023 mysqld: version    = 6,
Jun 24 19:34:32 sv2010023 mysqld: component  = PRIMARY,
Jun 24 19:34:32 sv2010023 mysqld: conf_id    = 51,
Jun 24 19:34:32 sv2010023 mysqld: members    = 2/3 (joined/total),
Jun 24 19:34:32 sv2010023 mysqld: act_id     = 61077,
Jun 24 19:34:32 sv2010023 mysqld: last_appl. = 61026,
Jun 24 19:34:32 sv2010023 mysqld: protocols  = 2/10/4 (gcs/repl/appl),
Jun 24 19:34:32 sv2010023 mysqld: vote policy= 0,
Jun 24 19:34:32 sv2010023 mysqld: group UUID = b9ebe058-3b6c-11ea-ab98-c2ef6750dcc2
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Flow-control interval: [28, 28]
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 61078)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: ####### processing CC 61078, local, ordered
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Process first view: b9ebe058-3b6c-11ea-ab98-c2ef6750dcc2 my uuid: 32cf458a-d523-11eb-88d7-c63ff92f0341
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Server sv2010023 connected to cluster at position b9ebe058-3b6c-11ea-ab98-c2ef6750dcc2:61078 with ID 32cf458a-d523-11eb-88d7-c63ff92f0341
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Server status change disconnected -> connected
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: ####### My UUID: 32cf458a-d523-11eb-88d7-c63ff92f0341
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Service thread queue flushed.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: State transfer required:
Jun 24 19:34:32 sv2010023 mysqld: Group state: b9ebe058-3b6c-11ea-ab98-c2ef6750dcc2:61078
Jun 24 19:34:32 sv2010023 mysqld: Local state: 00000000-0000-0000-0000-000000000000:-1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Server status change connected -> joiner
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Joiner monitor thread started to monitor
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address 'sv2010023.example.org' --datadir '/apps/database/mariadb/' --parent '3327' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1'
Jun 24 19:34:32 sv2010023 mysqld: WSREP_SST: [INFO] SSL configuration: CA='/etc/pki/mariadb/certs/mariadb-ca.crt', CERT='/etc/pki/mariadb/private/mariadb-sst-3.pem', KEY='', MODE='DISABLED', encrypt='4' (20210624 19:34:32.847)
Jun 24 19:34:32 sv2010023 mysqld: WSREP_SST: [INFO] Logging all stderr of SST/mariabackup to syslog (20210624 19:34:32.930)
Jun 24 19:34:32 sv2010023 -wsrep-sst-joiner: Streaming with mbstream
Jun 24 19:34:32 sv2010023 -wsrep-sst-joiner: Using socat as streamer
Jun 24 19:34:32 sv2010023 -wsrep-sst-joiner: Using openssl based encryption with socat: with key and crt
Jun 24 19:34:32 sv2010023 -wsrep-sst-joiner: Both certificate and key files required
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_mariabackup --role 'joiner' --address 'sv2010023.example.org' --datadir '/apps/database/mariadb/' --parent '3327' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1
Jun 24 19:34:32 sv2010023 mysqld: Read: '(null)'
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'joiner' --address 'sv2010023.example.org' --datadir '/apps/database/mariadb/' --parent '3327' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1: 22 (Invalid argument)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [ERROR] WSREP: Failed to prepare for 'mariabackup' SST. Unrecoverable.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [ERROR] WSREP: SST request callback failed. This is unrecoverable, restart required.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: ReplicatorSMM::abort()
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Closing send monitor...
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Closed send monitor.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: gcomm: terminating thread
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: gcomm: joining thread
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: gcomm: closing backend
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: view(view_id(NON_PRIM,1f23bb88-8d9b,53) memb {
Jun 24 19:34:32 sv2010023 mysqld: 32cf458a-88d7,1
Jun 24 19:34:32 sv2010023 mysqld: } joined {
Jun 24 19:34:32 sv2010023 mysqld: } left {
Jun 24 19:34:32 sv2010023 mysqld: } partitioned {
Jun 24 19:34:32 sv2010023 mysqld: 1f23bb88-8d9b,1
Jun 24 19:34:32 sv2010023 mysqld: a942f9fc-b31d,1
Jun 24 19:34:32 sv2010023 mysqld: })
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: PC protocol downgrade 1 -> 0
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: view((empty))
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: gcomm: closed
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Flow-control interval: [16, 16]
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Received NON-PRIMARY.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Shifting PRIMARY -> OPEN (TO: 61078)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: New SELF-LEAVE.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Flow-control interval: [0, 0]
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 61078)
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 0 [Note] WSREP: RECV thread exiting 0: Success
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: recv_thread() joined.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Closing replication queue.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: Closing slave action queue.
Jun 24 19:34:32 sv2010023 mysqld: 2021-06-24 19:34:32 2 [Note] WSREP: /usr/sbin/mysqld: Terminated.