Bug #56676 | 'show slave status' ,'show global status' hang when 'stop slave' takes too long | ||
---|---|---|---|
Submitted: | 9 Sep 2010 8:52 | Modified: | 10 Jan 2013 11:12 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.1.50 | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[9 Sep 2010 8:52]
Shane Bester
[9 Sep 2010 8:58]
MySQL Verification Team
it might be considered a feature request to improve this. it's annoying problem to deal with at the moment. the real-life use case is when a long-running query is being run by the sql thread, 'stop slave' will hang, and this problem is apparent there. see related support issue for example (email 4).
[9 Sep 2010 9:04]
Andrei Elkin
STOP-SLAVE handler acquires at least two mutex:s starting from LOCK_active_mi. When it goes to cond_wait it actually releases the last one which is `mi->run_lock' and to keep LOCK_active_mi locked. It requires investigation whether LOCK_active_mi is really necessary to hold that long by STOP-SLAVE handler.
[29 Jun 2011 11:14]
MySQL Verification Team
see bug #42930 for another show global status problem.
[10 Jan 2013 11:12]
Erlend Dahl
Fixed in 5.7.0