MySQL Bugs: #33038: some tests do not run from our test-suite against cge

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

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.

Workaround: do a softlink for all binaries from the libexec into bin e.g.

ln -s .../libexec/ndbd .../bin/ndbd

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

Thank you for the report.

Please indicate accurate package name you use (file name of archive).

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".