2020-05-25 22:24:29 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-05-25 22:24:29 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-05-25 22:24:29 0 [Note] WSREP: Found saved state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63, safe_to_bootstrap: 0 2020-05-25 22:24:29 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 Seqno: 62 - 63 Offset: 1280 Synced: 1 2020-05-25 22:24:29 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0, offset: 1280 2020-05-25 22:24:29 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2020-05-25 22:24:29 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2020-05-25 22:24:29 0 [Note] WSREP: Recovering GCache ring buffer: didn't recover any events. 2020-05-25 22:24:29 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.0.1.14; base_port = 4567; 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 = /var/lib/mysql/; 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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fa... 2020-05-25 22:24:29 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:29 0 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63, protocol version: -1 2020-05-25 22:24:29 0 [Note] WSREP: GCache history reset: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:0 -> 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:29 0 [Note] WSREP: Start replication 2020-05-25 22:24:29 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-05-25 22:24:29 0 [Note] WSREP: Setting GCS initial position to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:29 0 [Note] WSREP: protonet asio version 0 2020-05-25 22:24:29 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-05-25 22:24:29 0 [Note] WSREP: backend: asio 2020-05-25 22:24:29 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-05-25 22:24:29 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-05-25 22:24:29 0 [Note] WSREP: restore pc from disk failed 2020-05-25 22:24:29 0 [Note] WSREP: GMCast version 0 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-05-25 22:24:29 0 [Note] WSREP: EVS version 1 2020-05-25 22:24:29 0 [Note] WSREP: gcomm: connecting to group 'n4tdb01_wsrep_cluster', peer '10.0.1.13:,10.0.1.14:,10.0.1.15:' 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.0.1.14:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') connection established to 8a8ca0b3-bb24 tcp://10.0.1.13:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-05-25 22:24:29 0 [Note] WSREP: declaring 8a8ca0b3-bb24 at tcp://10.0.1.13:4567 stable 2020-05-25 22:24:29 0 [Note] WSREP: Node 8a8ca0b3-bb24 state prim 2020-05-25 22:24:29 0 [Note] WSREP: view(view_id(PRIM,7ff14eaf-b98f,4) memb { 7ff14eaf-b98f,0 8a8ca0b3-bb24,0 } joined { } left { } partitioned { }) 2020-05-25 22:24:29 0 [Note] WSREP: save pc into disk 2020-05-25 22:24:29 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.1.15:4567 2020-05-25 22:24:29 0 [Note] WSREP: gcomm: connected 2020-05-25 22:24:29 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-05-25 22:24:29 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-05-25 22:24:29 0 [Note] WSREP: Opened channel 'n4tdb01_wsrep_cluster' 2020-05-25 22:24:29 1 [Note] WSREP: Starting rollbacker thread 1 2020-05-25 22:24:29 2 [Note] WSREP: Starting applier thread 2 2020-05-25 22:24:29 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-05-25 22:24:29 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 803e9f15-9ed6-11ea-8996-137424fe9dfd 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd from 0 (mdb2) 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd from 1 (mdb1) 2020-05-25 22:24:30 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 3, members = 1/2 (joined/total), act_id = 65, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 2020-05-25 22:24:30 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-05-25 22:24:30 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 65) 2020-05-25 22:24:30 2 [Note] WSREP: ####### processing CC 65, local, unordered 2020-05-25 22:24:30 2 [Note] WSREP: Process first view: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 my uuid: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Server mdb2 connected to cluster at position 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 with ID 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Server status change disconnected -> connected 2020-05-25 22:24:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:30 2 [Note] WSREP: ####### My UUID: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Cert index reset to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 (proto: 9), state transfer needed: yes 2020-05-25 22:24:30 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:30 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65, protocol version: 4 2020-05-25 22:24:30 2 [Note] WSREP: State transfer required: Group state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 Local state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:30 2 [Note] WSREP: Server status change connected -> joiner 2020-05-25 22:24:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:30 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-05-25 22:24:30 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.0.1.14' --datadir '/var/lib/mysql/' --parent '25596' --mysqld-args --wsrep_start_position=86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63' WSREP_SST: [INFO] Moving /var/lib/mysql//mariabackup.prepare.log to /tmp/sst_log_archive/mariabackup.prepare.log.2020.05.25-22.24.30.389224199 (20200525 22:24:30.392) WSREP_SST: [INFO] Moving /var/lib/mysql//mariabackup.move.log to /tmp/sst_log_archive/mariabackup.move.log.2020.05.25-22.24.30.389224199 (20200525 22:24:30.399) WSREP_SST: [INFO] Streaming with xbstream (20200525 22:24:30.409) WSREP_SST: [INFO] Using socat as streamer (20200525 22:24:30.412) WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | pigz -dc -p 8 | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20200525 22:24:30.482) 2020-05-25 22:24:30 2 [Note] WSREP: Prepared SST request: mariabackup|10.0.1.14:4444/xtrabackup_sst//1 2020-05-25 22:24:30 2 [Note] WSREP: ####### IST uuid:86a3014e-9e9d-11ea-8f7d-829b023fcaf0 f: 64, l: 65, STRv: 2 2020-05-25 22:24:30 2 [Note] WSREP: IST receiver addr using tcp://10.0.1.14:4568 2020-05-25 22:24:30 2 [Note] WSREP: Prepared IST receiver for 64-65, listening at: tcp://10.0.1.14:4568 2020-05-25 22:24:30 0 [Note] WSREP: Member 0.0 (mdb2) requested state transfer from '*any*'. Selected 1.0 (mdb1)(SYNCED) as donor. 2020-05-25 22:24:30 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 65) 2020-05-25 22:24:30 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2020-05-25 22:24:31 0 [Note] WSREP: 1.0 (mdb1): State transfer to 0.0 (mdb2) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Member 1.0 (mdb1) synced with group. WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20200525 22:24:31.208) WSREP_SST: [INFO] Galera co-ords from recovery: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 0 (20200525 22:24:31.212) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20200525 22:24:31.218) WSREP_SST: [INFO] Removing the sst_in_progress file (20200525 22:24:31.222) 2020-05-25 22:24:31 3 [Note] WSREP: SST received 2020-05-25 22:24:31 3 [Note] WSREP: Server status change joiner -> initializing 2020-05-25 22:24:31 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 0 [Note] InnoDB: Using Linux native AIO 2020-05-25 22:24:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-25 22:24:31 0 [Note] InnoDB: Uses event mutexes 2020-05-25 22:24:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-05-25 22:24:31 0 [Note] InnoDB: Number of pools: 1 2020-05-25 22:24:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-05-25 22:24:31 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-05-25 22:24:31 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-25 22:24:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-25 22:24:31 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2020-05-25 22:24:31 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2020-05-25 22:24:31 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-05-25 22:24:31 0 [Note] InnoDB: New log files created, LSN=1882151 2020-05-25 22:24:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-05-25 22:24:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-25 22:24:31 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-25 22:24:31 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-25 22:24:31 0 [Note] InnoDB: Waiting for purge to start 2020-05-25 22:24:31 0 [Note] InnoDB: 10.4.13 started; log sequence number 1882636; transaction id 231 2020-05-25 22:24:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-05-25 22:24:31 0 [Note] InnoDB: Buffer pool(s) load completed at 200525 22:24:31 2020-05-25 22:24:31 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-05-25 22:24:31 0 [Note] Server socket created on IP: '::'. 2020-05-25 22:24:31 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-05-25 22:24:31 0 [Note] WSREP: Server initialized 2020-05-25 22:24:31 0 [Note] WSREP: Server status change initializing -> initialized 2020-05-25 22:24:31 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 3 [Note] WSREP: Server status change initialized -> joined 2020-05-25 22:24:31 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 3 [Note] WSREP: Recovered position from storage: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 3 [Note] WSREP: Recovered view from SST: id: 00000000-0000-0000-0000-000000000000:-1 status: primary protocol_version: 0 capabilities: final: yes own_index: -1 members(0): 2020-05-25 22:24:31 3 [Warning] WSREP: View recovered from stable storage was empty. If the server is doing rolling upgrade from previous version which does not support storing view info into stable storage, this is ok. Otherwise this may be a sign of malfunction. 2020-05-25 22:24:31 10 [Note] WSREP: Cluster table is empty, not recovering transactions 2020-05-25 22:24:31 3 [Note] WSREP: SST received: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 0 [Note] WSREP: Joiner monitor thread ended with total time 1 sec 2020-05-25 22:24:31 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:31 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65, protocol version: -1 2020-05-25 22:24:31 2 [Note] WSREP: Installed new state from SST: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 11 [Note] WSREP: Starting applier thread 11 2020-05-25 22:24:31 12 [Note] WSREP: Starting applier thread 12 2020-05-25 22:24:31 13 [Note] WSREP: Starting applier thread 13 2020-05-25 22:24:31 14 [Note] WSREP: Starting applier thread 14 2020-05-25 22:24:31 15 [Note] WSREP: Starting applier thread 15 2020-05-25 22:24:31 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 64-65 2020-05-25 22:24:31 0 [Note] WSREP: ####### IST applying starts with 64 2020-05-25 22:24:31 0 [Note] WSREP: ####### IST current seqno initialized to 64 2020-05-25 22:24:31 0 [Note] WSREP: Receiving IST... 0.0% (0/2 events) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Receiving IST...100.0% (2/2 events) complete. 2020-05-25 22:24:31 16 [Note] WSREP: Starting applier thread 16 2020-05-25 22:24:31 17 [Note] WSREP: Starting applier thread 17 2020-05-25 22:24:31 18 [Note] WSREP: Starting applier thread 18 2020-05-25 22:24:31 19 [Note] WSREP: Starting applier thread 19 2020-05-25 22:24:31 20 [Note] WSREP: Starting applier thread 20 2020-05-25 22:24:31 21 [Note] WSREP: Starting applier thread 21 2020-05-25 22:24:31 22 [Note] WSREP: Starting applier thread 22 2020-05-25 22:24:31 24 [Note] WSREP: Starting applier thread 24 2020-05-25 22:24:31 25 [Note] WSREP: Starting applier thread 25 2020-05-25 22:24:31 26 [Note] WSREP: Starting applier thread 26 2020-05-25 22:24:31 27 [Note] WSREP: Starting applier thread 27 2020-05-25 22:24:31 28 [Note] WSREP: Starting applier thread 28 2020-05-25 22:24:31 29 [Note] WSREP: Starting applier thread 29 2020-05-25 22:24:31 30 [Note] WSREP: Starting applier thread 30 2020-05-25 22:24:31 31 [Note] WSREP: Starting applier thread 31 2020-05-25 22:24:31 32 [Note] WSREP: Starting applier thread 32 2020-05-25 22:24:31 33 [Note] WSREP: Starting applier thread 33 2020-05-25 22:24:31 34 [Note] WSREP: Starting applier thread 34 2020-05-25 22:24:31 35 [Note] WSREP: Starting applier thread 35 2020-05-25 22:24:31 36 [Note] WSREP: Starting applier thread 36 2020-05-25 22:24:31 37 [Note] WSREP: Starting applier thread 37 2020-05-25 22:24:31 38 [Note] WSREP: Starting applier thread 38 2020-05-25 22:24:31 39 [Note] WSREP: Starting applier thread 39 2020-05-25 22:24:31 40 [Note] WSREP: Starting applier thread 40 2020-05-25 22:24:31 41 [Note] WSREP: Starting applier thread 41 2020-05-25 22:24:31 42 [Note] WSREP: Starting applier thread 42 2020-05-25 22:24:31 2 [Note] WSREP: Draining apply monitors after IST upto 65 2020-05-25 22:24:31 2 [Note] WSREP: IST received: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 2020-05-25 22:24:31 2 [Note] WSREP: Lowest cert indnex boundary for CC from sst: 65 2020-05-25 22:24:31 2 [Note] WSREP: Min available from gcache for CC from sst: 64 2020-05-25 22:24:31 0 [Note] Reading of all Master_info entries succeeded 2020-05-25 22:24:31 0 [Note] Added new Master_info '' to hash table 2020-05-25 22:24:31 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-05-25 22:24:31 0 [Note] WSREP: 0.0 (mdb2): State transfer from 1.0 (mdb1) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 65) 2020-05-25 22:24:31 0 [Note] WSREP: Member 0.0 (mdb2) synced with group. 2020-05-25 22:24:31 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 65) 2020-05-25 22:24:31 2 [Note] WSREP: Server mdb2 synced with group 2020-05-25 22:24:31 2 [Note] WSREP: Server status change joined -> synced 2020-05-25 22:24:31 2 [Note] WSREP: Synchronized with group, ready for connections 2020-05-25 22:24:31 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 44 [Warning] IP address '10.0.1.11' could not be resolved: Name or service not known 2020-05-25 22:24:32 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-05-25 22:25:17 19 [Warning] WSREP: trx protocol version: 4 does not match certification protocol version: -1 2020-05-25 22:25:31 45 [Warning] Aborted connection 45 to db: 'pippo' user: 'root' host: 'localhost' (This connection closed normally) 2020-05-25 22:25:36 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2020-05-25 22:25:36 0 [Note] WSREP: Shutdown replication 2020-05-25 22:25:36 0 [Note] WSREP: Server status change synced -> disconnecting 2020-05-25 22:25:36 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:36 0 [Note] WSREP: Closing send monitor... 2020-05-25 22:25:36 0 [Note] WSREP: Closed send monitor. 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: terminating thread 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: joining thread 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: closing backend 2020-05-25 22:25:37 0 [Note] WSREP: view(view_id(NON_PRIM,7ff14eaf-b98f,4) memb { 7ff14eaf-b98f,0 } joined { } left { } partitioned { 8a8ca0b3-bb24,0 }) 2020-05-25 22:25:37 0 [Note] WSREP: view((empty)) 2020-05-25 22:25:37 0 [Note] WSREP: gcomm: closed 2020-05-25 22:25:37 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-05-25 22:25:37 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-05-25 22:25:37 0 [Note] WSREP: Received NON-PRIMARY. 2020-05-25 22:25:37 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 66) 2020-05-25 22:25:37 0 [Note] WSREP: New SELF-LEAVE. 2020-05-25 22:25:37 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-05-25 22:25:37 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-05-25 22:25:37 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-05-25 22:25:37 0 [Note] WSREP: RECV thread exiting 0: Success 2020-05-25 22:25:37 18 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:-1 status: non-primary protocol_version: 3 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: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4, mdb2 ================================================= 2020-05-25 22:25:37 18 [Note] WSREP: Non-primary view 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 0 [Note] WSREP: recv_thread() joined. 2020-05-25 22:25:37 0 [Note] WSREP: Closing replication queue. 2020-05-25 22:25:37 0 [Note] WSREP: Closing slave action queue. 2020-05-25 22:25:37 18 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:-1 status: non-primary protocol_version: 3 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0): ================================================= 2020-05-25 22:25:37 18 [Note] WSREP: Non-primary view 2020-05-25 22:25:37 18 [Note] WSREP: Server status change disconnecting -> disconnected 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 18 [Note] WSREP: Applier thread exiting ret: 0 thd: 18 2020-05-25 22:25:37 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 0 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (KILLED) 2020-05-25 22:25:37 0 [Note] WSREP: killing local connection: 44 2020-05-25 22:25:37 0 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (This connection closed normally) 2020-05-25 22:25:37 44 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (This connection closed normally) 2020-05-25 22:25:37 21 [Note] WSREP: Applier thread exiting ret: 6 thd: 21 2020-05-25 22:25:37 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 20 [Note] WSREP: Applier thread exiting ret: 6 thd: 20 2020-05-25 22:25:37 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 12 [Note] WSREP: Applier thread exiting ret: 6 thd: 12 2020-05-25 22:25:37 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 2 [Note] WSREP: Applier thread exiting ret: 6 thd: 2 2020-05-25 22:25:37 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 32 [Note] WSREP: Applier thread exiting ret: 6 thd: 32 2020-05-25 22:25:37 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 13 [Note] WSREP: Applier thread exiting ret: 6 thd: 13 2020-05-25 22:25:37 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 14 [Note] WSREP: Applier thread exiting ret: 6 thd: 14 2020-05-25 22:25:37 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 41 [Note] WSREP: Applier thread exiting ret: 6 thd: 41 2020-05-25 22:25:37 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 22 [Note] WSREP: Applier thread exiting ret: 6 thd: 22 2020-05-25 22:25:37 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 25 [Note] WSREP: Applier thread exiting ret: 6 thd: 25 2020-05-25 22:25:37 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 27 [Note] WSREP: Applier thread exiting ret: 6 thd: 27 2020-05-25 22:25:37 27 [Warning] Aborted connection 27 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 30 [Note] WSREP: Applier thread exiting ret: 6 thd: 30 2020-05-25 22:25:37 30 [Warning] Aborted connection 30 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 31 [Note] WSREP: Applier thread exiting ret: 6 thd: 31 2020-05-25 22:25:37 31 [Warning] Aborted connection 31 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 29 [Note] WSREP: Applier thread exiting ret: 6 thd: 29 2020-05-25 22:25:37 29 [Warning] Aborted connection 29 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 28 [Note] WSREP: Applier thread exiting ret: 6 thd: 28 2020-05-25 22:25:37 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 34 [Note] WSREP: Applier thread exiting ret: 6 thd: 34 2020-05-25 22:25:37 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 33 [Note] WSREP: Applier thread exiting ret: 6 thd: 33 2020-05-25 22:25:37 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 26 [Note] WSREP: Applier thread exiting ret: 6 thd: 26 2020-05-25 22:25:37 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 35 [Note] WSREP: Applier thread exiting ret: 6 thd: 35 2020-05-25 22:25:37 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 24 [Note] WSREP: Applier thread exiting ret: 6 thd: 24 2020-05-25 22:25:37 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 11 [Note] WSREP: Applier thread exiting ret: 6 thd: 11 2020-05-25 22:25:37 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 15 [Note] WSREP: Applier thread exiting ret: 6 thd: 15 2020-05-25 22:25:37 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 42 [Note] WSREP: Applier thread exiting ret: 6 thd: 42 2020-05-25 22:25:37 42 [Warning] Aborted connection 42 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 39 [Note] WSREP: Applier thread exiting ret: 6 thd: 39 2020-05-25 22:25:37 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 40 [Note] WSREP: Applier thread exiting ret: 6 thd: 40 2020-05-25 22:25:37 40 [Warning] Aborted connection 40 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 37 [Note] WSREP: Applier thread exiting ret: 6 thd: 37 2020-05-25 22:25:37 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 38 [Note] WSREP: Applier thread exiting ret: 6 thd: 38 2020-05-25 22:25:37 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 36 [Note] WSREP: Applier thread exiting ret: 6 thd: 36 2020-05-25 22:25:37 36 [Warning] Aborted connection 36 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17 2020-05-25 22:25:37 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 16 [Note] WSREP: Applier thread exiting ret: 6 thd: 16 2020-05-25 22:25:37 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 19 [Note] WSREP: Applier thread exiting ret: 6 thd: 19 2020-05-25 22:25:37 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:38 1 [Note] WSREP: rollbacker thread exiting 1 2020-05-25 22:25:38 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:38 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-05-25 22:25:38 0 [Note] InnoDB: FTS optimize thread exiting. 2020-05-25 22:25:38 0 [Note] WSREP: dtor state: CLOSED 2020-05-25 22:25:38 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.333333, misses: 2, in use: 1, in pool: 1 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 3 oooe fraction 0.333333 oool fraction 0 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 6 oooe fraction 0 oool fraction 0.166667 2020-05-25 22:25:38 0 [Note] WSREP: cert index usage at exit 0 2020-05-25 22:25:38 0 [Note] WSREP: cert trx map usage at exit 1 2020-05-25 22:25:38 0 [Note] WSREP: deps set usage at exit 0 2020-05-25 22:25:38 0 [Note] WSREP: avg deps dist 0 2020-05-25 22:25:38 0 [Note] WSREP: avg cert interval 0 2020-05-25 22:25:38 0 [Note] WSREP: cert index size 0 2020-05-25 22:25:38 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:38 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2020-05-25 22:25:38 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-05-25 22:25:38 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: -1) 2020-05-25 22:25:38 0 [Note] WSREP: Flushing memory map to disk... 2020-05-25 22:25:38 0 [Note] InnoDB: Starting shutdown... 2020-05-25 22:25:38 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-05-25 22:25:38 0 [Note] InnoDB: Buffer pool(s) dump completed at 200525 22:25:38 2020-05-25 22:25:40 0 [Note] InnoDB: Shutdown completed; log sequence number 1895195; transaction id 265 2020-05-25 22:25:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-05-25 22:25:40 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-05-25 22:25:42 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-05-25 22:25:42 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-05-25 22:25:42 0 [Note] WSREP: Found saved state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, safe_to_bootstrap: 0 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 Seqno: 64 - 66 Offset: 1280 Synced: 1 2020-05-25 22:25:42 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0, offset: 1280 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 64-66 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/1048 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (1048/1048 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/3 locked buffers 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 1048/1073741824 2020-05-25 22:25:42 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.0.1.14; base_port = 4567; 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 = /var/lib/mysql/; 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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fa... 2020-05-25 22:25:42 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:42 0 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, protocol version: -1 2020-05-25 22:25:42 0 [Note] WSREP: Start replication 2020-05-25 22:25:42 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-05-25 22:25:42 0 [Note] WSREP: Setting GCS initial position to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 2020-05-25 22:25:42 0 [Note] WSREP: protonet asio version 0 2020-05-25 22:25:42 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-05-25 22:25:42 0 [Note] WSREP: backend: asio 2020-05-25 22:25:42 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-05-25 22:25:42 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-05-25 22:25:42 0 [Note] WSREP: restore pc from disk failed 2020-05-25 22:25:42 0 [Note] WSREP: GMCast version 0 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-05-25 22:25:42 0 [Note] WSREP: EVS version 1 2020-05-25 22:25:42 0 [Note] WSREP: gcomm: connecting to group 'n4tdb01_wsrep_cluster', peer '10.0.1.13:,10.0.1.14:,10.0.1.15:' 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.0.1.14:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') connection established to 8a8ca0b3-bb24 tcp://10.0.1.13:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-05-25 22:25:43 0 [Note] WSREP: declaring 8a8ca0b3-bb24 at tcp://10.0.1.13:4567 stable 2020-05-25 22:25:43 0 [Note] WSREP: Node 8a8ca0b3-bb24 state prim 2020-05-25 22:25:43 0 [Note] WSREP: view(view_id(PRIM,8a8ca0b3-bb24,6) memb { 8a8ca0b3-bb24,0 ab80ace4-8cdf,0 } joined { } left { } partitioned { }) 2020-05-25 22:25:43 0 [Note] WSREP: save pc into disk 2020-05-25 22:25:43 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.1.15:4567 2020-05-25 22:25:43 0 [Note] WSREP: gcomm: connected 2020-05-25 22:25:43 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-05-25 22:25:43 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-05-25 22:25:43 0 [Note] WSREP: Opened channel 'n4tdb01_wsrep_cluster' 2020-05-25 22:25:43 1 [Note] WSREP: Starting rollbacker thread 1 2020-05-25 22:25:43 2 [Note] WSREP: Starting applier thread 2 2020-05-25 22:25:43 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: sent state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 from 0 (mdb1) 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 from 1 (mdb2) 2020-05-25 22:25:43 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 5, members = 2/2 (joined/total), act_id = 66, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 2020-05-25 22:25:43 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-05-25 22:25:43 0 [Note] WSREP: Restored state OPEN -> JOINED (66) 2020-05-25 22:25:43 2 [Note] WSREP: ####### processing CC 66, local, unordered 2020-05-25 22:25:43 2 [Note] WSREP: Process first view: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 my uuid: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Server mdb2 connected to cluster at position 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 with ID ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Server status change disconnected -> connected 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: ####### My UUID: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Cert index reset to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 (proto: 9), state transfer needed: no 2020-05-25 22:25:43 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:43 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, protocol version: 4 2020-05-25 22:25:43 2 [Note] WSREP: REPL Protocols: 9 (4) 2020-05-25 22:25:43 2 [Note] WSREP: ####### Adjusting cert position: 66 -> 66 2020-05-25 22:25:43 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:43 0 [Note] WSREP: Member 1.0 (mdb2) synced with group. 2020-05-25 22:25:43 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 66) 2020-05-25 22:25:43 2 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 status: primary protocol_version: 3 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: 8a8ca0b3-9ed3-11ea-bb24-feceed4887ed, mdb1 1: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6, mdb2 ================================================= 2020-05-25 22:25:43 2 [Note] WSREP: Server status change connected -> joiner 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: Server status change joiner -> initializing 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 0 [Note] InnoDB: Using Linux native AIO 2020-05-25 22:25:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-25 22:25:43 0 [Note] InnoDB: Uses event mutexes 2020-05-25 22:25:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-05-25 22:25:43 0 [Note] InnoDB: Number of pools: 1 2020-05-25 22:25:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-05-25 22:25:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-05-25 22:25:43 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-25 22:25:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-25 22:25:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-05-25 22:25:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-25 22:25:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-25 22:25:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-25 22:25:43 0 [Note] InnoDB: Waiting for purge to start 2020-05-25 22:25:43 0 [Note] InnoDB: 10.4.13 started; log sequence number 1895204; transaction id 262 2020-05-25 22:25:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-05-25 22:25:43 0 [Note] InnoDB: Buffer pool(s) load completed at 200525 22:25:43 2020-05-25 22:25:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-05-25 22:25:43 0 [Note] Server socket created on IP: '::'. 2020-05-25 22:25:43 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-05-25 22:25:43 0 [Note] WSREP: Server initialized 2020-05-25 22:25:43 0 [Note] WSREP: Server status change initializing -> initialized 2020-05-25 22:25:43 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 9 [Note] WSREP: Cluster table is empty, not recovering transactions 2020-05-25 22:25:43 2 [Note] WSREP: Server status change initialized -> joined 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 10 [Note] WSREP: Starting applier thread 10 2020-05-25 22:25:43 11 [Note] WSREP: Starting applier thread 11 2020-05-25 22:25:43 0 [Note] Reading of all Master_info entries succeeded 2020-05-25 22:25:43 0 [Note] Added new Master_info '' to hash table 2020-05-25 22:25:43 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-05-25 22:25:43 14 [Note] WSREP: Starting applier thread 14 2020-05-25 22:25:43 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 66 2020-05-25 22:25:43 2 [Note] WSREP: Min available from gcache for CC from group: 64 2020-05-25 22:25:43 2 [Note] WSREP: Server mdb2 synced with group 2020-05-25 22:25:43 2 [Note] WSREP: Server status change joined -> synced 2020-05-25 22:25:43 2 [Note] WSREP: Synchronized with group, ready for connections 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 15 [Note] WSREP: Starting applier thread 15 2020-05-25 22:25:43 16 [Note] WSREP: Starting applier thread 16 2020-05-25 22:25:43 17 [Note] WSREP: Starting applier thread 17 2020-05-25 22:25:43 18 [Note] WSREP: Starting applier thread 18 2020-05-25 22:25:43 19 [Note] WSREP: Starting applier thread 19 2020-05-25 22:25:43 20 [Note] WSREP: Starting applier thread 20 2020-05-25 22:25:43 21 [Note] WSREP: Starting applier thread 21 2020-05-25 22:25:43 22 [Note] WSREP: Starting applier thread 22 2020-05-25 22:25:43 23 [Note] WSREP: Starting applier thread 23 2020-05-25 22:25:43 24 [Note] WSREP: Starting applier thread 24 2020-05-25 22:25:43 25 [Note] WSREP: Starting applier thread 25 2020-05-25 22:25:43 26 [Note] WSREP: Starting applier thread 26 2020-05-25 22:25:43 27 [Note] WSREP: Starting applier thread 27 2020-05-25 22:25:43 28 [Note] WSREP: Starting applier thread 28 2020-05-25 22:25:43 29 [Note] WSREP: Starting applier thread 29 2020-05-25 22:25:43 30 [Note] WSREP: Starting applier thread 30 2020-05-25 22:25:43 31 [Note] WSREP: Starting applier thread 31 2020-05-25 22:25:43 32 [Note] WSREP: Starting applier thread 32 2020-05-25 22:25:43 33 [Note] WSREP: Starting applier thread 33 2020-05-25 22:25:43 34 [Note] WSREP: Starting applier thread 34 2020-05-25 22:25:43 35 [Note] WSREP: Starting applier thread 35 2020-05-25 22:25:43 36 [Note] WSREP: Starting applier thread 36 2020-05-25 22:25:43 37 [Note] WSREP: Starting applier thread 37 2020-05-25 22:25:43 38 [Note] WSREP: Starting applier thread 38 2020-05-25 22:25:43 39 [Note] WSREP: Starting applier thread 39 2020-05-25 22:25:43 40 [Note] WSREP: Starting applier thread 40 2020-05-25 22:25:43 41 [Note] WSREP: Starting applier thread 41 2020-05-25 22:25:43 42 [Note] WSREP: Starting applier thread 42 2020-05-25 22:25:44 43 [Warning] IP address '10.0.1.11' could not be resolved: Name or service not known 2020-05-25 22:25:45 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-05-26 0:26:31 44 [Warning] Aborted connection 44 to db: 'pippo' user: 'root' host: 'localhost' (This connection closed normally) [root@mdb2 my.cnf.d]# date Tue May 26 00:35:23 UTC 2020 [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# [root@mdb2 my.cnf.d]# cat /var/lib/mysql/error.log 2020-05-25 22:24:29 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-05-25 22:24:29 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-05-25 22:24:29 0 [Note] WSREP: Found saved state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63, safe_to_bootstrap: 0 2020-05-25 22:24:29 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 Seqno: 62 - 63 Offset: 1280 Synced: 1 2020-05-25 22:24:29 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0, offset: 1280 2020-05-25 22:24:29 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2020-05-25 22:24:29 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2020-05-25 22:24:29 0 [Note] WSREP: Recovering GCache ring buffer: didn't recover any events. 2020-05-25 22:24:29 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.0.1.14; base_port = 4567; 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 = /var/lib/mysql/; 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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fa... 2020-05-25 22:24:29 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:29 0 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63, protocol version: -1 2020-05-25 22:24:29 0 [Note] WSREP: GCache history reset: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:0 -> 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:29 0 [Note] WSREP: Start replication 2020-05-25 22:24:29 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-05-25 22:24:29 0 [Note] WSREP: Setting GCS initial position to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:29 0 [Note] WSREP: protonet asio version 0 2020-05-25 22:24:29 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-05-25 22:24:29 0 [Note] WSREP: backend: asio 2020-05-25 22:24:29 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-05-25 22:24:29 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-05-25 22:24:29 0 [Note] WSREP: restore pc from disk failed 2020-05-25 22:24:29 0 [Note] WSREP: GMCast version 0 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-05-25 22:24:29 0 [Note] WSREP: EVS version 1 2020-05-25 22:24:29 0 [Note] WSREP: gcomm: connecting to group 'n4tdb01_wsrep_cluster', peer '10.0.1.13:,10.0.1.14:,10.0.1.15:' 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.0.1.14:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') connection established to 8a8ca0b3-bb24 tcp://10.0.1.13:4567 2020-05-25 22:24:29 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-05-25 22:24:29 0 [Note] WSREP: declaring 8a8ca0b3-bb24 at tcp://10.0.1.13:4567 stable 2020-05-25 22:24:29 0 [Note] WSREP: Node 8a8ca0b3-bb24 state prim 2020-05-25 22:24:29 0 [Note] WSREP: view(view_id(PRIM,7ff14eaf-b98f,4) memb { 7ff14eaf-b98f,0 8a8ca0b3-bb24,0 } joined { } left { } partitioned { }) 2020-05-25 22:24:29 0 [Note] WSREP: save pc into disk 2020-05-25 22:24:29 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.1.15:4567 2020-05-25 22:24:29 0 [Note] WSREP: gcomm: connected 2020-05-25 22:24:29 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-05-25 22:24:29 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-05-25 22:24:29 0 [Note] WSREP: Opened channel 'n4tdb01_wsrep_cluster' 2020-05-25 22:24:29 1 [Note] WSREP: Starting rollbacker thread 1 2020-05-25 22:24:29 2 [Note] WSREP: Starting applier thread 2 2020-05-25 22:24:29 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-05-25 22:24:29 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 803e9f15-9ed6-11ea-8996-137424fe9dfd 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd from 0 (mdb2) 2020-05-25 22:24:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: 803e9f15-9ed6-11ea-8996-137424fe9dfd from 1 (mdb1) 2020-05-25 22:24:30 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 3, members = 1/2 (joined/total), act_id = 65, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 2020-05-25 22:24:30 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-05-25 22:24:30 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 65) 2020-05-25 22:24:30 2 [Note] WSREP: ####### processing CC 65, local, unordered 2020-05-25 22:24:30 2 [Note] WSREP: Process first view: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 my uuid: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Server mdb2 connected to cluster at position 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 with ID 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Server status change disconnected -> connected 2020-05-25 22:24:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:30 2 [Note] WSREP: ####### My UUID: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4 2020-05-25 22:24:30 2 [Note] WSREP: Cert index reset to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 (proto: 9), state transfer needed: yes 2020-05-25 22:24:30 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:30 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65, protocol version: 4 2020-05-25 22:24:30 2 [Note] WSREP: State transfer required: Group state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 Local state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:30 2 [Note] WSREP: Server status change connected -> joiner 2020-05-25 22:24:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:30 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-05-25 22:24:30 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '10.0.1.14' --datadir '/var/lib/mysql/' --parent '25596' --mysqld-args --wsrep_start_position=86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63' WSREP_SST: [INFO] Moving /var/lib/mysql//mariabackup.prepare.log to /tmp/sst_log_archive/mariabackup.prepare.log.2020.05.25-22.24.30.389224199 (20200525 22:24:30.392) WSREP_SST: [INFO] Moving /var/lib/mysql//mariabackup.move.log to /tmp/sst_log_archive/mariabackup.move.log.2020.05.25-22.24.30.389224199 (20200525 22:24:30.399) WSREP_SST: [INFO] Streaming with xbstream (20200525 22:24:30.409) WSREP_SST: [INFO] Using socat as streamer (20200525 22:24:30.412) WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | pigz -dc -p 8 | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20200525 22:24:30.482) 2020-05-25 22:24:30 2 [Note] WSREP: Prepared SST request: mariabackup|10.0.1.14:4444/xtrabackup_sst//1 2020-05-25 22:24:30 2 [Note] WSREP: ####### IST uuid:86a3014e-9e9d-11ea-8f7d-829b023fcaf0 f: 64, l: 65, STRv: 2 2020-05-25 22:24:30 2 [Note] WSREP: IST receiver addr using tcp://10.0.1.14:4568 2020-05-25 22:24:30 2 [Note] WSREP: Prepared IST receiver for 64-65, listening at: tcp://10.0.1.14:4568 2020-05-25 22:24:30 0 [Note] WSREP: Member 0.0 (mdb2) requested state transfer from '*any*'. Selected 1.0 (mdb1)(SYNCED) as donor. 2020-05-25 22:24:30 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 65) 2020-05-25 22:24:30 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2020-05-25 22:24:31 0 [Note] WSREP: 1.0 (mdb1): State transfer to 0.0 (mdb2) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Member 1.0 (mdb1) synced with group. WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20200525 22:24:31.208) WSREP_SST: [INFO] Galera co-ords from recovery: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 0 (20200525 22:24:31.212) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20200525 22:24:31.218) WSREP_SST: [INFO] Removing the sst_in_progress file (20200525 22:24:31.222) 2020-05-25 22:24:31 3 [Note] WSREP: SST received 2020-05-25 22:24:31 3 [Note] WSREP: Server status change joiner -> initializing 2020-05-25 22:24:31 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 0 [Note] InnoDB: Using Linux native AIO 2020-05-25 22:24:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-25 22:24:31 0 [Note] InnoDB: Uses event mutexes 2020-05-25 22:24:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-05-25 22:24:31 0 [Note] InnoDB: Number of pools: 1 2020-05-25 22:24:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-05-25 22:24:31 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-05-25 22:24:31 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-25 22:24:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-25 22:24:31 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2020-05-25 22:24:31 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2020-05-25 22:24:31 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-05-25 22:24:31 0 [Note] InnoDB: New log files created, LSN=1882151 2020-05-25 22:24:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-05-25 22:24:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-25 22:24:31 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-25 22:24:31 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-25 22:24:31 0 [Note] InnoDB: Waiting for purge to start 2020-05-25 22:24:31 0 [Note] InnoDB: 10.4.13 started; log sequence number 1882636; transaction id 231 2020-05-25 22:24:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-05-25 22:24:31 0 [Note] InnoDB: Buffer pool(s) load completed at 200525 22:24:31 2020-05-25 22:24:31 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-05-25 22:24:31 0 [Note] Server socket created on IP: '::'. 2020-05-25 22:24:31 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-05-25 22:24:31 0 [Note] WSREP: Server initialized 2020-05-25 22:24:31 0 [Note] WSREP: Server status change initializing -> initialized 2020-05-25 22:24:31 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 3 [Note] WSREP: Server status change initialized -> joined 2020-05-25 22:24:31 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 3 [Note] WSREP: Recovered position from storage: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 3 [Note] WSREP: Recovered view from SST: id: 00000000-0000-0000-0000-000000000000:-1 status: primary protocol_version: 0 capabilities: final: yes own_index: -1 members(0): 2020-05-25 22:24:31 3 [Warning] WSREP: View recovered from stable storage was empty. If the server is doing rolling upgrade from previous version which does not support storing view info into stable storage, this is ok. Otherwise this may be a sign of malfunction. 2020-05-25 22:24:31 10 [Note] WSREP: Cluster table is empty, not recovering transactions 2020-05-25 22:24:31 3 [Note] WSREP: SST received: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 0 [Note] WSREP: Joiner monitor thread ended with total time 1 sec 2020-05-25 22:24:31 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:24:31 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65, protocol version: -1 2020-05-25 22:24:31 2 [Note] WSREP: Installed new state from SST: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:63 2020-05-25 22:24:31 11 [Note] WSREP: Starting applier thread 11 2020-05-25 22:24:31 12 [Note] WSREP: Starting applier thread 12 2020-05-25 22:24:31 13 [Note] WSREP: Starting applier thread 13 2020-05-25 22:24:31 14 [Note] WSREP: Starting applier thread 14 2020-05-25 22:24:31 15 [Note] WSREP: Starting applier thread 15 2020-05-25 22:24:31 2 [Note] WSREP: Receiving IST: 2 writesets, seqnos 64-65 2020-05-25 22:24:31 0 [Note] WSREP: ####### IST applying starts with 64 2020-05-25 22:24:31 0 [Note] WSREP: ####### IST current seqno initialized to 64 2020-05-25 22:24:31 0 [Note] WSREP: Receiving IST... 0.0% (0/2 events) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Receiving IST...100.0% (2/2 events) complete. 2020-05-25 22:24:31 16 [Note] WSREP: Starting applier thread 16 2020-05-25 22:24:31 17 [Note] WSREP: Starting applier thread 17 2020-05-25 22:24:31 18 [Note] WSREP: Starting applier thread 18 2020-05-25 22:24:31 19 [Note] WSREP: Starting applier thread 19 2020-05-25 22:24:31 20 [Note] WSREP: Starting applier thread 20 2020-05-25 22:24:31 21 [Note] WSREP: Starting applier thread 21 2020-05-25 22:24:31 22 [Note] WSREP: Starting applier thread 22 2020-05-25 22:24:31 24 [Note] WSREP: Starting applier thread 24 2020-05-25 22:24:31 25 [Note] WSREP: Starting applier thread 25 2020-05-25 22:24:31 26 [Note] WSREP: Starting applier thread 26 2020-05-25 22:24:31 27 [Note] WSREP: Starting applier thread 27 2020-05-25 22:24:31 28 [Note] WSREP: Starting applier thread 28 2020-05-25 22:24:31 29 [Note] WSREP: Starting applier thread 29 2020-05-25 22:24:31 30 [Note] WSREP: Starting applier thread 30 2020-05-25 22:24:31 31 [Note] WSREP: Starting applier thread 31 2020-05-25 22:24:31 32 [Note] WSREP: Starting applier thread 32 2020-05-25 22:24:31 33 [Note] WSREP: Starting applier thread 33 2020-05-25 22:24:31 34 [Note] WSREP: Starting applier thread 34 2020-05-25 22:24:31 35 [Note] WSREP: Starting applier thread 35 2020-05-25 22:24:31 36 [Note] WSREP: Starting applier thread 36 2020-05-25 22:24:31 37 [Note] WSREP: Starting applier thread 37 2020-05-25 22:24:31 38 [Note] WSREP: Starting applier thread 38 2020-05-25 22:24:31 39 [Note] WSREP: Starting applier thread 39 2020-05-25 22:24:31 40 [Note] WSREP: Starting applier thread 40 2020-05-25 22:24:31 41 [Note] WSREP: Starting applier thread 41 2020-05-25 22:24:31 42 [Note] WSREP: Starting applier thread 42 2020-05-25 22:24:31 2 [Note] WSREP: Draining apply monitors after IST upto 65 2020-05-25 22:24:31 2 [Note] WSREP: IST received: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:65 2020-05-25 22:24:31 2 [Note] WSREP: Lowest cert indnex boundary for CC from sst: 65 2020-05-25 22:24:31 2 [Note] WSREP: Min available from gcache for CC from sst: 64 2020-05-25 22:24:31 0 [Note] Reading of all Master_info entries succeeded 2020-05-25 22:24:31 0 [Note] Added new Master_info '' to hash table 2020-05-25 22:24:31 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-05-25 22:24:31 0 [Note] WSREP: 0.0 (mdb2): State transfer from 1.0 (mdb1) complete. 2020-05-25 22:24:31 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 65) 2020-05-25 22:24:31 0 [Note] WSREP: Member 0.0 (mdb2) synced with group. 2020-05-25 22:24:31 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 65) 2020-05-25 22:24:31 2 [Note] WSREP: Server mdb2 synced with group 2020-05-25 22:24:31 2 [Note] WSREP: Server status change joined -> synced 2020-05-25 22:24:31 2 [Note] WSREP: Synchronized with group, ready for connections 2020-05-25 22:24:31 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:24:31 44 [Warning] IP address '10.0.1.11' could not be resolved: Name or service not known 2020-05-25 22:24:32 0 [Note] WSREP: (7ff14eaf-b98f, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-05-25 22:25:17 19 [Warning] WSREP: trx protocol version: 4 does not match certification protocol version: -1 2020-05-25 22:25:31 45 [Warning] Aborted connection 45 to db: 'pippo' user: 'root' host: 'localhost' (This connection closed normally) 2020-05-25 22:25:36 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2020-05-25 22:25:36 0 [Note] WSREP: Shutdown replication 2020-05-25 22:25:36 0 [Note] WSREP: Server status change synced -> disconnecting 2020-05-25 22:25:36 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:36 0 [Note] WSREP: Closing send monitor... 2020-05-25 22:25:36 0 [Note] WSREP: Closed send monitor. 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: terminating thread 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: joining thread 2020-05-25 22:25:36 0 [Note] WSREP: gcomm: closing backend 2020-05-25 22:25:37 0 [Note] WSREP: view(view_id(NON_PRIM,7ff14eaf-b98f,4) memb { 7ff14eaf-b98f,0 } joined { } left { } partitioned { 8a8ca0b3-bb24,0 }) 2020-05-25 22:25:37 0 [Note] WSREP: view((empty)) 2020-05-25 22:25:37 0 [Note] WSREP: gcomm: closed 2020-05-25 22:25:37 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-05-25 22:25:37 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-05-25 22:25:37 0 [Note] WSREP: Received NON-PRIMARY. 2020-05-25 22:25:37 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 66) 2020-05-25 22:25:37 0 [Note] WSREP: New SELF-LEAVE. 2020-05-25 22:25:37 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-05-25 22:25:37 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-05-25 22:25:37 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-05-25 22:25:37 0 [Note] WSREP: RECV thread exiting 0: Success 2020-05-25 22:25:37 18 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:-1 status: non-primary protocol_version: 3 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: 7ff14eaf-9ed6-11ea-b98f-8fc2b85537f4, mdb2 ================================================= 2020-05-25 22:25:37 18 [Note] WSREP: Non-primary view 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 0 [Note] WSREP: recv_thread() joined. 2020-05-25 22:25:37 0 [Note] WSREP: Closing replication queue. 2020-05-25 22:25:37 0 [Note] WSREP: Closing slave action queue. 2020-05-25 22:25:37 18 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:-1 status: non-primary protocol_version: 3 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0): ================================================= 2020-05-25 22:25:37 18 [Note] WSREP: Non-primary view 2020-05-25 22:25:37 18 [Note] WSREP: Server status change disconnecting -> disconnected 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:37 18 [Note] WSREP: Applier thread exiting ret: 0 thd: 18 2020-05-25 22:25:37 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 0 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (KILLED) 2020-05-25 22:25:37 0 [Note] WSREP: killing local connection: 44 2020-05-25 22:25:37 0 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (This connection closed normally) 2020-05-25 22:25:37 44 [Warning] Aborted connection 44 to db: 'unconnected' user: 'maxscale' host: '10.0.1.11' (This connection closed normally) 2020-05-25 22:25:37 21 [Note] WSREP: Applier thread exiting ret: 6 thd: 21 2020-05-25 22:25:37 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 20 [Note] WSREP: Applier thread exiting ret: 6 thd: 20 2020-05-25 22:25:37 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 12 [Note] WSREP: Applier thread exiting ret: 6 thd: 12 2020-05-25 22:25:37 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 2 [Note] WSREP: Applier thread exiting ret: 6 thd: 2 2020-05-25 22:25:37 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 32 [Note] WSREP: Applier thread exiting ret: 6 thd: 32 2020-05-25 22:25:37 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 13 [Note] WSREP: Applier thread exiting ret: 6 thd: 13 2020-05-25 22:25:37 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 14 [Note] WSREP: Applier thread exiting ret: 6 thd: 14 2020-05-25 22:25:37 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 41 [Note] WSREP: Applier thread exiting ret: 6 thd: 41 2020-05-25 22:25:37 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 22 [Note] WSREP: Applier thread exiting ret: 6 thd: 22 2020-05-25 22:25:37 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 25 [Note] WSREP: Applier thread exiting ret: 6 thd: 25 2020-05-25 22:25:37 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 27 [Note] WSREP: Applier thread exiting ret: 6 thd: 27 2020-05-25 22:25:37 27 [Warning] Aborted connection 27 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 30 [Note] WSREP: Applier thread exiting ret: 6 thd: 30 2020-05-25 22:25:37 30 [Warning] Aborted connection 30 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 31 [Note] WSREP: Applier thread exiting ret: 6 thd: 31 2020-05-25 22:25:37 31 [Warning] Aborted connection 31 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 29 [Note] WSREP: Applier thread exiting ret: 6 thd: 29 2020-05-25 22:25:37 29 [Warning] Aborted connection 29 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 28 [Note] WSREP: Applier thread exiting ret: 6 thd: 28 2020-05-25 22:25:37 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 34 [Note] WSREP: Applier thread exiting ret: 6 thd: 34 2020-05-25 22:25:37 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 33 [Note] WSREP: Applier thread exiting ret: 6 thd: 33 2020-05-25 22:25:37 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 26 [Note] WSREP: Applier thread exiting ret: 6 thd: 26 2020-05-25 22:25:37 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 35 [Note] WSREP: Applier thread exiting ret: 6 thd: 35 2020-05-25 22:25:37 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 24 [Note] WSREP: Applier thread exiting ret: 6 thd: 24 2020-05-25 22:25:37 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 11 [Note] WSREP: Applier thread exiting ret: 6 thd: 11 2020-05-25 22:25:37 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 15 [Note] WSREP: Applier thread exiting ret: 6 thd: 15 2020-05-25 22:25:37 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 42 [Note] WSREP: Applier thread exiting ret: 6 thd: 42 2020-05-25 22:25:37 42 [Warning] Aborted connection 42 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 39 [Note] WSREP: Applier thread exiting ret: 6 thd: 39 2020-05-25 22:25:37 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 40 [Note] WSREP: Applier thread exiting ret: 6 thd: 40 2020-05-25 22:25:37 40 [Warning] Aborted connection 40 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 37 [Note] WSREP: Applier thread exiting ret: 6 thd: 37 2020-05-25 22:25:37 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 38 [Note] WSREP: Applier thread exiting ret: 6 thd: 38 2020-05-25 22:25:37 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 36 [Note] WSREP: Applier thread exiting ret: 6 thd: 36 2020-05-25 22:25:37 36 [Warning] Aborted connection 36 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17 2020-05-25 22:25:37 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 16 [Note] WSREP: Applier thread exiting ret: 6 thd: 16 2020-05-25 22:25:37 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:37 19 [Note] WSREP: Applier thread exiting ret: 6 thd: 19 2020-05-25 22:25:37 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:38 1 [Note] WSREP: rollbacker thread exiting 1 2020-05-25 22:25:38 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-05-25 22:25:38 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-05-25 22:25:38 0 [Note] InnoDB: FTS optimize thread exiting. 2020-05-25 22:25:38 0 [Note] WSREP: dtor state: CLOSED 2020-05-25 22:25:38 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.333333, misses: 2, in use: 1, in pool: 1 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 3 oooe fraction 0.333333 oool fraction 0 2020-05-25 22:25:38 0 [Note] WSREP: mon: entered 6 oooe fraction 0 oool fraction 0.166667 2020-05-25 22:25:38 0 [Note] WSREP: cert index usage at exit 0 2020-05-25 22:25:38 0 [Note] WSREP: cert trx map usage at exit 1 2020-05-25 22:25:38 0 [Note] WSREP: deps set usage at exit 0 2020-05-25 22:25:38 0 [Note] WSREP: avg deps dist 0 2020-05-25 22:25:38 0 [Note] WSREP: avg cert interval 0 2020-05-25 22:25:38 0 [Note] WSREP: cert index size 0 2020-05-25 22:25:38 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:38 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2020-05-25 22:25:38 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-05-25 22:25:38 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: -1) 2020-05-25 22:25:38 0 [Note] WSREP: Flushing memory map to disk... 2020-05-25 22:25:38 0 [Note] InnoDB: Starting shutdown... 2020-05-25 22:25:38 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-05-25 22:25:38 0 [Note] InnoDB: Buffer pool(s) dump completed at 200525 22:25:38 2020-05-25 22:25:40 0 [Note] InnoDB: Shutdown completed; log sequence number 1895195; transaction id 265 2020-05-25 22:25:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-05-25 22:25:40 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-05-25 22:25:42 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-05-25 22:25:42 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-05-25 22:25:42 0 [Note] WSREP: Found saved state: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, safe_to_bootstrap: 0 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 Seqno: 64 - 66 Offset: 1280 Synced: 1 2020-05-25 22:25:42 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0, offset: 1280 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 64-66 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/1048 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (1048/1048 bytes) complete. 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/3 locked buffers 2020-05-25 22:25:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 1048/1073741824 2020-05-25 22:25:42 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.0.1.14; base_port = 4567; 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 = /var/lib/mysql/; 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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fa... 2020-05-25 22:25:42 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:42 0 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, protocol version: -1 2020-05-25 22:25:42 0 [Note] WSREP: Start replication 2020-05-25 22:25:42 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-05-25 22:25:42 0 [Note] WSREP: Setting GCS initial position to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 2020-05-25 22:25:42 0 [Note] WSREP: protonet asio version 0 2020-05-25 22:25:42 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-05-25 22:25:42 0 [Note] WSREP: backend: asio 2020-05-25 22:25:42 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-05-25 22:25:42 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-05-25 22:25:42 0 [Note] WSREP: restore pc from disk failed 2020-05-25 22:25:42 0 [Note] WSREP: GMCast version 0 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-05-25 22:25:42 0 [Note] WSREP: EVS version 1 2020-05-25 22:25:42 0 [Note] WSREP: gcomm: connecting to group 'n4tdb01_wsrep_cluster', peer '10.0.1.13:,10.0.1.14:,10.0.1.15:' 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.0.1.14:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') connection established to 8a8ca0b3-bb24 tcp://10.0.1.13:4567 2020-05-25 22:25:42 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-05-25 22:25:43 0 [Note] WSREP: declaring 8a8ca0b3-bb24 at tcp://10.0.1.13:4567 stable 2020-05-25 22:25:43 0 [Note] WSREP: Node 8a8ca0b3-bb24 state prim 2020-05-25 22:25:43 0 [Note] WSREP: view(view_id(PRIM,8a8ca0b3-bb24,6) memb { 8a8ca0b3-bb24,0 ab80ace4-8cdf,0 } joined { } left { } partitioned { }) 2020-05-25 22:25:43 0 [Note] WSREP: save pc into disk 2020-05-25 22:25:43 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.1.15:4567 2020-05-25 22:25:43 0 [Note] WSREP: gcomm: connected 2020-05-25 22:25:43 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-05-25 22:25:43 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-05-25 22:25:43 0 [Note] WSREP: Opened channel 'n4tdb01_wsrep_cluster' 2020-05-25 22:25:43 1 [Note] WSREP: Starting rollbacker thread 1 2020-05-25 22:25:43 2 [Note] WSREP: Starting applier thread 2 2020-05-25 22:25:43 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: sent state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 from 0 (mdb1) 2020-05-25 22:25:43 0 [Note] WSREP: STATE EXCHANGE: got state msg: ac1b02e4-9ed6-11ea-8701-a3609fef04b5 from 1 (mdb2) 2020-05-25 22:25:43 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 5, members = 2/2 (joined/total), act_id = 66, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 2020-05-25 22:25:43 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-05-25 22:25:43 0 [Note] WSREP: Restored state OPEN -> JOINED (66) 2020-05-25 22:25:43 2 [Note] WSREP: ####### processing CC 66, local, unordered 2020-05-25 22:25:43 2 [Note] WSREP: Process first view: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0 my uuid: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Server mdb2 connected to cluster at position 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 with ID ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Server status change disconnected -> connected 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: ####### My UUID: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6 2020-05-25 22:25:43 2 [Note] WSREP: Cert index reset to 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 (proto: 9), state transfer needed: no 2020-05-25 22:25:43 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:43 2 [Note] WSREP: ####### Assign initial position for certification: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66, protocol version: 4 2020-05-25 22:25:43 2 [Note] WSREP: REPL Protocols: 9 (4) 2020-05-25 22:25:43 2 [Note] WSREP: ####### Adjusting cert position: 66 -> 66 2020-05-25 22:25:43 0 [Note] WSREP: Service thread queue flushed. 2020-05-25 22:25:43 0 [Note] WSREP: Member 1.0 (mdb2) synced with group. 2020-05-25 22:25:43 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 66) 2020-05-25 22:25:43 2 [Note] WSREP: ================================================ View: id: 86a3014e-9e9d-11ea-8f7d-829b023fcaf0:66 status: primary protocol_version: 3 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: 8a8ca0b3-9ed3-11ea-bb24-feceed4887ed, mdb1 1: ab80ace4-9ed6-11ea-8cdf-eab063bfbbb6, mdb2 ================================================= 2020-05-25 22:25:43 2 [Note] WSREP: Server status change connected -> joiner 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: Server status change joiner -> initializing 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 0 [Note] InnoDB: Using Linux native AIO 2020-05-25 22:25:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-05-25 22:25:43 0 [Note] InnoDB: Uses event mutexes 2020-05-25 22:25:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-05-25 22:25:43 0 [Note] InnoDB: Number of pools: 1 2020-05-25 22:25:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-05-25 22:25:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-05-25 22:25:43 0 [Note] InnoDB: Completed initialization of buffer pool 2020-05-25 22:25:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-25 22:25:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-05-25 22:25:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-05-25 22:25:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-25 22:25:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-05-25 22:25:43 0 [Note] InnoDB: Waiting for purge to start 2020-05-25 22:25:43 0 [Note] InnoDB: 10.4.13 started; log sequence number 1895204; transaction id 262 2020-05-25 22:25:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-05-25 22:25:43 0 [Note] InnoDB: Buffer pool(s) load completed at 200525 22:25:43 2020-05-25 22:25:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-05-25 22:25:43 0 [Note] Server socket created on IP: '::'. 2020-05-25 22:25:43 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-05-25 22:25:43 0 [Note] WSREP: Server initialized 2020-05-25 22:25:43 0 [Note] WSREP: Server status change initializing -> initialized 2020-05-25 22:25:43 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 9 [Note] WSREP: Cluster table is empty, not recovering transactions 2020-05-25 22:25:43 2 [Note] WSREP: Server status change initialized -> joined 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 10 [Note] WSREP: Starting applier thread 10 2020-05-25 22:25:43 11 [Note] WSREP: Starting applier thread 11 2020-05-25 22:25:43 0 [Note] Reading of all Master_info entries succeeded 2020-05-25 22:25:43 0 [Note] Added new Master_info '' to hash table 2020-05-25 22:25:43 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-05-25 22:25:43 14 [Note] WSREP: Starting applier thread 14 2020-05-25 22:25:43 2 [Note] WSREP: Lowest cert indnex boundary for CC from group: 66 2020-05-25 22:25:43 2 [Note] WSREP: Min available from gcache for CC from group: 64 2020-05-25 22:25:43 2 [Note] WSREP: Server mdb2 synced with group 2020-05-25 22:25:43 2 [Note] WSREP: Server status change joined -> synced 2020-05-25 22:25:43 2 [Note] WSREP: Synchronized with group, ready for connections 2020-05-25 22:25:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-05-25 22:25:43 15 [Note] WSREP: Starting applier thread 15 2020-05-25 22:25:43 16 [Note] WSREP: Starting applier thread 16 2020-05-25 22:25:43 17 [Note] WSREP: Starting applier thread 17 2020-05-25 22:25:43 18 [Note] WSREP: Starting applier thread 18 2020-05-25 22:25:43 19 [Note] WSREP: Starting applier thread 19 2020-05-25 22:25:43 20 [Note] WSREP: Starting applier thread 20 2020-05-25 22:25:43 21 [Note] WSREP: Starting applier thread 21 2020-05-25 22:25:43 22 [Note] WSREP: Starting applier thread 22 2020-05-25 22:25:43 23 [Note] WSREP: Starting applier thread 23 2020-05-25 22:25:43 24 [Note] WSREP: Starting applier thread 24 2020-05-25 22:25:43 25 [Note] WSREP: Starting applier thread 25 2020-05-25 22:25:43 26 [Note] WSREP: Starting applier thread 26 2020-05-25 22:25:43 27 [Note] WSREP: Starting applier thread 27 2020-05-25 22:25:43 28 [Note] WSREP: Starting applier thread 28 2020-05-25 22:25:43 29 [Note] WSREP: Starting applier thread 29 2020-05-25 22:25:43 30 [Note] WSREP: Starting applier thread 30 2020-05-25 22:25:43 31 [Note] WSREP: Starting applier thread 31 2020-05-25 22:25:43 32 [Note] WSREP: Starting applier thread 32 2020-05-25 22:25:43 33 [Note] WSREP: Starting applier thread 33 2020-05-25 22:25:43 34 [Note] WSREP: Starting applier thread 34 2020-05-25 22:25:43 35 [Note] WSREP: Starting applier thread 35 2020-05-25 22:25:43 36 [Note] WSREP: Starting applier thread 36 2020-05-25 22:25:43 37 [Note] WSREP: Starting applier thread 37 2020-05-25 22:25:43 38 [Note] WSREP: Starting applier thread 38 2020-05-25 22:25:43 39 [Note] WSREP: Starting applier thread 39 2020-05-25 22:25:43 40 [Note] WSREP: Starting applier thread 40 2020-05-25 22:25:43 41 [Note] WSREP: Starting applier thread 41 2020-05-25 22:25:43 42 [Note] WSREP: Starting applier thread 42 2020-05-25 22:25:44 43 [Warning] IP address '10.0.1.11' could not be resolved: Name or service not known 2020-05-25 22:25:45 0 [Note] WSREP: (ab80ace4-8cdf, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-05-26 0:26:31 44 [Warning] Aborted connection 44 to db: 'pippo' user: 'root' host: 'localhost' (This connection closed normally)