Bug #45972 ndb.ndb_autodiscover fails occasionally with pb2

• Submitted: 6 Jul 2009 14:42
• Modified: 9 Jan 9:55
• Reporter: Georgi Kodinov
• Status: Won't fix
• Category: Tests: Cluster
• Severity: S3 (Non-critical)
• Version: 5.0-bugteam, 5.0
• OS: MacOS (test-max-macosx10.5-i386)
• CPU Architecture: Any

[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:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706144425-0l1akrqt391ztq49) (merge vers: 5.0.84) (pib:11)

[8 Jul 2009 13:30] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706144751-t600eoz0cpxrxwcb) (merge vers: 5.1.37) (pib:11)

[9 Jul 2009 7:35] Bugs System

Pushed into 5.0.84 (revid:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706144425-0l1akrqt391ztq49) (merge vers: 5.0.84) (pib:11)

[9 Jul 2009 7:37] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706144751-t600eoz0cpxrxwcb) (merge vers: 5.1.37) (pib:11)

[10 Jul 2009 11:21] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090710111017-bnh2cau84ug1hvei) (version source revid:[e-mail]-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:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-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:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-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:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-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:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)

[9 Jan 9:55] Magnus Blåudd

Posted by developer:
 
Test was removed:

commit b8ed4ba47a3e05dcbdb9e8db69d1ff3d6917c376
Author: Magnus Blåudd <[e-mail]>
Date:   Fri Dec 22 10:39:05 2017 +0100

    WL#9185 MySQL Cluster support for new DD

    Remove test ndb_team.ndb_autodiscover which test that table should be
    resurrected after removing .frm files. There are no .frm files anymore
    and thus test is not relevant.