2019-12-07 6:33:24 0 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000102 of size 134217728 bytes 2019-12-07 6:33:25 0 [Note] WSREP: Deleted page /var/lib/mysql/gcache.page.000101 mysqld: /home/buildbot/buildbot/build/mariadb-10.4.10/wsrep-lib/src/transaction.cpp:1038: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed. 191207 7:25:12 [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.10-MariaDB-1:10.4.10+maria~xenial-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=53 max_threads=202 thread_count=63 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1377108 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f8734113c28 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 = 0x7f87d82d2cf8 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x564202c4c2ce] /usr/sbin/mysqld(handle_fatal_signal+0x307)[0x5642026ddc97] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f887d004390] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f887bd21428] /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f887bd2302a] /lib/x86_64-linux-gnu/libc.so.6(+0x2dbd7)[0x7f887bd19bd7] /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f887bd19c82] /usr/sbin/mysqld(+0xe7c8e6)[0x564202ceb8e6] /usr/sbin/mysqld(_ZN22Wsrep_replayer_serviceD2Ev+0x60)[0x564202635300] /usr/sbin/mysqld(_ZN20Wsrep_client_service6replayEv+0x105)[0x564202634125] /usr/sbin/mysqld(_ZN5wsrep11transaction15after_statementEv+0x3db)[0x564202cf782b] /usr/sbin/mysqld(_ZN5wsrep12client_state15after_statementEv+0xc5)[0x564202cd4c15] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x22bf)[0x5642024d12ef] /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x5642024d1c5c] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x23a)[0x5642025ae6da] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5642025ae79d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f887cffa6ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f887bdf341d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x0): Connection ID (thread ID): 1 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 10485760 unlimited bytes Max core file size unlimited unlimited bytes Max resident set unlimited unlimited bytes Max processes 772599 772599 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 772599 772599 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: core 2019-12-07 7:25:37 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.3(r4535) by Codership Oy loaded successfully. 2019-12-07 7:25:37 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-12-07 7:25:37 0 [Note] WSREP: Found saved state: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:-1, safe_to_bootstrap: 0 2019-12-07 7:25:37 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea Seqno: -1 - -1 Offset: -1 Synced: 0 2019-12-07 7:25:37 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea, offset: -1 2019-12-07 7:25:37 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2019-12-07 7:25:38 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2019-12-07 7:25:38 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 10958885-10958885 2019-12-07 7:25:38 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/20176 bytes) complete. 2019-12-07 7:25:38 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (20176/20176 bytes) complete. 2019-12-07 7:25:38 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1 locked buffers 2019-12-07 7:25:38 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 20176/1073741824 2019-12-07 7:25:39 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_create():332: Failed to create recv_q. 2019-12-07 7:25:39 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_create():382: Failed to create GCS connection handle. 2019-12-07 7:25:39 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 3.3.3.3; 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 = 1G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = f 2019-12-07 7:25:39 0 [Note] WSREP: Flushing memory map to disk... 2019-12-07 7:25:40 0 [ERROR] WSREP: could not create gcs connection (FATAL) at galera/src/galera_gcs.hpp:Gcs():93 2019-12-07 7:25:40 0 [ERROR] WSREP: Failed to create a new provider '/usr/lib/galera/libgalera_smm.so' with options 'gcache.size=1G':Failed to initialize wsrep provider 2019-12-07 7:25:40 0 [ERROR] WSREP: Failed to load provider 2019-12-07 7:25:40 0 [ERROR] Aborting 2019-12-07 8:52:23 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' wsrep loader: [INFO] wsrep_load(): Galera 26.4.3(r4535) by Codership Oy loaded successfully. 2019-12-07 8:52:23 0 [Note] WSREP: CRC-32C: using hardware acceleration. 2019-12-07 8:52:23 0 [Note] WSREP: Found saved state: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:-1, safe_to_bootstrap: 0 2019-12-07 8:52:23 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 2 UUID: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea Seqno: 10958885 - 10958885 Offset: 69868440 Synced: 1 2019-12-07 8:52:23 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea, offset: 69868440 2019-12-07 8:52:23 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/1073741848 bytes) complete. 2019-12-07 8:52:23 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (1073741848/1073741848 bytes) complete. 2019-12-07 8:52:23 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 10958885-10958885 2019-12-07 8:52:23 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/20176 bytes) complete. 2019-12-07 8:52:23 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (20176/20176 bytes) complete. 2019-12-07 8:52:23 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1 locked buffers 2019-12-07 8:52:23 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 20176/1073741824 2019-12-07 8:52:23 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 3.3.3.3; 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 = 1G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = f 2019-12-07 8:52:23 0 [Note] WSREP: Service thread queue flushed. 2019-12-07 8:52:23 0 [Note] WSREP: ####### Assign initial position for certification: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883, protocol version: -1 2019-12-07 8:52:23 0 [Note] WSREP: Start replication 2019-12-07 8:52:23 0 [Note] WSREP: Connecting with bootstrap option: 0 2019-12-07 8:52:23 0 [Note] WSREP: Setting GCS initial position to 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 2019-12-07 8:52:23 0 [Note] WSREP: protonet asio version 0 2019-12-07 8:52:23 0 [Note] WSREP: Using CRC-32C for message checksums. 2019-12-07 8:52:23 0 [Note] WSREP: backend: asio 2019-12-07 8:52:23 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2019-12-07 8:52:23 0 [Note] WSREP: restore pc from disk successfully 2019-12-07 8:52:23 0 [Note] WSREP: GMCast version 0 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2019-12-07 8:52:23 0 [Note] WSREP: EVS version 1 2019-12-07 8:52:23 0 [Note] WSREP: gcomm: connecting to group 'compdb_cluster', peer '1.1.1.1:,2.2.2.2:,3.3.3.3:' 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://3.3.3.3:4567 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') connection established to f61e6708 tcp://1.1.1.1:4567 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://4.4.4.4:4567 2019-12-07 8:52:23 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') connection established to 2ac99a34 tcp://2.2.2.2:4567 2019-12-07 8:52:24 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') connection established to 98478792 tcp://4.4.4.4:4567 2019-12-07 8:52:24 0 [Note] WSREP: gcomm: connected 2019-12-07 8:52:24 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2019-12-07 8:52:24 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2019-12-07 8:52:24 0 [Note] WSREP: Opened channel 'compdb_cluster' 2019-12-07 8:52:24 1 [Note] WSREP: Starting rollbacker thread 1 2019-12-07 8:52:24 2 [Note] WSREP: Starting applier thread 2 2019-12-07 8:52:25 0 [Note] WSREP: EVS version upgrade 0 -> 1 2019-12-07 8:52:25 0 [Note] WSREP: declaring 2ac99a34 at tcp://2.2.2.2:4567 stable 2019-12-07 8:52:25 0 [Note] WSREP: declaring 98478792 at tcp://4.4.4.4:4567 stable 2019-12-07 8:52:25 0 [Note] WSREP: declaring f61e6708 at tcp://1.1.1.1:4567 stable 2019-12-07 8:52:25 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2019-12-07 8:52:25 0 [Note] WSREP: Node 2ac99a34 state prim 2019-12-07 8:52:25 0 [Note] WSREP: view(view_id(PRIM,2ac99a34,24) memb { 2ac99a34,0 4e3212ac,0 98478792,0 f61e6708,0 } joined { } left { } partitioned { }) 2019-12-07 8:52:25 0 [Note] WSREP: save pc into disk 2019-12-07 8:52:25 0 [Note] WSREP: clear restored view 2019-12-07 8:52:25 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 4 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2019-12-07 8:52:25 0 [Warning] WSREP: Action message in non-primary configuration from member 0 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e3e2375f-18ce-11ea-8135-37b034c877df 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: e3e2375f-18ce-11ea-8135-37b034c877df from 0 (Server2) 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: e3e2375f-18ce-11ea-8135-37b034c877df from 1 (Server3) 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: e3e2375f-18ce-11ea-8135-37b034c877df from 3 (Server1) 2019-12-07 8:52:25 0 [Note] WSREP: STATE EXCHANGE: got state msg: e3e2375f-18ce-11ea-8135-37b034c877df from 2 (Picard) 2019-12-07 8:52:25 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 23, members = 3/4 (joined/total), act_id = 11000815, last_appl. = 11000696, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea 2019-12-07 8:52:25 0 [Note] WSREP: Flow-control interval: [32, 32] 2019-12-07 8:52:25 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 11000816) 2019-12-07 8:52:25 2 [Note] WSREP: ####### processing CC 11000816, local, ordered 2019-12-07 8:52:25 2 [Note] WSREP: REPL Protocols: 10 (5, 3) 2019-12-07 8:52:25 2 [Note] WSREP: ####### My UUID: 4e3212ac-0c39-11ea-a1a5-f77ba90b52eb 2019-12-07 8:52:25 2 [Note] WSREP: Server Server3 connected to cluster at position 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:11000816 with ID 4e3212ac-0c39-11ea-a1a5-f77ba90b52eb 2019-12-07 8:52:25 2 [Note] WSREP: Server status change disconnected -> connected 2019-12-07 8:52:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:25 2 [Note] WSREP: State transfer required: Group state: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:11000816 Local state: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 2019-12-07 8:52:25 2 [Note] WSREP: Server status change connected -> joiner 2019-12-07 8:52:25 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:25 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '3.3.3.3' --datadir '/var/lib/mysql/' --parent '13642' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --mysqld-args --wsrep_start_position=2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883' WSREP_SST: [INFO] Streaming with xbstream (20191207 08:52:25.608) WSREP_SST: [INFO] Using socat as streamer (20191207 08:52:25.610) Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20191207 08:52:25.644) Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported Cannot open netlink socket: Protocol not supported 2019-12-07 8:52:26 2 [Note] WSREP: Prepared SST request: mariabackup|3.3.3.3:4444/xtrabackup_sst//1 2019-12-07 8:52:26 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2019-12-07 8:52:26 0 [Note] WSREP: Service thread queue flushed. 2019-12-07 8:52:26 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 2019-12-07 8:52:26 2 [Note] WSREP: ####### IST uuid:2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea f: 10958884, l: 11000816, STRv: 3 2019-12-07 8:52:26 2 [Note] WSREP: IST receiver addr using tcp://3.3.3.3:4568 2019-12-07 8:52:26 2 [Note] WSREP: Prepared IST receiver for 10958884-11000816, listening at: tcp://3.3.3.3:4568 2019-12-07 8:52:26 0 [Note] WSREP: Member 1.0 (Server3) requested state transfer from '*any*'. Selected 3.0 (Server1)(SYNCED) as donor. 2019-12-07 8:52:26 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 11000835) 2019-12-07 8:52:26 2 [Note] WSREP: Requesting state transfer: success, donor: 3 2019-12-07 8:52:26 0 [Note] WSREP: 3.0 (Server1): State transfer to 1.0 (Server3) complete. WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20191207 08:52:26.378) WSREP_SST: [INFO] Galera co-ords from recovery: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 0 (20191207 08:52:26.381) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20191207 08:52:26.383) WSREP_SST: [INFO] Removing the sst_in_progress file (20191207 08:52:26.385) 2019-12-07 8:52:26 3 [Note] WSREP: SST received 2019-12-07 8:52:26 3 [Note] WSREP: Server status change joiner -> initializing 2019-12-07 8:52:26 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:26 0 [Note] InnoDB: Using Linux native AIO 2019-12-07 8:52:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-12-07 8:52:26 0 [Note] InnoDB: Uses event mutexes 2019-12-07 8:52:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-12-07 8:52:26 0 [Note] InnoDB: Number of pools: 1 2019-12-07 8:52:26 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-12-07 8:52:26 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-12-07 8:52:26 0 [Note] InnoDB: Completed initialization of buffer pool 2019-12-07 8:52:26 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-12-07 8:52:26 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes 2019-12-07 8:52:26 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes 2019-12-07 8:52:26 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-12-07 8:52:26 0 [Note] InnoDB: New log files created, LSN=18250466146 2019-12-07 8:52:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-12-07 8:52:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-12-07 8:52:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-12-07 8:52:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-12-07 8:52:26 0 [Note] InnoDB: Waiting for purge to start 2019-12-07 8:52:26 0 [Note] InnoDB: 10.4.10 started; log sequence number 18250466316; transaction id 22330818 2019-12-07 8:52:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-12-07 8:52:26 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-12-07 8:52:26 0 [Note] Server socket created on IP: '0.0.0.0'. 2019-12-07 8:52:26 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2019-12-07 8:52:26 0 [Note] WSREP: Server initialized 2019-12-07 8:52:26 0 [Note] WSREP: Server status change initializing -> initialized 2019-12-07 8:52:26 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:26 3 [Note] WSREP: Server status change initialized -> joined 2019-12-07 8:52:26 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:26 3 [Note] WSREP: Recovered position from storage: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 2019-12-07 8:52:26 0 [Note] Reading of all Master_info entries succeeded 2019-12-07 8:52:26 0 [Note] Added new Master_info '' to hash table 2019-12-07 8:52:26 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.10-MariaDB-1:10.4.10+maria~xenial-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2019-12-07 8:52:26 3 [Note] WSREP: Recovered view from SST: id: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10567131 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(4): 0: 2ac99a34-0c39-11ea-9964-4fc93037a5c6, Server2 1: 4e3212ac-0c39-11ea-a1a4-f77ba90b52eb, Server3 2: 98478792-1861-11ea-a9ca-4f08296fcf3c, Picard 3: f61e6708-1815-11ea-a504-5a28bf7ceee7, Server1 2019-12-07 8:52:26 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2019-12-07 8:52:26 13 [Note] WSREP: Recovered cluster id 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea 2019-12-07 8:52:26 3 [Note] WSREP: SST received: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 2019-12-07 8:52:26 2 [Note] WSREP: Installed new state from SST: 2952eb7b-0bd5-11ea-a5ab-0f9165f2a6ea:10958883 2019-12-07 8:52:26 2 [Note] WSREP: Receiving IST: 41933 writesets, seqnos 10958884-11000816 2019-12-07 8:52:26 0 [Note] WSREP: ####### IST applying starts with 10958884 2019-12-07 8:52:26 0 [Note] WSREP: ####### IST current seqno initialized to 10958884 2019-12-07 8:52:26 0 [Note] WSREP: Receiving IST... 0.0% ( 0/41933 events) complete. 2019-12-07 8:52:26 0 [Note] WSREP: Service thread queue flushed. 2019-12-07 8:52:26 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:10958883, protocol version: -1 2019-12-07 8:52:26 0 [Note] WSREP: ####### processing CC 10958895, from IST, ordered 2019-12-07 8:52:26 0 [Note] WSREP: REPL Protocols: 10 (5, 3) 2019-12-07 8:52:26 0 [Note] WSREP: ####### ST not required 2019-12-07 8:52:26 0 [Note] WSREP: Skipping cert index reset 2019-12-07 8:52:26 0 [Note] WSREP: ####### Adjusting cert position: 10958883 -> 10958895 2019-12-07 8:52:26 0 [Note] WSREP: Service thread queue flushed. 2019-12-07 8:52:26 0 [Note] WSREP: ####### Setting monitor position to 10958895 2019-12-07 8:52:26 0 [Note] WSREP: Lowest cert indnex boundary for CC from group: 10958895 2019-12-07 8:52:26 0 [Note] WSREP: Min available from gcache for CC from group: 10958884 2019-12-07 8:52:26 0 [Note] WSREP: Member 3.0 (Server1) synced with group. 2019-12-07 8:52:26 0 [Note] InnoDB: Buffer pool(s) load completed at 191207 8:52:26 2019-12-07 8:52:27 0 [Note] WSREP: IST preload starting at 11000697 2019-12-07 8:52:27 0 [Note] WSREP: ####### processing CC 11000816, from IST, ordered 2019-12-07 8:52:27 0 [Note] WSREP: (4e3212ac, 'tcp://0.0.0.0:4567') turning message relay requesting off