Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] /usr/sbin/mysqld (mysqld 10.4.20-MariaDB) starting as process 2379 ... Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 67571) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: wsrep_load(): Galera 26.4.8(r902dd26) by Codership Oy loaded successfully. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Found saved state: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587, safe_to_bootstrap: 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache DEBUG: opened preamble: Jun 25 12:26:25 sv1810949 mysqld: Version: 2 Jun 25 12:26:25 sv1810949 mysqld: UUID: c227de0f-f8aa-11e8-a038-ce7a6cae1f98 Jun 25 12:26:25 sv1810949 mysqld: Seqno: 833 - 3587 Jun 25 12:26:25 sv1810949 mysqld: Offset: 1280 Jun 25 12:26:25 sv1810949 mysqld: Synced: 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: c227de0f-f8aa-11e8-a038-ce7a6cae1f98, offset: 1280 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 833-3587 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/5507136 bytes) complete. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (5507136/5507136 bytes) complete. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 531/3286 locked buffers Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 1068335608/1073741824 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Passing config to GCS: base_dir = /apps/database/mariadb/; base_host = sv1810949.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_ Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Service thread queue flushed. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: ####### Assign initial position for certification: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587, protocol version: -1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Start replication Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Connecting with bootstrap option: 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Setting GCS initial position to c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: protonet asio version 0 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: SSL cipher list set to 'AES128-SHA' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Using CRC-32C for message checksums. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: backend: asio Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Warning] WSREP: access file(/apps/database/mariadb//gvwstate.dat) failed(No such file or directory) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: restore pc from disk failed Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: GMCast version 0 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: (cbb362d6-90b4, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: (cbb362d6-90b4, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: EVS version 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: gcomm: bootstrapping new group 'mariadb_cluster_test' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: EVS version upgrade 0 -> 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: PC protocol upgrade 0 -> 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Node cbb362d6-90b4 state prim Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: view(view_id(PRIM,cbb362d6-90b4,1) memb { Jun 25 12:26:25 sv1810949 mysqld: cbb362d6-90b4,1 Jun 25 12:26:25 sv1810949 mysqld: } joined { Jun 25 12:26:25 sv1810949 mysqld: } left { Jun 25 12:26:25 sv1810949 mysqld: } partitioned { Jun 25 12:26:25 sv1810949 mysqld: }) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: save pc into disk Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr without UUID: ssl://1.1.1.152:4567 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr proto entry 0x55adf2f43750 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr without UUID: ssl://1.1.1.154:4567 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr proto entry 0x55adf2f4bdc0 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr without UUID: ssl://1.1.1.155:4567 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: discarding pending addr proto entry 0x55adf2f543e0 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: gcomm: connected Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Opened channel 'mariadb_cluster_test' Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: cbb4bb5d-d59f-11eb-8d83-b294342745db Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 1 [Note] WSREP: Starting rollbacker thread 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Starting applier thread 2 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: STATE EXCHANGE: sent state msg: cbb4bb5d-d59f-11eb-8d83-b294342745db Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: cbb4bb5d-d59f-11eb-8d83-b294342745db from 0 (sv1810949) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Quorum results: Jun 25 12:26:25 sv1810949 mysqld: version = 6, Jun 25 12:26:25 sv1810949 mysqld: component = PRIMARY, Jun 25 12:26:25 sv1810949 mysqld: conf_id = 0, Jun 25 12:26:25 sv1810949 mysqld: members = 1/1 (joined/total), Jun 25 12:26:25 sv1810949 mysqld: act_id = 3587, Jun 25 12:26:25 sv1810949 mysqld: last_appl. = 3587, Jun 25 12:26:25 sv1810949 mysqld: protocols = 2/10/4 (gcs/repl/appl), Jun 25 12:26:25 sv1810949 mysqld: vote policy= 0, Jun 25 12:26:25 sv1810949 mysqld: group UUID = c227de0f-f8aa-11e8-a038-ce7a6cae1f98 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Flow-control interval: [16, 16] Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Restored state OPEN -> JOINED (3588) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Member 0.1 (sv1810949) synced with group. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3588) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: ####### processing CC 3588, local, ordered Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Process first view: c227de0f-f8aa-11e8-a038-ce7a6cae1f98 my uuid: cbb362d6-d59f-11eb-90b4-aab11597609c Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Server sv1810949 connected to cluster at position c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3588 with ID cbb362d6-d59f-11eb-90b4-aab11597609c Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Server status change disconnected -> connected Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: ####### My UUID: cbb362d6-d59f-11eb-90b4-aab11597609c Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Service thread queue flushed. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: REPL Protocols: 10 (5) Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 3588 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] WSREP: Service thread queue flushed. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: ================================================ Jun 25 12:26:25 sv1810949 mysqld: View: Jun 25 12:26:25 sv1810949 mysqld: id: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3588 Jun 25 12:26:25 sv1810949 mysqld: status: primary Jun 25 12:26:25 sv1810949 mysqld: protocol_version: 4 Jun 25 12:26:25 sv1810949 mysqld: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jun 25 12:26:25 sv1810949 mysqld: final: no Jun 25 12:26:25 sv1810949 mysqld: own_index: 0 Jun 25 12:26:25 sv1810949 mysqld: members(1): Jun 25 12:26:25 sv1810949 mysqld: 0: cbb362d6-d59f-11eb-90b4-aab11597609c, sv1810949 Jun 25 12:26:25 sv1810949 mysqld: ================================================= Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Server status change connected -> joiner Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: Server status change joiner -> initializing Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Using Linux native AIO Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Uses event mutexes Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Number of pools: 1 Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Using SSE2 crc32 instructions Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Completed initialization of buffer pool Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Jun 25 12:26:25 sv1810949 mysqld: 2021-06-25 12:26:25 0 [Note] InnoDB: Waiting for purge to start Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] InnoDB: 10.4.20 started; log sequence number 26189298; transaction id 690251 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] InnoDB: Loading buffer pool(s) from /apps/database/mariadb/ib_buffer_pool Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Warning] 'proxies_priv' entry '@% root@sv1810949.example.org' ignored in --skip-name-resolve mode. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] WSREP: Server initialized Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] WSREP: Server status change initializing -> initialized Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 11 [Note] WSREP: Starting applier thread 11 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 10 [Note] WSREP: Starting applier thread 10 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 12 [Note] WSREP: Starting applier thread 12 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 9 [Note] WSREP: Recovered cluster id c227de0f-f8aa-11e8-a038-ce7a6cae1f98 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Server status change initialized -> joined Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] Reading of all Master_info entries succeeded Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] Added new Master_info '' to hash table Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] /usr/sbin/mysqld: ready for connections. Jun 25 12:26:26 sv1810949 mysqld: Version: '10.4.20-MariaDB' socket: '/apps/database/mariadb/mariadb.sock' port: 3306 MariaDB Server Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3588 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Min available from gcache for CC from group: 833 Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Server sv1810949 synced with group Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Server status change joined -> synced Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: Synchronized with group, ready for connections Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:26 sv1810949 mysqld: 2021-06-25 12:26:26 0 [Note] InnoDB: Buffer pool(s) load completed at 210625 12:26:26 Jun 25 12:26:47 sv1810949 mysqld: 2021-06-25 12:26:47 0 [Note] WSREP: (cbb362d6-90b4, 'ssl://0.0.0.0:4567') connection established to d8bc0ac8-af5a ssl://1.1.1.154:4567 Jun 25 12:26:47 sv1810949 mysqld: 2021-06-25 12:26:47 0 [Note] WSREP: (cbb362d6-90b4, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: declaring d8bc0ac8-af5a at ssl://1.1.1.154:4567 stable Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: Node cbb362d6-90b4 state prim Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: view(view_id(PRIM,cbb362d6-90b4,2) memb { Jun 25 12:26:48 sv1810949 mysqld: cbb362d6-90b4,1 Jun 25 12:26:48 sv1810949 mysqld: d8bc0ac8-af5a,1 Jun 25 12:26:48 sv1810949 mysqld: } joined { Jun 25 12:26:48 sv1810949 mysqld: } left { Jun 25 12:26:48 sv1810949 mysqld: } partitioned { Jun 25 12:26:48 sv1810949 mysqld: }) Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: save pc into disk Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: d909faa9-d59f-11eb-a8c3-be540aec85ae Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: STATE EXCHANGE: sent state msg: d909faa9-d59f-11eb-a8c3-be540aec85ae Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: STATE EXCHANGE: got state msg: d909faa9-d59f-11eb-a8c3-be540aec85ae from 0 (sv1810949) Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: STATE EXCHANGE: got state msg: d909faa9-d59f-11eb-a8c3-be540aec85ae from 1 (sv1810950) Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: Quorum results: Jun 25 12:26:48 sv1810949 mysqld: version = 6, Jun 25 12:26:48 sv1810949 mysqld: component = PRIMARY, Jun 25 12:26:48 sv1810949 mysqld: conf_id = 1, Jun 25 12:26:48 sv1810949 mysqld: members = 1/2 (joined/total), Jun 25 12:26:48 sv1810949 mysqld: act_id = 3588, Jun 25 12:26:48 sv1810949 mysqld: last_appl. = 3587, Jun 25 12:26:48 sv1810949 mysqld: protocols = 2/10/4 (gcs/repl/appl), Jun 25 12:26:48 sv1810949 mysqld: vote policy= 0, Jun 25 12:26:48 sv1810949 mysqld: group UUID = c227de0f-f8aa-11e8-a038-ce7a6cae1f98 Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: Flow-control interval: [23, 23] Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: ####### processing CC 3589, local, ordered Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: ####### My UUID: cbb362d6-d59f-11eb-90b4-aab11597609c Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: Skipping cert index reset Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: REPL Protocols: 10 (5) Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: ####### Adjusting cert position: 3588 -> 3589 Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 0 [Note] WSREP: Service thread queue flushed. Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: ================================================ Jun 25 12:26:48 sv1810949 mysqld: View: Jun 25 12:26:48 sv1810949 mysqld: id: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3589 Jun 25 12:26:48 sv1810949 mysqld: status: primary Jun 25 12:26:48 sv1810949 mysqld: protocol_version: 4 Jun 25 12:26:48 sv1810949 mysqld: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jun 25 12:26:48 sv1810949 mysqld: final: no Jun 25 12:26:48 sv1810949 mysqld: own_index: 0 Jun 25 12:26:48 sv1810949 mysqld: members(2): Jun 25 12:26:48 sv1810949 mysqld: 0: cbb362d6-d59f-11eb-90b4-aab11597609c, sv1810949 Jun 25 12:26:48 sv1810949 mysqld: 1: d8bc0ac8-d59f-11eb-af5a-7b5dc8ac56bd, sv1810950 Jun 25 12:26:48 sv1810949 mysqld: ================================================= Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3589 Jun 25 12:26:48 sv1810949 mysqld: 2021-06-25 12:26:48 2 [Note] WSREP: Min available from gcache for CC from group: 833 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Member 1.1 (sv1810950) requested state transfer from '*any*'. Selected 0.1 (sv1810949)(SYNCED) as donor. Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 3589) Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: Detected STR version: 1, req_len: 163, req: STRv1 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: IST request: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3585-3589|ssl://sv1810950.example.org:4568 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: Server status change synced -> donor Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Donor monitor thread started to monitor Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address 'sv1810950.example.org:4444/xtrabackup_sst//1' --local-port '3306' --socket '/apps/database/mariadb/mariadb.sock' --datadir '/apps/database/mariadb/' --gtid 'c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3585' --gtid-domain-id '0' --bypass --mysqld-args --wsrep-new-cluster --wsrep_start_position=c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587' Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: sst_donor_thread signaled with 0 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 2 [Note] WSREP: SSL cipher list set to 'AES128-SHA' Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: async IST sender starting to serve ssl://sv1810950.example.org:4568 sending 3586-3589, preload starts from 3589 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: IST sender 3586 -> 3589 Jun 25 12:26:49 sv1810949 mysqld: WSREP_SST: [INFO] SSL configuration: CA='', CERT='', KEY='', MODE='DISABLED', encrypt='4' (20210625 12:26:49.225) Jun 25 12:26:49 sv1810949 mysqld: WSREP_SST: [INFO] Logging all stderr of SST/mariabackup to syslog (20210625 12:26:49.318) Jun 25 12:26:49 sv1810949 -wsrep-sst-donor: Streaming with mbstream Jun 25 12:26:49 sv1810949 -wsrep-sst-donor: Using socat as streamer Jun 25 12:26:49 sv1810949 -wsrep-sst-donor: Using openssl based encryption with socat: with key and crt Jun 25 12:26:49 sv1810949 -wsrep-sst-donor: Both certificate and key files required Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [ERROR] WSREP: Failed to read from: wsrep_sst_mariabackup --role 'donor' --address 'sv1810950.example.org:4444/xtrabackup_sst//1' --local-port '3306' --socket '/apps/database/mariadb/mariadb.sock' --datadir '/apps/database/mariadb/' --gtid 'c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3585' --gtid-domain-id '0' --bypass --mysqld-args --wsrep-new-cluster --wsrep_start_position=c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'donor' --address 'sv1810950.example.org:4444/xtrabackup_sst//1' --local-port '3306' --socket '/apps/database/mariadb/mariadb.sock' --datadir '/apps/database/mariadb/' --gtid 'c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3585' --gtid-domain-id '0' --bypass --mysqld-args --wsrep-new-cluster --wsrep_start_position=c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587: 22 (Invalid argument) Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: SST sending failed: -22 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Server status change donor -> joined Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [ERROR] WSREP: Command did not run: wsrep_sst_mariabackup --role 'donor' --address 'sv1810950.example.org:4444/xtrabackup_sst//1' --local-port '3306' --socket '/apps/database/mariadb/mariadb.sock' --datadir '/apps/database/mariadb/' --gtid 'c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3585' --gtid-domain-id '0' --bypass --mysqld-args --wsrep-new-cluster --wsrep_start_position=c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3587 Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Warning] WSREP: 0.1 (sv1810949): State transfer to 1.1 (sv1810950) failed: -22 (Invalid argument) Jun 25 12:26:49 sv1810949 mysqld: 2021-06-25 12:26:49 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 3589) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: ssl://1.1.1.154:60092 Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: forgetting d8bc0ac8-af5a (ssl://1.1.1.154:4567) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Node cbb362d6-90b4 state prim Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: view(view_id(PRIM,cbb362d6-90b4,3) memb { Jun 25 12:26:50 sv1810949 mysqld: cbb362d6-90b4,1 Jun 25 12:26:50 sv1810949 mysqld: } joined { Jun 25 12:26:50 sv1810949 mysqld: } left { Jun 25 12:26:50 sv1810949 mysqld: } partitioned { Jun 25 12:26:50 sv1810949 mysqld: d8bc0ac8-af5a,1 Jun 25 12:26:50 sv1810949 mysqld: }) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: save pc into disk Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Member 0.1 (sv1810949) synced with group. Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3589) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 11 [Note] WSREP: Server sv1810949 synced with group Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 11 [Note] WSREP: Server status change joined -> synced Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 11 [Note] WSREP: Synchronized with group, ready for connections Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: forgetting d8bc0ac8-af5a (ssl://1.1.1.154:4567) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x7f828800f2a8 Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Deferred close timer destruct Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: da44275d-d59f-11eb-b2eb-6fd4d8932ccb Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: STATE EXCHANGE: sent state msg: da44275d-d59f-11eb-b2eb-6fd4d8932ccb Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: STATE EXCHANGE: got state msg: da44275d-d59f-11eb-b2eb-6fd4d8932ccb from 0 (sv1810949) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Quorum results: Jun 25 12:26:50 sv1810949 mysqld: version = 6, Jun 25 12:26:50 sv1810949 mysqld: component = PRIMARY, Jun 25 12:26:50 sv1810949 mysqld: conf_id = 2, Jun 25 12:26:50 sv1810949 mysqld: members = 1/1 (joined/total), Jun 25 12:26:50 sv1810949 mysqld: act_id = 3589, Jun 25 12:26:50 sv1810949 mysqld: last_appl. = 3587, Jun 25 12:26:50 sv1810949 mysqld: protocols = 2/10/4 (gcs/repl/appl), Jun 25 12:26:50 sv1810949 mysqld: vote policy= 0, Jun 25 12:26:50 sv1810949 mysqld: group UUID = c227de0f-f8aa-11e8-a038-ce7a6cae1f98 Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Flow-control interval: [16, 16] Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: ####### processing CC 3590, local, ordered Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: ####### My UUID: cbb362d6-d59f-11eb-90b4-aab11597609c Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: Skipping cert index reset Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: REPL Protocols: 10 (5) Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: ####### Adjusting cert position: 3589 -> 3590 Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: Service thread queue flushed. Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 0 [Note] WSREP: async IST sender served Jun 25 12:26:50 sv1810949 mysqld: 2021-06-25 12:26:50 12 [Note] WSREP: ================================================ Jun 25 12:26:50 sv1810949 mysqld: View: Jun 25 12:26:50 sv1810949 mysqld: id: c227de0f-f8aa-11e8-a038-ce7a6cae1f98:3590 Jun 25 12:26:50 sv1810949 mysqld: status: primary Jun 25 12:26:50 sv1810949 mysqld: protocol_version: 4 Jun 25 12:26:50 sv1810949 mysqld: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Jun 25 12:26:50 sv1810949 mysqld: final: no Jun 25 12:26:50 sv1810949 mysqld: own_index: 0 Jun 25 12:26:50 sv1810949 mysqld: members(1): Jun 25 12:26:50 sv1810949 mysqld: 0: cbb362d6-d59f-11eb-90b4-aab11597609c, sv1810949 Jun 25 12:26:50 sv1810949 mysqld: =================================================