Bugs - Deadlocked Slave When Running SHOW/KILL/STOP SLAVE Commands. (Doc ID 1588518.1)

Last updated on JANUARY 23, 2016

Applies to:

MySQL Server - Version 5.5 to 5.7 [Release 5.5 to 5.7]
Information in this document applies to any platform.

Goal

Problem:
------------

Slave server can become totally deadlocked and hang when executing certain SHOW or STOP SLAVE commands.
Command hangs/deadlocks have been seen and often involve one or more of the following:

o) MTS (Multi thread slave) had some deadlocks in older versions of 5.6.
o) FLUSH TABLES WITH READ LOCK may have been executed first.
o) SHOW PROCESSLIST
o) SHOW SLAVE STATUS
o) STOP SLAVE/START SLAVE
o) SHOW MASTER LOGS
o) binary log rotation caused by PURGE MASTER LOG,S or max_binlog_size was hit, or expire_logs_days is set.
o) A reconnecting slave who tries to KILL zombie slaves.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms