CURRENT_TEST: galera_3nodes.galera_certification_ccc 2019-02-18 18:34:24 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2019-02-18 18:34:24 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on 2019-02-18 18:34:24 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld (mysqld 10.3.13-MariaDB-debug-log) starting as process 63769 ... 2019-02-18 18:34:24 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4186) 2019-02-18 18:34:24 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2019-02-18 18:34:24 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. 2019-02-18 18:34:24 0 [Note] WSREP: Read nil XID from storage engines, skipping position init 2019-02-18 18:34:24 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm_3.so' 2019-02-18 18:34:24 0 [Note] WSREP: wsrep_load(): Galera 25.3.25(r3836) by Codership Oy loaded successfully. 2019-02-18 18:34:24 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-02-18 18:34:24 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data//grastate.dat' 2019-02-18 18:34:24 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 2019-02-18 18:34:24 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; cert.log_conflicts = no; cert.optimistic_pa = yes; dbug = ; 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.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3/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.re 2019-02-18 18:34:24 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1 2019-02-18 18:34:24 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2019-02-18 18:34:24 0 [Note] WSREP: wsrep_sst_grab() 2019-02-18 18:34:24 0 [Note] WSREP: Start replication 2019-02-18 18:34:24 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2019-02-18 18:34:24 0 [Note] WSREP: protonet asio version 0 2019-02-18 18:34:24 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-02-18 18:34:24 0 [Note] WSREP: backend: asio 2019-02-18 18:34:24 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-02-18 18:34:24 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data//gvwstate.dat) failed(No such file or directory) 2019-02-18 18:34:24 0 [Note] WSREP: restore pc from disk failed 2019-02-18 18:34:24 0 [Note] WSREP: GMCast version 0 2019-02-18 18:34:24 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2019-02-18 18:34:24 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2019-02-18 18:34:24 0 [Note] WSREP: EVS version 0 2019-02-18 18:34:24 0 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '127.0.0.1:16003' 2019-02-18 18:34:24 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') connection established to 0d573e32 tcp://127.0.0.1:16003 2019-02-18 18:34:24 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:16006 2019-02-18 18:34:25 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') connection established to 0d5a7b96 tcp://127.0.0.1:16006 2019-02-18 18:34:25 0 [Note] WSREP: declaring 0d573e32 at tcp://127.0.0.1:16003 stable 2019-02-18 18:34:25 0 [Note] WSREP: declaring 0d5a7b96 at tcp://127.0.0.1:16006 stable 2019-02-18 18:34:25 0 [Note] WSREP: Node 0d573e32 state prim 2019-02-18 18:34:25 0 [Note] WSREP: view(view_id(PRIM,0d573e32,2) memb { 0d573e32,0 0d5a7b96,0 0d5ed38f,0 } joined { } left { } partitioned { }) 2019-02-18 18:34:25 0 [Note] WSREP: save pc into disk 2019-02-18 18:34:25 0 [Note] WSREP: gcomm: connected 2019-02-18 18:34:25 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-02-18 18:34:25 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-02-18 18:34:25 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-02-18 18:34:25 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2019-02-18 18:34:25 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-02-18 18:34:25 0 [Note] WSREP: Waiting for SST to complete. 2019-02-18 18:34:25 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 0da8e16a-339b-11e9-8f06-06a70c5cbc15 2019-02-18 18:34:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0da8e16a-339b-11e9-8f06-06a70c5cbc15 from 0 (cnt7glr11.localdomain) 2019-02-18 18:34:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0da8e16a-339b-11e9-8f06-06a70c5cbc15 from 2 (cnt7glr11.localdomain) 2019-02-18 18:34:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0da8e16a-339b-11e9-8f06-06a70c5cbc15 from 1 (cnt7glr11.localdomain) 2019-02-18 18:34:25 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 = 0d583b6f-339b-11e9-aad9-fb8787bbc115 2019-02-18 18:34:25 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-02-18 18:34:25 0 [Note] WSREP: Trying to continue unpaused monitor 2019-02-18 18:34:25 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0) 2019-02-18 18:34:25 2 [Note] WSREP: State transfer required: Group state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:0 Local state: 00000000-0000-0000-0000-000000000000:-1 2019-02-18 18:34:25 2 [Note] WSREP: New cluster view: global state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:0, view# 2: Primary, number of nodes: 3, my index: 2, protocol version 3 2019-02-18 18:34:25 2 [Warning] WSREP: Gap in state sequence. Need state transfer. 2019-02-18 18:34:25 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16011' --datadir '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/' --defaults-file '/home/stepan/mariadb/10.3/mysql-test/var/my.cnf' --defaults-group-suffix '.3' --parent '63769' '' --binlog-index 'mysqld-bin.index'' 2019-02-18 18:34:25 2 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:16011/rsync_sst 2019-02-18 18:34:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:34:25 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-02-18 18:34:25 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4 2019-02-18 18:34:25 0 [Note] WSREP: Service thread queue flushed. 2019-02-18 18:34:25 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (0d583b6f-339b-11e9-aad9-fb8787bbc115): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482 at galera/src/replicator_str.cpp:prepare_state_request():535. IST will be unavailable. 2019-02-18 18:34:25 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-02-18 18:34:25 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-02-18 18:34:25 2 [Note] WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable). Will keep retrying every 1 second(s) 2019-02-18 18:34:26 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-02-18 18:34:27 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 1.0 (cnt7glr11.localdomain) complete. 2019-02-18 18:34:27 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. 2019-02-18 18:34:27 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-02-18 18:34:27 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) 2019-02-18 18:34:27 2 [Note] WSREP: Requesting state transfer: success after 3 tries, donor: 0 2019-02-18 18:34:27 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 0d583b6f-339b-11e9-aad9-fb8787bbc115:0 2019-02-18 18:34:28 0 [Note] WSREP: (0d5ed38f, 'tcp://0.0.0.0:16009') turning message relay requesting off 2019-02-18 18:34:28 0 [Note] WSREP: 1.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2019-02-18 18:34:28 0 [Note] WSREP: Member 1.0 (cnt7glr11.localdomain) synced with group. 2019-02-18 18:34:29 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 2.0 (cnt7glr11.localdomain) complete. 2019-02-18 18:34:29 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 63913 (20190218 18:34:29.032) WSREP_SST: [INFO] Joiner cleanup done. (20190218 18:34:29.541) 2019-02-18 18:34:29 0 [Note] WSREP: SST complete, seqno: 0 2019-02-18 18:34:29 0 [Note] Plugin 'partition' is disabled. 2019-02-18 18:34:29 0 [Note] InnoDB: Using Linux native AIO 2019-02-18 18:34:29 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-18 18:34:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-18 18:34:29 0 [Note] InnoDB: Uses event mutexes 2019-02-18 18:34:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-02-18 18:34:29 0 [Note] InnoDB: Number of pools: 1 2019-02-18 18:34:29 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-18 18:34:29 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2019-02-18 18:34:29 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-18 18:34:29 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-18 18:34:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1642606 2019-02-18 18:34:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-18 18:34:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-18 18:34:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-18 18:34:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-18 18:34:29 0 [Note] InnoDB: Waiting for purge to start 2019-02-18 18:34:29 0 [Note] InnoDB: 10.3.13 started; log sequence number 1642615; transaction id 34 2019-02-18 18:34:29 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:34:29 0 [Note] Plugin 'SEQUENCE' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2019-02-18 18:34:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190218 18:34:29 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_CMP' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'user_variables' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2019-02-18 18:34:29 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2019-02-18 18:34:29 0 [Warning] /home/stepan/mariadb/10.3/sql/mysqld: unknown option '--loose-pam-debug' 2019-02-18 18:34:29 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-18 18:34:29 0 [Note] WSREP: Signalling provider to continue. 2019-02-18 18:34:29 0 [Note] WSREP: SST received: 0d583b6f-339b-11e9-aad9-fb8787bbc115:0 2019-02-18 18:34:29 0 [Note] Reading of all Master_info entries succeded 2019-02-18 18:34:29 0 [Note] Added new Master_info '' to hash table 2019-02-18 18:34:29 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld: ready for connections. Version: '10.3.13-MariaDB-debug-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2019-02-18 18:34:29 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2019-02-18 18:34:29 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 0) 2019-02-18 18:34:29 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2019-02-18 18:34:29 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 2019-02-18 18:34:29 2 [Note] WSREP: Synchronized with group, ready for connections 2019-02-18 18:34:29 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:43:22 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-02-18 18:43:22 0 [Note] WSREP: Stop replication 2019-02-18 18:43:22 0 [Note] WSREP: Closing send monitor... 2019-02-18 18:43:22 0 [Note] WSREP: Closed send monitor. 2019-02-18 18:43:22 0 [Note] WSREP: gcomm: terminating thread 2019-02-18 18:43:22 0 [Note] WSREP: gcomm: joining thread 2019-02-18 18:43:22 0 [Note] WSREP: gcomm: closing backend 2019-02-18 18:43:22 0 [Note] WSREP: view(view_id(NON_PRIM,0d573e32,2) memb { 0d5ed38f,0 } joined { } left { } partitioned { 0d573e32,0 0d5a7b96,0 }) 2019-02-18 18:43:22 0 [Note] WSREP: view((empty)) 2019-02-18 18:43:22 0 [Note] WSREP: gcomm: closed 2019-02-18 18:43:22 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2019-02-18 18:43:22 0 [Note] WSREP: Flow-control interval: [16, 16] 2019-02-18 18:43:22 0 [Note] WSREP: Trying to continue unpaused monitor 2019-02-18 18:43:22 0 [Note] WSREP: Received NON-PRIMARY. 2019-02-18 18:43:22 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 273) 2019-02-18 18:43:22 0 [Note] WSREP: Received self-leave message. 2019-02-18 18:43:22 0 [Note] WSREP: Flow-control interval: [0, 0] 2019-02-18 18:43:22 0 [Note] WSREP: Trying to continue unpaused monitor 2019-02-18 18:43:22 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2019-02-18 18:43:22 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 273) 2019-02-18 18:43:22 0 [Note] WSREP: RECV thread exiting 0: Success 2019-02-18 18:43:22 2 [Note] WSREP: New cluster view: global state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:273, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2019-02-18 18:43:22 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:43:22 2 [Note] WSREP: New cluster view: global state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:273, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2019-02-18 18:43:22 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:43:22 0 [Note] WSREP: recv_thread() joined. 2019-02-18 18:43:22 0 [Note] WSREP: Closing replication queue. 2019-02-18 18:43:22 0 [Note] WSREP: Closing slave action queue. 2019-02-18 18:43:22 2 [Note] WSREP: applier thread exiting (code:0) 2019-02-18 18:43:24 1 [Note] WSREP: rollbacker thread exiting 2019-02-18 18:43:24 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-02-18 18:43:24 0 [Note] InnoDB: FTS optimize thread exiting. 2019-02-18 18:43:24 0 [Note] WSREP: dtor state: CLOSED 2019-02-18 18:43:24 0 [Note] WSREP: mon: entered 273 oooe fraction 0 oool fraction 0 2019-02-18 18:43:24 0 [Note] WSREP: mon: entered 273 oooe fraction 0.018315 oool fraction 0 2019-02-18 18:43:24 0 [Note] WSREP: mon: entered 280 oooe fraction 0 oool fraction 0.00357143 2019-02-18 18:43:24 0 [Note] WSREP: cert index usage at exit 0 2019-02-18 18:43:24 0 [Note] WSREP: cert trx map usage at exit 18 2019-02-18 18:43:24 0 [Note] WSREP: deps set usage at exit 0 2019-02-18 18:43:24 0 [Note] WSREP: avg deps dist 61.1099 2019-02-18 18:43:24 0 [Note] WSREP: avg cert interval 0 2019-02-18 18:43:24 0 [Note] WSREP: cert index size 20 2019-02-18 18:43:24 0 [Note] WSREP: Service thread queue flushed. 2019-02-18 18:43:24 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2019-02-18 18:43:24 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.522222, misses: 43, in use: 0, in pool: 43 trx map: conn query map: 2019-02-18 18:43:24 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.530055, misses: 86, in use: 0, in pool: 86 2019-02-18 18:43:24 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 273) 2019-02-18 18:43:24 0 [Note] WSREP: Flushing memory map to disk... 2019-02-18 18:43:24 0 [Note] InnoDB: Starting shutdown... 2019-02-18 18:43:24 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:43:24 0 [Note] InnoDB: Instance 0, restricted to 128 pages due to innodb_buf_pool_dump_pct=25 2019-02-18 18:43:24 0 [Note] InnoDB: Buffer pool(s) dump completed at 190218 18:43:24 2019-02-18 18:43:26 0 [Note] InnoDB: Shutdown completed; log sequence number 1896166; transaction id 580 2019-02-18 18:43:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-02-18 18:43:26 0 [Note] Debug sync points hit: 12073 2019-02-18 18:43:26 0 [Note] Debug sync points executed: 0 2019-02-18 18:43:26 0 [Note] Debug sync points max active per thread: 0 2019-02-18 18:43:26 0 [Note] /home/stepan/mariadb/10.3/sql/mysqld: Shutdown complete 2019-02-18 18:44:18 0 [Warning] You need to use --log-bin to make --binlog-format work. 2019-02-18 18:44:18 0 [Note] InnoDB: Using Linux native AIO 2019-02-18 18:44:18 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-18 18:44:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-18 18:44:18 0 [Note] InnoDB: Uses event mutexes 2019-02-18 18:44:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-02-18 18:44:18 0 [Note] InnoDB: Number of pools: 1 2019-02-18 18:44:18 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-18 18:44:18 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3 (disabling future attempts) 2019-02-18 18:44:18 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-02-18 18:44:18 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-18 18:44:18 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-18 18:44:18 0 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=1896175 2019-02-18 18:44:18 0 [Note] InnoDB: Starting to delete and rewrite log files. 2019-02-18 18:44:18 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2019-02-18 18:44:18 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2019-02-18 18:44:18 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-02-18 18:44:18 0 [Note] InnoDB: New log files created, LSN=1896175 2019-02-18 18:44:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-18 18:44:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-18 18:44:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-18 18:44:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-18 18:44:18 0 [Note] InnoDB: Waiting for purge to start 2019-02-18 18:44:18 0 [Note] InnoDB: 10.4.3 started; log sequence number 1896175; transaction id 582 2019-02-18 18:44:18 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:44:18 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-18 18:44:18 0 [Note] InnoDB: Buffer pool(s) load completed at 190218 18:44:18 2019-02-18 18:44:18 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-18 18:44:18 0 [Note] Reading of all Master_info entries succeded 2019-02-18 18:44:18 0 [Note] Added new Master_info '' to hash table 2019-02-18 18:44:18 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: ready for connections. Version: '10.4.3-MariaDB-debug-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2019-02-18 18:47:37 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-02-18 18:47:37 0 [Note] InnoDB: FTS optimize thread exiting. 2019-02-18 18:47:37 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-02-18 18:47:37 0 [Note] InnoDB: Starting shutdown... 2019-02-18 18:47:37 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:47:37 0 [Note] InnoDB: Buffer pool(s) dump completed at 190218 18:47:37 2019-02-18 18:47:38 0 [Note] InnoDB: Shutdown completed; log sequence number 1897537; transaction id 591 2019-02-18 18:47:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-02-18 18:47:38 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: Shutdown complete 2019-02-18 18:50:05 0 [Warning] You need to use --log-bin to make --binlog-format work. 2019-02-18 18:50:05 0 [Note] InnoDB: Using Linux native AIO 2019-02-18 18:50:05 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-18 18:50:05 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-18 18:50:05 0 [Note] InnoDB: Uses event mutexes 2019-02-18 18:50:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-02-18 18:50:05 0 [Note] InnoDB: Number of pools: 1 2019-02-18 18:50:05 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-18 18:50:05 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3 (disabling future attempts) 2019-02-18 18:50:05 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-02-18 18:50:05 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-18 18:50:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-18 18:50:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-18 18:50:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-18 18:50:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-18 18:50:05 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-18 18:50:05 0 [Note] InnoDB: Waiting for purge to start 2019-02-18 18:50:06 0 [Note] InnoDB: 10.4.3 started; log sequence number 1897537; transaction id 593 2019-02-18 18:50:06 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:50:06 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-18 18:50:06 0 [Note] InnoDB: Buffer pool(s) load completed at 190218 18:50:06 2019-02-18 18:50:06 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-18 18:50:06 0 [Note] Reading of all Master_info entries succeded 2019-02-18 18:50:06 0 [Note] Added new Master_info '' to hash table 2019-02-18 18:50:06 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: ready for connections. Version: '10.4.3-MariaDB-debug-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2019-02-18 18:51:12 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2019-02-18 18:51:12 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-02-18 18:51:12 0 [Note] InnoDB: FTS optimize thread exiting. 2019-02-18 18:51:12 0 [Note] InnoDB: Starting shutdown... 2019-02-18 18:51:12 0 [Note] InnoDB: Dumping buffer pool(s) to /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:51:12 0 [Note] InnoDB: Buffer pool(s) dump completed at 190218 18:51:12 2019-02-18 18:51:13 0 [Note] InnoDB: Shutdown completed; log sequence number 1897546; transaction id 594 2019-02-18 18:51:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-02-18 18:51:13 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: Shutdown complete 2019-02-18 18:53:57 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.0(r4477) by Codership Oy loaded successfully. 2019-02-18 18:53:57 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-02-18 18:53:57 0 [Note] WSREP: Found saved state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:273, safe_to_bootstrap: 0 2019-02-18 18:53:57 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 0d583b6f-339b-11e9-aad9-fb8787bbc115 Seqno: 1 - 273 Offset: 1280 Synced: 1 2019-02-18 18:53:57 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 0d583b6f-339b-11e9-aad9-fb8787bbc115, offset: 1280 2019-02-18 18:53:57 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2019-02-18 18:53:57 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2019-02-18 18:53:57 0 [Note] WSREP: Recovering GCache ring buffer: didn't recover any events. 2019-02-18 18:53:57 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; cert.log_conflicts = no; cert.optimistic_pa = yes; dbug = ; 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.debug = 0; gcache.dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data//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_thro 2019-02-18 18:53:57 0 [Note] WSREP: GCache history reset: old(0d583b6f-339b-11e9-aad9-fb8787bbc115:0 -> 0d583b6f-339b-11e9-aad9-fb8787bbc115:273 2019-02-18 18:53:57 0 [Note] WSREP: Start replication 2019-02-18 18:53:57 0 [Note] WSREP: Connecting with bootstrap option: 0 2019-02-18 18:53:57 0 [Note] WSREP: Setting GCS initial position to 0d583b6f-339b-11e9-aad9-fb8787bbc115:273 2019-02-18 18:53:57 0 [Note] WSREP: protonet asio version 0 2019-02-18 18:53:57 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-02-18 18:53:57 0 [Note] WSREP: backend: asio 2019-02-18 18:53:57 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-02-18 18:53:57 0 [Warning] WSREP: access file(/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data//gvwstate.dat) failed(No such file or directory) 2019-02-18 18:53:57 0 [Note] WSREP: restore pc from disk failed 2019-02-18 18:53:57 0 [Note] WSREP: GMCast version 0 2019-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2019-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2019-02-18 18:53:57 0 [Note] WSREP: EVS version 1 2019-02-18 18:53:57 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-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to c829a633 tcp://127.0.0.1:16009 2019-02-18 18:53:57 0 [Warning] WSREP: (c829a633, 'tcp://0.0.0.0:16009') address 'tcp://127.0.0.1:16009' points to own listening address, blacklisting 2019-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to 0d573e32 tcp://127.0.0.1:16003 2019-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2019-02-18 18:53:57 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to 0d5a7b96 tcp://127.0.0.1:16006 2019-02-18 18:53:57 0 [Note] WSREP: declaring 0d573e32 at tcp://127.0.0.1:16003 stable 2019-02-18 18:53:57 0 [Note] WSREP: declaring 0d5a7b96 at tcp://127.0.0.1:16006 stable 2019-02-18 18:53:57 0 [Note] WSREP: Node 0d573e32 state prim 2019-02-18 18:53:57 0 [Note] WSREP: view(view_id(PRIM,0d573e32,4) memb { 0d573e32,0 0d5a7b96,0 c829a633,0 } joined { } left { } partitioned { }) 2019-02-18 18:53:57 0 [Note] WSREP: save pc into disk 2019-02-18 18:53:58 0 [Note] WSREP: gcomm: connected 2019-02-18 18:53:58 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-02-18 18:53:58 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-02-18 18:53:58 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-02-18 18:53:58 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2019-02-18 18:53:58 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-02-18 18:53:58 0 [Note] WSREP: STATE EXCHANGE: sent state msg: c8776816-339d-11e9-b60f-2f00950b329b 2019-02-18 18:53:58 0 [Note] WSREP: STATE EXCHANGE: got state msg: c8776816-339d-11e9-b60f-2f00950b329b from 0 (cnt7glr11.localdomain) 2019-02-18 18:53:58 0 [Note] WSREP: STATE EXCHANGE: got state msg: c8776816-339d-11e9-b60f-2f00950b329b from 1 (cnt7glr11.localdomain) 2019-02-18 18:53:58 0 [Note] WSREP: STATE EXCHANGE: got state msg: c8776816-339d-11e9-b60f-2f00950b329b from 2 (cnt7glr11.localdomain) 2019-02-18 18:53:58 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 3, members = 3/3 (joined/total), act_id = 273, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 0d583b6f-339b-11e9-aad9-fb8787bbc115 2019-02-18 18:53:58 0 [Note] WSREP: Writing down CC checksum: 4dc417fe ad0901a7 71bc717e fa909255 at offset 312 2019-02-18 18:53:58 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-02-18 18:53:58 0 [Note] WSREP: Trying to continue unpaused monitor 2019-02-18 18:53:58 0 [Note] WSREP: Restored state OPEN -> JOINED (273) 2019-02-18 18:53:58 3 [Note] WSREP: Starting applier thread 3 2019-02-18 18:53:58 3 [Note] WSREP: ####### processing CC 273, local, unordered 2019-02-18 18:53:58 3 [Note] WSREP: ####### drain monitors upto -1 2019-02-18 18:53:58 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2019-02-18 18:53:58 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 273) 2019-02-18 18:53:58 3 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-02-18 18:53:58 3 [Note] WSREP: ####### My UUID: c829a633-339d-11e9-843d-17b154b6314a 2019-02-18 18:53:58 3 [Note] WSREP: Server cnt7glr11.localdomain connected to cluster at position 0d583b6f-339b-11e9-aad9-fb8787bbc115:273 with ID c829a633-339d-11e9-843d-17b154b6314a 2019-02-18 18:53:58 3 [Note] WSREP: Server status change disconnected -> connected 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 3 [Note] WSREP: ####### ST not required 2019-02-18 18:53:58 3 [Note] WSREP: Cert index reset to 0d583b6f-339b-11e9-aad9-fb8787bbc115:273 (proto: 9), state transfer needed: no 2019-02-18 18:53:58 0 [Note] WSREP: Service thread queue flushed. 2019-02-18 18:53:58 3 [Note] WSREP: ####### Assign initial position for certification: 0d583b6f-339b-11e9-aad9-fb8787bbc115:273, protocol version: 4 2019-02-18 18:53:58 3 [Note] WSREP: ================================================ View: id: 0d583b6f-339b-11e9-aad9-fb8787bbc115:273 seqno: 4 status: 0 protocol_version: 3 own_index: 2 final: 0 members 2019-02-18 18:53:58 3 [Note] WSREP: id: 0d573e32-339b-11e9-a10e-af92bbe41c6d name: cnt7glr11.localdomain 2019-02-18 18:53:58 3 [Note] WSREP: id: 0d5a7b96-339b-11e9-82fd-0266789e1d58 name: cnt7glr11.localdomain 2019-02-18 18:53:58 3 [Note] WSREP: id: c829a633-339d-11e9-843d-17b154b6314a name: cnt7glr11.localdomain 2019-02-18 18:53:58 3 [Note] WSREP: ================================================= 2019-02-18 18:53:58 3 [Note] WSREP: Server status change connected -> joiner 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 3 [Note] WSREP: Server status change joiner -> initializing 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 0 [Note] InnoDB: Using Linux native AIO 2019-02-18 18:53:58 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-18 18:53:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-18 18:53:58 0 [Note] InnoDB: Uses event mutexes 2019-02-18 18:53:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-02-18 18:53:58 0 [Note] InnoDB: Number of pools: 1 2019-02-18 18:53:58 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-18 18:53:58 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3 (disabling future attempts) 2019-02-18 18:53:58 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-02-18 18:53:58 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-18 18:53:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-18 18:53:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-18 18:53:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-18 18:53:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-18 18:53:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-18 18:53:58 0 [Note] InnoDB: Waiting for purge to start 2019-02-18 18:53:58 0 [Note] InnoDB: 10.4.3 started; log sequence number 1897546; transaction id 593 2019-02-18 18:53:58 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-18 18:53:58 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-18 18:53:58 0 [Note] InnoDB: Buffer pool(s) load completed at 190218 18:53:58 2019-02-18 18:53:58 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-18 18:53:58 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-02-18 18:53:58 0 [Note] WSREP: Server initialized 2019-02-18 18:53:58 0 [Note] WSREP: Server status change initializing -> initialized 2019-02-18 18:53:58 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 10 [Note] WSREP: Cluster table is empty, not recovering transactions 2019-02-18 18:53:58 3 [Note] WSREP: Server status change initialized -> joined 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:53:58 0 [Note] Reading of all Master_info entries succeded 2019-02-18 18:53:58 0 [Note] Added new Master_info '' to hash table 2019-02-18 18:53:58 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: ready for connections. Version: '10.4.3-MariaDB-debug-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2019-02-18 18:53:58 3 [Note] WSREP: Server cnt7glr11.localdomain synced with group 2019-02-18 18:53:58 3 [Note] WSREP: Server status change joined -> synced 2019-02-18 18:53:58 3 [Note] WSREP: Synchronized with group, ready for connections 2019-02-18 18:53:58 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-18 18:54:00 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection to peer c829a633 with addr tcp://127.0.0.1:16009 timed out, no messages seen in PT3S 2019-02-18 18:54:00 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') turning message relay requesting off mysqld: galera/src/trx_handle.hpp:932: void galera::TrxHandleMaster::finalize(wsrep_seqno_t): Assertion `version() >= WriteSetNG::VER5' failed. 190222 17:42:15 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.4.3-MariaDB-debug-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467703 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f111c000b00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f11a89ecd80 thread_stack 0x49000 /home/stepan/mariadb/10.4/sql/mysqld(my_print_stacktrace+0x40)[0x55b4c1eea324] mysys/stacktrace.c:269(my_print_stacktrace)[0x55b4c1721f65] sigaction.c:0(__restore_rt)[0x7f11befb05d0] :0(__GI_raise)[0x7f11bd29f207] :0(__GI_abort)[0x7f11bd2a08f8] :0(__assert_fail_base)[0x7f11bd298026] :0(__GI___assert_fail)[0x7f11bd2980d2] src/trx_handle.hpp:933(galera::TrxHandleMaster::finalize(long))[0x7f11bb13d3d7] src/replicator_smm.cpp:659(galera::ReplicatorSMM::replicate(galera::TrxHandleMaster&, wsrep_trx_meta*))[0x7f11bb12f935] src/wsrep_provider.cpp:543(galera_certify)[0x7f11bb14c0c8] src/wsrep_provider_v26.cpp:737(wsrep::wsrep_provider_v26::certify(wsrep::client_id, wsrep::ws_handle&, int, wsrep::ws_meta&))[0x55b4c1fa4ab6] src/transaction.cpp:1328(wsrep::transaction::certify_commit(wsrep::unique_lock&))[0x55b4c1f9b18e] src/transaction.cpp:296(wsrep::transaction::before_prepare(wsrep::unique_lock&))[0x55b4c1f976fc] wsrep/client_state.hpp:386(wsrep::client_state::before_prepare())[0x55b4c1622e10] sql/wsrep_trans_observer.h:159(wsrep_before_prepare(THD*, bool))[0x55b4c1723658] sql/handler.cc:1211(prepare_or_error(handlerton*, THD*, bool))[0x55b4c17264be] sql/handler.cc:1560(ha_commit_trans(THD*, bool))[0x55b4c172722e] sql/transaction.cc:313(trans_commit(THD*))[0x55b4c156685e] sql/sql_parse.cc:5849(mysql_execute_command(THD*))[0x55b4c13ea442] sql/sql_parse.cc:8141(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b4c13f150b] sql/sql_parse.cc:7964(wsrep_mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b4c13f0b3a] sql/sql_parse.cc:1804(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b4c13dc8d4] sql/sql_parse.cc:1358(do_command(THD*))[0x55b4c13db221] sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x55b4c1551a36] sql/sql_connect.cc:1303(handle_one_connection)[0x55b4c155177a] pthread_create.c:0(start_thread)[0x7f11befa8dd5] /lib64/libc.so.6(clone+0x6d)[0x7f11bd366ead] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f111c00b5f8): commit Connection ID (thread ID): 14 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file at /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ 2019-02-22 20:44:46 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.0(r4477) by Codership Oy loaded successfully. 2019-02-22 20:44:46 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-02-22 20:44:46 0 [Note] WSREP: Found saved state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:-1, safe_to_bootstrap: 0 2019-02-22 20:44:46 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 0d583b6f-339b-11e9-aad9-fb8787bbc115 Seqno: -1 - -1 Offset: -1 Synced: 0 2019-02-22 20:44:46 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 0d583b6f-339b-11e9-aad9-fb8787bbc115, offset: -1 2019-02-22 20:44:46 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2019-02-22 20:44:46 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2019-02-22 20:44:46 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 274-278 2019-02-22 20:44:46 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/2000 bytes) complete. 2019-02-22 20:44:46 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (2000/2000 bytes) complete. 2019-02-22 20:44:46 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/6 locked buffers 2019-02-22 20:44:46 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 2000/134217728 2019-02-22 20:44:46 0 [Note] WSREP: Passing config to GCS: base_dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/; base_host = 127.0.0.1; base_port = 16009; cert.log_conflicts = no; cert.optimistic_pa = yes; dbug = ; 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.debug = 0; gcache.dir = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data//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_thro 2019-02-22 20:44:46 0 [Note] WSREP: GCache history reset: old(0d583b6f-339b-11e9-aad9-fb8787bbc115:278 -> 0d583b6f-339b-11e9-aad9-fb8787bbc115:-1 2019-02-22 20:44:46 0 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): full reset 2019-02-22 20:44:46 0 [Note] WSREP: Start replication 2019-02-22 20:44:46 0 [Note] WSREP: Connecting with bootstrap option: 0 2019-02-22 20:44:46 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2019-02-22 20:44:46 0 [Note] WSREP: protonet asio version 0 2019-02-22 20:44:46 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-02-22 20:44:46 0 [Note] WSREP: backend: asio 2019-02-22 20:44:46 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-02-22 20:44:46 0 [Note] WSREP: restore pc from disk successfully 2019-02-22 20:44:46 0 [Note] WSREP: GMCast version 0 2019-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') listening at tcp://0.0.0.0:16009 2019-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') multicast: , ttl: 1 2019-02-22 20:44:46 0 [Note] WSREP: EVS version 1 2019-02-22 20:44:46 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-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to c829a633 tcp://127.0.0.1:16009 2019-02-22 20:44:46 0 [Warning] WSREP: (c829a633, 'tcp://0.0.0.0:16009') address 'tcp://127.0.0.1:16009' points to own listening address, blacklisting 2019-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to 0d573e32 tcp://127.0.0.1:16003 2019-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') turning message relay requesting on, nonlive peers: 2019-02-22 20:44:46 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection established to 0d5a7b96 tcp://127.0.0.1:16006 2019-02-22 20:44:46 0 [Note] WSREP: gcomm: connected 2019-02-22 20:44:46 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-02-22 20:44:46 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-02-22 20:44:46 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-02-22 20:44:46 0 [Note] WSREP: declaring 0d573e32 at tcp://127.0.0.1:16003 stable 2019-02-22 20:44:46 0 [Note] WSREP: declaring 0d5a7b96 at tcp://127.0.0.1:16006 stable 2019-02-22 20:44:46 0 [Note] WSREP: Node 0d573e32 state prim 2019-02-22 20:44:46 2 [Note] WSREP: Starting applier thread 2 2019-02-22 20:44:46 0 [Note] WSREP: view(view_id(PRIM,0d573e32,6) memb { 0d573e32,0 0d5a7b96,0 c829a633,0 } joined { } left { } partitioned { }) 2019-02-22 20:44:46 0 [Note] WSREP: save pc into disk 2019-02-22 20:44:46 0 [Note] WSREP: clear restored view 2019-02-22 20:44:46 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2019-02-22 20:44:46 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-02-22 20:44:46 0 [Note] WSREP: STATE EXCHANGE: sent state msg: ed476725-36d1-11e9-977a-e2e72779ce7a 2019-02-22 20:44:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: ed476725-36d1-11e9-977a-e2e72779ce7a from 0 (cnt7glr11.localdomain) 2019-02-22 20:44:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: ed476725-36d1-11e9-977a-e2e72779ce7a from 1 (cnt7glr11.localdomain) 2019-02-22 20:44:46 0 [Note] WSREP: STATE EXCHANGE: got state msg: ed476725-36d1-11e9-977a-e2e72779ce7a from 2 (cnt7glr11.localdomain) 2019-02-22 20:44:46 0 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 5, members = 2/3 (joined/total), act_id = 278, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), vote policy= 1, group UUID = 0d583b6f-339b-11e9-aad9-fb8787bbc115 2019-02-22 20:44:46 0 [Note] WSREP: Writing down CC checksum: a0c88e9a 9c87ffa6 f7ced71e 75552f56 at offset 312 2019-02-22 20:44:46 0 [Note] WSREP: Flow-control interval: [28, 28] 2019-02-22 20:44:46 0 [Note] WSREP: Trying to continue unpaused monitor 2019-02-22 20:44:46 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 278) 2019-02-22 20:44:46 2 [Note] WSREP: ####### processing CC 278, local, unordered 2019-02-22 20:44:46 2 [Note] WSREP: ####### drain monitors upto -1 2019-02-22 20:44:46 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2019-02-22 20:44:46 2 [Note] WSREP: ####### My UUID: c829a633-339d-11e9-843e-17b154b6314a 2019-02-22 20:44:46 2 [Note] WSREP: Server cnt7glr11.localdomain connected to cluster at position 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 with ID c829a633-339d-11e9-843e-17b154b6314a 2019-02-22 20:44:46 2 [Note] WSREP: Server status change disconnected -> connected 2019-02-22 20:44:46 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-22 20:44:46 2 [Note] WSREP: State transfer required: Group state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 Local state: 0d583b6f-339b-11e9-aad9-fb8787bbc115:-1 2019-02-22 20:44:46 2 [Note] WSREP: Server status change connected -> joiner 2019-02-22 20:44:46 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-22 20:44:46 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '127.0.0.1:16011' --datadir '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/' --defaults-file '/home/stepan/mariadb/10.3/mysql-test/var/mysqld.3.cnf' --parent '67889' '' ''' 2019-02-22 20:44:46 2 [Note] WSREP: Prepared SST request: rsync|127.0.0.1:16011/rsync_sst 2019-02-22 20:44:46 2 [Note] WSREP: Cert index reset to 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 (proto: 9), state transfer needed: yes 2019-02-22 20:44:46 0 [Note] WSREP: Service thread queue flushed. 2019-02-22 20:44:46 2 [Note] WSREP: ####### Assign initial position for certification: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278, protocol version: 4 2019-02-22 20:44:46 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state seqno is undefined: 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():576 at galera/src/replicator_str.cpp:prepare_state_request():647. IST will be unavailable. 2019-02-22 20:44:47 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) requested state transfer from '*any*'. Selected 0.0 (cnt7glr11.localdomain)(SYNCED) as donor. 2019-02-22 20:44:47 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 278) 2019-02-22 20:44:47 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2019-02-22 20:44:48 0 [Note] WSREP: 0.0 (cnt7glr11.localdomain): State transfer to 2.0 (cnt7glr11.localdomain) complete. 2019-02-22 20:44:48 0 [Note] WSREP: Member 0.0 (cnt7glr11.localdomain) synced with group. WSREP_SST: [INFO] Joiner cleanup. rsync PID: 67943 (20190222 20:44:49.067) 2019-02-22 20:44:49 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') connection to peer c829a633 with addr tcp://127.0.0.1:16009 timed out, no messages seen in PT3S 2019-02-22 20:44:49 0 [Note] WSREP: (c829a633, 'tcp://0.0.0.0:16009') turning message relay requesting off WSREP_SST: [INFO] Joiner cleanup done. (20190222 20:44:49.579) 2019-02-22 20:44:49 4 [Note] WSREP: SST received 2019-02-22 20:44:49 4 [Note] WSREP: Server status change joiner -> initializing 2019-02-22 20:44:49 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-22 20:44:49 0 [Note] InnoDB: Using Linux native AIO 2019-02-22 20:44:49 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-02-22 20:44:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-22 20:44:49 0 [Note] InnoDB: Uses event mutexes 2019-02-22 20:44:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-02-22 20:44:49 0 [Note] InnoDB: Number of pools: 1 2019-02-22 20:44:49 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-02-22 20:44:49 0 [Note] mysqld: O_TMPFILE is not supported on /home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3 (disabling future attempts) 2019-02-22 20:44:49 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-02-22 20:44:49 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-22 20:44:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-22 20:44:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1898919 2019-02-22 20:44:49 0 [Note] InnoDB: Upgrading redo log: 2*50331648 bytes; LSN=1898937 2019-02-22 20:44:50 0 [Note] InnoDB: Starting to delete and rewrite log files. 2019-02-22 20:44:50 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2019-02-22 20:44:50 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2019-02-22 20:44:50 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-02-22 20:44:50 0 [Note] InnoDB: New log files created, LSN=1898937 2019-02-22 20:44:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-02-22 20:44:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-02-22 20:44:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-22 20:44:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-22 20:44:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-22 20:44:50 0 [Note] InnoDB: Waiting for purge to start 2019-02-22 20:44:50 0 [Note] InnoDB: 10.4.3 started; log sequence number 1898937; transaction id 592 2019-02-22 20:44:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-02-22 20:44:50 0 [Note] Recovering after a crash using tc.log 2019-02-22 20:44:50 0 [Note] Starting crash recovery... 2019-02-22 20:44:50 0 [Note] InnoDB: Loading buffer pool(s) from /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/ib_buffer_pool 2019-02-22 20:44:50 0 [Note] InnoDB: Buffer pool(s) load completed at 190222 20:44:50 2019-02-22 20:44:50 0 [Note] Crash recovery finished. 2019-02-22 20:44:50 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-02-22 20:44:50 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-02-22 20:44:50 0 [Note] WSREP: Server initialized 2019-02-22 20:44:50 0 [Note] WSREP: Server status change initializing -> initialized 2019-02-22 20:44:50 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-22 20:44:50 4 [Note] WSREP: Server status change initialized -> joined 2019-02-22 20:44:50 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-02-22 20:44:50 0 [Note] Reading of all Master_info entries succeded 2019-02-22 20:44:50 0 [Note] Added new Master_info '' to hash table 2019-02-22 20:44:50 0 [Note] /home/stepan/mariadb/10.4/sql/mysqld: ready for connections. Version: '10.4.3-MariaDB-debug-log' socket: '/home/stepan/mariadb/10.3/mysql-test/var/tmp/mysqld.3.sock' port: 16002 Source distribution 2019-02-22 20:44:50 4 [Note] WSREP: Recovered position from storage: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 2019-02-22 20:44:50 4 [Note] WSREP: Recovered view from SST: id: 00000000-0000-0000-0000-000000000000:-1 status: primary prococol_version: 0 capabilities: final: yes own_index: -1 members(0): 2019-02-22 20:44:50 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-02-22 20:44:50 13 [Note] WSREP: Cluster table is empty, not recovering transactions 2019-02-22 20:44:50 4 [Note] WSREP: SST received: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 2019-02-22 20:44:50 2 [Note] WSREP: Resetting GCache seqno map due to seqno gap: -1..278 2019-02-22 20:44:50 2 [Note] WSREP: GCache history reset: old(0d583b6f-339b-11e9-aad9-fb8787bbc115:0 -> 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 2019-02-22 20:44:50 0 [Note] WSREP: Service thread queue flushed. 2019-02-22 20:44:50 2 [Note] WSREP: ####### Assign initial position for certification: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278, protocol version: 4 2019-02-22 20:44:50 2 [Note] WSREP: Installed new state from SST: 0d583b6f-339b-11e9-aad9-fb8787bbc115:278 2019-02-22 20:44:50 0 [Note] WSREP: 2.0 (cnt7glr11.localdomain): State transfer from 0.0 (cnt7glr11.localdomain) complete. 2019-02-22 20:44:50 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 278) 2019-02-22 20:44:50 0 [Note] WSREP: Member 2.0 (cnt7glr11.localdomain) synced with group. 2019-02-22 20:44:50 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 278) 2019-02-22 20:44:50 2 [Note] WSREP: Server cnt7glr11.localdomain synced with group 2019-02-22 20:44:50 2 [Note] WSREP: Server status change joined -> synced 2019-02-22 20:44:50 2 [Note] WSREP: Synchronized with group, ready for connections 2019-02-22 20:44:50 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. mysqld: galera/src/trx_handle.hpp:932: void galera::TrxHandleMaster::finalize(wsrep_seqno_t): Assertion `version() >= WriteSetNG::VER5' failed. 190222 20:57:14 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.4.3-MariaDB-debug-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467703 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f6e5c000b00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f6ef00abd80 thread_stack 0x49000 mysys/stacktrace.c:269(my_print_stacktrace)[0x558bb2060324] sql/signal_handler.cc:168(handle_fatal_signal)[0x558bb1897f65] sigaction.c:0(__restore_rt)[0x7f6ef4ef05d0] :0(__GI_raise)[0x7f6ef31df207] :0(__GI_abort)[0x7f6ef31e08f8] :0(__assert_fail_base)[0x7f6ef31d8026] :0(__GI___assert_fail)[0x7f6ef31d80d2] src/trx_handle.hpp:933(galera::TrxHandleMaster::finalize(long))[0x7f6ef107d3d7] src/replicator_smm.cpp:659(galera::ReplicatorSMM::replicate(galera::TrxHandleMaster&, wsrep_trx_meta*))[0x7f6ef106f935] src/wsrep_provider.cpp:543(galera_certify)[0x7f6ef108c0c8] src/wsrep_provider_v26.cpp:737(wsrep::wsrep_provider_v26::certify(wsrep::client_id, wsrep::ws_handle&, int, wsrep::ws_meta&))[0x558bb211aab6] src/transaction.cpp:1328(wsrep::transaction::certify_commit(wsrep::unique_lock&))[0x558bb211118e] src/transaction.cpp:296(wsrep::transaction::before_prepare(wsrep::unique_lock&))[0x558bb210d6fc] wsrep/client_state.hpp:386(wsrep::client_state::before_prepare())[0x558bb1798e10] sql/wsrep_trans_observer.h:159(wsrep_before_prepare(THD*, bool))[0x558bb1899658] sql/handler.cc:1211(prepare_or_error(handlerton*, THD*, bool))[0x558bb189c4be] sql/handler.cc:1560(ha_commit_trans(THD*, bool))[0x558bb189d22e] sql/transaction.cc:313(trans_commit(THD*))[0x558bb16dc85e] sql/sql_parse.cc:5849(mysql_execute_command(THD*))[0x558bb1560442] sql/sql_parse.cc:8141(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558bb156750b] sql/sql_parse.cc:7964(wsrep_mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558bb1566b3a] sql/sql_parse.cc:1804(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558bb15528d4] sql/sql_parse.cc:1358(do_command(THD*))[0x558bb1551221] sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x558bb16c7a36] sql/sql_connect.cc:1303(handle_one_connection)[0x558bb16c777a] pthread_create.c:0(start_thread)[0x7f6ef4ee8dd5] /lib64/libc.so.6(clone+0x6d)[0x7f6ef32a6ead] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f6e5c015008): commit Connection ID (thread ID): 14 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file at /home/stepan/mariadb/10.3/mysql-test/var/mysqld.3/data/