Bug #18952 | NDB Auto Discovery is failing designed tests in ndb_autodiscovery.test | ||
---|---|---|---|
Submitted: | 10 Apr 2006 13:56 | Modified: | 22 Dec 2017 10:38 |
Reporter: | Lars Thalmann | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
Version: | mysql-5.1 | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | 5.1 bk, 5.1-Telco, disabled, ndb, ndb_autodiscover, test failure |
[10 Apr 2006 13:56]
Lars Thalmann
[10 Apr 2006 15:20]
Valeriy Kravchuk
Verified just as described with 5.1.10-BK (ChangeSet@1.2303.1.1, 2006-04-09 19:43:36-07:00)
[13 Apr 2006 11:24]
Tomas Ulin
this is disabled because ndb handler cannot handle explicit remove of frm
[23 Feb 2007 0:32]
Jonathan Miller
Hi, I took a look at this today and it seems the auto discovery has changed. The test now fails on each sub test unless you add a "show tables" right after the frm removal. Not sure this is the was auto discovery is supposed to be working. /jeb
[26 Apr 2007 21:04]
Jonathan Miller
create table t1( id int not null primary key, name char(20) ) engine=ndb; insert into t1 values(1, "Autodiscover"); flush tables; --remove_file $MYSQLTEST_VARDIR/master-data/test/t1.frm select * from t1; show status like 'handler_discover%'; Errors are (from /data1/mysql-5.1-telco2/mysql-test/var/log/mysqltest-time) : mysqltest: At line 28: query 'select * from t1' failed: 1105: Failed to open 't1', error while unpacking from engine # # Test discover + INSERT # flush tables; --remove_file $MYSQLTEST_VARDIR/master-data/test/t1.frm insert into t1 values (2, "Auto 2"); show status like 'handler_discover%'; insert into t1 values (3, "Discover 3"); show status like 'handler_discover%'; flush tables; --remove_file $MYSQLTEST_VARDIR/master-data/test/t1.frm select * from t1 order by id; show status like 'handler_discover%'; Errors are (from /data1/mysql-5.1-telco2/mysql-test/var/log/mysqltest-time) : mysqltest: At line 38: query 'insert into t1 values (2, "Auto 2")' failed: 1105: Failed to open 't1', error while unpacking from engine This trend continues through the test case. Note, if you do a SHOW TABLES before the select, insert, update, etc... then the test passes.
[22 Dec 2017 9:42]
Magnus BlÄudd
Posted by developer: Fixed as part of WL#9185. Tests were removing .frm files form MySQL data directory and testing if they were created again(or not) by the ndbcluster plugin in MySQL Server. Since we no longer have .frm files, the two test ndb_autodiscover and ndb_autodiscover2 are removed.
[22 Dec 2017 10:38]
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
[22 Dec 2017 10:38]
Jon Stephens
Fixed in NDB 8.0.1 by WL#9185, see same for documentation info. Closed.