Shutting down MySQL, ERROR!

22 views
Skip to first unread message

Network/Systems Administrator

unread,
Sep 12, 2017, 2:32:10 PM9/12/17
to codership
when performing a normal shutdown (/etc/init.d/mysql stop) on 1 node of a 3 node cluster i'm receiving the following output:

Shutting down MySQL.................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... ERROR!


Log:
2017-09-12 13:22:39 32142 [Note] /usr/sbin/mysqld: Normal shutdown

2017-09-12 13:22:39 32142 [Note] WSREP: Stop replication
2017-09-12 13:22:39 32142 [Note] WSREP: Closing send monitor...
2017-09-12 13:22:39 32142 [Note] WSREP: Closed send monitor.
2017-09-12 13:22:39 32142 [Note] WSREP: gcomm: terminating thread
2017-09-12 13:22:39 32142 [Note] WSREP: gcomm: joining thread
2017-09-12 13:22:39 32142 [Note] WSREP: gcomm: closing backend
2017-09-12 13:22:39 32142 [Note] WSREP: view(view_id(NON_PRIM,45883e00,21) memb {
        90576b6c,0
} joined {
} left {
} partitioned {
        45883e00,0
        b8680ff9,0
})
2017-09-12 13:22:39 32142 [Note] WSREP: view((empty))
2017-09-12 13:22:39 32142 [Note] WSREP: gcomm: closed
2017-09-12 13:22:39 32142 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2017-09-12 13:22:39 32142 [Note] WSREP: Flow-control interval: [16, 16]
2017-09-12 13:22:39 32142 [Note] WSREP: Received NON-PRIMARY.
2017-09-12 13:22:39 32142 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 296366268)
2017-09-12 13:22:39 32142 [Note] WSREP: Received self-leave message.
2017-09-12 13:22:39 32142 [Note] WSREP: Flow-control interval: [0, 0]
2017-09-12 13:22:39 32142 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2017-09-12 13:22:39 32142 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 296366268)
2017-09-12 13:22:39 32142 [Note] WSREP: RECV thread exiting 0: Success
2017-09-12 13:22:39 32142 [Note] WSREP: recv_thread() joined.
2017-09-12 13:22:39 32142 [Note] WSREP: Closing replication queue.
2017-09-12 13:22:39 32142 [Note] WSREP: Closing slave action queue.
2017-09-12 13:22:39 32142 [Note] WSREP: New cluster view: global state: 6e288bd8-05ab-11e7-9eab-df926b9d300d:296366268, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3
2017-09-12 13:22:39 32142 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-09-12 13:22:39 32142 [Note] WSREP: New cluster view: global state: 6e288bd8-05ab-11e7-9eab-df926b9d300d:296366268, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3
2017-09-12 13:22:39 32142 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-09-12 13:22:39 32142 [Note] WSREP: applier thread exiting (code:0)
2017-09-12 13:22:41 32142 [Note] WSREP: killing local connection: 291187
2017-09-12 13:22:41 32142 [Note] WSREP: killing local connection: 289578
2017-09-12 13:22:41 32142 [Note] WSREP: killing local connection: 289043
2017-09-12 13:22:41 32142 [Note] WSREP: killing local connection: 289579

has anyone experience this type of behavior? i've been able to stop/start & restart single nodes without an issue up until today. no configuration changes have been made...

MySQL/Galera Versions:
mysql-wsrep-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64
mysql-wsrep-client-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64
mysql-wsrep-devel-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64
mysql-wsrep-libs-compat-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64
mysql-wsrep-server-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64
mysql-wsrep-shared-5.6-5.6.35-25.18.20170106.1f9ae89.el6.x86_64

galera-3-25.3.20-2.el6.x86_64

Reply all
Reply to author
Forward
0 new messages