Bug #21965 mysqld hangs in "show master logs" in parallell with switching log file
Submitted: 1 Sep 2006 12:58 Modified: 6 Sep 2006 10:32
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1-wl2325-5.0 OS:
Assigned to: Jonas Oreland CPU Architecture:Any

[1 Sep 2006 12: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 13: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 20: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 11: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 12: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 12: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 7:07] Jonas Oreland
pushed into 4.1.22 and 5.0.25 and 5.1.12
[6 Sep 2006 10: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 10: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