Bug #21283 ndb_restore_compat.test fails randomly
Submitted: 25 Jul 2006 19:17 Modified: 15 Sep 2006 21:26
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.12 OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[25 Jul 2006 19:17] Ingo Strüwing 
Description:
ndb_restore_compat             [ fail ]

Errors are (from /nfstmp1/ingo/autopush-76/mysql-5.1/mysql-test/var/log/mysqltest-time) :
apply_status: 723: No such table existed
Restore: Failed to restore epoch
mysqltest: At line 18: command "$NDB_TOOLS_DIR/ndb_restore --no-defaults -e -b 1 -n 2 -p 1 -r $MYSQL_TEST_DIR/std_data/ndb_backup51 >> $NDB_TOOLS_OUTPUT" failed
(the last lines may be the most important ones)

How to repeat:
BUILD/compile-pentium-debug-max
make test

This happened two times for me on production.mysql.com. Trying the individual test did not repeat the problem. Even a couple of tests in front of it didn't.
[10 Aug 2006 9:53] Jonas Oreland 
The problem is ndb_autodiscover3 when running with --mysqld=--binlog-format=statement

It does not recreate apply_status table after "restart -i"
[10 Aug 2006 10:04] Jonas Oreland 
Also discovered that mysql-test-run.pl is waiting for apply_status
  but this table should only be used in case of row-based replication.

Therefore changing to have it use "schema" table instead
  (which is active always)
[10 Aug 2006 11: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/10255

ChangeSet@1.2246, 2006-08-10 13:33:49+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#21283
    this test in its current form depend on binlog format row
[10 Aug 2006 11:35] Jonas Oreland 
see also http://bugs.mysql.com/bug.php?id=21563
[10 Aug 2006 11:49] 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/10257

ChangeSet@1.2270, 2006-08-10 13:49:37+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#21283 - merge disabled.def
[1 Sep 2006 8:10] Jonas Oreland 
pushed to 5.1.12, nothing to document
[12 Sep 2006 17:45] Andrei Elkin 
Noticed that the failure seems to have higher probability if no /dev/shm devices
are used.
[15 Sep 2006 21:26] Jonas Oreland 
Did as described
Examined log file
Opened new bug report as this is something in mysql-test-run.pl
http://bugs.mysql.com/22409

Nothing to document (in this bug :-)