Bug #33038 some tests do not run from our test-suite against cge
Submitted: 6 Dec 2007 13:20 Modified: 7 Jul 2008 6:05
Reporter: Oli Sennhauser Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.22-ndb-6.3.6 OS:Linux
Assigned to: CPU Architecture:Any

[6 Dec 2007 13:20] Oli Sennhauser
Description:
Customer wants to verfiy that our CGE build was done properly. So I run the mysql-test suite against it.
The test failed on test:
* system_mysql_db_fix50030.test
* system_mysql_db_fix50117.test

and all cluster related tests...

How to repeat:
./mysql-test-run

...
main.system_mysql_db_fix50030  [ fail ]

Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
sh: -c: line 1: syntax error near unexpected token `>'
sh: -c: line 1: `/usr/local/mysql/bin/mysql --no-defaults --debug-check --host=localhost  --user=root --password= --port=9306 --socket=/usr/local/mysql/mysql-test/var/tmp/master.sock --character-sets-dir=/usr/local/mysql/share/mysql/charsets --force test <  > /usr/local/mysql/mysql-test/var/log/system_mysql_db_fix50030.log 2>&1'
mysqltest: At line 67: command "$MYSQL --force test < $MYSQL_FIX_PRIVILEGE_TABLES > $MYSQLTEST_VARDIR/log/system_mysql_db_fix50030.log 2>&1" failed
(the last lines may be the most important ones)

Aborting: main.system_mysql_db_fix50030 failed in default mode. To continue, re-run with '--force'.
Stopping All Servers

and for the cluster related tests:

./mysql-test-run ndb_alter_table
Logging: ./mysql-test-run ndb_alter_table
MySQL Version 5.1.22
Using binlog format 'mixed'
Using ndbcluster when necessary, mysqld supports it
Setting mysqld to support SSL connections
mysql-test-run: WARNING: Could not find all required ndb binaries, all ndb tests will fail, use --skip-ndbcluster to skip testing it.
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9310
Using NDBCLUSTER_PORT_SLAVE = 9311
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

ndb.ndb_alter_table            [ fail ]

ERROR: Failed to find cluster binaries
-------------------------------------------------------
Stopping All Servers
Failed 1/1 tests, 0.00% were successful.

The log files in var/log may give you some hint
of what went wrong.
If you want to report this error, please read first the documentation at
http://www.mysql.com/doc/en/MySQL_test_suite.html
The servers were restarted 0 times
Spent 0 seconds actually executing testcases

mysql-test-run in default mode: *** Failing the test(s): ndb.ndb_alter_table
mysql-test-run: *** ERROR: there were failing test cases

Suggested fix:
at least better error messages.
[6 Dec 2007 15:11] Oli Sennhauser
Workaround: do a softlink for all binaries from the libexec into bin e.g.

ln -s .../libexec/ndbd .../bin/ndbd
[6 Dec 2007 16:38] Oli Sennhauser
Found an other bug:

ndb.ndb_row_format             [ pass ]          22037
ndb.ndb_single_user            [ fail ]

Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 25: query 'create table t1 (a int key, b int unique, c int) engine ndb' failed with wrong errno 1050: 'Table 't1' already exists', instead of 1005...
(the last lines may be the most important ones)

Aborting: ndb.ndb_single_user failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
mysql-test-run: WARNING: Forcing kill of process 27886

If this test is run dedicated it passes correctly:

./mysql-test-run ndb_single_user | tee -a oli_test.log.95
Logging: ./mysql-test-run ndb_single_user
MySQL Version 5.1.22
Using binlog format 'mixed'
Using ndbcluster when necessary, mysqld supports it
Setting mysqld to support SSL connections
TRACE 99: /usr/local/mysql/bin
/usr/local/mysql/bin/ndbd - /usr/local/mysql/bin/ndb_mgm - /usr/local/mysql/bin/ndb_mgmd - /usr/local/mysql/bin/ndb_waiter
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Using NDBCLUSTER_PORT       = 9310
Using NDBCLUSTER_PORT_SLAVE = 9311
Using IM_PORT               = 9312
Using IM_MYSQLD1_PORT       = 9313
Using IM_MYSQLD2_PORT       = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
Installing Master Cluster
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

ndb.ndb_single_user            [ pass ]          35817
-------------------------------------------------------
Stopping All Servers
mysql-test-run: WARNING: Forcing kill of process 28155
All 1 tests were successful.
The servers were restarted 1 times
Spent 35.817 seconds actually executing testcases
[7 Jun 2008 6:05] Sveta Smirnova
Thank you for the report.

Please indicate accurate package name you use (file name of archive).
[7 Jul 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".