Unable to stop XtraDB cluster node

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hello,

I have setup a two node cluster using using MySQL-5.7. Now i am trying to stop one of the nodes using the command “systemctl stop mysql” and it keeps waiting. I can see the following at the end of the logs

2018-08-29T16:40:19.055121Z 2 [Note] WSREP: Setting wsrep_ready to false
2018-08-29T16:40:19.055080Z 0 [Note] WSREP: RECV thread exiting 0: Success
2018-08-29T16:40:19.055267Z 0 [Note] WSREP: recv_thread() joined.
2018-08-29T16:40:19.055298Z 0 [Note] WSREP: Closing replication queue.
2018-08-29T16:40:19.055322Z 0 [Note] WSREP: Closing slave action queue.
2018-08-29T16:40:19.055345Z 0 [Note] WSREP: Waiting for active wsrep applier to exit
mysql: [Warning] Using a password on the command line interface can be insecure.

It seems while it is stopping the server it tries to use some command close to the end and that is not responding. Please help.

Thanks.

2

Seems like applier thread is busy applying replicated action. But of-course it should exit.
Do you have reproducible test-case. We can investigate the problem.

Also, please share complete log files and error log.

3

Hey Krunal,

It seems i had defined a script in wsrep_notify_cmd that was causing this issue. I have disabled this option at the moment and now it is stopping as expected.

Thanks.

4

Great to hear you got it working.
Happy using PXC :slight_smile: