2019-07-05 18:14:28 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:32 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.2(r4498) by Codership Oy loaded successfully. 2019-07-05 18:14:28 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-07-05 18:14:28 0 [Note] WSREP: Found saved state: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:32, safe_to_bootstrap: 1 2019-07-05 18:14:28 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de Seqno: 5 - 32 Offset: 1280 Synced: 1 2019-07-05 18:14:28 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de, offset: 1280 2019-07-05 18:14:28 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2019-07-05 18:14:28 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2019-07-05 18:14:28 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 5-32 2019-07-05 18:14:28 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/11544 bytes) complete. 2019-07-05 18:14:28 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (11544/11544 bytes) complete. 2019-07-05 18:14:28 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/28 locked buffers 2019-07-05 18:14:28 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 11544/134217728 2019-07-05 18:14:28 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 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.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fal 2019-07-05 18:14:28 0 [Note] WSREP: Start replication 2019-07-05 18:14:28 0 [Note] WSREP: Connecting with bootstrap option: 1 2019-07-05 18:14:28 0 [Note] WSREP: Setting GCS initial position to 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:32 2019-07-05 18:14:28 0 [Note] WSREP: protonet asio version 0 2019-07-05 18:14:28 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-07-05 18:14:28 0 [Note] WSREP: backend: asio 2019-07-05 18:14:28 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-07-05 18:14:28 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2019-07-05 18:14:28 0 [Note] WSREP: restore pc from disk failed 2019-07-05 18:14:28 0 [Note] WSREP: GMCast version 0 2019-07-05 18:14:28 0 [Note] WSREP: (baafee77, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2019-07-05 18:14:28 0 [Note] WSREP: (baafee77, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2019-07-05 18:14:28 0 [Note] WSREP: EVS version 1 2019-07-05 18:14:28 0 [Note] WSREP: gcomm: bootstrapping new group 'my_wsrep_cluster' 2019-07-05 18:14:28 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2019-07-05 18:14:28 0 [Note] WSREP: EVS version upgrade 0 -> 1 2019-07-05 18:14:28 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2019-07-05 18:14:28 0 [Note] WSREP: Node baafee77 state prim 2019-07-05 18:14:28 0 [Note] WSREP: view(view_id(PRIM,baafee77,1) memb { baafee77,0 } joined { } left { } partitioned { }) 2019-07-05 18:14:28 0 [Note] WSREP: save pc into disk 2019-07-05 18:14:28 0 [Note] WSREP: gcomm: connected 2019-07-05 18:14:28 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-07-05 18:14:28 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-07-05 18:14:28 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-07-05 18:14:28 1 [Note] WSREP: Starting applier thread 1 2019-07-05 18:14:28 2 [Note] WSREP: Starting post rollbacker thread 2 2019-07-05 18:14:28 3 [Note] WSREP: Starting rollbacker thread 3 2019-07-05 18:14:28 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2019-07-05 18:14:28 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: bab065d8-9f50-11e9-92d1-e28fe2386467 2019-07-05 18:14:28 0 [Note] WSREP: STATE EXCHANGE: sent state msg: bab065d8-9f50-11e9-92d1-e28fe2386467 2019-07-05 18:14:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: bab065d8-9f50-11e9-92d1-e28fe2386467 from 0 (vt-test) 2019-07-05 18:14:28 0 [Note] WSREP: Quorum results: version = 5, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 32, last_appl. = -1, protocols = 1/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 5e0782b9-9f4d-11e9-b0d5-2205fd1477de 2019-07-05 18:14:28 0 [Note] WSREP: Writing down CC checksum: 062ddd5f bc035110 6a711c21 7f777484 at offset 120 2019-07-05 18:14:28 0 [Note] WSREP: Flow-control interval: [16, 16] 2019-07-05 18:14:28 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-05 18:14:28 0 [Note] WSREP: Restored state OPEN -> JOINED (33) 2019-07-05 18:14:28 1 [Note] WSREP: ####### processing CC 33, local, ordered 2019-07-05 18:14:28 1 [Note] WSREP: ####### drain monitors upto -1 2019-07-05 18:14:28 1 [Note] WSREP: REPL Protocols: 10 (5, 3) 2019-07-05 18:14:28 1 [Note] WSREP: ####### My UUID: baafee77-9f50-11e9-9c3e-3f11ed827ccf 2019-07-05 18:14:28 1 [Note] WSREP: Server vt-test connected to cluster at position 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:33 with ID baafee77-9f50-11e9-9c3e-3f11ed827ccf 2019-07-05 18:14:28 1 [Note] WSREP: Server status change disconnected -> connected 2019-07-05 18:14:28 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:28 1 [Note] WSREP: ####### ST not required 2019-07-05 18:14:28 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:0 (proto: 10), state transfer needed: no 2019-07-05 18:14:28 0 [Note] WSREP: Service thread queue flushed. 2019-07-05 18:14:28 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:0, protocol version: 5 2019-07-05 18:14:28 1 [Note] WSREP: ####### Adjusting cert position: 0 -> 33 2019-07-05 18:14:28 0 [Note] WSREP: Service thread queue flushed. 2019-07-05 18:14:28 1 [Note] WSREP: ####### Setting monitor position to 33 2019-07-05 18:14:28 0 [Note] WSREP: Member 0.0 (vt-test) synced with group. 2019-07-05 18:14:28 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 33) 2019-07-05 18:14:28 1 [Note] WSREP: Lowest cert indnex boundary for CC from group: 33 2019-07-05 18:14:28 1 [Note] WSREP: Min available from gcache for CC from group: 5 2019-07-05 18:14:28 1 [Note] WSREP: ================================================ View: id: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:33 status: primary protocol_version: 4 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: baafee77-9f50-11e9-9c3e-3f11ed827ccf, vt-test ================================================= 2019-07-05 18:14:28 1 [Note] WSREP: Server status change connected -> joiner 2019-07-05 18:14:28 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:28 1 [Note] WSREP: Server status change joiner -> initializing 2019-07-05 18:14:28 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:29 0 [Note] Initializing built-in plugins 2019-07-05 18:14:29 0 [Note] Initializing plugins specified on the command line 2019-07-05 18:14:29 0 [Note] InnoDB: Using Linux native AIO 2019-07-05 18:14:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-05 18:14:29 0 [Note] InnoDB: Uses event mutexes 2019-07-05 18:14:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-05 18:14:29 0 [Note] InnoDB: Number of pools: 1 2019-07-05 18:14:29 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-05 18:14:29 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-07-05 18:14:29 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-07-05 18:14:29 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-05 18:14: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-07-05 18:14:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-05 18:14:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-05 18:14:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-05 18:14:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-05 18:14:29 0 [Note] InnoDB: Waiting for purge to start 2019-07-05 18:14:29 0 [Note] InnoDB: 10.4.6 started; log sequence number 242027; transaction id 200 2019-07-05 18:14:29 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-07-05 18:14:29 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-05 18:14:29 0 [Note] Initializing installed plugins 2019-07-05 18:14:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190705 18:14:29 2019-07-05 18:14:29 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-05 18:14:29 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-07-05 18:14:29 0 [Note] WSREP: Server initialized 2019-07-05 18:14:29 0 [Note] WSREP: Server status change initializing -> initialized 2019-07-05 18:14:29 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:29 1 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2019-07-05 18:14:29 11 [Note] WSREP: Recovered cluster id 5e0782b9-9f4d-11e9-b0d5-2205fd1477de 2019-07-05 18:14:29 1 [Note] WSREP: Server status change initialized -> joined 2019-07-05 18:14:29 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:29 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:29 0 [Note] Reading of all Master_info entries succeeded 2019-07-05 18:14:29 0 [Note] Added new Master_info '' to hash table 2019-07-05 18:14:29 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.6-MariaDB-1:10.4.6+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2019-07-05 18:14:29 1 [Note] WSREP: Server vt-test synced with group 2019-07-05 18:14:29 1 [Note] WSREP: Server status change joined -> synced 2019-07-05 18:14:29 1 [Note] WSREP: Synchronized with group, ready for connections 2019-07-05 18:14:29 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:29 14 [Warning] Aborted connection 14 to db: 'mysql' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 23 [Warning] Aborted connection 23 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 27 [Warning] Aborted connection 27 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 29 [Warning] Aborted connection 29 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 30 [Warning] Aborted connection 30 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 31 [Warning] Aborted connection 31 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 36 [Warning] Aborted connection 36 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:29 40 [Warning] Aborted connection 40 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) mysqld: /home/buildbot/buildbot/build/mariadb-10.4.6/wsrep-lib/src/transaction.cpp:456: int wsrep::transaction::ordered_commit(): Assertion `state() == s_committing' failed. 190705 18:14:35 [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.6-MariaDB-1:10.4.6+maria~bionic-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=1 max_threads=102 thread_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760240 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fc59c03abd8 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 = 0x7fc5b015bdd8 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x563a02cf7e0e] /usr/sbin/mysqld(handle_fatal_signal+0x515)[0x563a02770f95] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7fc5c1aa3890] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xc7)[0x7fc5c0db3e97] /lib/x86_64-linux-gnu/libc.so.6(abort+0x141)[0x7fc5c0db5801] /lib/x86_64-linux-gnu/libc.so.6(+0x3039a)[0x7fc5c0da539a] /lib/x86_64-linux-gnu/libc.so.6(+0x30412)[0x7fc5c0da5412] /usr/sbin/mysqld(_ZN5wsrep11transaction14ordered_commitEv+0x225)[0x563a02d744d5] /usr/sbin/mysqld(+0x93628a)[0x563a0285228a] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x1bb)[0x563a0285809b] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbb+0x1d7)[0x563a02858527] /usr/sbin/mysqld(+0x93c5ff)[0x563a028585ff] /usr/sbin/mysqld(+0x93c903)[0x563a02858903] /usr/sbin/mysqld(+0x93ca63)[0x563a02858a63] /usr/sbin/mysqld(_Z17ha_rollback_transP3THDb+0x17c)[0x563a0277493c] /usr/sbin/mysqld(_Z14trans_rollbackP3THD+0x57)[0x563a02656c17] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x375a)[0x563a025643ea] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x34)[0x563a024ca444] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x154)[0x563a024d0e64] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x5b5)[0x563a024d1885] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x9e6)[0x563a024ccd66] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x808)[0x563a024ce0b8] /usr/sbin/mysqld(+0x63de25)[0x563a02559e25] /usr/sbin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x166)[0x563a0255bc96] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1f0b)[0x563a02562b9b] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x563a0256971a] /usr/sbin/mysqld(+0x64df66)[0x563a02569f66] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x217a)[0x563a0256c9ea] /usr/sbin/mysqld(_Z10do_commandP3THD+0x148)[0x563a0256d348] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x2c2)[0x563a02648542] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x563a0264860d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7fc5c1a986db] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc5c0e9688f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fc59c14f480): ROLLBACK Connection ID (thread ID): 41 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=on,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,condition_pushdown_from_having=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... Working directory at /var/lib/mysql Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 3696 3696 processes Max open files 16364 16364 files Max locked memory 16777216 16777216 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 3696 3696 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/usr/share/apport/apport %p %s %c %d %P 2019-07-05 18:14:42 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:36 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.2(r4498) by Codership Oy loaded successfully. 2019-07-05 18:14:42 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-07-05 18:14:42 0 [Note] WSREP: Found saved state: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:-1, safe_to_bootstrap: 1 2019-07-05 18:14:42 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de Seqno: -1 - -1 Offset: -1 Synced: 0 2019-07-05 18:14:42 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de, offset: -1 2019-07-05 18:14:42 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2019-07-05 18:14:42 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2019-07-05 18:14:42 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 5-36 2019-07-05 18:14:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/13360 bytes) complete. 2019-07-05 18:14:42 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (13360/13360 bytes) complete. 2019-07-05 18:14:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/32 locked buffers 2019-07-05 18:14:42 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 13360/134217728 2019-07-05 18:14:42 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 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.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = fal 2019-07-05 18:14:42 0 [Note] WSREP: Start replication 2019-07-05 18:14:42 0 [Note] WSREP: Connecting with bootstrap option: 1 2019-07-05 18:14:42 0 [Note] WSREP: Setting GCS initial position to 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:36 2019-07-05 18:14:42 0 [Note] WSREP: protonet asio version 0 2019-07-05 18:14:42 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-07-05 18:14:42 0 [Note] WSREP: backend: asio 2019-07-05 18:14:42 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-07-05 18:14:42 0 [Note] WSREP: restore pc from disk successfully 2019-07-05 18:14:42 0 [Note] WSREP: GMCast version 0 2019-07-05 18:14:42 0 [Note] WSREP: (baafee77, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2019-07-05 18:14:42 0 [Note] WSREP: (baafee77, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2019-07-05 18:14:42 0 [Note] WSREP: EVS version 1 2019-07-05 18:14:42 0 [Note] WSREP: gcomm: bootstrapping new group 'my_wsrep_cluster' 2019-07-05 18:14:42 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2019-07-05 18:14:42 0 [Note] WSREP: EVS version upgrade 0 -> 1 2019-07-05 18:14:42 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2019-07-05 18:14:42 0 [Note] WSREP: Node baafee77 state prim 2019-07-05 18:14:42 0 [Note] WSREP: view(view_id(PRIM,baafee77,3) memb { baafee77,0 } joined { } left { } partitioned { }) 2019-07-05 18:14:42 0 [Note] WSREP: save pc into disk 2019-07-05 18:14:42 0 [Note] WSREP: clear restored view 2019-07-05 18:14:42 0 [Note] WSREP: gcomm: connected 2019-07-05 18:14:42 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-07-05 18:14:42 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-07-05 18:14:42 0 [Note] WSREP: Opened channel 'my_wsrep_cluster' 2019-07-05 18:14:42 1 [Note] WSREP: Starting applier thread 1 2019-07-05 18:14:42 2 [Note] WSREP: Starting post rollbacker thread 2 2019-07-05 18:14:42 3 [Note] WSREP: Starting rollbacker thread 3 2019-07-05 18:14:42 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2019-07-05 18:14:42 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: c30090c2-9f50-11e9-9e5e-0bf180e1de83 2019-07-05 18:14:42 0 [Note] WSREP: STATE EXCHANGE: sent state msg: c30090c2-9f50-11e9-9e5e-0bf180e1de83 2019-07-05 18:14:42 0 [Note] WSREP: STATE EXCHANGE: got state msg: c30090c2-9f50-11e9-9e5e-0bf180e1de83 from 0 (vt-test) 2019-07-05 18:14:42 0 [Note] WSREP: Quorum results: version = 5, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 36, last_appl. = -1, protocols = 1/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 5e0782b9-9f4d-11e9-b0d5-2205fd1477de 2019-07-05 18:14:42 0 [Note] WSREP: Writing down CC checksum: a00cf13a 77b5b17e 0e29ed2e e19d4a04 at offset 120 2019-07-05 18:14:42 0 [Note] WSREP: Flow-control interval: [16, 16] 2019-07-05 18:14:42 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-05 18:14:42 0 [Note] WSREP: Restored state OPEN -> JOINED (37) 2019-07-05 18:14:42 1 [Note] WSREP: ####### processing CC 37, local, ordered 2019-07-05 18:14:42 1 [Note] WSREP: ####### drain monitors upto -1 2019-07-05 18:14:42 1 [Note] WSREP: REPL Protocols: 10 (5, 3) 2019-07-05 18:14:42 1 [Note] WSREP: ####### My UUID: baafee77-9f50-11e9-9c3f-3f11ed827ccf 2019-07-05 18:14:42 1 [Note] WSREP: Server vt-test connected to cluster at position 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:37 with ID baafee77-9f50-11e9-9c3f-3f11ed827ccf 2019-07-05 18:14:42 1 [Note] WSREP: Server status change disconnected -> connected 2019-07-05 18:14:42 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:42 1 [Note] WSREP: ####### ST not required 2019-07-05 18:14:42 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:0 (proto: 10), state transfer needed: no 2019-07-05 18:14:42 0 [Note] WSREP: Service thread queue flushed. 2019-07-05 18:14:42 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:0, protocol version: 5 2019-07-05 18:14:42 1 [Note] WSREP: ####### Adjusting cert position: 0 -> 37 2019-07-05 18:14:42 0 [Note] WSREP: Service thread queue flushed. 2019-07-05 18:14:42 1 [Note] WSREP: ####### Setting monitor position to 37 2019-07-05 18:14:42 0 [Note] WSREP: Member 0.0 (vt-test) synced with group. 2019-07-05 18:14:42 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 37) 2019-07-05 18:14:42 1 [Note] WSREP: Lowest cert indnex boundary for CC from group: 37 2019-07-05 18:14:42 1 [Note] WSREP: Min available from gcache for CC from group: 5 2019-07-05 18:14:42 1 [Note] WSREP: ================================================ View: id: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:37 status: primary protocol_version: 4 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: baafee77-9f50-11e9-9c3f-3f11ed827ccf, vt-test ================================================= 2019-07-05 18:14:42 1 [Note] WSREP: Server status change connected -> joiner 2019-07-05 18:14:42 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:42 1 [Note] WSREP: Server status change joiner -> initializing 2019-07-05 18:14:42 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:42 0 [Note] Initializing built-in plugins 2019-07-05 18:14:42 0 [Note] Initializing plugins specified on the command line 2019-07-05 18:14:42 0 [Note] InnoDB: Using Linux native AIO 2019-07-05 18:14:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-05 18:14:42 0 [Note] InnoDB: Uses event mutexes 2019-07-05 18:14:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-05 18:14:42 0 [Note] InnoDB: Number of pools: 1 2019-07-05 18:14:42 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-05 18:14:42 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-07-05 18:14:42 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-07-05 18:14:42 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-05 18:14:42 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-05 18:14:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-05 18:14:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-05 18:14:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-05 18:14:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-05 18:14:43 0 [Note] InnoDB: Waiting for purge to start 2019-07-05 18:14:43 0 [Note] InnoDB: 10.4.6 started; log sequence number 250193; transaction id 213 2019-07-05 18:14:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-07-05 18:14:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-05 18:14:43 0 [Note] Initializing installed plugins 2019-07-05 18:14:43 0 [Note] InnoDB: Buffer pool(s) load completed at 190705 18:14:43 2019-07-05 18:14:43 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-07-05 18:14:43 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-07-05 18:14:43 0 [Note] WSREP: Server initialized 2019-07-05 18:14:43 0 [Note] WSREP: Server status change initializing -> initialized 2019-07-05 18:14:43 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:43 1 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 2019-07-05 18:14:43 11 [Note] WSREP: Recovered cluster id 5e0782b9-9f4d-11e9-b0d5-2205fd1477de 2019-07-05 18:14:43 1 [Note] WSREP: Server status change initialized -> joined 2019-07-05 18:14:43 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:43 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:43 0 [Note] Reading of all Master_info entries succeeded 2019-07-05 18:14:43 0 [Note] Added new Master_info '' to hash table 2019-07-05 18:14:43 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.6-MariaDB-1:10.4.6+maria~bionic-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2019-07-05 18:14:43 1 [Note] WSREP: Server vt-test synced with group 2019-07-05 18:14:43 1 [Note] WSREP: Server status change joined -> synced 2019-07-05 18:14:43 1 [Note] WSREP: Synchronized with group, ready for connections 2019-07-05 18:14:43 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:43 14 [Warning] Aborted connection 14 to db: 'mysql' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 23 [Warning] Aborted connection 23 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 25 [Warning] Aborted connection 25 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 26 [Warning] Aborted connection 26 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 27 [Warning] Aborted connection 27 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 28 [Warning] Aborted connection 28 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 29 [Warning] Aborted connection 29 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 30 [Warning] Aborted connection 30 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 31 [Warning] Aborted connection 31 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 34 [Warning] Aborted connection 34 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 35 [Warning] Aborted connection 35 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 36 [Warning] Aborted connection 36 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 37 [Warning] Aborted connection 37 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 38 [Warning] Aborted connection 38 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:43 40 [Warning] Aborted connection 40 to db: 'unconnected' user: 'root' host: 'localhost' (This connection closed normally) 2019-07-05 18:14:45 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2019-07-05 18:14:45 0 [Note] WSREP: Shutdown replication 2019-07-05 18:14:45 0 [Note] WSREP: Server status change synced -> disconnecting 2019-07-05 18:14:45 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:45 0 [Note] WSREP: Closing send monitor... 2019-07-05 18:14:45 0 [Note] WSREP: Closed send monitor. 2019-07-05 18:14:45 0 [Note] WSREP: gcomm: terminating thread 2019-07-05 18:14:45 0 [Note] WSREP: gcomm: joining thread 2019-07-05 18:14:45 0 [Note] WSREP: gcomm: closing backend 2019-07-05 18:14:45 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2019-07-05 18:14:45 0 [Note] WSREP: view((empty)) 2019-07-05 18:14:45 0 [Note] WSREP: gcomm: closed 2019-07-05 18:14:45 0 [Note] WSREP: Received self-leave message. 2019-07-05 18:14:45 0 [Note] WSREP: Writing down CC checksum: 8a3333e0 ad193310 1d05ba07 95974222 at offset 64 2019-07-05 18:14:45 0 [Note] WSREP: Flow-control interval: [0, 0] 2019-07-05 18:14:45 0 [Note] WSREP: Trying to continue unpaused monitor 2019-07-05 18:14:45 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2019-07-05 18:14:45 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 37) 2019-07-05 18:14:45 0 [Note] WSREP: RECV thread exiting 0: Success 2019-07-05 18:14:45 1 [Note] WSREP: ####### processing CC -1, local, ordered 2019-07-05 18:14:45 1 [Note] WSREP: ####### drain monitors upto 37 2019-07-05 18:14:45 1 [Note] WSREP: ####### My UUID: baafee77-9f50-11e9-9c3f-3f11ed827ccf 2019-07-05 18:14:45 1 [Note] WSREP: ####### ST not required 2019-07-05 18:14:45 0 [Note] WSREP: recv_thread() joined. 2019-07-05 18:14:45 0 [Note] WSREP: Closing replication queue. 2019-07-05 18:14:45 0 [Note] WSREP: Closing slave action queue. 2019-07-05 18:14:45 1 [Note] WSREP: ================================================ View: id: 5e0782b9-9f4d-11e9-b0d5-2205fd1477de:-1 status: non-primary protocol_version: 4 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-05 18:14:45 1 [Note] WSREP: Non-primary view 2019-07-05 18:14:45 1 [Note] WSREP: Server status change disconnecting -> disconnected 2019-07-05 18:14:45 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:45 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-07-05 18:14:45 1 [Note] WSREP: Applier thread exiting ret: 0 thd: 1 2019-07-05 18:14:45 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2019-07-05 18:14:45 3 [Note] WSREP: rollbacker thread exiting 3 2019-07-05 18:14:45 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2019-07-05 18:14:45 2 [Note] WSREP: post rollbacker thread exiting 2 2019-07-05 18:14:45 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2019-07-05 18:14:45 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-05 18:14:45 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-05 18:14:45 0 [Note] WSREP: dtor state: CLOSED 2019-07-05 18:14:45 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2019-07-05 18:14:45 0 [Note] WSREP: apply mon: entered 0 2019-07-05 18:14:45 0 [Note] WSREP: apply mon: entered 0 2019-07-05 18:14:45 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 2019-07-05 18:14:45 0 [Note] WSREP: cert index usage at exit 0 2019-07-05 18:14:45 0 [Note] WSREP: cert trx map usage at exit 0 2019-07-05 18:14:45 0 [Note] WSREP: deps set usage at exit 0 2019-07-05 18:14:45 0 [Note] WSREP: avg deps dist 0 2019-07-05 18:14:45 0 [Note] WSREP: avg cert interval 0 2019-07-05 18:14:45 0 [Note] WSREP: cert index size 0 2019-07-05 18:14:45 0 [Note] WSREP: Service thread queue flushed. 2019-07-05 18:14:45 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 2019-07-05 18:14:45 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2019-07-05 18:14:45 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 37) 2019-07-05 18:14:45 0 [Note] WSREP: Flushing memory map to disk... 2019-07-05 18:14:45 0 [Note] InnoDB: Starting shutdown... 2019-07-05 18:14:45 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2019-07-05 18:14:45 0 [Note] InnoDB: Buffer pool(s) dump completed at 190705 18:14:45 2019-07-05 18:14:46 0 [Note] InnoDB: Shutdown completed; log sequence number 254338; transaction id 224 2019-07-05 18:14:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-05 18:14:46 0 [Note] /usr/sbin/mysqld: Shutdown complete