Bug #21806 Incorrect handling of cluster restart in binlog
Submitted: 24 Aug 2006 8:44 Modified: 28 Dec 2006 14:24
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version: OS:
Assigned to: Tomas Ulin CPU Architecture:Any

[24 Aug 2006 8:44] Jonas Oreland
Description:
>./mysql-test-run.pl --valgrind-all --mysqld=--binlog-format=row ndb_binlog_discover
or
>./mysql-test-run.pl --manual-gdb --mysqld=--binlog-format=row ndb_binlog_discover
 (with master actually running in valgrind)

and watch it not function, some errors:

1) sometimes schema_gci get set to 0 in
    void NdbEventBuffer::add_op(), m_active_op_count == 0
  makeing mysqld think that a restart --initial work

2) every now and then a trailing share comes around, 
  which will be freed multiple times, doing "invalid read", causing pain and
  missery.

behaviour is random (at best) and clearly does not work.

How to repeat:
mysql-test-run.pl --valgrind-all --mysqld=--binlog-format=row ndb_binlog_discover

normally does the trick.
watch master(1).err and notice 1) or 2)
[24 Aug 2006 18:29] Jonas Oreland
martin: why do you assign it to you?
[25 Aug 2006 6:57] 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/10864

ChangeSet@1.2285, 2006-08-25 08:57:38+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#21806
    disable ndb_autodiscover3 (cluster restart (--initial))
[12 Sep 2006 13:04] Ingo Strüwing
Hi Jonas,

may this possibly also fix this:

ndb_binlog_discover            [ fail ]

Errors are (from /dev/shm/var-ps_row-8/log/mysqltest-time) :
mysqltest: At line 33: query 'drop table t1' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_binlog_discover.log

Stopping All Servers
Restoring snapshot of databases
Saving core.27206
Resuming Tests

Seen in https://intranet.mysql.com/~knielsen/pb/getlog.pl?dir=mysql-5.1-engines&entry=istruewing@p...
[20 Dec 2006 14:34] 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/17220
[28 Dec 2006 14:24] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.15 changelog.