2020-07-02 6:30:43 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-07-02 6:30:43 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 830570695) 2020-07-02 6:30:43 2 [Note] WSREP: ####### processing CC 830570695, local, ordered 2020-07-02 6:30:43 2 [Note] WSREP: Process first view: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb my uuid: 98209ae5-bb78-11ea-9bce-c7f5b725a4ba 2020-07-02 6:30:43 2 [Note] WSREP: Server SRV2 connected to cluster at position 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830570695 with ID 98209ae5-bb78-11ea-9bce-c7f5b725a4ba 2020-07-02 6:30:43 2 [Note] WSREP: Server status change disconnected -> connected 2020-07-02 6:30:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:43 2 [Note] WSREP: ####### My UUID: 98209ae5-bb78-11ea-9bce-c7f5b725a4ba 2020-07-02 6:30:43 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-07-02 6:30:43 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:30:43 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-07-02 6:30:43 2 [Note] WSREP: State transfer required: Group state: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830570695 Local state: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569278 2020-07-02 6:30:43 2 [Note] WSREP: Server status change connected -> joiner 2020-07-02 6:30:43 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:43 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-07-02 6:30:43 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '192.168.148.226' --datadir '/var/lib/mysql/' --parent '5879' --binlog '/var/lib/mysql/master-bin' --binlog-index '/var/lib/mysql/master-bin.index' --mysqld-args --wsrep_start_position=59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569278' WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20200702 06:30:43.420) 2020-07-02 6:30:43 0 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000000 of size 134217728 bytes 2020-07-02 6:30:43 2 [Note] WSREP: Prepared SST request: mariabackup|192.168.148.226:4444/xtrabackup_sst//1 2020-07-02 6:30:43 2 [Note] WSREP: ####### IST uuid:59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb f: 830569279, l: 830570695, STRv: 3 2020-07-02 6:30:43 2 [Note] WSREP: IST receiver addr using tcp://192.168.148.226:4568 2020-07-02 6:30:43 2 [Note] WSREP: Prepared IST receiver for 830569279-830570695, listening at: tcp://192.168.148.226:4568 2020-07-02 6:30:43 0 [Note] WSREP: Member 1.0 (SRV2) requested state transfer from '*any*'. Selected 2.0 (SRV1)(SYNCED) as donor. 2020-07-02 6:30:43 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 830570800) 2020-07-02 6:30:43 2 [Note] WSREP: Requesting state transfer: success, donor: 2 2020-07-02 6:30:44 0 [Note] WSREP: 2.0 (SRV1): State transfer to 1.0 (SRV2) complete. 2020-07-02 6:30:44 0 [Note] WSREP: Member 2.0 (SRV1) synced with group. 2020-07-02 6:30:44 3 [Note] WSREP: SST received 2020-07-02 6:30:44 3 [Note] WSREP: Server status change joiner -> initializing 2020-07-02 6:30:44 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:44 0 [Warning] The parameter innodb_large_prefix is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ 2020-07-02 6:30:44 0 [Note] InnoDB: Using Linux native AIO 2020-07-02 6:30:44 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-07-02 6:30:44 0 [Note] InnoDB: Uses event mutexes 2020-07-02 6:30:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-07-02 6:30:44 0 [Note] InnoDB: Number of pools: 1 2020-07-02 6:30:44 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-07-02 6:30:44 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 4, chunk size = 128M 2020-07-02 6:30:44 0 [Note] InnoDB: Completed initialization of buffer pool 2020-07-02 6:30:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-07-02 6:30:44 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 536870912 bytes 2020-07-02 6:30:44 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 536870912 bytes 2020-07-02 6:30:44 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-07-02 6:30:44 0 [Note] InnoDB: New log files created, LSN=550975749143 2020-07-02 6:30:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-07-02 6:30:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-07-02 6:30:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-07-02 6:30:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-07-02 6:30:44 0 [Note] InnoDB: Waiting for purge to start 2020-07-02 6:30:44 0 [Note] InnoDB: 10.4.13 started; log sequence number 550975749644; transaction id 2110823490 2020-07-02 6:30:44 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-07-02 6:30:44 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-07-02 6:30:44 0 [Note] Server socket created on IP: '192.168.148.226'. 2020-07-02 6:30:44 0 [Warning] 'user' entry '@srv2.payin7.com' ignored in --skip-name-resolve mode. 2020-07-02 6:30:44 0 [Warning] 'proxies_priv' entry '@% root@srv2.payin7.com' ignored in --skip-name-resolve mode. 2020-07-02 6:30:44 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-07-02 6:30:44 0 [Note] WSREP: Server initialized 2020-07-02 6:30:44 0 [Note] WSREP: Server status change initializing -> initialized 2020-07-02 6:30:44 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:44 3 [Note] WSREP: Server status change initialized -> joined 2020-07-02 6:30:44 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:44 3 [Note] WSREP: Recovered position from storage: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569278 2020-07-02 6:30:44 19 [Note] WSREP: Starting applier thread 19 2020-07-02 6:30:44 21 [Note] WSREP: Starting applier thread 21 2020-07-02 6:30:44 14 [Note] WSREP: Starting applier thread 14 2020-07-02 6:30:44 22 [Note] WSREP: Starting applier thread 22 2020-07-02 6:30:44 20 [Note] WSREP: Starting applier thread 20 2020-07-02 6:30:44 15 [Note] WSREP: Starting applier thread 15 2020-07-02 6:30:44 17 [Note] WSREP: Starting applier thread 17 2020-07-02 6:30:44 18 [Note] WSREP: Starting applier thread 18 2020-07-02 6:30:44 12 [Note] WSREP: Starting applier thread 12 2020-07-02 6:30:44 13 [Note] WSREP: Starting applier thread 13 2020-07-02 6:30:44 16 [Note] WSREP: Starting applier thread 16 2020-07-02 6:30:44 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-07-02 6:30:44 11 [Note] WSREP: Starting applier thread 11 2020-07-02 6:30:44 23 [Note] WSREP: Starting applier thread 23 2020-07-02 6:30:44 24 [Note] WSREP: Starting applier thread 24 2020-07-02 6:30:44 25 [Note] WSREP: Starting applier thread 25 2020-07-02 6:30:44 3 [Note] WSREP: Recovered view from SST: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:821219235 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: -1 members(3): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 98209ae5-bb78-11ea-9bcd-c7f5b725a4ba, SRV2 2: 9f03a2e3-bb78-11ea-8cfd-c6ef66345640, SRV1 2020-07-02 6:30:44 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:44 28 [Note] WSREP: Recovered cluster id 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb 2020-07-02 6:30:44 3 [Note] WSREP: SST received: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569278 2020-07-02 6:30:44 0 [Note] WSREP: Joiner monitor thread ended with total time 1 sec 2020-07-02 6:30:44 2 [Note] WSREP: Installed new state from SST: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569278 2020-07-02 6:30:44 2 [Note] WSREP: Receiving IST: 1417 writesets, seqnos 830569279-830570695 2020-07-02 6:30:44 0 [Note] WSREP: ####### IST applying starts with 830569279 2020-07-02 6:30:44 0 [Note] WSREP: ####### IST current seqno initialized to 830569201 2020-07-02 6:30:44 0 [Note] WSREP: Receiving IST... 0.0% ( 0/1495 events) complete. 2020-07-02 6:30:44 0 [Note] WSREP: IST preload starting at 830569201 2020-07-02 6:30:44 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:30:44 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:830569200, protocol version: 5 2020-07-02 6:30:44 12 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table payin7_core.p_order_customer_due_email_log; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos 767, Internal MariaDB error code: 1213 2020-07-02 6:30:44 14 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table payin7_core.p_order_customer_due_email_log; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos 766, Internal MariaDB error code: 1213 2020-07-02 6:30:44 12 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 149, seqno 830569284 2020-07-02 6:30:44 14 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 149, seqno 830569285 2020-07-02 6:30:44 19 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table payin7_core.p_order_customer_due_email_log; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log FIRST, end_log_pos 766, Internal MariaDB error code: 1213 2020-07-02 6:30:44 19 [Warning] WSREP: Event 3 Write_rows_v1 apply failed: 149, seqno 830569280 2020-07-02 6:30:44 19 [ERROR] WSREP: Failed to apply write set: gtid: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569280 server_id: 929c349f-bb78-11ea-a696-fa2539cbb929 client_id: 5006472 trx_id: 73399364 flags: 3 (start_transaction | commit) 2020-07-02 6:30:44 19 [Note] WSREP: Closing send monitor... 2020-07-02 6:30:44 19 [Note] WSREP: Closed send monitor. 2020-07-02 6:30:44 19 [Note] WSREP: gcomm: terminating thread 2020-07-02 6:30:44 19 [Note] WSREP: gcomm: joining thread 2020-07-02 6:30:44 19 [Note] WSREP: gcomm: closing backend 2020-07-02 6:30:44 12 [ERROR] WSREP: Failed to apply write set: gtid: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569284 server_id: 929c349f-bb78-11ea-a696-fa2539cbb929 client_id: 5006472 trx_id: 73399415 flags: 3 (start_transaction | commit) 2020-07-02 6:30:44 19 [Note] WSREP: view(view_id(NON_PRIM,929c349f-a696,32) memb { 98209ae5-9bce,0 } joined { } left { } partitioned { 929c349f-a696,0 9f03a2e3-8cfd,0 }) 2020-07-02 6:30:44 19 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-07-02 6:30:44 19 [Note] WSREP: view((empty)) 2020-07-02 6:30:44 19 [Note] WSREP: gcomm: closed 2020-07-02 6:30:44 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-07-02 6:30:44 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-07-02 6:30:44 0 [Note] WSREP: Received NON-PRIMARY. 2020-07-02 6:30:44 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 830570956) 2020-07-02 6:30:44 0 [Note] WSREP: New SELF-LEAVE. 2020-07-02 6:30:44 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-07-02 6:30:44 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-07-02 6:30:44 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-07-02 6:30:44 0 [Note] WSREP: RECV thread exiting 0: Success 2020-07-02 6:30:44 14 [ERROR] WSREP: Failed to apply write set: gtid: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569285 server_id: 929c349f-bb78-11ea-a696-fa2539cbb929 client_id: 5006472 trx_id: 73399431 flags: 3 (start_transaction | commit) 2020-07-02 6:30:44 19 [Note] WSREP: recv_thread() joined. 2020-07-02 6:30:44 19 [Note] WSREP: Closing replication queue. 2020-07-02 6:30:44 19 [Note] WSREP: Closing slave action queue. 2020-07-02 6:30:44 0 [Note] WSREP: REPL Protocols: 10 (5) 2020-07-02 6:30:44 0 [Note] WSREP: ####### Adjusting cert position: 830569331 -> 830569332 2020-07-02 6:30:44 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:30:44 0 [Note] WSREP: Lowest cert indnex boundary for CC from ist: 830569201 2020-07-02 6:30:44 0 [Note] WSREP: Min available from gcache for CC from ist: 830500848 2020-07-02 6:30:44 16 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569332 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: -1 members(2): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 9f03a2e3-bb78-11ea-8cfd-c6ef66345640, SRV1 ================================================= 2020-07-02 6:30:44 16 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:44 0 [ERROR] WSREP: got asio system error while reading IST stream: asio.misc:2 2020-07-02 6:30:44 0 [ERROR] WSREP: IST didn't contain all write sets, expected last: 830570695 last received: 830570224 mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/wsrep-lib/include/wsrep/client_state.hpp:603: int wsrep::client_state::bf_abort(wsrep::seqno): Assertion `mode_ == m_local || transaction_.is_streaming()' failed. 200702 6:30:44 [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.13-MariaDB-log key_buffer_size=10485760 read_buffer_size=1048576 max_used_connections=1 max_threads=92 thread_count=25 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 200902 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa06c007bf8 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 = 0x7fa0a49dfcf0 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55e6a28cb6ce] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55e6a2361f7f] sigaction.c:0(__restore_rt)[0x7fa202954630] :0(__GI_raise)[0x7fa200c25387] :0(__GI_abort)[0x7fa200c26a78] :0(__assert_fail_base)[0x7fa200c1e1a6] :0(__GI___assert_fail)[0x7fa200c1e252] /usr/sbin/mysqld(_Z14wsrep_bf_abortPK3THDPS_+0x47c)[0x55e6a22d738c] /usr/sbin/mysqld(wsrep_thd_bf_abort+0x16)[0x55e6a22dd306] /usr/sbin/mysqld(+0xa5c4d6)[0x55e6a250e4d6] /usr/sbin/mysqld(+0x5aec10)[0x55e6a2060c10] /usr/sbin/mysqld(+0xa9cf7c)[0x55e6a254ef7c] /usr/sbin/mysqld(+0xaa4a84)[0x55e6a2556a84] /usr/sbin/mysqld(+0xb21354)[0x55e6a25d3354] /usr/sbin/mysqld(+0xa65414)[0x55e6a2517414] /usr/sbin/mysqld(+0xa65f28)[0x55e6a2517f28] /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPKh+0x16f)[0x55e6a236d48f] /usr/sbin/mysqld(_ZN14Rows_log_event9write_rowEP14rpl_group_infob+0x235)[0x55e6a2468ea5] /usr/sbin/mysqld(_ZN20Write_rows_log_event11do_exec_rowEP14rpl_group_info+0x7d)[0x55e6a246930d] /usr/sbin/mysqld(_ZN14Rows_log_event14do_apply_eventEP14rpl_group_info+0x2dc)[0x55e6a245ca0c] /usr/sbin/mysqld(_Z18wsrep_apply_eventsP3THDP14Relay_log_infoPKvm+0x23d)[0x55e6a22d633d] /usr/sbin/mysqld(_ZN21Wsrep_applier_service15apply_write_setERKN5wsrep7ws_metaERKNS0_12const_bufferERNS0_14mutable_bufferE+0x9d)[0x55e6a22c206d] /usr/sbin/mysqld(+0xea62bf)[0x55e6a29582bf] /usr/sbin/mysqld(_ZN5wsrep12server_state8on_applyERNS_21high_priority_serviceERKNS_9ws_handleERKNS_7ws_metaERKNS_12const_bufferE+0x2a)[0x55e6a2958e0a] /usr/sbin/mysqld(+0xeb6e61)[0x55e6a2968e61] src/trx_handle.cpp:387(galera::TrxHandleSlave::apply(void*, wsrep_cb_status (*)(void*, wsrep_ws_handle const*, unsigned int, wsrep_buf const*, wsrep_trx_meta const*, bool*), wsrep_trx_meta const&, bool&))[0x7fa1f7838390] src/replicator_smm.cpp:496(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandleSlave&))[0x7fa1f7870a8a] src/gu_logger.hpp:96(gu::Logger::no_log(gu::LogLevel))[0x7fa1f7882c37] src/replicator_str.cpp:1142(galera::ReplicatorSMM::recv_IST(void*))[0x7fa1f78831df] src/replicator_smm.cpp:396(galera::ReplicatorSMM::async_recv(void*))[0x7fa1f7876e29] src/wsrep_provider.cpp:263(galera_recv)[0x7fa1f7889518] /usr/sbin/mysqld(_ZN5wsrep18wsrep_provider_v2611run_applierEPNS_21high_priority_serviceE+0xe)[0x55e6a296792e] /usr/sbin/mysqld(+0x825e42)[0x55e6a22d7e42] /usr/sbin/mysqld(_Z15start_wsrep_THDPv+0x35d)[0x55e6a22cc72d] /usr/sbin/mysqld(+0xdcb78d)[0x55e6a287d78d] pthread_create.c:0(start_thread)[0x7fa20294cea5] /lib64/libc.so.6(clone+0x6d)[0x7fa200ced8dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa1ec9ba24b): INSERT INTO `p_order_customer_due_email_log` (`id`, `created_on`, `customer_id`, `order_id`, `payment_plan_payment_id`, `email_type`, `due_overdue_days`, `is_order_overdue`, `options`, `response`) VALUES (NULL, '2020-07-02 06:30:36', 10980, 36415, 30129, 'overdue', 710, 'yes', '{\"default_recipients\":true,\"send_if_sent\":false}', '{\"error\":\"Not sending overdue email as it has already been sent and no more than once allowed\"}') Connection ID (thread ID): 25 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 31203 31203 processes Max open files 16364 16364 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 31203 31203 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: co... 2020-07-02 6:30:54 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569332 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy loaded successfully. 2020-07-02 6:30:54 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2020-07-02 6:30:54 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 0 2020-07-02 6:30:54 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb Seqno: -1 - -1 Offset: -1 Synced: 0 2020-07-02 6:30:54 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb, offset: -1 2020-07-02 6:30:54 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. 2020-07-02 6:30:54 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. 2020-07-02 6:30:54 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 830501321-830570224 2020-07-02 6:30:54 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/134183608 bytes) complete. 2020-07-02 6:30:54 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (134183608/134183608 bytes) complete. 2020-07-02 6:30:54 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 16/68998 locked buffers 2020-07-02 6:30:54 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 134183608/134217728 2020-07-02 6:30:54 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.148.226; 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.check... 2020-07-02 6:30:54 0 [Note] WSREP: Start replication 2020-07-02 6:30:54 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-07-02 6:30:54 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2020-07-02 6:30:54 0 [Note] WSREP: protonet asio version 0 2020-07-02 6:30:54 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-07-02 6:30:54 0 [Note] WSREP: backend: asio 2020-07-02 6:30:54 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-07-02 6:30:54 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2020-07-02 6:30:54 0 [Note] WSREP: restore pc from disk failed 2020-07-02 6:30:54 0 [Note] WSREP: GMCast version 0 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-07-02 6:30:54 0 [Note] WSREP: EVS version 1 2020-07-02 6:30:54 0 [Note] WSREP: gcomm: connecting to group 'cluster1', peer '192.168.198.58:,192.168.148.226:,192.168.138.240:' 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://192.168.148.226:4567 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') connection established to 9f03a2e3-8cfd tcp://192.168.198.58:4567 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-07-02 6:30:54 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') connection established to 929c349f-a696 tcp://192.168.138.240:4567 2020-07-02 6:30:54 0 [Note] WSREP: EVS version upgrade 0 -> 1 2020-07-02 6:30:54 0 [Note] WSREP: declaring 929c349f-a696 at tcp://192.168.138.240:4567 stable 2020-07-02 6:30:54 0 [Note] WSREP: declaring 9f03a2e3-8cfd at tcp://192.168.198.58:4567 stable 2020-07-02 6:30:54 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2020-07-02 6:30:54 0 [Note] WSREP: Node 929c349f-a696 state prim 2020-07-02 6:30:54 0 [Note] WSREP: view(view_id(PRIM,929c349f-a696,34) memb { 929c349f-a696,0 94b0f457-8448,0 9f03a2e3-8cfd,0 } joined { } left { } partitioned { }) 2020-07-02 6:30:54 0 [Note] WSREP: save pc into disk 2020-07-02 6:30:55 0 [Note] WSREP: gcomm: connected 2020-07-02 6:30:55 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-07-02 6:30:55 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-07-02 6:30:55 0 [Note] WSREP: Opened channel 'cluster1' 2020-07-02 6:30:55 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2020-07-02 6:30:55 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2020-07-02 6:30:55 2 [Note] WSREP: Starting applier thread 2 2020-07-02 6:30:55 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 94fe6320-bc2d-11ea-a29b-7ec71f857d39 2020-07-02 6:30:55 1 [Note] WSREP: Starting rollbacker thread 1 2020-07-02 6:30:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 94fe6320-bc2d-11ea-a29b-7ec71f857d39 from 0 (SRV3) 2020-07-02 6:30:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 94fe6320-bc2d-11ea-a29b-7ec71f857d39 from 2 (SRV1) 2020-07-02 6:30:55 0 [Note] WSREP: STATE EXCHANGE: got state msg: 94fe6320-bc2d-11ea-a29b-7ec71f857d39 from 1 (SRV2) 2020-07-02 6:30:55 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 12, members = 2/3 (joined/total), act_id = 830572397, last_appl. = 830570866, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb 2020-07-02 6:30:55 0 [Note] WSREP: Flow-control interval: [28, 28] 2020-07-02 6:30:55 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 830572398) 2020-07-02 6:30:55 2 [Note] WSREP: ####### processing CC 830572398, local, ordered 2020-07-02 6:30:55 2 [Note] WSREP: Process first view: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb my uuid: 94b0f457-bc2d-11ea-8448-43f9df54c00f 2020-07-02 6:30:55 2 [Note] WSREP: Server SRV2 connected to cluster at position 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572398 with ID 94b0f457-bc2d-11ea-8448-43f9df54c00f 2020-07-02 6:30:55 2 [Note] WSREP: Server status change disconnected -> connected 2020-07-02 6:30:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:55 2 [Note] WSREP: ####### My UUID: 94b0f457-bc2d-11ea-8448-43f9df54c00f 2020-07-02 6:30:55 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-07-02 6:30:55 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:30:55 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-07-02 6:30:55 2 [Note] WSREP: State transfer required: Group state: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572398 Local state: 00000000-0000-0000-0000-000000000000:-1 2020-07-02 6:30:55 2 [Note] WSREP: Server status change connected -> joiner 2020-07-02 6:30:55 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:55 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-07-02 6:30:55 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '192.168.148.226' --datadir '/var/lib/mysql/' --parent '6555' --binlog '/var/lib/mysql/master-bin' --binlog-index '/var/lib/mysql/master-bin.index' --mysqld-args --wsrep_start_position=59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830569332' 2020-07-02 6:30:55 0 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000000 of size 134217728 bytes WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20200702 06:30:55.499) 2020-07-02 6:30:55 2 [Note] WSREP: Prepared SST request: mariabackup|192.168.148.226:4444/xtrabackup_sst//1 2020-07-02 6:30:55 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 830572398, STRv: 3 2020-07-02 6:30:55 2 [Note] WSREP: IST receiver addr using tcp://192.168.148.226:4568 2020-07-02 6:30:55 2 [Note] WSREP: Prepared IST receiver for 0-830572398, listening at: tcp://192.168.148.226:4568 2020-07-02 6:30:55 0 [Note] WSREP: Member 1.0 (SRV2) requested state transfer from '*any*'. Selected 0.0 (SRV3)(SYNCED) as donor. 2020-07-02 6:30:55 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 830572505) 2020-07-02 6:30:55 2 [Note] WSREP: Requesting state transfer: success, donor: 0 2020-07-02 6:30:55 2 [Note] WSREP: Resetting GCache seqno map due to different histories. 2020-07-02 6:30:55 2 [Note] WSREP: GCache history reset: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830570224 -> 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572398 2020-07-02 6:30:55 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 134100272 bytes 2020-07-02 6:30:55 2 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 0/51 locked buffers 2020-07-02 6:30:57 0 [Note] WSREP: (94b0f457-8448, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-07-02 6:32:02 0 [Note] WSREP: 0.0 (SRV3): State transfer to 1.0 (SRV2) complete. 2020-07-02 6:32:02 0 [Note] WSREP: Member 0.0 (SRV3) synced with group. 2020-07-02 6:32:08 0 [Warning] WSREP: Did not find domain ID from SST script output '59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830581312'. Domain ID must be set manually to keep binlog consistent 2020-07-02 6:32:08 3 [Note] WSREP: SST received 2020-07-02 6:32:08 3 [Note] WSREP: Server status change joiner -> initializing 2020-07-02 6:32:08 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 0 [Note] mysqld: Aria engine: starting recovery recovered pages: 0% 17% 55% 71% 94% 100% (0.0 seconds); tables to flush: 1 0 (0.0 seconds); 2020-07-02 6:32:08 0 [Note] mysqld: Aria engine: recovery done 2020-07-02 6:32:08 0 [Warning] The parameter innodb_large_prefix is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ 2020-07-02 6:32:08 0 [Note] InnoDB: Using Linux native AIO 2020-07-02 6:32:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-07-02 6:32:08 0 [Note] InnoDB: Uses event mutexes 2020-07-02 6:32:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-07-02 6:32:08 0 [Note] InnoDB: Number of pools: 1 2020-07-02 6:32:08 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-07-02 6:32:08 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 4, chunk size = 128M 2020-07-02 6:32:08 0 [Note] InnoDB: Completed initialization of buffer pool 2020-07-02 6:32:08 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-07-02 6:32:08 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 536870912 bytes 2020-07-02 6:32:08 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 536870912 bytes 2020-07-02 6:32:08 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-07-02 6:32:08 0 [Note] InnoDB: New log files created, LSN=550983745807 2020-07-02 6:32:08 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 2 row operations to undo 2020-07-02 6:32:08 0 [Note] InnoDB: Trx id counter is 2116049661 2020-07-02 6:32:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-07-02 6:32:08 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2020-07-02 6:32:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-07-02 6:32:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-07-02 6:32:08 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-07-02 6:32:08 0 [Note] InnoDB: Rolled back recovered transaction 2116049660 2020-07-02 6:32:08 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2020-07-02 6:32:08 0 [Note] InnoDB: 10.4.13 started; log sequence number 550983746060; transaction id 2116049664 2020-07-02 6:32:08 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-07-02 6:32:08 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-07-02 6:32:08 0 [Note] Recovering after a crash using /var/lib/mysql/master-bin 2020-07-02 6:32:08 0 [Note] Starting crash recovery... 2020-07-02 6:32:08 0 [Note] Crash recovery finished. 2020-07-02 6:32:08 0 [Note] Server socket created on IP: '192.168.148.226'. 2020-07-02 6:32:08 0 [Warning] 'user' entry '@srv2.payin7.com' ignored in --skip-name-resolve mode. 2020-07-02 6:32:08 0 [Warning] 'proxies_priv' entry '@% root@srv2.payin7.com' ignored in --skip-name-resolve mode. 2020-07-02 6:32:08 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-07-02 6:32:08 0 [Note] WSREP: Server initialized 2020-07-02 6:32:08 0 [Note] WSREP: Server status change initializing -> initialized 2020-07-02 6:32:08 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 3 [Note] WSREP: Server status change initialized -> joined 2020-07-02 6:32:08 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 3 [Note] WSREP: Recovered position from storage: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830581370 2020-07-02 6:32:08 11 [Note] WSREP: Starting applier thread 11 2020-07-02 6:32:08 13 [Note] WSREP: Starting applier thread 13 2020-07-02 6:32:08 14 [Note] WSREP: Starting applier thread 14 2020-07-02 6:32:08 12 [Note] WSREP: Starting applier thread 12 2020-07-02 6:32:08 15 [Note] WSREP: Starting applier thread 15 2020-07-02 6:32:08 22 [Note] WSREP: Starting applier thread 22 2020-07-02 6:32:08 17 [Note] WSREP: Starting applier thread 17 2020-07-02 6:32:08 18 [Note] WSREP: Starting applier thread 18 2020-07-02 6:32:08 16 [Note] WSREP: Starting applier thread 16 2020-07-02 6:32:08 23 [Note] WSREP: Starting applier thread 23 2020-07-02 6:32:08 21 [Note] WSREP: Starting applier thread 21 2020-07-02 6:32:08 20 [Note] WSREP: Starting applier thread 20 2020-07-02 6:32:08 19 [Note] WSREP: Starting applier thread 19 2020-07-02 6:32:08 25 [Note] WSREP: Starting applier thread 25 2020-07-02 6:32:08 24 [Note] WSREP: Starting applier thread 24 2020-07-02 6:32:08 3 [Note] WSREP: Recovered view from SST: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572398 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: 1 members(3): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 94b0f457-bc2d-11ea-8448-43f9df54c00f, SRV2 2: 9f03a2e3-bb78-11ea-8cfd-c6ef66345640, SRV1 2020-07-02 6:32:08 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 27 [Note] WSREP: Recovered cluster id 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb 2020-07-02 6:32:08 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-07-02 6:32:08 3 [Note] WSREP: SST received: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830581370 2020-07-02 6:32:08 2 [Note] WSREP: Installed new state from SST: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830581370 2020-07-02 6:32:08 0 [Note] WSREP: Joiner monitor thread ended with total time 73 sec 2020-07-02 6:32:08 2 [Note] WSREP: Cert. index preload up to 830581370 2020-07-02 6:32:08 0 [Note] WSREP: ####### IST applying starts with 830581371 2020-07-02 6:32:08 0 [Note] WSREP: ####### IST current seqno initialized to 830570867 2020-07-02 6:32:08 0 [Note] WSREP: Receiving IST... 0.0% ( 0/1532 events) complete. 2020-07-02 6:32:08 0 [Note] WSREP: IST preload starting at 830570867 2020-07-02 6:32:08 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:32:08 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:830570866, protocol version: 5 2020-07-02 6:32:08 0 [Note] WSREP: REPL Protocols: 10 (5) 2020-07-02 6:32:08 0 [Note] WSREP: ####### Adjusting cert position: 830570956 -> 830570957 2020-07-02 6:32:08 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:32:08 0 [Note] WSREP: Lowest cert indnex boundary for CC from preload: 830570867 2020-07-02 6:32:08 0 [Note] WSREP: Min available from gcache for CC from preload: 830570867 2020-07-02 6:32:08 0 [ERROR] WSREP: got asio system error while reading IST stream: asio.misc:2 2020-07-02 6:32:08 0 [ERROR] WSREP: IST didn't contain all write sets, expected last: 830572398 last received: 830571890 2020-07-02 6:32:08 11 [ERROR] WSREP: Receiving IST failed, node restart required: IST receiver reported failure: 71 (Protocol error) at galera/src/replicator_smm.hpp:pop_front():314. Null event. 2020-07-02 6:32:08 2 [Note] WSREP: Cert. index preloaded up to 830571890 2020-07-02 6:32:08 2 [Note] WSREP: Lowest cert indnex boundary for CC from sst: 830570867 2020-07-02 6:32:08 2 [Note] WSREP: Min available from gcache for CC from sst: 830570867 2020-07-02 6:32:08 0 [Note] WSREP: 1.0 (SRV2): State transfer from 0.0 (SRV3) complete. 2020-07-02 6:32:08 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 830582423) 2020-07-02 6:32:08 11 [Note] WSREP: Closing send monitor... 2020-07-02 6:32:08 11 [Note] WSREP: Closed send monitor. 2020-07-02 6:32:08 11 [Note] WSREP: gcomm: terminating thread 2020-07-02 6:32:08 11 [Note] WSREP: gcomm: joining thread 2020-07-02 6:32:08 11 [Note] WSREP: gcomm: closing backend 2020-07-02 6:32:08 11 [Note] WSREP: view(view_id(NON_PRIM,929c349f-a696,34) memb { 94b0f457-8448,0 } joined { } left { } partitioned { 929c349f-a696,0 9f03a2e3-8cfd,0 }) 2020-07-02 6:32:08 11 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-07-02 6:32:08 11 [Note] WSREP: view((empty)) 2020-07-02 6:32:08 11 [Note] WSREP: gcomm: closed 2020-07-02 6:32:08 2 [Warning] WSREP: 0x55699f22cf68 down context(s) not set 2020-07-02 6:32:08 2 [Warning] WSREP: Failed to send SYNC signal: -107 (Transport endpoint is not connected) 2020-07-02 6:32:08 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-07-02 6:32:08 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-07-02 6:32:08 0 [Note] WSREP: Received NON-PRIMARY. 2020-07-02 6:32:08 0 [Note] WSREP: Shifting JOINED -> OPEN (TO: 830582423) 2020-07-02 6:32:08 2 [Warning] WSREP: Failed to send SYNC signal: -107 (Transport endpoint is not connected) 2020-07-02 6:32:08 0 [Note] WSREP: New SELF-LEAVE. 2020-07-02 6:32:08 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-07-02 6:32:08 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-07-02 6:32:08 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-07-02 6:32:08 0 [Note] WSREP: RECV thread exiting 0: Success 2020-07-02 6:32:08 2 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:-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: no own_index: 0 members(1): 0: 94b0f457-bc2d-11ea-8448-43f9df54c00f, SRV2 ================================================= 2020-07-02 6:32:08 2 [Note] WSREP: Non-primary view 2020-07-02 6:32:08 2 [Note] WSREP: Server status change joined -> connected 2020-07-02 6:32:08 11 [Note] WSREP: recv_thread() joined. 2020-07-02 6:32:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 11 [Note] WSREP: Closing replication queue. 2020-07-02 6:32:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 11 [Note] WSREP: Closing slave action queue. 2020-07-02 6:32:08 2 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:-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): ================================================= 2020-07-02 6:32:08 2 [Note] WSREP: Non-primary view 2020-07-02 6:32:08 2 [Note] WSREP: Server status change connected -> disconnected 2020-07-02 6:32:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 13 [Note] WSREP: Applier thread exiting ret: 6 thd: 13 2020-07-02 6:32:08 12 [Note] WSREP: Applier thread exiting ret: 6 thd: 12 2020-07-02 6:32:08 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17 2020-07-02 6:32:08 15 [Note] WSREP: Applier thread exiting ret: 6 thd: 15 2020-07-02 6:32:08 24 [Note] WSREP: Applier thread exiting ret: 6 thd: 24 2020-07-02 6:32:08 16 [Note] WSREP: Applier thread exiting ret: 6 thd: 16 2020-07-02 6:32:08 14 [Note] WSREP: Applier thread exiting ret: 6 thd: 14 2020-07-02 6:32:08 20 [Note] WSREP: Applier thread exiting ret: 6 thd: 20 2020-07-02 6:32:08 18 [Note] WSREP: Applier thread exiting ret: 6 thd: 18 2020-07-02 6:32:08 25 [Note] WSREP: Applier thread exiting ret: 6 thd: 25 2020-07-02 6:32:08 19 [Note] WSREP: Applier thread exiting ret: 6 thd: 19 2020-07-02 6:32:08 22 [Note] WSREP: Applier thread exiting ret: 6 thd: 22 2020-07-02 6:32:08 21 [Note] WSREP: Applier thread exiting ret: 6 thd: 21 2020-07-02 6:32:08 23 [Note] WSREP: Applier thread exiting ret: 6 thd: 23 2020-07-02 6:32:08 11 [Note] WSREP: Applier thread exiting ret: 6 thd: 11 2020-07-02 6:32:08 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:32:08 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 2020-07-02 6:32:08 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2 2020-07-02 6:32:21 0 [Note] InnoDB: Buffer pool(s) load completed at 200702 6:32:21