two thousand and seventeen - 09 - 14T15 : thirty-eight : 44.398172Z zero [ Warning ] option 'max_binlog_size' : unsigned value two billion one hundred and forty-seven million four hundred and eighty-three thousand six hundred and forty-eight adjusted to one billion seventy-three million seven hundred and forty-one thousand eight hundred and twenty-four
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point three nine eight three one seven + 08 : 00 zero [ Warning ] TIMESTAMP with implicit DEFAULT value is deprecated . Please use -- explicit_defaults_for_timestamp server option ( see documentation for more details ) .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point three nine eight three five four + 08 : 00 zero [ Warning ] 'NO_ZERO_DATE' , 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode . They will be merged with strict mode in a future release .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point four one five one nine zero + 08 : 00 zero [ Note ] -- secure - file - priv is set to NULL . Operations related to importing and exporting data are disabled
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point four one five two four five + 08 : 00 zero [ Note ] / usr / local / mysql / bin / mysqld ( mysqld 5.7.18 - fifteen - twenty-nine point two zero - log ) starting as process two thousand two hundred and seven . . .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point five three zero three nine two + 08 : 00 zero [ Note ] WSREP : No pre - stored wsrep - start position found . Skipping position initialization .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point five three zero four three nine + 08 : 00 zero [ Note ] WSREP : wsrep_load ( ) : loading provider library '/usr/local/mysql/lib/libgalera_smm.so'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point five nine nine four eight five + 08 : 00 zero [ Note ] WSREP : wsrep_load ( ) : Galera three point two zero ( r ) by Codership Oy < info @ codership . com > loaded successfully .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point five nine nine six eight four + 08 : 00 zero [ Note ] WSREP : CRC - 32C : using hardware acceleration .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point six zero two five three five + 08 : 00 zero [ Note ] WSREP : galera / src / saved_state . cpp : SavedState ( ) : one hundred and twenty : Found saved state : d205fc58 - nine thousand nine hundred and forty-seven - 11e7 - 905a - 2b8124076583 : zero , safe_to_bootsrap : one
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point six three five five one three + 08 : 00 zero [ Note ] WSREP : galera / src / galera_gcs . hpp : Gcs ( ) : eighty-nine : Passing config to GCS : base_dir = / data / three thousand three hundred and six / data / ; base_host = 1.1.1.113 ; base_port = four thousand five hundred and sixty-seven ; cert . log_conflicts = no ; debug = one ; evs . auto_evict = zero ; 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 = three ; evs . send_window = ten ; evs . stats_report_period = PT1M ; evs . suspect_timeout = PT5S ; evs . user_send_window = four ; evs . view_forget_timeout = PT24H ; gcache . dir = / data / three thousand three hundred and six / data / ; gcache . keep_pages_count = zero ; gcache . keep_pages_size = zero ; gcache . mem_size = zero ; gcache . name = / data / three thousand three hundred and six / data //galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 1G; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; 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 = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven seven five five one + 08 : 00 zero [ Note ] WSREP : galera / src / certification . cpp : assign_initial_position ( ) : nine hundred and thirteen : Assign initial position for certification : zero , protocol version : - one
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven seven six two three + 08 : 00 zero [ Note ] WSREP : Preparing to initiate SST / IST
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven seven six three one + 08 : 00 zero [ Note ] WSREP : Starting replication
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven seven six six three + 08 : 00 zero [ Note ] WSREP : galera / src / replicator_smm . cpp : connect ( ) : three hundred and forty-two : Setting initial position to d205fc58 - nine thousand nine hundred and forty-seven - 11e7 - 905a - 2b8124076583 : zero
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven eight zero six three + 08 : 00 zero [ Note ] WSREP : gcomm / src / datagram . cpp : checksum_type ( ) : twenty-six : Using CRC - 32C for message checksums .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven eight three eight three + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : connect ( ) : two hundred and seventy-nine : gcomm thread scheduling priority set to other : zero
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven eight five six five + 08 : 00 zero [ Warning ] WSREP : gcomm / src / view . cpp : read_file ( ) : three hundred and eighty-nine : Fail to access the file ( / data / three thousand three hundred and six / data //gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven eight five seven six + 08 : 00 zero [ Note ] WSREP : gcomm / src / pc . cpp : PC ( ) : two hundred and fifty-six : Restoring primary - component from disk failed . Either node is booting for first time or re - booting after a graceful shutdown
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven nine two three nine + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : GMCast ( ) : ninety-eight : GMCast version zero
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven nine five eight four + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : GMCast ( ) : one hundred and ninety-one : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) listening at tcp : //0.0.0.0:4567
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven seven nine six zero four + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : GMCast ( ) : one hundred and ninety-two : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) multicast : , ttl : one
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight zero zero five four + 08 : 00 zero [ Note ] WSREP : gcomm / src / evs_proto . cpp : Proto ( ) : one hundred and ninety-nine : EVS version zero
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight zero three one zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : connect ( ) : three hundred and nine : gcomm : connecting to group 'Byrd_PXC' , peer '1.1.1.111:,1.1.1.112:,1.1.1.113:'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight four seven six eight + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : handle_established ( ) : five hundred and fifty-five : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) connection established to cae2ac03 tcp : //1.1.1.113:4567
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight four eight four one + 08 : 00 zero [ Warning ] WSREP : gcomm / src / gmcast . cpp : handle_established ( ) : five hundred and eighty : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) address ' tcp://1.1.1.113:4567 ' points to own listening address , blacklisting
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight five two six eight + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : handle_established ( ) : five hundred and fifty-five : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) connection established to e0f85c9b tcp : //1.1.1.111:4567
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight five three six three + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : check_liveness ( ) : one thousand one hundred and forty-seven : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) turning message relay requesting on , nonlive peers :
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point seven eight five three eight four + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : handle_established ( ) : five hundred and fifty-five : ( cae2ac03 , ' tcp://0.0.0.0:4567 ' ) connection established to 857db596 tcp : //1.1.1.112:4567
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point eight six one six six nine + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : handle_stable_view ( ) : one thousand five hundred and ninety-seven : declaring 857db596 at tcp : //1.1.1.112:4567 stable
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point eight six one eight one six + 08 : 00 zero [ Note ] WSREP : gcomm / src / gmcast . cpp : handle_stable_view ( ) : one thousand five hundred and ninety-seven : declaring e0f85c9b at tcp : //1.1.1.111:4567 stable
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point eight six three seven one nine + 08 : 00 zero [ Note ] WSREP : gcomm / src / pc_proto . cpp : is_prim ( ) : seven hundred and ninety-six : Node 857db596 state primary
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point eight six six four seven five + 08 : 00 zero [ Note ] WSREP : gcomm / src / pc_proto . cpp : deliver_view ( ) : two hundred and twenty-nine : Current view of cluster as seen by this node
view ( view_id ( PRIM , 857db596 , seventeen )
memb {
857db596 , zero
cae2ac03 , zero
e0f85c9b , zero
}
joined {
}
left {
}
partitioned {
}
)
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-four point eight six six five two six + 08 : 00 zero [ Note ] WSREP : gcomm / src / pc . cpp : handle_up ( ) : thirty : Save the discovered primary - component to disk
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight four five two seven + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : connect ( ) : three hundred and nineteen : gcomm : connected
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight four nine six four + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_shift_state ( ) : five hundred and ninety-six : Shifting CLOSED - > OPEN ( TO : zero )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight five five one eight + 08 : 00 zero [ Note ] WSREP : Waiting for SST / IST to complete .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six four nine nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_comp_msg ( ) : four hundred and ten : New COMPONENT : primary = yes , bootstrap = no , my_idx = one , memb_num = three
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six six eight zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_core . cpp : core_handle_comp_msg ( ) : seven hundred and seventy-one : STATE EXCHANGE : Waiting for state UUID .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six eight four zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_core . cpp : core_handle_uuid_msg ( ) : eight hundred and sixty-one : STATE EXCHANGE : sent state msg : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six eight seven zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_state_msg ( ) : five hundred and ninety-two : STATE EXCHANGE : got state msg : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35 from zero ( MySQL02 )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six eight nine four + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : group_print_state_debug ( ) : five hundred and seventy-four :
Version : four
Flags : 0x3
Protocols : zero / seven / three
State : SYNCED
Desync count : zero
Prim state : SYNCED
Prim UUID : 86182a4e - nine thousand nine hundred and sixty-two - 11e7 - eight thousand nine hundred and thirty-five - 13a5c5d97653
Prim seqno : six
First seqno : - one
Last seqno : zero
Prim JOINED : two
State UUID : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35
Group UUID : e91545a3 - nine thousand nine hundred and sixty-one - 11e7 - a297 - a6d9abf17c70
Name : 'MySQL02'
Incoming addr : '1.1.1.112:3306'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six nine one zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_state_msg ( ) : five hundred and ninety-two : STATE EXCHANGE : got state msg : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35 from two ( MySQL01 )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two eight six nine three zero + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : group_print_state_debug ( ) : five hundred and seventy-four :
Version : four
Flags : 0x2
Protocols : zero / seven / three
State : SYNCED
Desync count : zero
Prim state : SYNCED
Prim UUID : 86182a4e - nine thousand nine hundred and sixty-two - 11e7 - eight thousand nine hundred and thirty-five - 13a5c5d97653
Prim seqno : six
First seqno : - one
Last seqno : zero
Prim JOINED : two
State UUID : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35
Group UUID : e91545a3 - nine thousand nine hundred and sixty-one - 11e7 - a297 - a6d9abf17c70
Name : 'MySQL01'
Incoming addr : '1.1.1.111:3306'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine one three four nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_state_msg ( ) : five hundred and ninety-two : STATE EXCHANGE : got state msg : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35 from one ( MySQL03 )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine one four two nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : group_print_state_debug ( ) : five hundred and seventy-four :
Version : four
Flags : 00
Protocols : zero / seven / three
State : NON - PRIMARY
Desync count : zero
Prim state : NON - PRIMARY
Prim UUID : 00000000 - 0000 - 0000 - 0000 - 000000000000
Prim seqno : - one
First seqno : - one
Last seqno : zero
Prim JOINED : zero
State UUID : cb033ff5 - nine thousand nine hundred and sixty-two - 11e7 - 95e0 - 4f27451b8c35
Group UUID : d205fc58 - nine thousand nine hundred and forty-seven - 11e7 - 905a - 2b8124076583
Name : 'MySQL03'
Incoming addr : '1.1.1.113:3306'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine one four six four + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : group_post_state_exchange ( ) : three hundred and sixty-nine : Quorum results :
version = four ,
component = PRIMARY ,
conf_id = six ,
members = two / three ( primary / total ) ,
act_id = zero ,
last_appl . = - one ,
protocols = zero / seven / three ( gcs / repl / appl ) ,
group UUID = e91545a3 - nine thousand nine hundred and sixty-one - 11e7 - a297 - a6d9abf17c70
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine one five nine one + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : _set_fc_limits ( ) : eight hundred and three : Flow - control interval : [ one hundred and seventy-three , one hundred and seventy-three ]
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine one six one six + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_shift_state ( ) : five hundred and ninety-six : Shifting OPEN - > PRIMARY ( TO : zero )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine two six nine zero + 08 : 00 two [ Note ] WSREP : galera / src / replicator_smm . cpp : process_conf_change ( ) : one thousand five hundred and thirty-six : State transfer required :
Group state : e91545a3 - nine thousand nine hundred and sixty-one - 11e7 - a297 - a6d9abf17c70 : zero
Local state : d205fc58 - nine thousand nine hundred and forty-seven - 11e7 - 905a - 2b8124076583 : zero
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine two eight two zero + 08 : 00 two [ Note ] WSREP : New cluster view : global state : e91545a3 - nine thousand nine hundred and sixty-one - 11e7 - a297 - a6d9abf17c70 : zero , view # 7: Primary, number of nodes: 3, my index: 1, protocol version 3
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine two eight eight four + 08 : 00 two [ Warning ] WSREP : Gap in state sequence . Need state transfer .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point two nine three five eight four + 08 : 00 zero [ Note ] WSREP : Initiating SST / IST transfer on JOINER side ( wsrep_sst_xtrabackup - v2 -- role 'joiner' -- address '1.1.1.113' -- datadir '/data/3306/data/' -- defaults - file '/etc/my.cnf' -- defaults - group - suffix '' -- parent '2207' -- binlog '/data/3306/sql_log/mysql-bin' )
which : no xtrabackup in ( / usr / sbin : / sbin : / opt / Percona - XtraDB - Cluster - 5.7.18 - rel15 - 29.20.1.Linux.x86_64.ssl101 / bin : / usr / local / sbin : / usr / local / bin : / usr / sbin : / usr / bin : / root / bin )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six one nine seven three + 08 : 00 WSREP_SST : [ ERROR ] ******************* FATAL ERROR * *********************
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six four four seven four + 08 : 00 WSREP_SST : [ ERROR ] xtrabackup not in path : / usr / sbin : / sbin : / opt / Percona - XtraDB - Cluster - 5.7.18 - rel15 - 29.20.1.Linux.x86_64.ssl101 / bin : / usr / local / sbin : / usr / local / bin : / usr / sbin : / usr / bin : / root / bin
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six five eight three eight + 08 : 00 WSREP_SST : [ ERROR ] ******************************************************
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six six zero nine two + 08 : 00 zero [ ERROR ] WSREP : Failed to read 'ready <addr>' from : wsrep_sst_xtrabackup - v2 -- role 'joiner' -- address '1.1.1.113' -- datadir '/data/3306/data/' -- defaults - file '/etc/my.cnf' -- defaults - group - suffix '' -- parent '2207' -- binlog '/data/3306/sql_log/mysql-bin'
Read : '(null)'
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six six two four two + 08 : 00 zero [ ERROR ] WSREP : Process completed with error : wsrep_sst_xtrabackup - v2 -- role 'joiner' -- address '1.1.1.113' -- datadir '/data/3306/data/' -- defaults - file '/etc/my.cnf' -- defaults - group - suffix '' -- parent '2207' -- binlog '/data/3306/sql_log/mysql-bin' : two ( No such file or directory )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six six three one zero + 08 : 00 two [ ERROR ] WSREP : Failed to prepare for 'xtrabackup-v2' SST . Unrecoverable .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six six three two two + 08 : 00 two [ ERROR ] Aborting
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-five point four six six three two five + 08 : 00 two [ Note ] Giving two client threads a chance to die gracefully
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven one five seven + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_sm . cpp : gcs_sm_close ( ) : seventy-six : Closing send monitor . . .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven two two eight + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_sm . cpp : gcs_sm_close ( ) : one hundred and six : Closed send monitor .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven two five seven + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : close ( ) : three hundred and thirty-one : gcomm : terminating thread
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven two seven six + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : close ( ) : three hundred and thirty-four : gcomm : joining thread
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven three zero eight + 08 : 00 one [ Note ] WSREP : rollbacker thread exiting
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six seven nine two nine + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : close ( ) : three hundred and thirty-eight : gcomm : closing backend
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six eight nine nine three + 08 : 00 two [ Note ] WSREP : gcomm / src / pc_proto . cpp : deliver_view ( ) : two hundred and twenty-nine : Current view of cluster as seen by this node
view ( view_id ( NON_PRIM , 857db596 , seventeen )
memb {
cae2ac03 , zero
}
joined {
}
left {
}
partitioned {
857db596 , zero
e0f85c9b , zero
}
)
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine one four eight + 08 : 00 two [ Note ] WSREP : gcomm / src / pc_proto . cpp : deliver_view ( ) : two hundred and twenty-nine : Current view of cluster as seen by this node
view ( ( empty ) )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine four six seven + 08 : 00 two [ Note ] WSREP : gcs / src / gcs_gcomm . cpp : close ( ) : three hundred and fifty : gcomm : closed
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine five six nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_comp_msg ( ) : four hundred and ten : New COMPONENT : primary = no , bootstrap = no , my_idx = zero , memb_num = one
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine five eight four + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : _set_fc_limits ( ) : eight hundred and three : Flow - control interval : [ one hundred , one hundred ]
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine five eight nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_handle_act_conf ( ) : nine hundred and twenty-three : Received NON - PRIMARY .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine five nine two + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_shift_state ( ) : five hundred and ninety-six : Shifting PRIMARY - > OPEN ( TO : zero )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine five nine nine + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs_group . cpp : gcs_group_handle_comp_msg ( ) : four hundred and thirty : Received self - leave message .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine six zero three + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : _set_fc_limits ( ) : eight hundred and three : Flow - control interval : [ zero , zero ]
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine six zero six + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_handle_act_conf ( ) : nine hundred and nineteen : Received SELF - LEAVE . Closing connection .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine six zero eight + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_shift_state ( ) : five hundred and ninety-six : Shifting OPEN - > CLOSED ( TO : zero )
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine six one three + 08 : 00 zero [ Note ] WSREP : gcs / src / gcs . cpp : gcs_recv_thread ( ) : one thousand four hundred and ten : RECV thread exiting zero : Success
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine seven seven three + 08 : 00 two [ Note ] WSREP : gcs / src / gcs . cpp : _close ( ) : one thousand one hundred and ninety-seven : recv_thread ( ) joined .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine seven eight eight + 08 : 00 two [ Note ] WSREP : gcs / src / gcs . cpp : _close ( ) : one thousand two hundred and three : Closing replication queue .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine seven nine two + 08 : 00 two [ Note ] WSREP : gcs / src / gcs . cpp : _close ( ) : one thousand two hundred and twenty-six : Closing slave action queue .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine eight four four + 08 : 00 zero [ Note ] WSREP : Waiting for active wsrep applier to exit
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine eight four nine + 08 : 00 zero [ Note ] WSREP : Service disconnected .
two thousand and seventeen - 09 - 14T23 : thirty-eight : forty-seven point four six nine eight five one + 08 : 00 zero [ Note ] WSREP : Waiting to close threads . . . . . .
two thousand and seventeen - 09 - 14T23 : thirty-eight : fifty-two point four seven zero five six two + 08 : 00 zero [ Note ] WSREP : Some threads may fail to exit .
two thousand and seventeen - 09 - 14T23 : thirty-eight : fifty-two point four seven zero seven six four + 08 : 00 zero [ Note ] Binlog end
two thousand and seventeen - 09 - 14T23 : thirty-eight : fifty-two point four seven one zero seven four + 08 : 00 zero [ Note ] / usr / local / mysql / bin / mysqld : Shutdown complete