Bug #45972 ndb.ndb_autodiscover fails occasionally with pb2
Submitted: 6 Jul 2009 14:42 Modified: 6 Jul 2009 14:45
Reporter: Georgi Kodinov Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Cluster Severity:S3 (Non-critical)
Version:5.0-bugteam, 5.0 OS:Mac OS X (test-max-macosx10.5-i386)
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D3 (Medium)

[6 Jul 2009 14:42] Georgi Kodinov
Description:
ndb_autodiscover               [ fail ]

mysqltest: In included file "./include/ndb_wait_connected.inc": At line 21: Failed waiting for mysqld to reconnect to ndbd

The result from queries just before the failure was:
< snip >
create table t2 (b int,c longblob) engine=ndb;
use test;
select * from t1;
a	b
show tables;
Tables_in_test
t1
drop table t1;
use test2;
drop table t2;
drop database test2;
use test;
drop database if exists test_only_ndb_tables;
create database test_only_ndb_tables;
use test_only_ndb_tables;
create table t1 (a int primary key) engine=ndb;
select * from t1;
a
select * from t1;
ERROR HY000: Can't lock file (errno: 157)

More results from queries before failure can be found in /Volumes/hd2/test/sb_1-627249-1246887241.12/mysql-5.0.84-osx10.5-i386-test/mysql-test/var/log/ndb_autodiscover.log

Warnings from just before the error:
Error 1296 Got error 4009 'Cluster Failure' from NDB

How to repeat:
Run the test enough times

Suggested fix:
n/a
[6 Jul 2009 14:45] 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/78026

2798 Georgi Kodinov	2009-07-06
      Bug#45972: disable the test case in 5.0
[6 Jul 2009 14:45] Georgi Kodinov
back to verified : test suite disablement
[7 Jul 2009 7:52] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:joro@sun.com-20090706144425-0l1akrqt391ztq49) (merge vers: 5.0.84) (pib:11)
[8 Jul 2009 13:30] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:joro@sun.com-20090706144751-t600eoz0cpxrxwcb) (merge vers: 5.1.37) (pib:11)
[9 Jul 2009 7:35] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:joro@sun.com-20090706144425-0l1akrqt391ztq49) (merge vers: 5.0.84) (pib:11)
[9 Jul 2009 7:37] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:joro@sun.com-20090706144751-t600eoz0cpxrxwcb) (merge vers: 5.1.37) (pib:11)
[10 Jul 2009 11:21] Bugs System
Pushed into 5.4.4-alpha (revid:anozdrin@bk-internal.mysql.com-20090710111017-bnh2cau84ug1hvei) (version source revid:joro@sun.com-20090706152246-15vlu8s4tj7366yc) (merge vers: 5.4.4-alpha) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:33] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)