Slave thread stuck in Waiting for Global Read Lock (Doc ID 1475278.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

On : 5.5 version, the mysqldump Command-Line Tool

ACTUAL BEHAVIOR
---------------
When performing a mysqldump task on the server, it freezes/hangs and has to be killed to continue.

EXPECTED BEHAVIOR
-----------------------
The mysqldump program should continue as normal to completion without hanging.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Binary logging was enabled.
2. Slave thread was in the process of being killed.
3. A SHOW PROCESSLIST command was in play.
4. An UPDATE command was being used that may have rotated the binary log.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot effectively back up the database or get confused when it works sometimes and not other times.

Cause

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