2018-10-17 1:00:26 140464223209216 [Warning] Aborted connection 175442 to db: 'app_log' user: 'dep_adm' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464223209216 [Warning] Aborted connection 176296 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464093972224 [Warning] Aborted connection 176286 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464221673216 [Warning] Aborted connection 176290 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464221980416 [Warning] Aborted connection 176295 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464223823616 [Warning] Aborted connection 176289 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464224438016 [Warning] Aborted connection 176282 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464221366016 [Warning] Aborted connection 176292 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:30 140464095201024 [Warning] Aborted connection 176297 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464222902016 [Warning] Aborted connection 176283 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464225359616 [Warning] Aborted connection 176284 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464094893824 [Warning] Aborted connection 176294 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464094279424 [Warning] Aborted connection 176285 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140489927579392 [Warning] Aborted connection 176288 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464224130816 [Warning] Aborted connection 176287 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140464224745216 [Warning] Aborted connection 176291 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:05:32 140489655666432 [Warning] Aborted connection 176293 to db: 'hive' user: 'hive' host: '10.178.221.199' (Got an error reading communication packets) 2018-10-17 2:10:10 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 71e962be with addr tcp://10.178.221.195:4567 timed out, no messages seen in PT3S 2018-10-17 2:10:10 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer dd54677b with addr tcp://10.178.221.235:4567 timed out, no messages seen in PT3S 2018-10-17 2:10:10 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.178.221.195:4567 tcp://10.178.221.235:4567 2018-10-17 2:10:11 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') reconnecting to 71e962be (tcp://10.178.221.195:4567), attempt 0 2018-10-17 2:10:11 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') reconnecting to dd54677b (tcp://10.178.221.235:4567), attempt 0 2018-10-17 2:10:12 140489714030336 [Note] WSREP: evs::proto(37eb949f, OPERATIONAL, view_id(REG,37eb949f,19)) suspecting node: 71e962be 2018-10-17 2:10:12 140489714030336 [Note] WSREP: evs::proto(37eb949f, OPERATIONAL, view_id(REG,37eb949f,19)) suspected node without join message, declaring inactive 2018-10-17 2:10:12 140489714030336 [Note] WSREP: evs::proto(37eb949f, OPERATIONAL, view_id(REG,37eb949f,19)) suspecting node: dd54677b 2018-10-17 2:10:12 140489714030336 [Note] WSREP: evs::proto(37eb949f, OPERATIONAL, view_id(REG,37eb949f,19)) suspected node without join message, declaring inactive 2018-10-17 2:10:13 140489714030336 [Note] WSREP: view(view_id(NON_PRIM,37eb949f,19) memb { 37eb949f,0 } joined { } left { } partitioned { 71e962be,0 dd54677b,0 }) 2018-10-17 2:10:13 140489714030336 [Note] WSREP: view(view_id(NON_PRIM,37eb949f,20) memb { 37eb949f,0 } joined { } left { } partitioned { 71e962be,0 dd54677b,0 }) 2018-10-17 2:10:13 140489705637632 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Flow-control interval: [16, 16] 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Received NON-PRIMARY. 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3822788) 2018-10-17 2:10:13 140489705637632 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Flow-control interval: [16, 16] 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Trying to continue unpaused monitor 2018-10-17 2:10:13 140489705637632 [Note] WSREP: Received NON-PRIMARY. 2018-10-17 2:10:14 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 00000000 with addr tcp://10.178.221.235:4567 timed out, no messages seen in PT3S 2018-10-17 2:10:14 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 00000000 with addr tcp://10.178.221.195:4567 timed out, no messages seen in PT3S 2018-10-17 2:10:18 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 00000000 with addr tcp://10.178.221.195:4567 timed out, no messages seen in PT3S 2018-10-17 2:38:34 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 00000000 with addr tcp://10.178.221.235:4567 timed out, no messages seen in PT3S 2018-10-17 2:38:34 140489714030336 [Warning] WSREP: last inactive check more than PT1.5S ago (PT28M16.4376S), skipping check 2018-10-17 02:38:34 0x7fc03915e700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/os/os0file.cc line 2506 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/ InnoDB: about forcing recovery. 181017 2:38:34 [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.2.15-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=26 max_threads=1026 thread_count=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2385485 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 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 = 0x0 thread_stack 0x49000 /maria/galera/bin/mysqld(my_print_stacktrace+0x2e)[0xde328e] /maria/galera/bin/mysqld(handle_fatal_signal+0x471)[0x7e05f1] 2018-10-17 2:38:35 140464234981120 [Warning] InnoDB: A long semaphore wait: --Thread 140489927886592 has waited at trx0sys.ic line 80 for 1713.00 seconds the semaphore: X-lock on RW-latch at 0x7fc618e3ea38 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0flu.cc line 1226 2018-10-17 2:38:35 140464234981120 [Note] InnoDB: A semaphore wait: --Thread 140489927886592 has waited at trx0sys.ic line 80 for 1713.00 seconds the semaphore: X-lock on RW-latch at 0x7fc618e3ea38 created in file buf0buf.cc line 1471 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time read locked in file not yet reserved line 0 Last time write locked in file buf0flu.cc line 1226 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 2018-10-17 2:38:35 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection established to 71e962be tcp://10.178.221.195:4567 2018-10-17 2:38:35 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection established to dd54677b tcp://10.178.221.235:4567 2018-10-17 2:38:35 140489714030336 [Note] WSREP: declaring 71e962be at tcp://10.178.221.195:4567 stable 2018-10-17 2:38:35 140489714030336 [Note] WSREP: declaring dd54677b at tcp://10.178.221.235:4567 stable 2018-10-17 2:38:35 140489714030336 [Note] WSREP: Node 71e962be state prim 2018-10-17 2:38:35 140489714030336 [Note] WSREP: view(view_id(PRIM,37eb949f,21) memb { 37eb949f,0 71e962be,0 dd54677b,0 } joined { } left { } partitioned { }) 2018-10-17 2:38:35 140489714030336 [Note] WSREP: save pc into disk 2018-10-17 2:38:35 140489714030336 [Warning] WSREP: open file(/maria_data/data//gvwstate.dat.tmp) failed(Read-only file system) 2018-10-17 2:38:35 140489705637632 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2018-10-17 2:38:35 140489705637632 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 4ef66bdb-d16a-11e8-b5ef-5a3ca95d3f93 2018-10-17 2:38:35 140489705637632 [Note] WSREP: STATE EXCHANGE: sent state msg: 4ef66bdb-d16a-11e8-b5ef-5a3ca95d3f93 2018-10-17 2:38:35 140489705637632 [Note] WSREP: STATE EXCHANGE: got state msg: 4ef66bdb-d16a-11e8-b5ef-5a3ca95d3f93 from 0 (skcc-dep-db-p03) 2018-10-17 2:38:35 140489705637632 [Note] WSREP: STATE EXCHANGE: got state msg: 4ef66bdb-d16a-11e8-b5ef-5a3ca95d3f93 from 1 (skcc-dep-db-p01) 2018-10-17 2:38:35 140489705637632 [Note] WSREP: STATE EXCHANGE: got state msg: 4ef66bdb-d16a-11e8-b5ef-5a3ca95d3f93 from 2 (skcc-dep-db-p02) 2018-10-17 2:38:35 140489705637632 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 20, members = 2/3 (joined/total), act_id = 3822917, last_appl. = 3822681, protocols = 0/8/3 (gcs/repl/appl), group UUID = 21dc149d-5f25-11e8-9959-b79132e907c9 2018-10-17 2:38:35 140489705637632 [Note] WSREP: Flow-control interval: [28, 28] 2018-10-17 2:38:35 140489705637632 [Note] WSREP: Trying to continue unpaused monitor 2018-10-17 2:38:35 140489705637632 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3822917) sigaction.c:0(__restore_rt)[0x7fc6620376d0] :0(__GI_raise)[0x7fc660e43277] :0(__GI_abort)[0x7fc660e44968] /maria/galera/bin/mysqld[0xbac7a3] /maria/galera/bin/mysqld[0xab4510] /maria/galera/bin/mysqld[0xc73294] sql/item.h:651(Item)[0xc7d3f9] sql/table.cc:1016(parse_vcol_defs(THD*, st_mem_root*, TABLE*, bool*))[0xa900fa] sql/item_func.cc:3713(Item_udf_func::print(String*, enum_query_type))[0xa91dfa] sql/item.h:1970(get_item_copy)[0xc1300f] sql/sql_trigger.cc:758(Table_triggers_list::create_trigger(THD*, TABLE_LIST*, String*))[0xc14072] psi/mysql_file.h:1274(inline_mysql_file_delete)[0xc14dae] sql/item.cc:7120(Item::cache_const_expr_transformer(THD*, unsigned char*))[0xc15084] sql/item.cc:9454(resolve_const_item(THD*, Item**, Item*))[0xc15177] sql/item.h:5077(Item_copy_int)[0xc17e56] 2018-10-17 2:38:38 140489714030336 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') turning message relay requesting off pthread_create.c:0(start_thread)[0x7fc66202fe25] /lib64/libc.so.6(clone+0x6d)[0x7fc660f0bbad] 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. 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Read nil XID from storage engines, skipping position init 2018-10-17 7:45:10 140410477242176 [Note] WSREP: wsrep_load(): loading provider library '/maria/galera/lib/libgalera_smm.so' 2018-10-17 7:45:10 140410477242176 [Note] WSREP: wsrep_load(): Galera 25.3.23(r3789) by Codership Oy loaded successfully. 2018-10-17 7:45:10 140410477242176 [Note] WSREP: CRC-32C: using hardware acceleration. 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Found saved state: 21dc149d-5f25-11e8-9959-b79132e907c9:-1, safe_to_bootstrap: 0 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Passing config to GCS: base_dir = /maria_data/data/; base_host = 10.178.221.237; base_port = 4567; cert.log_conflicts = no; 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 = /maria_data/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /maria_data/data//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_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 2018-10-17 7:45:10 140410477242176 [Note] WSREP: GCache history reset: 21dc149d-5f25-11e8-9959-b79132e907c9:0 -> 21dc149d-5f25-11e8-9959-b79132e907c9:3822729 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Assign initial position for certification: 3822729, protocol version: -1 2018-10-17 7:45:10 140410477242176 [Note] WSREP: wsrep_sst_grab() 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Start replication 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Setting initial position to 21dc149d-5f25-11e8-9959-b79132e907c9:3822729 2018-10-17 7:45:10 140410477242176 [Note] WSREP: protonet asio version 0 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Using CRC-32C for message checksums. 2018-10-17 7:45:10 140410477242176 [Note] WSREP: backend: asio 2018-10-17 7:45:10 140410477242176 [Note] WSREP: gcomm thread scheduling priority set to other:0 2018-10-17 7:45:10 140410477242176 [Note] WSREP: restore pc from disk successfully 2018-10-17 7:45:10 140410477242176 [Note] WSREP: GMCast version 0 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2018-10-17 7:45:10 140410477242176 [Note] WSREP: EVS version 0 2018-10-17 7:45:10 140410477242176 [Note] WSREP: gcomm: connecting to group 'skcc-dep-db', peer '10.178.221.195:,10.178.221.235:,10.178.221.237:' 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection established to 37eb949f tcp://10.178.221.237:4567 2018-10-17 7:45:10 140410477242176 [Warning] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') address 'tcp://10.178.221.237:4567' points to own listening address, blacklisting 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection established to 71e962be tcp://10.178.221.195:4567 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2018-10-17 7:45:10 140410477242176 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection established to dd54677b tcp://10.178.221.235:4567 2018-10-17 7:45:10 140410477242176 [Note] WSREP: declaring 71e962be at tcp://10.178.221.195:4567 stable 2018-10-17 7:45:10 140410477242176 [Note] WSREP: declaring dd54677b at tcp://10.178.221.235:4567 stable 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Node 71e962be state prim 2018-10-17 7:45:10 140410477242176 [Note] WSREP: view(view_id(PRIM,37eb949f,23) memb { 37eb949f,0 71e962be,0 dd54677b,0 } joined { } left { } partitioned { }) 2018-10-17 7:45:10 140410477242176 [Note] WSREP: save pc into disk 2018-10-17 7:45:10 140410477242176 [Note] WSREP: clear restored view 2018-10-17 7:45:10 140410477242176 [Note] WSREP: gcomm: connected 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Opened channel 'skcc-dep-db' 2018-10-17 7:45:10 140410156455680 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3 2018-10-17 7:45:10 140410477242176 [Note] WSREP: Waiting for SST to complete. 2018-10-17 7:45:10 140410156455680 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 237081c5-d195-11e8-a812-d35f226df9b7 2018-10-17 7:45:10 140410156455680 [Note] WSREP: STATE EXCHANGE: sent state msg: 237081c5-d195-11e8-a812-d35f226df9b7 2018-10-17 7:45:10 140410156455680 [Note] WSREP: STATE EXCHANGE: got state msg: 237081c5-d195-11e8-a812-d35f226df9b7 from 0 (skcc-dep-db-p03) 2018-10-17 7:45:10 140410156455680 [Note] WSREP: STATE EXCHANGE: got state msg: 237081c5-d195-11e8-a812-d35f226df9b7 from 1 (skcc-dep-db-p01) 2018-10-17 7:45:10 140410156455680 [Note] WSREP: STATE EXCHANGE: got state msg: 237081c5-d195-11e8-a812-d35f226df9b7 from 2 (skcc-dep-db-p02) 2018-10-17 7:45:10 140410156455680 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 22, members = 2/3 (joined/total), act_id = 3832937, last_appl. = -1, protocols = 0/8/3 (gcs/repl/appl), group UUID = 21dc149d-5f25-11e8-9959-b79132e907c9 2018-10-17 7:45:10 140410156455680 [Note] WSREP: Flow-control interval: [28, 28] 2018-10-17 7:45:10 140410156455680 [Note] WSREP: Trying to continue unpaused monitor 2018-10-17 7:45:10 140410156455680 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3832937) 2018-10-17 7:45:10 140410401335040 [Note] WSREP: State transfer required: Group state: 21dc149d-5f25-11e8-9959-b79132e907c9:3832937 Local state: 21dc149d-5f25-11e8-9959-b79132e907c9:3822729 2018-10-17 7:45:10 140410401335040 [Note] WSREP: New cluster view: global state: 21dc149d-5f25-11e8-9959-b79132e907c9:3832937, view# 23: Primary, number of nodes: 3, my index: 0, protocol version 3 2018-10-17 7:45:10 140410401335040 [Warning] WSREP: Gap in state sequence. Need state transfer. 2018-10-17 7:45:10 140410148062976 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.178.221.237' --datadir '/maria_data/data/' --parent '23558' --binlog '/maria_log/galera-bin' ' 2018-10-17 7:45:11 140410401335040 [Note] WSREP: Prepared SST request: rsync|10.178.221.237:4444/rsync_sst 2018-10-17 7:45:11 140410401335040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-10-17 7:45:11 140410401335040 [Note] WSREP: REPL Protocols: 8 (3, 2) 2018-10-17 7:45:11 140410401335040 [Note] WSREP: Assign initial position for certification: 3832937, protocol version: 3 2018-10-17 7:45:11 140410198419200 [Note] WSREP: Service thread queue flushed. 2018-10-17 7:45:11 140410401335040 [Note] WSREP: IST receiver addr using tcp://10.178.221.237:4568 2018-10-17 7:45:11 140410401335040 [Note] WSREP: Prepared IST receiver, listening at: tcp://10.178.221.237:4568 2018-10-17 7:45:11 140410156455680 [Note] WSREP: Member 0.0 (skcc-dep-db-p03) requested state transfer from 'skcc-dep-db-p03,'. Selected 1.0 (skcc-dep-db-p01)(SYNCED) as donor. 2018-10-17 7:45:11 140410156455680 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3832937) 2018-10-17 7:45:11 140410401335040 [Note] WSREP: Requesting state transfer: success, donor: 1 2018-10-17 7:45:11 140410401335040 [Note] WSREP: GCache history reset: 21dc149d-5f25-11e8-9959-b79132e907c9:0 -> 21dc149d-5f25-11e8-9959-b79132e907c9:3832937 2018-10-17 7:45:13 140410164848384 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') connection to peer 37eb949f with addr tcp://10.178.221.237:4567 timed out, no messages seen in PT3S 2018-10-17 7:45:13 140410164848384 [Note] WSREP: (37eb949f, 'tcp://0.0.0.0:4567') turning message relay requesting off 2018-10-17 7:45:50 140410156455680 [Note] WSREP: 1.0 (skcc-dep-db-p01): State transfer to 0.0 (skcc-dep-db-p03) complete. 2018-10-17 7:45:50 140410156455680 [Note] WSREP: Member 1.0 (skcc-dep-db-p01) synced with group. WSREP_SST: [INFO] Extracting binlog files: (20181017 07:45:50.386) galera-bin.000191 WSREP_SST: [INFO] Joiner cleanup. rsync PID: 23617 (20181017 07:45:50.874) WSREP_SST: [INFO] Joiner cleanup done. (20181017 07:45:51.381) 2018-10-17 7:45:51 140410477242176 [Note] WSREP: SST complete, seqno: 3832937 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: For Galera, using innodb_lock_schedule_algorithm=fcfs 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Uses event mutexes 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Using Linux native AIO 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Number of pools: 1 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Using SSE2 crc32 instructions 2018-10-17 7:45:51 140410477242176 [Note] InnoDB: Initializing buffer pool, total size = 22G, instances = 11, chunk size = 128M 2018-10-17 7:45:52 140410477242176 [Note] InnoDB: Completed initialization of buffer pool 2018-10-17 7:45:52 140384015369984 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-10-17 7:45:52 140410477242176 [Note] InnoDB: Highest supported file format is Barracuda. 2018-10-17 7:45:53 140410477242176 [Note] InnoDB: Starting crash recovery from checkpoint LSN=37406663187 2018-10-17 7:46:03 140410477242176 [Note] InnoDB: Last binlog file '/maria_log/galera-bin.000190', position 78004755 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: Setting file '/maria_data/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: File '/maria_data/data/ibtmp1' size is now 12 MB. 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: Waiting for purge to start 2018-10-17 7:46:11 140410477242176 [Note] InnoDB: 5.7.22 started; log sequence number 37406663196 2018-10-17 7:46:11 140384546051840 [Note] InnoDB: Loading buffer pool(s) from /maria_data/data/ib_buffer_pool 2018-10-17 7:46:11 140410477242176 [Note] Plugin 'FEEDBACK' is disabled. 2018-10-17 7:46:11 140410477242176 [Note] Recovering after a crash using /maria_log/galera-bin 2018-10-17 7:46:11 140410477242176 [Note] Starting crash recovery... 2018-10-17 7:46:11 140410477242176 [Note] Crash recovery finished. 2018-10-17 7:46:11 140410477242176 [Note] Server socket created on IP: '0.0.0.0'. 2018-10-17 7:46:11 140410477242176 [Warning] 'user' entry 'root@skcc-dep-db-p01.skcc-dep.com' ignored in --skip-name-resolve mode. 2018-10-17 7:46:11 140410477242176 [Warning] 'proxies_priv' entry '@% root@skcc-dep-db-p01.skcc-dep.com' ignored in --skip-name-resolve mode. 2018-10-17 7:46:11 140410477242176 [Note] WSREP: Signalling provider to continue. 2018-10-17 7:46:11 140410477242176 [Note] WSREP: SST received: 21dc149d-5f25-11e8-9959-b79132e907c9:3832937 2018-10-17 7:46:11 140410156455680 [Note] WSREP: 0.0 (skcc-dep-db-p03): State transfer from 1.0 (skcc-dep-db-p01) complete. 2018-10-17 7:46:11 140410156455680 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3832937) 2018-10-17 7:46:11 140410477242176 [Note] Reading of all Master_info entries succeded 2018-10-17 7:46:11 140410477242176 [Note] Added new Master_info '' to hash table 2018-10-17 7:46:11 140410477242176 [Note] /maria/galera/bin/mysqld: ready for connections. Version: '10.2.15-MariaDB-log' socket: '/maria/tmp/galera.sock' port: 3306 MariaDB Server 2018-10-17 7:46:11 140410156455680 [Note] WSREP: Member 0.0 (skcc-dep-db-p03) synced with group. 2018-10-17 7:46:11 140410156455680 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3832937) 2018-10-17 7:46:11 140410401335040 [Note] WSREP: Synchronized with group, ready for connections 2018-10-17 7:46:11 140410401335040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-10-17 7:46:11 140409729791744 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2018-10-17 7:46:51 140384546051840 [Note] InnoDB: Buffer pool(s) load completed at 181017 7:46:51