Bug #5098 mysql-test-run fails during ndb_autodiscover
Submitted: 18 Aug 2004 19:46 Modified: 19 Aug 2004 14:47
Reporter: Patrick Lin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.0.1-alpha OS:Linux (Fedora 2)
Assigned to: Martin Skold CPU Architecture:Any

[18 Aug 2004 19:46] Patrick Lin
Description:
Hi,

I installed and built 5.0.1-alpha snapshot.  I then ran the ndb specific tests with:

mysql-test-run --local --with-ndbcluster --force --do-test=ndb

The results were:

/home/plin/mysql/mysql-5.0.1-alpha/ndb/src/mgmclient/ndb_mgm --try-reconnect=1 localhost 9350
-- NDB Cluster -- Management Client --
Connecting to Management Server: localhost:9350
Executing STOP on all nodes.
Cannot connect to management server (localhost:9350).Shutdown failed.
*  1010: Management server not connected
*        
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Starting ndbcluster
Starting ndbd connectstring="host=localhost:9350;nodeid=2"
Starting ndbd connectstring="host=localhost:9350;nodeid=3"
Waiting for started...
NDBT_ProgramExit: 0 - OK
-- NDB Cluster -- Management Client --
Connecting to Management Server: localhost:9350
Cluster Configuration
---------------------
2 NDB Node(s)
DB node:        2  (Version: 3.5.0)
DB node:        3  (Version: 3.5.0)

4 API Node(s)
API node:       11  (not connected) 
API node:       12  (not connected) 
API node:       13  (not connected) 
API node:       14  (not connected) 

1 MGM Node(s)
MGM node:       1  (Version: 3.5.0)

Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

 TEST                           RESULT
------------------------------------------
ndb_alter_table                [ pass ]
ndb_autodiscover               [ fail ]

Errors are (from /home/plin/mysql/mysql-5.0.1-alpha/mysql-test/var/log/mysqltest-time) :
/home/plin/mysql/mysql-5.0.1-alpha/client/.libs/mysqltest: At line 268: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ndb_autodiscover.result   2004-07-27 09:39:36.000000000 +0300
--- r/ndb_autodiscover.reject   2004-08-18 20:39:08.647502080 +0300
***************
*** 95,101 ****
  Variable_name Value
  Handler_discover      1
  SHOW TABLES FROM test;
! Tables_in_test
  create table IF NOT EXISTS t3(
  id int not null primary key,
  id2 int not null,
--- 95,101 ----
  Variable_name Value
  Handler_discover      1
  SHOW TABLES FROM test;
! Tables_in_test        table_type
  create table IF NOT EXISTS t3(
  id int not null primary key,
  id2 int not null,
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Resuming Tests

ndb_autodiscover2              [ pass ]
ndb_basic                      [ pass ]
ndb_cache                      [ pass ]
ndb_index                      [ pass ]
ndb_index_ordered              [ pass ]
ndb_index_unique               [ pass ]
ndb_insert                     [ pass ]
ndb_minmax                     [ pass ]
ndb_replace                    [ pass ]
------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished

It seems like a minor fix...

Patrick

How to repeat:
1) Build 5.0.1-alpha snapshot.
2) cd mysql-test.
3) Run "mysql-test-run --local --with-ndbcluster --force --do-test=ndb"
[18 Aug 2004 23:49] MySQL Verification Team
Verified with latest BK source 5.0 tree:

Starting Tests

 TEST                           RESULT
------------------------------------------
ndb_alter_table                [ pass ]
ndb_autodiscover               [ fail ]

Errors are (from /home/miguel/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/home/miguel/mysql-5.0/client/.libs/mysqltest: At line 268: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ndb_autodiscover.result   2004-08-18 23:16:53.000000000 +0300
--- r/ndb_autodiscover.reject   2004-08-19 00:44:36.517029072 +0300
[19 Aug 2004 13:09] Magnus BlÄudd
In 5.0 the output from the SHOW TABLES command has an extra column for table_type. Result file need to be updated.

 SHOW TABLES 
Tables_in_test        table_type 
                                  ^-------------
[19 Aug 2004 15:20] Martin Skold
Result file fixed and pushed.