Not the answer you need?
Register and ask your own question!

Unable to stop XtraDB cluster node

shahidbashir7861shahidbashir7861 EntrantCurrent User Role Novice

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.



  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    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.
  • shahidbashir7861shahidbashir7861 Entrant Current User Role Novice
    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.

  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    Great to hear you got it working.
    Happy using PXC :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.