CURRENT_TEST: galera_3nodes.galera_certification_ccc 2020-06-12 17:12:26 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-06-12 17:12:26 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on 2020-06-12 17:12:26 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld (mysqld 10.3.23-MariaDB-log) starting as process 6651 ... 2020-06-12 17:12:26 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186) 2020-06-12 17:12:26 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2020-06-12 17:12:26 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16011' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members. 2020-06-12 17:12:26 0 [Note] WSREP: Read nil XID from storage engines, skipping position init 2020-06-12 17:12:26 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm_3.so' 2020-06-12 17:12:26 0 [Note] WSREP: wsrep_load(): Galera 25.3.29(rb0f34b0) by Codership Oy loaded successfully. 2020-06-12 17:12:26 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-06-12 17:12:26 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//grastate.dat' 2020-06-12 17:12:26 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2020-06-12 17:12:26 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; 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 = PT30S; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT10S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs... 2020-06-12 17:12:26 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1 2020-06-12 17:12:26 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2020-06-12 17:12:26 0 [Note] WSREP: wsrep_sst_grab() 2020-06-12 17:12:26 0 [Note] WSREP: Start replication 2020-06-12 17:12:26 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2020-06-12 17:12:26 0 [Note] WSREP: protonet asio version 0 2020-06-12 17:12:26 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-06-12 17:12:26 0 [Note] WSREP: backend: asio 2020-06-12 17:12:26 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-06-12 17:12:26 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//gvwstate.dat) failed(No such file or directory) 2020-06-12 17:12:26 0 [Note] WSREP: restore pc from disk failed 2020-06-12 17:12:26 0 [Note] WSREP: GMCast version 0 2020-06-12 17:12:26 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2020-06-12 17:12:26 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2020-06-12 17:12:26 0 [Note] WSREP: EVS version 0 2020-06-12 17:12:26 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16003' 2020-06-12 17:12:26 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') connection established to be3593ae tcp://127.0.0.1:16003 2020-06-12 17:12:26 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2020-06-12 17:12:26 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') connection established to be526f4c tcp://127.0.0.1:16006 2020-06-12 17:12:26 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:12:26 0 [Note] WSREP: Node be3593ae state prim 2020-06-12 17:12:26 0 [Note] WSREP: view(view_id(PRIM,be3593ae,2) memb { be3593ae,0 be364b75,0 } joined { } left { } partitioned { }) 2020-06-12 17:12:26 0 [Note] WSREP: save pc into disk 2020-06-12 17:12:26 0 [Note] WSREP: forgetting be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:12:27 0 [Note] WSREP: gcomm: connected 2020-06-12 17:12:27 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-06-12 17:12:27 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-06-12 17:12:27 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2020-06-12 17:12:27 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2020-06-12 17:12:27 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-06-12 17:12:27 0 [Warning] WSREP: SYNC message from member 0 in non-primary configuration. Ignored. 2020-06-12 17:12:27 0 [Note] WSREP: Waiting for SST to complete. 2020-06-12 17:12:27 0 [Note] WSREP: STATE EXCHANGE: sent state msg: be843165-acb6-11ea-b8d7-57f891bf7bc5 2020-06-12 17:12:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: be843165-acb6-11ea-b8d7-57f891bf7bc5 from 0 (cnt7glr11.localdomain) 2020-06-12 17:12:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: be843165-acb6-11ea-b8d7-57f891bf7bc5 from 1 (cnt7glr11.localdomain) 2020-06-12 17:12:27 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:12:27 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 17:12:27 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0) 2020-06-12 17:12:27 1 [Note] WSREP: State transfer required: Group state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0 Local state: 00000000-0000-0000-0000-000000000000:-1 2020-06-12 17:12:27 1 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3 2020-06-12 17:12:27 1 [Warning] WSREP: Gap in state sequence. Need state transfer. 2020-06-12 17:12:27 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16011' --datadir '/home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/' --defaults-file '/home/stepan/mariadb/10.3.23/mysql-test/var/my.cnf' --defaults-group-suffix '.3' --parent '6651' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.3 --defaults-file=/home/stepan/mariadb/10.3.23/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300' 2020-06-12 17:12:27 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2020-06-12 17:12:27 1 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:16011/rsync_sst 2020-06-12 17:12:27 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:12:27 1 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:12:27 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:12:27 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:12:27 1 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (be36cf8b-acb6-11ea-aa2c-e3149c2ff908): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():483. IST will be unavailable. 2020-06-12 17:12:27 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2020-06-12 17:12:27 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) 2020-06-12 17:12:27 1 [Note] WSREP: Requesting state transfer: success, donor: 0 2020-06-12 17:12:27 1 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0 2020-06-12 17:12:28 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') connection established to be526f4c tcp://127.0.0.1:16006 2020-06-12 17:12:28 0 [Warning] WSREP: discarding established (time wait) be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:12:29 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 1.0 (cnt7glr11.localdomain) complete. 2020-06-12 17:12:29 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2020-06-12 17:12:29 0 [Note] WSREP: cleaning up be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:12:29 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') connection established to be526f4c tcp://127.0.0.1:16006 WSREP_SST: [INFO] Joiner cleanup. rsync PID: 6827 (20200612 17:12:29.540) WSREP_SST: [INFO] Joiner cleanup done. (20200612 17:12:30.047) 2020-06-12 17:12:30 0 [Note] WSREP: SST complete, seqno: 0 2020-06-12 17:12:30 0 [Note] Plugin 'partition' is disabled. 2020-06-12 17:12:30 0 [Note] InnoDB: Using Linux native AIO 2020-06-12 17:12:30 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-06-12 17:12:30 0 [Note] InnoDB: Uses event mutexes 2020-06-12 17:12:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-06-12 17:12:30 0 [Note] InnoDB: Number of pools: 1 2020-06-12 17:12:30 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-06-12 17:12:30 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2020-06-12 17:12:30 0 [Note] InnoDB: Completed initialization of buffer pool 2020-06-12 17:12:30 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-06-12 17:12:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1635929 2020-06-12 17:12:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-06-12 17:12:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-06-12 17:12:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-06-12 17:12:30 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-06-12 17:12:30 0 [Note] InnoDB: 10.3.23 started; log sequence number 1636994; transaction id 34 2020-06-12 17:12:30 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/ib_buffer_pool 2020-06-12 17:12:30 0 [Note] Plugin 'SEQUENCE' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_CMP' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2020-06-12 17:12:30 0 [Note] InnoDB: Buffer pool(s) load completed at 200612 17:12:30 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'user_variables' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2020-06-12 17:12:30 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2020-06-12 17:12:30 0 [Warning] /home/stepan/mariadb/10.3.23/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2020-06-12 17:12:30 0 [Warning] /home/stepan/mariadb/10.3.23/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2020-06-12 17:12:30 0 [Warning] /home/stepan/mariadb/10.3.23/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2020-06-12 17:12:30 0 [Warning] /home/stepan/mariadb/10.3.23/sql/mysqld: unknown option '--loose-pam-debug' 2020-06-12 17:12:30 0 [Warning] /home/stepan/mariadb/10.3.23/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2020-06-12 17:12:30 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-06-12 17:12:30 0 [Note] WSREP: Signalling provider to continue. 2020-06-12 17:12:30 0 [Note] WSREP: SST received: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0 2020-06-12 17:12:30 0 [Note] Reading of all Master_info entries succeeded 2020-06-12 17:12:30 0 [Note] Added new Master_info '' to hash table 2020-06-12 17:12:30 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld: ready for connections. Version: '10.3.23-MariaDB-log' socket: '/home/stepan/mariadb/10.3.23/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2020-06-12 17:12:30 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:12:30 0 [Note] WSREP: declaring be526f4c at tcp://127.0.0.1:16006 stable 2020-06-12 17:12:30 0 [Note] WSREP: Node be3593ae state prim 2020-06-12 17:12:30 0 [Note] WSREP: view(view_id(PRIM,be3593ae,3) memb { be3593ae,0 be364b75,0 be526f4c,0 } joined { } left { } partitioned { }) 2020-06-12 17:12:30 0 [Note] WSREP: save pc into disk 2020-06-12 17:12:30 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2020-06-12 17:12:30 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-06-12 17:12:30 0 [Note] WSREP: STATE EXCHANGE: sent state msg: c0e637f3-acb6-11ea-82bb-c3c4e39302f5 2020-06-12 17:12:30 0 [Warning] WSREP: JOIN message from member -1580281144379703295 in non-primary configuration. Ignored. 2020-06-12 17:12:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: c0e637f3-acb6-11ea-82bb-c3c4e39302f5 from 0 (cnt7glr11.localdomain) 2020-06-12 17:12:30 0 [Note] WSREP: STATE EXCHANGE: got state msg: c0e637f3-acb6-11ea-82bb-c3c4e39302f5 from 1 (cnt7glr11.localdomain) 2020-06-12 17:12:31 0 [Note] WSREP: STATE EXCHANGE: got state msg: c0e637f3-acb6-11ea-82bb-c3c4e39302f5 from 2 (cnt7glr11.localdomain) 2020-06-12 17:12:31 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 2, members = 1/3 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:12:31 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:12:31 1 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 3: Primary, number of nodes: 3, my index: 1, protocol version 3 2020-06-12 17:12:31 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:12:31 1 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:12:31 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:12:31 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:12:31 0 [Note] WSREP: 1.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2020-06-12 17:12:31 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0) 2020-06-12 17:12:31 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) synced with group. 2020-06-12 17:12:31 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2020-06-12 17:12:31 1 [Note] WSREP: Synchronized with group, ready for connections 2020-06-12 17:12:31 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:12:31 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2020-06-12 17:12:32 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 2.0 (cnt7glr11.localdomain) complete. 2020-06-12 17:12:32 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2020-06-12 17:12:32 0 [Note] WSREP: (be364b75, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 17:12:33 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2020-06-12 17:12:33 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2020-06-12 17:36:46 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2020-06-12 17:36:46 0 [Note] WSREP: Stop replication 2020-06-12 17:36:46 0 [Note] WSREP: Closing send monitor... 2020-06-12 17:36:46 0 [Note] WSREP: Closed send monitor. 2020-06-12 17:36:46 0 [Note] WSREP: gcomm: terminating thread 2020-06-12 17:36:46 0 [Note] WSREP: gcomm: joining thread 2020-06-12 17:36:46 0 [Note] WSREP: gcomm: closing backend 2020-06-12 17:36:46 0 [Note] WSREP: view(view_id(NON_PRIM,be3593ae,3) memb { be364b75,0 } joined { } left { } partitioned { be3593ae,0 be526f4c,0 }) 2020-06-12 17:36:46 0 [Note] WSREP: view((empty)) 2020-06-12 17:36:46 0 [Note] WSREP: gcomm: closed 2020-06-12 17:36:46 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-06-12 17:36:46 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-06-12 17:36:46 0 [Note] WSREP: Received NON-PRIMARY. 2020-06-12 17:36:46 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 0) 2020-06-12 17:36:46 0 [Note] WSREP: Received self-leave message. 2020-06-12 17:36:46 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-06-12 17:36:46 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-06-12 17:36:46 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 0) 2020-06-12 17:36:46 0 [Note] WSREP: RECV thread exiting 0: Success 2020-06-12 17:36:46 0 [Note] WSREP: recv_thread() joined. 2020-06-12 17:36:46 0 [Note] WSREP: Closing replication queue. 2020-06-12 17:36:46 0 [Note] WSREP: Closing slave action queue. 2020-06-12 17:36:46 1 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2020-06-12 17:36:46 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:36:46 1 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2020-06-12 17:36:46 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:36:46 1 [Note] WSREP: applier thread exiting (code:0) 2020-06-12 17:36:48 2 [Note] WSREP: rollbacker thread exiting 2020-06-12 17:36:48 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-06-12 17:36:48 0 [Note] InnoDB: FTS optimize thread exiting. 2020-06-12 17:36:48 0 [Note] WSREP: dtor state: CLOSED 2020-06-12 17:36:48 0 [Note] WSREP: apply mon: entered 0 2020-06-12 17:36:48 0 [Note] WSREP: apply mon: entered 0 2020-06-12 17:36:48 0 [Note] WSREP: mon: entered 6 oooe fraction 0 oool fraction 0.166667 2020-06-12 17:36:48 0 [Note] WSREP: cert index usage at exit 0 2020-06-12 17:36:48 0 [Note] WSREP: cert trx map usage at exit 0 2020-06-12 17:36:48 0 [Note] WSREP: deps set usage at exit 0 2020-06-12 17:36:48 0 [Note] WSREP: avg deps dist 0 2020-06-12 17:36:48 0 [Note] WSREP: avg cert interval 0 2020-06-12 17:36:48 0 [Note] WSREP: cert index size 0 2020-06-12 17:36:48 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:36:48 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2020-06-12 17:36:48 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-06-12 17:36:48 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-06-12 17:36:48 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 0) 2020-06-12 17:36:48 0 [Note] WSREP: Flushing memory map to disk... 2020-06-12 17:36:48 0 [Note] InnoDB: Starting shutdown... 2020-06-12 17:36:48 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/ib_buffer_pool 2020-06-12 17:36:48 0 [Note] InnoDB: Instance 0, restricted to 127 pages due to innodb_buf_pool_dump_pct=25 2020-06-12 17:36:48 0 [Note] InnoDB: Buffer pool(s) dump completed at 200612 17:36:48 2020-06-12 17:36:49 0 [Note] InnoDB: Shutdown completed; log sequence number 1637012; transaction id 34 2020-06-12 17:36:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-06-12 17:36:49 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld: Shutdown complete 2020-06-12 17:37:15 0 [Note] WSREP: Read nil XID from storage engines, skipping position init 2020-06-12 17:37:15 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm_3.so' 2020-06-12 17:37:15 0 [Note] WSREP: wsrep_load(): Galera 25.3.29(rb0f34b0) by Codership Oy loaded successfully. 2020-06-12 17:37:15 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-06-12 17:37:15 0 [Note] WSREP: Found saved state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, safe_to_bootstrap: 0 2020-06-12 17:37:15 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; 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 = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//galera.cache; gcache.page_size = 128M; gcache.recover = no; 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 = 92233720368... 2020-06-12 17:37:15 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1 2020-06-12 17:37:15 0 [Note] WSREP: wsrep_sst_grab() 2020-06-12 17:37:15 0 [Note] WSREP: Start replication 2020-06-12 17:37:15 0 [Note] WSREP: Setting initial position to be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0 2020-06-12 17:37:15 0 [Note] WSREP: protonet asio version 0 2020-06-12 17:37:15 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-06-12 17:37:15 0 [Note] WSREP: backend: asio 2020-06-12 17:37:15 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-06-12 17:37:15 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//gvwstate.dat) failed(No such file or directory) 2020-06-12 17:37:15 0 [Note] WSREP: restore pc from disk failed 2020-06-12 17:37:15 0 [Note] WSREP: GMCast version 0 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2020-06-12 17:37:15 0 [Note] WSREP: EVS version 0 2020-06-12 17:37:15 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16003,127.0.0.1:16006,127.0.0.1:16009' 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') Found matching local endpoint for a connection, blacklisting address tcp://127.0.0.1:16009 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') connection established to be3593ae tcp://127.0.0.1:16003 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2020-06-12 17:37:15 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') connection established to be526f4c tcp://127.0.0.1:16006 2020-06-12 17:37:15 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:37:15 0 [Note] WSREP: declaring be526f4c at tcp://127.0.0.1:16006 stable 2020-06-12 17:37:15 0 [Note] WSREP: Node be3593ae state prim 2020-06-12 17:37:15 0 [Note] WSREP: view(view_id(PRIM,35ac5674,5) memb { 35ac5674,0 be3593ae,0 be526f4c,0 } joined { } left { } partitioned { }) 2020-06-12 17:37:15 0 [Note] WSREP: save pc into disk 2020-06-12 17:37:15 0 [Note] WSREP: gcomm: connected 2020-06-12 17:37:15 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-06-12 17:37:15 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-06-12 17:37:15 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2020-06-12 17:37:15 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 17:37:15 0 [Note] WSREP: Waiting for SST to complete. 2020-06-12 17:37:15 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 35f8e3a3-acba-11ea-9ebd-867dd7f6f931 2020-06-12 17:37:15 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 35f8e3a3-acba-11ea-9ebd-867dd7f6f931 2020-06-12 17:37:15 0 [Note] WSREP: STATE EXCHANGE: got state msg: 35f8e3a3-acba-11ea-9ebd-867dd7f6f931 from 0 (mdb1) 2020-06-12 17:37:15 0 [Note] WSREP: STATE EXCHANGE: got state msg: 35f8e3a3-acba-11ea-9ebd-867dd7f6f931 from 1 (cnt7glr11.localdomain) 2020-06-12 17:37:15 0 [Note] WSREP: STATE EXCHANGE: got state msg: 35f8e3a3-acba-11ea-9ebd-867dd7f6f931 from 2 (cnt7glr11.localdomain) 2020-06-12 17:37:15 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 4, members = 3/3 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:37:15 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:37:15 0 [Note] WSREP: Restored state OPEN -> JOINED (0) 2020-06-12 17:37:15 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 5: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 17:37:15 0 [Note] WSREP: SST complete, seqno: 0 2020-06-12 17:37:15 0 [Note] WSREP: Member 0.0 (mdb1) synced with group. 2020-06-12 17:37:15 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2020-06-12 17:37:15 0 [Note] InnoDB: Using Linux native AIO 2020-06-12 17:37:15 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-06-12 17:37:15 0 [Note] InnoDB: Uses event mutexes 2020-06-12 17:37:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-06-12 17:37:15 0 [Note] InnoDB: Number of pools: 1 2020-06-12 17:37:15 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-06-12 17:37:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-06-12 17:37:15 0 [Note] InnoDB: Completed initialization of buffer pool 2020-06-12 17:37:15 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-06-12 17:37:15 0 [Note] InnoDB: Resizing redo log from 2*5242880 to 2*50331648 bytes; LSN=1637021 2020-06-12 17:37:15 0 [Note] InnoDB: Starting to delete and rewrite log files. 2020-06-12 17:37:15 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2020-06-12 17:37:15 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2020-06-12 17:37:15 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-06-12 17:37:15 0 [Note] InnoDB: New log files created, LSN=1637021 2020-06-12 17:37:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-06-12 17:37:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-06-12 17:37:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-06-12 17:37:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-06-12 17:37:15 0 [Note] InnoDB: 10.3.23 started; log sequence number 1637021; transaction id 34 2020-06-12 17:37:15 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/ib_buffer_pool 2020-06-12 17:37:15 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-06-12 17:37:15 0 [Note] InnoDB: Buffer pool(s) load completed at 200612 17:37:15 2020-06-12 17:37:15 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-06-12 17:37:15 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:37:15 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:37:15 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:37:15 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:37:15 2 [Note] WSREP: Synchronized with group, ready for connections 2020-06-12 17:37:15 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:37:15 0 [Note] Reading of all Master_info entries succeeded 2020-06-12 17:37:15 0 [Note] Added new Master_info '' to hash table 2020-06-12 17:37:15 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld: ready for connections. Version: '10.3.23-MariaDB-log' socket: '/home/stepan/mariadb/10.3.23/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2020-06-12 17:37:18 0 [Note] WSREP: (35ac5674, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 17:37:44 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'root' host: 'localhost' (CLOSE_CONNECTION) 2020-06-12 17:37:44 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2020-06-12 17:37:44 0 [Note] WSREP: Stop replication 2020-06-12 17:37:44 0 [Note] WSREP: Closing send monitor... 2020-06-12 17:37:44 0 [Note] WSREP: Closed send monitor. 2020-06-12 17:37:44 0 [Note] WSREP: gcomm: terminating thread 2020-06-12 17:37:44 0 [Note] WSREP: gcomm: joining thread 2020-06-12 17:37:44 0 [Note] WSREP: gcomm: closing backend 2020-06-12 17:37:44 0 [Note] WSREP: view(view_id(NON_PRIM,35ac5674,5) memb { 35ac5674,0 } joined { } left { } partitioned { be3593ae,0 be526f4c,0 }) 2020-06-12 17:37:44 0 [Note] WSREP: view((empty)) 2020-06-12 17:37:44 0 [Note] WSREP: gcomm: closed 2020-06-12 17:37:44 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-06-12 17:37:44 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-06-12 17:37:44 0 [Note] WSREP: Received NON-PRIMARY. 2020-06-12 17:37:44 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 0) 2020-06-12 17:37:44 0 [Note] WSREP: Received self-leave message. 2020-06-12 17:37:44 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2020-06-12 17:37:44 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:37:44 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-06-12 17:37:44 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-06-12 17:37:44 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 0) 2020-06-12 17:37:44 0 [Note] WSREP: RECV thread exiting 0: Success 2020-06-12 17:37:44 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2020-06-12 17:37:44 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:37:44 0 [Note] WSREP: recv_thread() joined. 2020-06-12 17:37:44 0 [Note] WSREP: Closing replication queue. 2020-06-12 17:37:44 0 [Note] WSREP: Closing slave action queue. 2020-06-12 17:37:44 2 [Note] WSREP: applier thread exiting (code:0) 2020-06-12 17:37:44 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 29 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 29 [Warning] Aborted connection 29 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 23 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 27 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 25 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 35 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 24 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 13 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 34 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 16 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 20 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 21 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 22 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 8 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 18 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 37 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 11 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 27 [Warning] Aborted connection 27 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 14 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 28 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 12 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 15 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 33 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 32 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 26 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 9 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 23 [Warning] Aborted connection 23 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 10 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 30 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 30 [Warning] Aborted connection 30 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 17 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 36 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 38 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 19 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 31 [Note] WSREP: applier thread exiting (code:6) 2020-06-12 17:37:44 31 [Warning] Aborted connection 31 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 36 [Warning] Aborted connection 36 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:44 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:46 1 [Note] WSREP: rollbacker thread exiting 2020-06-12 17:37:46 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (CLOSE_CONNECTION) 2020-06-12 17:37:46 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-06-12 17:37:46 0 [Note] InnoDB: FTS optimize thread exiting. 2020-06-12 17:37:46 0 [Note] WSREP: dtor state: CLOSED 2020-06-12 17:37:46 0 [Note] WSREP: apply mon: entered 0 2020-06-12 17:37:46 0 [Note] WSREP: apply mon: entered 0 2020-06-12 17:37:46 0 [Note] WSREP: mon: entered 4 oooe fraction 0 oool fraction 0 2020-06-12 17:37:46 0 [Note] WSREP: cert index usage at exit 0 2020-06-12 17:37:46 0 [Note] WSREP: cert trx map usage at exit 0 2020-06-12 17:37:46 0 [Note] WSREP: deps set usage at exit 0 2020-06-12 17:37:46 0 [Note] WSREP: avg deps dist 0 2020-06-12 17:37:46 0 [Note] WSREP: avg cert interval 0 2020-06-12 17:37:46 0 [Note] WSREP: cert index size 0 2020-06-12 17:37:46 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:37:46 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2020-06-12 17:37:46 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-06-12 17:37:46 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2020-06-12 17:37:46 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 0) 2020-06-12 17:37:46 0 [Note] WSREP: Flushing memory map to disk... 2020-06-12 17:37:46 0 [Note] InnoDB: Starting shutdown... 2020-06-12 17:37:46 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/ib_buffer_pool 2020-06-12 17:37:46 0 [Note] InnoDB: Buffer pool(s) dump completed at 200612 17:37:46 2020-06-12 17:37:47 0 [Note] InnoDB: Shutdown completed; log sequence number 1638462; transaction id 34 2020-06-12 17:37:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-06-12 17:37:47 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld: Shutdown complete 2020-06-12 17:38:03 0 [Note] WSREP: Read nil XID from storage engines, skipping position init 2020-06-12 17:38:03 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm_3.so' 2020-06-12 17:38:03 0 [Note] WSREP: wsrep_load(): Galera 25.3.29(rb0f34b0) by Codership Oy loaded successfully. 2020-06-12 17:38:03 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-06-12 17:38:03 0 [Note] WSREP: Found saved state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, safe_to_bootstrap: 0 2020-06-12 17:38:03 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; 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 = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//galera.cache; gcache.page_size = 128M; gcache.recover = no; 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 = 92233720368... 2020-06-12 17:38:03 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1 2020-06-12 17:38:03 0 [Note] WSREP: wsrep_sst_grab() 2020-06-12 17:38:03 0 [Note] WSREP: Start replication 2020-06-12 17:38:03 0 [Note] WSREP: Setting initial position to be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0 2020-06-12 17:38:03 0 [Note] WSREP: protonet asio version 0 2020-06-12 17:38:03 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-06-12 17:38:03 0 [Note] WSREP: backend: asio 2020-06-12 17:38:03 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-06-12 17:38:03 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data//gvwstate.dat) failed(No such file or directory) 2020-06-12 17:38:03 0 [Note] WSREP: restore pc from disk failed 2020-06-12 17:38:03 0 [Note] WSREP: GMCast version 0 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2020-06-12 17:38:03 0 [Note] WSREP: EVS version 0 2020-06-12 17:38:03 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16003,127.0.0.1:16006,127.0.0.1:16009' 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') Found matching local endpoint for a connection, blacklisting address tcp://127.0.0.1:16009 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to be3593ae tcp://127.0.0.1:16003 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2020-06-12 17:38:03 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to be526f4c tcp://127.0.0.1:16006 2020-06-12 17:38:03 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:38:03 0 [Note] WSREP: declaring be526f4c at tcp://127.0.0.1:16006 stable 2020-06-12 17:38:03 0 [Note] WSREP: Node be3593ae state prim 2020-06-12 17:38:03 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,7) memb { 5269e0d3,0 be3593ae,0 be526f4c,0 } joined { } left { } partitioned { }) 2020-06-12 17:38:03 0 [Note] WSREP: save pc into disk 2020-06-12 17:38:04 0 [Note] WSREP: gcomm: connected 2020-06-12 17:38:04 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-06-12 17:38:04 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-06-12 17:38:04 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2020-06-12 17:38:04 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 17:38:04 0 [Note] WSREP: Waiting for SST to complete. 2020-06-12 17:38:04 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 5302bf52-acba-11ea-9fd6-ef8cb86e6abd 2020-06-12 17:38:04 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 5302bf52-acba-11ea-9fd6-ef8cb86e6abd 2020-06-12 17:38:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5302bf52-acba-11ea-9fd6-ef8cb86e6abd from 1 (cnt7glr11.localdomain) 2020-06-12 17:38:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5302bf52-acba-11ea-9fd6-ef8cb86e6abd from 0 (mdb1) 2020-06-12 17:38:04 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5302bf52-acba-11ea-9fd6-ef8cb86e6abd from 2 (cnt7glr11.localdomain) 2020-06-12 17:38:04 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 6, members = 3/3 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:38:04 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:38:04 0 [Note] WSREP: Restored state OPEN -> JOINED (0) 2020-06-12 17:38:04 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 7: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 17:38:04 0 [Note] WSREP: SST complete, seqno: 0 2020-06-12 17:38:04 0 [Note] WSREP: Member 0.0 (mdb1) synced with group. 2020-06-12 17:38:04 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2020-06-12 17:38:04 0 [Note] InnoDB: Using Linux native AIO 2020-06-12 17:38:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-06-12 17:38:04 0 [Note] InnoDB: Uses event mutexes 2020-06-12 17:38:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-06-12 17:38:04 0 [Note] InnoDB: Number of pools: 1 2020-06-12 17:38:04 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-06-12 17:38:04 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-06-12 17:38:04 0 [Note] InnoDB: Completed initialization of buffer pool 2020-06-12 17:38:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-06-12 17:38:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-06-12 17:38:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-06-12 17:38:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-06-12 17:38:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-06-12 17:38:04 0 [Note] InnoDB: Waiting for purge to start 2020-06-12 17:38:04 0 [Note] InnoDB: 10.3.23 started; log sequence number 1638462; transaction id 34 2020-06-12 17:38:04 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3.23/mysql-test/var/mysqld.3/data/ib_buffer_pool 2020-06-12 17:38:04 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-06-12 17:38:04 0 [Note] InnoDB: Buffer pool(s) load completed at 200612 17:38:04 2020-06-12 17:38:04 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-06-12 17:38:04 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:38:04 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:38:04 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:38:04 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:38:04 0 [Note] Reading of all Master_info entries succeeded 2020-06-12 17:38:04 0 [Note] Added new Master_info '' to hash table 2020-06-12 17:38:04 0 [Note] /home/stepan/mariadb/10.3.23/sql/mysqld: ready for connections. Version: '10.3.23-MariaDB-log' socket: '/home/stepan/mariadb/10.3.23/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2020-06-12 17:38:04 2 [Note] WSREP: Synchronized with group, ready for connections 2020-06-12 17:38:04 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:38:06 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 17:38:20 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:38:20 0 [Note] WSREP: forgetting be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:38:20 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:38:20 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,8) memb { 5269e0d3,0 be3593ae,0 } joined { } left { } partitioned { be526f4c,0 }) 2020-06-12 17:38:20 0 [Note] WSREP: save pc into disk 2020-06-12 17:38:20 0 [Note] WSREP: forgetting be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:38:20 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-06-12 17:38:20 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 5cbcee0c-acba-11ea-bcb7-5751b868d286 2020-06-12 17:38:20 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 5cbcee0c-acba-11ea-bcb7-5751b868d286 2020-06-12 17:38:20 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5cbcee0c-acba-11ea-bcb7-5751b868d286 from 0 (mdb1) 2020-06-12 17:38:20 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5cbcee0c-acba-11ea-bcb7-5751b868d286 from 1 (cnt7glr11.localdomain) 2020-06-12 17:38:20 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 7, members = 2/2 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:38:20 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 17:38:20 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 8: Primary, number of nodes: 2, my index: 0, protocol version 3 2020-06-12 17:38:20 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:38:20 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:38:20 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:38:20 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:38:25 0 [Note] WSREP: cleaning up be526f4c (tcp://127.0.0.1:16006) 2020-06-12 17:38:41 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:16006 2020-06-12 17:38:41 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to 68d243cd tcp://127.0.0.1:16006 2020-06-12 17:38:41 0 [Note] WSREP: declaring 68d243cd at tcp://127.0.0.1:16006 stable 2020-06-12 17:38:41 0 [Note] WSREP: declaring be3593ae at tcp://127.0.0.1:16003 stable 2020-06-12 17:38:41 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:38:41 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,9) memb { 5269e0d3,0 68d243cd,0 be3593ae,0 } joined { } left { } partitioned { }) 2020-06-12 17:38:41 0 [Note] WSREP: save pc into disk 2020-06-12 17:38:41 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 17:38:41 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 691ff3e6-acba-11ea-9a91-ba7c0b96895b 2020-06-12 17:38:41 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 691ff3e6-acba-11ea-9a91-ba7c0b96895b 2020-06-12 17:38:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: 691ff3e6-acba-11ea-9a91-ba7c0b96895b from 0 (mdb1) 2020-06-12 17:38:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: 691ff3e6-acba-11ea-9a91-ba7c0b96895b from 2 (cnt7glr11.localdomain) 2020-06-12 17:38:42 0 [Note] WSREP: STATE EXCHANGE: got state msg: 691ff3e6-acba-11ea-9a91-ba7c0b96895b from 1 (mdb1) 2020-06-12 17:38:42 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 8, members = 3/3 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:38:42 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:38:42 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 9: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 17:38:42 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:38:42 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:38:42 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:38:42 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:38:42 0 [Note] WSREP: Member 1.0 (mdb1) synced with group. 2020-06-12 17:38:44 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 17:39:23 0 [Note] WSREP: declaring 68d243cd at tcp://127.0.0.1:16006 stable 2020-06-12 17:39:23 0 [Note] WSREP: forgetting be3593ae (tcp://127.0.0.1:16003) 2020-06-12 17:39:23 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:39:23 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,10) memb { 5269e0d3,0 68d243cd,0 } joined { } left { } partitioned { be3593ae,0 }) 2020-06-12 17:39:23 0 [Note] WSREP: save pc into disk 2020-06-12 17:39:23 0 [Note] WSREP: forgetting be3593ae (tcp://127.0.0.1:16003) 2020-06-12 17:39:23 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-06-12 17:39:23 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 82112ccc-acba-11ea-b9d9-aea3b579407a 2020-06-12 17:39:23 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 82112ccc-acba-11ea-b9d9-aea3b579407a 2020-06-12 17:39:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: 82112ccc-acba-11ea-b9d9-aea3b579407a from 0 (mdb1) 2020-06-12 17:39:23 0 [Note] WSREP: STATE EXCHANGE: got state msg: 82112ccc-acba-11ea-b9d9-aea3b579407a from 1 (mdb1) 2020-06-12 17:39:23 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 9, members = 2/2 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:39:23 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 17:39:23 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 10: Primary, number of nodes: 2, my index: 0, protocol version 3 2020-06-12 17:39:23 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:39:23 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:39:23 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:39:23 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:39:28 0 [Note] WSREP: cleaning up be3593ae (tcp://127.0.0.1:16003) 2020-06-12 17:39:46 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to 8fca65f8 tcp://127.0.0.1:16003 2020-06-12 17:39:46 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2020-06-12 17:39:46 0 [Note] WSREP: declaring 68d243cd at tcp://127.0.0.1:16006 stable 2020-06-12 17:39:46 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 17:39:46 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:39:46 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,11) memb { 5269e0d3,0 68d243cd,0 8fca65f8,0 } joined { } left { } partitioned { }) 2020-06-12 17:39:46 0 [Note] WSREP: save pc into disk 2020-06-12 17:39:46 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 17:39:46 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 9017e86e-acba-11ea-acb9-26ea58c3acd9 2020-06-12 17:39:46 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9017e86e-acba-11ea-acb9-26ea58c3acd9 2020-06-12 17:39:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9017e86e-acba-11ea-acb9-26ea58c3acd9 from 0 (mdb1) 2020-06-12 17:39:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9017e86e-acba-11ea-acb9-26ea58c3acd9 from 1 (mdb1) 2020-06-12 17:39:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9017e86e-acba-11ea-acb9-26ea58c3acd9 from 2 (mdb1) 2020-06-12 17:39:47 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 10, members = 3/3 (joined/total), act_id = 0, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:39:47 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:39:47 2 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:0, view# 11: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 17:39:47 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:39:47 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:39:47 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2020-06-12 17:39:47 0 [Note] WSREP: Member 2.0 (mdb1) synced with group. 2020-06-12 17:39:47 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:39:49 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 17:50:57 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 17:50:57 0 [Note] WSREP: forgetting 68d243cd (tcp://127.0.0.1:16006) 2020-06-12 17:50:57 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:50:57 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,12) memb { 5269e0d3,0 8fca65f8,0 } joined { } left { } partitioned { 68d243cd,0 }) 2020-06-12 17:50:57 0 [Note] WSREP: save pc into disk 2020-06-12 17:50:58 0 [Note] WSREP: forgetting 68d243cd (tcp://127.0.0.1:16006) 2020-06-12 17:50:58 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-06-12 17:50:58 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2010d46e-acbc-11ea-aa0f-9adfb8867817 2020-06-12 17:50:58 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 2010d46e-acbc-11ea-aa0f-9adfb8867817 2020-06-12 17:50:58 0 [Note] WSREP: STATE EXCHANGE: got state msg: 2010d46e-acbc-11ea-aa0f-9adfb8867817 from 0 (mdb1) 2020-06-12 17:50:58 0 [Note] WSREP: STATE EXCHANGE: got state msg: 2010d46e-acbc-11ea-aa0f-9adfb8867817 from 1 (mdb1) 2020-06-12 17:50:58 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 11, members = 2/2 (joined/total), act_id = 4, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:50:58 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 17:50:58 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:4, view# 12: Primary, number of nodes: 2, my index: 0, protocol version 3 2020-06-12 17:50:58 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:50:58 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:50:58 18 [Note] WSREP: Assign initial position for certification: 4, protocol version: 4 2020-06-12 17:50:58 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:51:03 0 [Note] WSREP: cleaning up 68d243cd (tcp://127.0.0.1:16006) 2020-06-12 17:56:37 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:16006 2020-06-12 17:56:37 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to ea2c3d51 tcp://127.0.0.1:16006 2020-06-12 17:56:37 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 17:56:37 0 [Note] WSREP: declaring ea2c3d51 at tcp://127.0.0.1:16006 stable 2020-06-12 17:56:37 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 17:56:37 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,13) memb { 5269e0d3,0 8fca65f8,0 ea2c3d51,0 } joined { } left { } partitioned { }) 2020-06-12 17:56:37 0 [Note] WSREP: save pc into disk 2020-06-12 17:56:37 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 17:56:37 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: ea79d1b5-acbc-11ea-9bf0-3f3a8aa1ee15 2020-06-12 17:56:37 0 [Note] WSREP: STATE EXCHANGE: sent state msg: ea79d1b5-acbc-11ea-9bf0-3f3a8aa1ee15 2020-06-12 17:56:37 0 [Note] WSREP: STATE EXCHANGE: got state msg: ea79d1b5-acbc-11ea-9bf0-3f3a8aa1ee15 from 0 (mdb1) 2020-06-12 17:56:37 0 [Note] WSREP: STATE EXCHANGE: got state msg: ea79d1b5-acbc-11ea-9bf0-3f3a8aa1ee15 from 1 (mdb1) 2020-06-12 17:56:38 0 [Note] WSREP: STATE EXCHANGE: got state msg: ea79d1b5-acbc-11ea-9bf0-3f3a8aa1ee15 from 2 (mdb1) 2020-06-12 17:56:38 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 12, members = 2/3 (joined/total), act_id = 5, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 17:56:38 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 17:56:38 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:5, view# 13: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 17:56:38 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 17:56:38 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 17:56:38 18 [Note] WSREP: Assign initial position for certification: 5, protocol version: 4 2020-06-12 17:56:38 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 17:56:38 0 [Note] WSREP: Member 2.0 (mdb1) requested state transfer from '*any*'. Selected 1.0 (mdb1)(SYNCED) as donor. 2020-06-12 17:56:38 0 [Note] WSREP: 1.0 (mdb1): State transfer to 2.0 (mdb1) complete. 2020-06-12 17:56:38 0 [Note] WSREP: Member 1.0 (mdb1) synced with group. 2020-06-12 17:56:38 0 [Note] WSREP: 2.0 (mdb1): State transfer from 1.0 (mdb1) complete. 2020-06-12 17:56:38 0 [Note] WSREP: Member 2.0 (mdb1) synced with group. 2020-06-12 17:56:40 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 18:27:55 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 18:27:55 0 [Note] WSREP: forgetting ea2c3d51 (tcp://127.0.0.1:16006) 2020-06-12 18:27:55 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 18:27:55 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,14) memb { 5269e0d3,0 8fca65f8,0 } joined { } left { } partitioned { ea2c3d51,0 }) 2020-06-12 18:27:55 0 [Note] WSREP: save pc into disk 2020-06-12 18:27:55 0 [Note] WSREP: forgetting ea2c3d51 (tcp://127.0.0.1:16006) 2020-06-12 18:27:55 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-06-12 18:27:55 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 49fd7017-acc1-11ea-8d0e-daa4c10c3607 2020-06-12 18:27:55 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 49fd7017-acc1-11ea-8d0e-daa4c10c3607 2020-06-12 18:27:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 49fd7017-acc1-11ea-8d0e-daa4c10c3607 from 0 (mdb1) 2020-06-12 18:27:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 49fd7017-acc1-11ea-8d0e-daa4c10c3607 from 1 (mdb1) 2020-06-12 18:27:55 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 13, members = 2/2 (joined/total), act_id = 5, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 18:27:55 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 18:27:55 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:5, view# 14: Primary, number of nodes: 2, my index: 0, protocol version 3 2020-06-12 18:27:55 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 18:27:55 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 18:27:55 18 [Note] WSREP: Assign initial position for certification: 5, protocol version: 4 2020-06-12 18:27:55 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 18:28:01 0 [Note] WSREP: cleaning up ea2c3d51 (tcp://127.0.0.1:16006) 2020-06-12 18:46:27 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:16006 2020-06-12 18:46:27 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to e05a4078 tcp://127.0.0.1:16006 2020-06-12 18:46:27 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 18:46:27 0 [Note] WSREP: declaring e05a4078 at tcp://127.0.0.1:16006 stable 2020-06-12 18:46:27 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 18:46:27 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,15) memb { 5269e0d3,0 8fca65f8,0 e05a4078,0 } joined { } left { } partitioned { }) 2020-06-12 18:46:27 0 [Note] WSREP: save pc into disk 2020-06-12 18:46:27 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 18:46:27 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e0a9dd97-acc3-11ea-9273-9ffa3572bf59 2020-06-12 18:46:27 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e0a9dd97-acc3-11ea-9273-9ffa3572bf59 2020-06-12 18:46:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: e0a9dd97-acc3-11ea-9273-9ffa3572bf59 from 0 (mdb1) 2020-06-12 18:46:27 0 [Note] WSREP: STATE EXCHANGE: got state msg: e0a9dd97-acc3-11ea-9273-9ffa3572bf59 from 1 (mdb1) 2020-06-12 18:46:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: e0a9dd97-acc3-11ea-9273-9ffa3572bf59 from 2 (mdb1) 2020-06-12 18:46:28 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 14, members = 2/3 (joined/total), act_id = 6, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 18:46:28 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 18:46:28 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:6, view# 15: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 18:46:28 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 18:46:28 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 18:46:28 18 [Note] WSREP: Assign initial position for certification: 6, protocol version: 4 2020-06-12 18:46:28 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 18:46:28 0 [Note] WSREP: Member 2.0 (mdb1) requested state transfer from '*any*'. Selected 1.0 (mdb1)(SYNCED) as donor. 2020-06-12 18:46:28 0 [Note] WSREP: 1.0 (mdb1): State transfer to 2.0 (mdb1) complete. 2020-06-12 18:46:28 0 [Note] WSREP: Member 1.0 (mdb1) synced with group. 2020-06-12 18:46:28 0 [Note] WSREP: 2.0 (mdb1): State transfer from 1.0 (mdb1) complete. 2020-06-12 18:46:28 0 [Note] WSREP: Member 2.0 (mdb1) synced with group. 2020-06-12 18:46:30 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off 2020-06-12 19:19:53 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 19:19:53 0 [Note] WSREP: forgetting e05a4078 (tcp://127.0.0.1:16006) 2020-06-12 19:19:53 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 19:19:53 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,16) memb { 5269e0d3,0 8fca65f8,0 } joined { } left { } partitioned { e05a4078,0 }) 2020-06-12 19:19:53 0 [Note] WSREP: save pc into disk 2020-06-12 19:19:53 0 [Note] WSREP: forgetting e05a4078 (tcp://127.0.0.1:16006) 2020-06-12 19:19:53 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-06-12 19:19:53 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 8c3f9ba0-acc8-11ea-bf91-cb4672a161f4 2020-06-12 19:19:53 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 8c3f9ba0-acc8-11ea-bf91-cb4672a161f4 2020-06-12 19:19:53 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8c3f9ba0-acc8-11ea-bf91-cb4672a161f4 from 0 (mdb1) 2020-06-12 19:19:53 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8c3f9ba0-acc8-11ea-bf91-cb4672a161f4 from 1 (mdb1) 2020-06-12 19:19:53 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 15, members = 2/2 (joined/total), act_id = 7, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 19:19:53 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-06-12 19:19:53 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:7, view# 16: Primary, number of nodes: 2, my index: 0, protocol version 3 2020-06-12 19:19:53 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 19:19:53 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 19:19:53 18 [Note] WSREP: Assign initial position for certification: 7, protocol version: 4 2020-06-12 19:19:53 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 19:19:58 0 [Note] WSREP: cleaning up e05a4078 (tcp://127.0.0.1:16006) 2020-06-12 19:20:31 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:16006 2020-06-12 19:20:31 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') connection established to a2c23b72 tcp://127.0.0.1:16006 2020-06-12 19:20:31 0 [Note] WSREP: declaring 8fca65f8 at tcp://127.0.0.1:16003 stable 2020-06-12 19:20:31 0 [Note] WSREP: declaring a2c23b72 at tcp://127.0.0.1:16006 stable 2020-06-12 19:20:31 0 [Note] WSREP: Node 5269e0d3 state prim 2020-06-12 19:20:31 0 [Note] WSREP: view(view_id(PRIM,5269e0d3,17) memb { 5269e0d3,0 8fca65f8,0 a2c23b72,0 } joined { } left { } partitioned { }) 2020-06-12 19:20:31 0 [Note] WSREP: save pc into disk 2020-06-12 19:20:31 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2020-06-12 19:20:31 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a30fe7b5-acc8-11ea-a47f-42adf554794c 2020-06-12 19:20:31 0 [Note] WSREP: STATE EXCHANGE: sent state msg: a30fe7b5-acc8-11ea-a47f-42adf554794c 2020-06-12 19:20:31 0 [Note] WSREP: STATE EXCHANGE: got state msg: a30fe7b5-acc8-11ea-a47f-42adf554794c from 0 (mdb1) 2020-06-12 19:20:31 0 [Note] WSREP: STATE EXCHANGE: got state msg: a30fe7b5-acc8-11ea-a47f-42adf554794c from 1 (mdb1) 2020-06-12 19:20:32 0 [Note] WSREP: STATE EXCHANGE: got state msg: a30fe7b5-acc8-11ea-a47f-42adf554794c from 2 (mdb1) 2020-06-12 19:20:32 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 16, members = 3/3 (joined/total), act_id = 7, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = be36cf8b-acb6-11ea-aa2c-e3149c2ff908 2020-06-12 19:20:32 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-06-12 19:20:32 18 [Note] WSREP: New cluster view: global state: be36cf8b-acb6-11ea-aa2c-e3149c2ff908:7, view# 17: Primary, number of nodes: 3, my index: 0, protocol version 3 2020-06-12 19:20:32 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-06-12 19:20:32 18 [Note] WSREP: REPL Protocols: 9 (4, 2) 2020-06-12 19:20:32 18 [Note] WSREP: Assign initial position for certification: 7, protocol version: 4 2020-06-12 19:20:32 0 [Note] WSREP: Service thread queue flushed. 2020-06-12 19:20:32 0 [Note] WSREP: Member 2.0 (mdb1) synced with group. 2020-06-12 19:20:34 0 [Note] WSREP: (5269e0d3, 'tcp://0.0.0.0:16009') turning message relay requesting off