Bug #21965 mysqld hangs in "show master logs" in parallell with switching log file
Submitted: 1 Sep 2006 14:58 Modified: 6 Sep 2006 12:32
Reporter: Jonas Oreland
Status: Closed
Category:Server: Replication Severity:S3 (Non-critical)
Version:5.1-wl2325-5.0 OS:
Assigned to: Jonas Oreland Target Version:

[1 Sep 2006 14:58] Jonas Oreland 
Description:
mysqld deadlocks if doing "show master logs" parallell to switching log file

How to repeat:
1-ndb node
1-mysqld writing binlog, using "max-binlog-size=<a small value>" (I used 10m)
1-ndbapi program running at full speed, creating big load on binlog
1-mysql client script doing "show master logs;" at full speed
[1 Sep 2006 15:06] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11261

ChangeSet@1.2042, 2006-09-01 15:06:16+02:00, jonas@perch.ndb.mysql.com +3 -0
  bug#21965 - replication
    fix deadlock between "show master logs" and switching of logfile
[1 Sep 2006 22:01] Jonas Oreland 
Found that bug is present in 4.1, 5.0 and 5.1
And was introduced 2005-09 something.
[4 Sep 2006 13:43] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11345

ChangeSet@1.2544, 2006-09-04 13:43:34+02:00, jonas@perch.ndb.mysql.com +3 -0
  bug#21965 - replication
    fix deadlock if master switches log file in parallell with "show master logs"
[4 Sep 2006 14:19] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11349

ChangeSet@1.2293, 2006-09-04 14:19:39+02:00, jonas@perch.ndb.mysql.com +1 -0
  bug#21965
    merge to 5.1
[4 Sep 2006 14:28] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11350

ChangeSet@1.2294, 2006-09-04 14:26:18+02:00, jonas@perch.ndb.mysql.com +1 -0
  bug#21965
      merge to 5.1 - yet another merge fix
[6 Sep 2006 9:07] Jonas Oreland 
pushed into 4.1.22 and 5.0.25 and 5.1.12
[6 Sep 2006 12:32] MC Brown 
A note has been added to the 5.1.12, 5.0.25, and 4.1.22 changelogs: 

Running <literal>SHOW MASTER LOGS</literal> at the same time as binary log files were
being switched would cause <literal>mysqld</literal> to hang. (Bug #21965)
[8 Sep 2006 12:46] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/11613

ChangeSet@1.2026, 2006-09-08 12:46:23+02:00, jonas@perch.ndb.mysql.com +4 -0
  ndb -
    recommit bug#21965 only drop14c