Bug #37750 read only stops replication
Submitted: 30 Jun 2008 19:58 Modified: 1 Aug 2008 13:31
Reporter: Jeff Demel Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:4.1.22 OS:Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any
Tags: read only, replication

[30 Jun 2008 19:58] Jeff Demel 
Description:
I have replication up and running.  When I enable read-only on the slave, it stops processing queries on the slave, although the slave threads do not stop, and no errors are reported.  It's as if the SQL thread stops working, but there are no errors.

How to repeat:
To repeat, run the following on your slave:

FLUSH TABLES WITH READ LOCK;
SET GLOBAL read_only = ON;
[30 Jun 2008 21:30] Jeff Demel 
This was a syntax issue, apparently.  It's not a bug.
[1 Jul 2008 13:31] Susanne Ebrecht 
Many thanks for writing a bug report.

Do I understand you right? Can we close this bug report?
[1 Aug 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".