[MDEV-15998] Impossible to stop a replicating database Created: 2018-04-24  Updated: 2018-07-31  Resolved: 2018-07-31

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.1.32
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Benjamin Rigaud Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Ubuntu Trusty


 Description   

Hello,

Every two months, one replica won't stop (we stop it twice a day).
Am forced to do manually:
`STOP SLAVE;`
`FLUSH TABLES;`
And to send a SIGKILL.

Most tables use Aria engine, some TokuDB.
I kept the service in this state to be able to debug it if possible. What can I do without risking any corruption on my data?

Regards,
Ben

 Comments   
Comment by Benjamin Rigaud [ 2018-05-28 ]

It just occured again this weekend with Maria 10.1.33.

Regards,
Ben

Comment by Elena Stepanova [ 2018-05-28 ]

What do you mean by "replica won't stop"? The replication does not stop, despite your running STOP SLAVE? The command STOP SLAVE does not finish execution? The server does not stop when you are trying to shut it down?
Please clarify, attach your error log, and if possible, when the server reaches the state that troubles you (whatever it is), run 

gdb --batch --eval-command="thread apply all bt" <path to mysqld binary> <mysqld pid file>"

.

Comment by Benjamin Rigaud [ 2018-05-28 ]

Sorry If I was unclear: the mysql process won't stop when I do a "sudo service mysql stop"
This MariaDB instance is a replica.

I restarted the server one hour ago, I'll try this gdb command as soon as I have this issue again (in few weeks )

Comment by Sergei Golubchik [ 2018-07-02 ]

BenO, did you have this issue again?

Generated at Thu Feb 08 08:25:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.