CURRENT_TEST: galera_3nodes.galera_certification_ccc 2019-07-08 10:56:27 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2019-07-08 10:56:27 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on 2019-07-08 10:56:27 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld (mysqld 10.3.17-MariaDB-log) starting as process 7328 ... 2019-07-08 10:56:27 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4186) 2019-07-08 10:56:27 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2019-07-08 10:56:27 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16008' 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. 2019-07-08 10:56:27 0 [Note] WSREP: Read nil XID from storage engines, skipping position init 2019-07-08 10:56:27 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm_3.so' 2019-07-08 10:56:27 0 [Note] WSREP: wsrep_load(): Galera 25.3.26(r3857) by Codership Oy loaded successfully. 2019-07-08 10:56:27 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-07-08 10:56:27 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data//grastate.dat' 2019-07-08 10:56:27 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2019-07-08 10:56:27 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/; base_host = 127.0.0.1; base_port = 16006; 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/mysql-test/var/mysqld.2/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/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.recv_q_hard 2019-07-08 10:56:27 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1 2019-07-08 10:56:27 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2019-07-08 10:56:27 0 [Note] WSREP: wsrep_sst_grab() 2019-07-08 10:56:27 0 [Note] WSREP: Start replication 2019-07-08 10:56:27 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2019-07-08 10:56:27 0 [Note] WSREP: protonet asio version 0 2019-07-08 10:56:27 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-07-08 10:56:27 0 [Note] WSREP: backend: asio 2019-07-08 10:56:27 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-07-08 10:56:27 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory) 2019-07-08 10:56:27 0 [Note] WSREP: restore pc from disk failed 2019-07-08 10:56:27 0 [Note] WSREP: GMCast version 0 2019-07-08 10:56:27 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') listening at tcp://0.0.0.0:16006 2019-07-08 10:56:27 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') multicast: , ttl: 1 2019-07-08 10:56:27 0 [Note] WSREP: EVS version 0 2019-07-08 10:56:27 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16003' 2019-07-08 10:56:27 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') connection established to e3c33951 tcp://127.0.0.1:16003 2019-07-08 10:56:27 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') turning message relay requesting on, nonlive peers: 2019-07-08 10:56:28 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') connection established to e3c9600c tcp://127.0.0.1:16009 2019-07-08 10:56:28 0 [Note] WSREP: declaring e3c33951 at tcp://127.0.0.1:16003 stable 2019-07-08 10:56:28 0 [Note] WSREP: declaring e3c9600c at tcp://127.0.0.1:16009 stable 2019-07-08 10:56:28 0 [Note] WSREP: Node e3c33951 state prim 2019-07-08 10:56:28 0 [Note] WSREP: view(view_id(PRIM,e3c33951,2) memb { e3c33951,0 e3c4d874,0 e3c9600c,0 } joined { } left { } partitioned { }) 2019-07-08 10:56:28 0 [Note] WSREP: save pc into disk 2019-07-08 10:56:28 0 [Note] WSREP: gcomm: connected 2019-07-08 10:56:28 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-07-08 10:56:28 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-07-08 10:56:28 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-07-08 10:56:28 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2019-07-08 10:56:28 0 [Note] WSREP: Waiting for SST to complete. 2019-07-08 10:56:28 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-07-08 10:56:28 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e412baa5-a155-11e9-8c4f-4e0e49591b28 2019-07-08 10:56:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: e412baa5-a155-11e9-8c4f-4e0e49591b28 from 0 (cnt7glr11.localdomain) 2019-07-08 10:56:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: e412baa5-a155-11e9-8c4f-4e0e49591b28 from 2 (cnt7glr11.localdomain) 2019-07-08 10:56:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: e412baa5-a155-11e9-8c4f-4e0e49591b28 from 1 (cnt7glr11.localdomain) 2019-07-08 10:56:28 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 1, members = 1/3 (joined/total), act_id = 0, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = e3c49d03-a155-11e9-80eb-a614fcadb109 2019-07-08 10:56:28 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-07-08 10:56:28 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 10:56:28 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0) 2019-07-08 10:56:28 2 [Note] WSREP: State transfer required: Group state: e3c49d03-a155-11e9-80eb-a614fcadb109:0 Local state: 00000000-0000-0000-0000-000000000000:-1 2019-07-08 10:56:28 2 [Note] WSREP: New cluster view: global state: e3c49d03-a155-11e9-80eb-a614fcadb109:0, view# 2: Primary, number of nodes: 3, my index: 1, protocol version 3 2019-07-08 10:56:28 2 [Warning] WSREP: Gap in state sequence. Need state transfer. 2019-07-08 10:56:28 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16008' --datadir '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/' --defaults-file '/home/stepan/mariadb/10.3/mysql-test/var/my.cnf' --defaults-group-suffix '.2' --parent '7328' '' --binlog-index 'mysqld-bin.index'' 2019-07-08 10:56:28 2 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:16008/rsync_sst 2019-07-08 10:56:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 10:56:28 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-07-08 10:56:28 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2019-07-08 10:56:28 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 10:56:28 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (e3c49d03-a155-11e9-80eb-a614fcadb109): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. 2019-07-08 10:56:28 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-07-08 10:56:28 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) 2019-07-08 10:56:28 0 [Warning] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 2019-07-08 10:56:28 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2019-07-08 10:56:28 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> e3c49d03-a155-11e9-80eb-a614fcadb109:0 2019-07-08 10:56:29 0 [Warning] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable 2019-07-08 10:56:30 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 1.0 (cnt7glr11.localdomain) complete. 2019-07-08 10:56:30 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 10:56:30 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 7461 (20190708 10:56:30.875) WSREP_SST: [INFO] Joiner cleanup done. (20190708 10:56:31.383) 2019-07-08 10:56:31 0 [Note] WSREP: SST complete, seqno: 0 2019-07-08 10:56:31 0 [Note] Plugin 'partition' is disabled. 2019-07-08 10:56:31 0 [Note] InnoDB: Using Linux native AIO 2019-07-08 10:56:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-08 10:56:31 0 [Note] InnoDB: Uses event mutexes 2019-07-08 10:56:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-07-08 10:56:31 0 [Note] InnoDB: Number of pools: 1 2019-07-08 10:56:31 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-08 10:56:31 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2019-07-08 10:56:31 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-08 10:56:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-08 10:56:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1642365 2019-07-08 10:56:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-08 10:56:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-08 10:56:31 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-08 10:56:31 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-08 10:56:31 0 [Note] InnoDB: Waiting for purge to start 2019-07-08 10:56:31 0 [Note] InnoDB: 10.3.17 started; log sequence number 1643430; transaction id 34 2019-07-08 10:56:31 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 10:56:31 0 [Note] Plugin 'SEQUENCE' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_CMP' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'user_variables' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2019-07-08 10:56:31 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 10:56:31 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2019-07-08 10:56:31 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2019-07-08 10:56:31 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2019-07-08 10:56:31 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2019-07-08 10:56:31 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2019-07-08 10:56:31 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown option '--loose-pam-debug' 2019-07-08 10:56:31 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2019-07-08 10:56:31 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-08 10:56:31 0 [Note] WSREP: Signalling provider to continue. 2019-07-08 10:56:31 0 [Note] WSREP: SST received: e3c49d03-a155-11e9-80eb-a614fcadb109:0 2019-07-08 10:56:31 0 [Note] Reading of all Master_info entries succeeded 2019-07-08 10:56:31 0 [Note] Added new Master_info '' to hash table 2019-07-08 10:56:31 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld: ready for connections. Version: '10.3.17-MariaDB-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution 2019-07-08 10:56:31 0 [Note] WSREP: 1.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2019-07-08 10:56:31 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0) 2019-07-08 10:56:31 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 10:56:31 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2019-07-08 10:56:31 2 [Note] WSREP: Synchronized with group, ready for connections 2019-07-08 10:56:31 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 10:56:31 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') turning message relay requesting off 2019-07-08 10:56:31 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 2.0 (cnt7glr11.localdomain) complete. 2019-07-08 10:56:31 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 10:56:32 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2019-07-08 10:56:32 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 11:05:34 0 [Note] WSREP: declaring e3c33951 at tcp://127.0.0.1:16003 stable 2019-07-08 11:05:34 0 [Note] WSREP: forgetting e3c9600c (tcp://127.0.0.1:16009) 2019-07-08 11:05:34 0 [Note] WSREP: Node e3c33951 state prim 2019-07-08 11:05:34 0 [Note] WSREP: view(view_id(PRIM,e3c33951,3) memb { e3c33951,0 e3c4d874,0 } joined { } left { } partitioned { e3c9600c,0 }) 2019-07-08 11:05:34 0 [Note] WSREP: save pc into disk 2019-07-08 11:05:34 0 [Note] WSREP: forgetting e3c9600c (tcp://127.0.0.1:16009) 2019-07-08 11:05:34 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2019-07-08 11:05:34 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-07-08 11:05:34 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 2980b357-a157-11e9-b34b-73bb48ec5c85 2019-07-08 11:05:34 0 [Note] WSREP: STATE EXCHANGE: got state msg: 2980b357-a157-11e9-b34b-73bb48ec5c85 from 0 (cnt7glr11.localdomain) 2019-07-08 11:05:34 0 [Note] WSREP: STATE EXCHANGE: got state msg: 2980b357-a157-11e9-b34b-73bb48ec5c85 from 1 (cnt7glr11.localdomain) 2019-07-08 11:05:34 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 2, members = 2/2 (joined/total), act_id = 157, last_appl. = 127, protocols = 0/9/3 (gcs/repl/appl), group UUID = e3c49d03-a155-11e9-80eb-a614fcadb109 2019-07-08 11:05:34 0 [Note] WSREP: Flow-control interval: [23, 23] 2019-07-08 11:05:34 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:05:34 2 [Note] WSREP: New cluster view: global state: e3c49d03-a155-11e9-80eb-a614fcadb109:157, view# 3: Primary, number of nodes: 2, my index: 1, protocol version 3 2019-07-08 11:05:34 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:05:34 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-07-08 11:05:34 2 [Note] WSREP: Assign initial position for certification: 157, protocol version: 4 2019-07-08 11:05:34 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:05:39 0 [Note] WSREP: cleaning up e3c9600c (tcp://127.0.0.1:16009) 2019-07-08 11:10:23 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.80704S), skipping check 2019-07-08 11:20:12 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.10921S), skipping check 2019-07-08 11:20:54 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') connection established to 4e4737f4 tcp://127.0.0.1:16009 2019-07-08 11:20:54 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') turning message relay requesting on, nonlive peers: 2019-07-08 11:20:55 0 [Note] WSREP: declaring 4e4737f4 at tcp://127.0.0.1:16009 stable 2019-07-08 11:20:55 0 [Note] WSREP: declaring e3c33951 at tcp://127.0.0.1:16003 stable 2019-07-08 11:20:55 0 [Note] WSREP: Node e3c33951 state prim 2019-07-08 11:20:55 0 [Note] WSREP: view(view_id(PRIM,4e4737f4,4) memb { 4e4737f4,0 e3c33951,0 e3c4d874,0 } joined { } left { } partitioned { }) 2019-07-08 11:20:55 0 [Note] WSREP: save pc into disk 2019-07-08 11:20:55 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2019-07-08 11:20:55 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-07-08 11:20:55 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 4e945028-a159-11e9-b893-7e9ac89c9e10 2019-07-08 11:20:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4e945028-a159-11e9-b893-7e9ac89c9e10 from 1 (cnt7glr11.localdomain) 2019-07-08 11:20:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4e945028-a159-11e9-b893-7e9ac89c9e10 from 2 (cnt7glr11.localdomain) 2019-07-08 11:20:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 4e945028-a159-11e9-b893-7e9ac89c9e10 from 0 (cnt7glr11.localdomain) 2019-07-08 11:20:55 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 3, members = 2/3 (joined/total), act_id = 969, last_appl. = 895, protocols = 0/9/3 (gcs/repl/appl), group UUID = e3c49d03-a155-11e9-80eb-a614fcadb109 2019-07-08 11:20:55 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-07-08 11:20:55 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:20:55 2 [Note] WSREP: New cluster view: global state: e3c49d03-a155-11e9-80eb-a614fcadb109:969, view# 4: Primary, number of nodes: 3, my index: 2, protocol version 3 2019-07-08 11:20:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:20:55 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-07-08 11:20:55 2 [Note] WSREP: Assign initial position for certification: 969, protocol version: 4 2019-07-08 11:20:55 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:20:55 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 2.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-07-08 11:20:55 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 970) 2019-07-08 11:20:55 2 [Note] WSREP: IST request: e3c49d03-a155-11e9-80eb-a614fcadb109:157-969|tcp://127.0.0.1:16010 2019-07-08 11:20:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:20:55 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16011/rsync_sst' --socket '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2.sock' --datadir '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/' --defaults-file '/home/stepan/mariadb/10.3/mysql-test/var/my.cnf' --defaults-group-suffix '.2' '' --gtid 'e3c49d03-a155-11e9-80eb-a614fcadb109:157' --gtid-domain-id '0' --bypass' 2019-07-08 11:20:55 2 [Note] WSREP: sst_donor_thread signaled with 0 2019-07-08 11:20:55 0 [Note] WSREP: async IST sender starting to serve tcp://127.0.0.1:16010 sending 158-969 WSREP_SST: [INFO] Bypassing state dump. (20190708 11:20:55.551) 2019-07-08 11:20:55 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer to 0.0 (cnt7glr11.localdomain) complete. 2019-07-08 11:20:55 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 970) 2019-07-08 11:20:55 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 11:20:55 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 970) 2019-07-08 11:20:55 2 [Note] WSREP: Synchronized with group, ready for connections 2019-07-08 11:20:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:20:57 0 [Note] WSREP: async IST sender served 2019-07-08 11:20:58 0 [Note] WSREP: (e3c4d874, 'tcp://0.0.0.0:16006') turning message relay requesting off 2019-07-08 11:21:00 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer from 2.0 (cnt7glr11.localdomain) complete. 2019-07-08 11:21:00 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2019-07-08 11:26:42 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.07616S), skipping check 2019-07-08 11:29:48 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-07-08 11:29:48 0 [Note] WSREP: Stop replication 2019-07-08 11:29:48 0 [Note] WSREP: Closing send monitor... 2019-07-08 11:29:48 0 [Note] WSREP: Closed send monitor. 2019-07-08 11:29:48 0 [Note] WSREP: gcomm: terminating thread 2019-07-08 11:29:48 0 [Note] WSREP: gcomm: joining thread 2019-07-08 11:29:48 0 [Note] WSREP: gcomm: closing backend 2019-07-08 11:29:48 0 [Note] WSREP: view(view_id(NON_PRIM,4e4737f4,4) memb { e3c4d874,0 } joined { } left { } partitioned { 4e4737f4,0 e3c33951,0 }) 2019-07-08 11:29:48 0 [Note] WSREP: view((empty)) 2019-07-08 11:29:48 0 [Note] WSREP: gcomm: closed 2019-07-08 11:29:48 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2019-07-08 11:29:48 0 [Note] WSREP: Flow-control interval: [16, 16] 2019-07-08 11:29:48 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:29:48 0 [Note] WSREP: Received NON-PRIMARY. 2019-07-08 11:29:48 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 1523) 2019-07-08 11:29:48 0 [Note] WSREP: Received self-leave message. 2019-07-08 11:29:48 0 [Note] WSREP: Flow-control interval: [0, 0] 2019-07-08 11:29:48 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:29:48 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2019-07-08 11:29:48 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 1523) 2019-07-08 11:29:48 0 [Note] WSREP: RECV thread exiting 0: Success 2019-07-08 11:29:48 2 [Note] WSREP: New cluster view: global state: e3c49d03-a155-11e9-80eb-a614fcadb109:1523, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2019-07-08 11:29:48 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:29:48 2 [Note] WSREP: New cluster view: global state: e3c49d03-a155-11e9-80eb-a614fcadb109:1523, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2019-07-08 11:29:48 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:29:48 0 [Note] WSREP: recv_thread() joined. 2019-07-08 11:29:48 0 [Note] WSREP: Closing replication queue. 2019-07-08 11:29:48 0 [Note] WSREP: Closing slave action queue. 2019-07-08 11:29:48 2 [Note] WSREP: applier thread exiting (code:0) 2019-07-08 11:29:50 1 [Note] WSREP: rollbacker thread exiting 2019-07-08 11:29:50 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-08 11:29:50 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-08 11:29:50 0 [Note] WSREP: dtor state: CLOSED 2019-07-08 11:29:50 0 [Note] WSREP: mon: entered 1523 oooe fraction 0 oool fraction 0 2019-07-08 11:29:50 0 [Note] WSREP: mon: entered 1523 oooe fraction 0 oool fraction 0 2019-07-08 11:29:50 0 [Note] WSREP: mon: entered 1547 oooe fraction 0 oool fraction 0.000646412 2019-07-08 11:29:50 0 [Note] WSREP: cert index usage at exit 0 2019-07-08 11:29:50 0 [Note] WSREP: cert trx map usage at exit 116 2019-07-08 11:29:50 0 [Note] WSREP: deps set usage at exit 0 2019-07-08 11:29:50 0 [Note] WSREP: avg deps dist 70.7163 2019-07-08 11:29:50 0 [Note] WSREP: avg cert interval 0 2019-07-08 11:29:50 0 [Note] WSREP: cert index size 118 2019-07-08 11:29:50 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:29:50 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2019-07-08 11:29:50 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.907407, misses: 65, in use: 0, in pool: 65 2019-07-08 11:29:50 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.894032, misses: 87, in use: 0, in pool: 87 2019-07-08 11:29:50 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 1523) 2019-07-08 11:29:50 0 [Note] WSREP: Flushing memory map to disk... 2019-07-08 11:29:50 0 [Note] InnoDB: Starting shutdown... 2019-07-08 11:29:50 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:29:50 0 [Note] InnoDB: Instance 0, restricted to 128 pages due to innodb_buf_pool_dump_pct=25 2019-07-08 11:29:50 0 [Note] InnoDB: Buffer pool(s) dump completed at 190708 11:29:50 2019-07-08 11:29:52 0 [Note] InnoDB: Shutdown completed; log sequence number 2680537; transaction id 3080 2019-07-08 11:29:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-08 11:29:52 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld: Shutdown complete 2019-07-08 11:33:04 0 [Warning] You need to use --log-bin to make --binlog-format work. 2019-07-08 11:33:04 0 [Note] InnoDB: Using Linux native AIO 2019-07-08 11:33:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-08 11:33:04 0 [Note] InnoDB: Uses event mutexes 2019-07-08 11:33:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-07-08 11:33:04 0 [Note] InnoDB: Number of pools: 1 2019-07-08 11:33:04 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-08 11:33:04 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2 (disabling future attempts) 2019-07-08 11:33:04 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-07-08 11:33:04 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-08 11:33:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-08 11:33:04 0 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=2680546 2019-07-08 11:33:04 0 [Note] InnoDB: Starting to delete and rewrite log files. 2019-07-08 11:33:04 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2019-07-08 11:33:04 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2019-07-08 11:33:04 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-07-08 11:33:04 0 [Note] InnoDB: New log files created, LSN=2680546 2019-07-08 11:33:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-08 11:33:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-08 11:33:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-08 11:33:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-08 11:33:04 0 [Note] InnoDB: 10.4.7 started; log sequence number 2680546; transaction id 3082 2019-07-08 11:33:04 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:33:04 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 11:33:04 2019-07-08 11:33:04 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-08 11:33:04 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-08 11:33:04 0 [Note] Reading of all Master_info entries succeeded 2019-07-08 11:33:04 0 [Note] Added new Master_info '' to hash table 2019-07-08 11:33:04 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld: ready for connections. Version: '10.4.7-MariaDB-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution 2019-07-08 11:34:20 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-07-08 11:34:20 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-08 11:34:20 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-08 11:34:20 0 [Note] InnoDB: Starting shutdown... 2019-07-08 11:34:20 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:34:20 0 [Note] InnoDB: Buffer pool(s) dump completed at 190708 11:34:20 2019-07-08 11:34:21 0 [Note] InnoDB: Shutdown completed; log sequence number 2681913; transaction id 3091 2019-07-08 11:34:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-08 11:34:21 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld: Shutdown complete 2019-07-08 11:35:01 0 [Warning] You need to use --log-bin to make --binlog-format work. 2019-07-08 11:35:01 0 [Note] InnoDB: Using Linux native AIO 2019-07-08 11:35:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-08 11:35:01 0 [Note] InnoDB: Uses event mutexes 2019-07-08 11:35:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-07-08 11:35:01 0 [Note] InnoDB: Number of pools: 1 2019-07-08 11:35:01 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-08 11:35:01 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2 (disabling future attempts) 2019-07-08 11:35:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-07-08 11:35:01 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-08 11:35:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-08 11:35:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-08 11:35:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-08 11:35:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-08 11:35:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-08 11:35:01 0 [Note] InnoDB: Waiting for purge to start 2019-07-08 11:35:01 0 [Note] InnoDB: 10.4.7 started; log sequence number 2681913; transaction id 3093 2019-07-08 11:35:01 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:35:01 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-08 11:35:01 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 11:35:01 2019-07-08 11:35:01 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-08 11:35:01 0 [Note] Reading of all Master_info entries succeeded 2019-07-08 11:35:01 0 [Note] Added new Master_info '' to hash table 2019-07-08 11:35:01 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld: ready for connections. Version: '10.4.7-MariaDB-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution 2019-07-08 11:36:10 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-07-08 11:36:10 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-08 11:36:10 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-08 11:36:10 0 [Note] InnoDB: Starting shutdown... 2019-07-08 11:36:10 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:36:10 0 [Note] InnoDB: Buffer pool(s) dump completed at 190708 11:36:10 2019-07-08 11:36:10 0 [Note] InnoDB: Shutdown completed; log sequence number 2681922; transaction id 3094 2019-07-08 11:36:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-08 11:36:10 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld: Shutdown complete 2019-07-08 11:49:36 0 [Note] WSREP: Loading provider /usr/lib/libgalera_smm_4.so initial position: 00000000-0000-0000-0000-000000000000:-1 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/libgalera_smm_4.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.2(r4498) by Codership Oy loaded successfully. 2019-07-08 11:49:36 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-07-08 11:49:36 0 [Note] WSREP: Found saved state: e3c49d03-a155-11e9-80eb-a614fcadb109:1523, safe_to_bootstrap: 0 2019-07-08 11:49:36 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: e3c49d03-a155-11e9-80eb-a614fcadb109 Seqno: 1 - 1523 Offset: 1280 Synced: 1 2019-07-08 11:49:36 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: e3c49d03-a155-11e9-80eb-a614fcadb109, offset: 1280 2019-07-08 11:49:36 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2019-07-08 11:49:36 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2019-07-08 11:49:36 0 [Note] WSREP: Recovering GCache ring buffer: didn't recover any events. 2019-07-08 11:49:36 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/; base_host = 127.0.0.1; base_port = 16006; 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/mysql-test/var/mysqld.2/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0 2019-07-08 11:49:36 0 [Note] WSREP: GCache history reset: old(e3c49d03-a155-11e9-80eb-a614fcadb109:0 -> e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:36 0 [Note] WSREP: Start replication 2019-07-08 11:49:36 0 [Note] WSREP: Connecting with bootstrap option: 0 2019-07-08 11:49:36 0 [Note] WSREP: Setting GCS initial position to e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:36 0 [Note] WSREP: protonet asio version 0 2019-07-08 11:49:36 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-07-08 11:49:36 0 [Note] WSREP: backend: asio 2019-07-08 11:49:36 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-07-08 11:49:36 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory) 2019-07-08 11:49:36 0 [Note] WSREP: restore pc from disk failed 2019-07-08 11:49:36 0 [Note] WSREP: GMCast version 0 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') listening at tcp://0.0.0.0:16006 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') multicast: , ttl: 1 2019-07-08 11:49:36 0 [Note] WSREP: EVS version 1 2019-07-08 11:49:36 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' 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') connection established to 504edafd tcp://127.0.0.1:16006 2019-07-08 11:49:36 0 [Warning] WSREP: (504edafd, 'tcp://0.0.0.0:16006') address 'tcp://127.0.0.1:16006' points to own listening address, blacklisting 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') connection established to e3c33951 tcp://127.0.0.1:16003 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') connection established to 4e4737f4 tcp://127.0.0.1:16009 2019-07-08 11:49:36 0 [Note] WSREP: (504edafd, 'tcp://0.0.0.0:16006') turning message relay requesting on, nonlive peers: 2019-07-08 11:49:36 0 [Note] WSREP: declaring 4e4737f4 at tcp://127.0.0.1:16009 stable 2019-07-08 11:49:36 0 [Note] WSREP: declaring e3c33951 at tcp://127.0.0.1:16003 stable 2019-07-08 11:49:36 0 [Note] WSREP: Node 4e4737f4 state prim 2019-07-08 11:49:36 0 [Note] WSREP: view(view_id(PRIM,4e4737f4,6) memb { 4e4737f4,0 504edafd,0 e3c33951,0 } joined { } left { } partitioned { }) 2019-07-08 11:49:36 0 [Note] WSREP: save pc into disk 2019-07-08 11:49:36 0 [Note] WSREP: gcomm: connected 2019-07-08 11:49:36 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-07-08 11:49:36 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-07-08 11:49:36 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-07-08 11:49:36 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2019-07-08 11:49:36 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-07-08 11:49:36 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 505af20b-a15d-11e9-af95-568b68734f12 2019-07-08 11:49:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 505af20b-a15d-11e9-af95-568b68734f12 from 0 (cnt7glr11.localdomain) 2019-07-08 11:49:36 2 [Note] WSREP: Starting post rollbacker thread 2 2019-07-08 11:49:36 3 [Note] WSREP: Starting applier thread 3 2019-07-08 11:49:36 1 [Note] WSREP: Starting rollbacker thread 1 2019-07-08 11:49:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 505af20b-a15d-11e9-af95-568b68734f12 from 2 (cnt7glr11.localdomain) 2019-07-08 11:49:36 0 [Note] WSREP: STATE EXCHANGE: got state msg: 505af20b-a15d-11e9-af95-568b68734f12 from 1 (cnt7glr11.localdomain) 2019-07-08 11:49:36 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 5, members = 2/3 (joined/total), act_id = 2703, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = e3c49d03-a155-11e9-80eb-a614fcadb109 2019-07-08 11:49:36 0 [Note] WSREP: Writing down CC checksum: 45962e45 46a0e927 a3fc11eb 605fa749 at offset 312 2019-07-08 11:49:36 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-07-08 11:49:36 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:49:36 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2703) 2019-07-08 11:49:36 3 [Note] WSREP: ####### processing CC 2703, local, unordered 2019-07-08 11:49:36 3 [Note] WSREP: ####### drain monitors upto -1 2019-07-08 11:49:36 3 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-07-08 11:49:36 3 [Note] WSREP: ####### My UUID: 504edafd-a15d-11e9-a5ef-4714459ede7a 2019-07-08 11:49:36 3 [Note] WSREP: Server cnt7glr11.localdomain connected to cluster at position e3c49d03-a155-11e9-80eb-a614fcadb109:2703 with ID 504edafd-a15d-11e9-a5ef-4714459ede7a 2019-07-08 11:49:36 3 [Note] WSREP: Server status change disconnected -> connected 2019-07-08 11:49:36 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:36 3 [Note] WSREP: State transfer required: Group state: e3c49d03-a155-11e9-80eb-a614fcadb109:2703 Local state: e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:36 3 [Note] WSREP: Server status change connected -> joiner 2019-07-08 11:49:36 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:36 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16008' --datadir '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/' --defaults-file '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.2.cnf' --parent '14576' '' ''' 2019-07-08 11:49:36 3 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:16008/rsync_sst 2019-07-08 11:49:36 3 [Note] WSREP: Cert index reset to e3c49d03-a155-11e9-80eb-a614fcadb109:2703 (proto: 9), state transfer needed: yes 2019-07-08 11:49:36 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:49:36 3 [Note] WSREP: ####### Assign initial position for certification: e3c49d03-a155-11e9-80eb-a614fcadb109:2703, protocol version: 4 2019-07-08 11:49:36 3 [Note] WSREP: ####### IST uuid:e3c49d03-a155-11e9-80eb-a614fcadb109 f: 1524, l: 2703, STRv: 2 2019-07-08 11:49:36 3 [Note] WSREP: IST receiver addr using tcp://127.0.0.1:16007 2019-07-08 11:49:36 3 [Note] WSREP: Prepared IST receiver for 1524-2703, listening at: tcp://127.0.0.1:16007 2019-07-08 11:49:36 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-07-08 11:49:36 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2703) 2019-07-08 11:49:36 3 [Note] WSREP: Requesting state transfer: success, donor: 0 2019-07-08 11:49:36 0 [ERROR] WSREP: got asio system error while reading IST stream: asio.system:104 2019-07-08 11:49:36 0 [ERROR] WSREP: IST didn't contain all write sets, expected last: 2703 last received: -1 2019-07-08 11:49:37 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 1.0 (cnt7glr11.localdomain) complete. 2019-07-08 11:49:37 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 14626 (20190708 11:49:37.938) WSREP_SST: [INFO] Joiner cleanup done. (20190708 11:49:38.446) 2019-07-08 11:49:38 4 [Note] WSREP: SST received 2019-07-08 11:49:38 4 [Note] WSREP: Server status change joiner -> initializing 2019-07-08 11:49:38 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 0 [Note] InnoDB: Using Linux native AIO 2019-07-08 11:49:38 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-08 11:49:38 0 [Note] InnoDB: Uses event mutexes 2019-07-08 11:49:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-07-08 11:49:38 0 [Note] InnoDB: Number of pools: 1 2019-07-08 11:49:38 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-08 11:49:38 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2 (disabling future attempts) 2019-07-08 11:49:38 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-07-08 11:49:38 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-08 11:49:38 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-08 11:49:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-08 11:49:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-08 11:49:38 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-08 11:49:38 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-08 11:49:38 0 [Note] InnoDB: 10.4.7 started; log sequence number 2681922; transaction id 3093 2019-07-08 11:49:38 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.2/data/ib_buffer_pool 2019-07-08 11:49:38 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-08 11:49:38 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 11:49:38 2019-07-08 11:49:38 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-08 11:49:38 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-07-08 11:49:38 0 [Note] WSREP: Server initialized 2019-07-08 11:49:38 0 [Note] WSREP: Server status change initializing -> initialized 2019-07-08 11:49:38 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 4 [Note] WSREP: Server status change initialized -> joined 2019-07-08 11:49:38 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 4 [Note] WSREP: Recovered position from storage: e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:38 4 [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): 2019-07-08 11:49:38 4 [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. 2019-07-08 11:49:38 12 [Note] WSREP: Cluster table is empty, not recovering transactions 2019-07-08 11:49:38 4 [Note] WSREP: SST received: e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:38 3 [Warning] WSREP: moving position backwards: 2703 -> 1523 2019-07-08 11:49:38 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:49:38 3 [Note] WSREP: ####### Assign initial position for certification: e3c49d03-a155-11e9-80eb-a614fcadb109:1523, protocol version: 4 2019-07-08 11:49:38 3 [Note] WSREP: Installed new state from SST: e3c49d03-a155-11e9-80eb-a614fcadb109:1523 2019-07-08 11:49:38 0 [Note] Reading of all Master_info entries succeeded 2019-07-08 11:49:38 0 [Note] Added new Master_info '' to hash table 2019-07-08 11:49:38 0 [Note] /home/stepan/galera/git/10.4/server/sql/mysqld: ready for connections. Version: '10.4.7-MariaDB-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution 2019-07-08 11:49:38 3 [Note] WSREP: Receiving IST: 1180 writesets, seqnos 1524-2703 2019-07-08 11:49:38 3 [ERROR] WSREP: Receiving IST failed, node restart required: IST receiver reported failure: 71 (Protocol error) at galera/src/replicator_smm.hpp:pop_front():320. Null event. 2019-07-08 11:49:38 3 [Note] WSREP: Closing send monitor... 2019-07-08 11:49:38 3 [Note] WSREP: Closed send monitor. 2019-07-08 11:49:38 3 [Note] WSREP: gcomm: terminating thread 2019-07-08 11:49:38 3 [Note] WSREP: gcomm: joining thread 2019-07-08 11:49:38 3 [Note] WSREP: gcomm: closing backend 2019-07-08 11:49:38 3 [Note] WSREP: view(view_id(NON_PRIM,4e4737f4,6) memb { 504edafd,0 } joined { } left { } partitioned { 4e4737f4,0 e3c33951,0 }) 2019-07-08 11:49:38 3 [Note] WSREP: view((empty)) 2019-07-08 11:49:38 3 [Note] WSREP: gcomm: closed 2019-07-08 11:49:38 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2019-07-08 11:49:38 0 [Note] WSREP: Writing down CC checksum: 353a45a5 5798c14d b89db5a6 c321d1ce at offset 144 2019-07-08 11:49:38 0 [Note] WSREP: Flow-control interval: [16, 16] 2019-07-08 11:49:38 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:49:38 0 [Note] WSREP: Received NON-PRIMARY. 2019-07-08 11:49:38 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 2705) 2019-07-08 11:49:38 0 [Note] WSREP: Received self-leave message. 2019-07-08 11:49:38 0 [Note] WSREP: Writing down CC checksum: ba76988a 0b0a5f89 1d775a78 675c55c5 at offset 64 2019-07-08 11:49:38 0 [Note] WSREP: Flow-control interval: [0, 0] 2019-07-08 11:49:38 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-08 11:49:38 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2019-07-08 11:49:38 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2019-07-08 11:49:38 0 [Note] WSREP: RECV thread exiting 0: Success 2019-07-08 11:49:38 3 [Note] WSREP: recv_thread() joined. 2019-07-08 11:49:38 3 [Note] WSREP: Closing replication queue. 2019-07-08 11:49:38 3 [Note] WSREP: Closing slave action queue. 2019-07-08 11:49:38 3 [Note] WSREP: IST received: e3c49d03-a155-11e9-80eb-a614fcadb109:-1 2019-07-08 11:49:38 3 [Warning] WSREP: Sending JOIN failed: -103 (Software caused connection abort). Will retry in new primary component. 2019-07-08 11:49:38 3 [ERROR] WSREP: Failed to JOIN the cluster after SST 2019-07-08 11:49:38 3 [Note] WSREP: ####### processing CC -1, local, unordered 2019-07-08 11:49:38 3 [Note] WSREP: ####### drain monitors upto 1523 2019-07-08 11:49:38 3 [Note] WSREP: ####### My UUID: 504edafd-a15d-11e9-a5ef-4714459ede7a 2019-07-08 11:49:38 3 [Note] WSREP: ####### ST not required 2019-07-08 11:49:38 3 [Note] WSREP: ================================================ View: id: e3c49d03-a155-11e9-80eb-a614fcadb109:-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: 504edafd-a15d-11e9-a5ef-4714459ede7a, cnt7glr11.localdomain ================================================= 2019-07-08 11:49:38 3 [Note] WSREP: Non-primary view 2019-07-08 11:49:38 3 [Note] WSREP: Server status change joined -> connected 2019-07-08 11:49:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 3 [Note] WSREP: ####### processing CC -1, local, unordered 2019-07-08 11:49:38 3 [Note] WSREP: ####### drain monitors upto 1523 2019-07-08 11:49:38 3 [Note] WSREP: ####### My UUID: 504edafd-a15d-11e9-a5ef-4714459ede7a 2019-07-08 11:49:38 3 [Note] WSREP: ####### ST not required 2019-07-08 11:49:38 3 [Note] WSREP: ================================================ View: id: e3c49d03-a155-11e9-80eb-a614fcadb109:-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): ================================================= 2019-07-08 11:49:38 3 [Note] WSREP: Non-primary view 2019-07-08 11:49:38 3 [Note] WSREP: Server status change connected -> disconnected 2019-07-08 11:49:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-08 11:49:38 0 [Note] WSREP: Service thread queue flushed. 2019-07-08 11:49:38 3 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 4 2019-07-08 11:49:38 3 [Note] WSREP: Applier thread exiting ret: 0 thd: 3 2019-07-08 11:49:38 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)