MySQL Bugs: #44574: Subtest test_bug37956 in mysql_client

Bug #44574	Subtest test_bug37956 in mysql_client_test fails on 5.0
Submitted:	30 Apr 2009 13:02	Modified:	4 May 2009 10:38
Reporter:	Bernt Marius Johnsen	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S7 (Test Cases)
Version:	5.0	OS:	Linux (Linux atum01 2.6.24-19-generic #1 SMP Fri Jul 11 23:41:49 UTC 2008 i686 GNU/Linux)
Assigned to:		CPU Architecture:	Any

Description:
[atum01:/export/home/tmp/mysql/xx/mysql-test] ./mtr mysql_client_test
Logging: ./mtr mysql_client_test
090430 15:00:59 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090430 15:00:59 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
MySQL Version 5.0.80
Skipping ndbcluster, mysqld not compiled with ndbcluster
Skipping SSL, mysqld not compiled with SSL
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 IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

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

mysql_client_test              [ fail ]

mysqltest: At line 12: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed

The result from queries just before the failure was:
exec of '/export/home/tmp/mysql/xx/tests/mysql_client_test --no-defaults --testcase --user=root --port=9306 --socket=/export/home/tmp/mysql/xx/mysql-test/var/tmp/master.sock --vardir=/export/home/tmp/mysql/xx/mysql-test/var --getopt-ll-test=25600M >> /export/home/tmp/mysql/xx/mysql-test/var/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0

More results from queries before failure can be found in /export/home/tmp/mysql/xx/mysql-test/var/log/mysql_client_test.log

Aborting: mysql_client_test failed in default mode. 
To continue, re-run with '--force'.
Stopping All Servers
tail[atum01:/export/home/tmp/mysql/xx/mysql-test] tail /export/home/tmp/mysql/xx/mysql-test/var/log/mysql_client_test.out.log

 total parameters in stmt: `2` (expected: `2`)

time[0]: 00-00-00 
time[1]: 00-00-00 

#####################################
211 of (1/1): test_bug37956  
#####################################
mysql_client_test.c:15957: check failed: '0'

How to repeat:
./mtr mysql_client_test

Do you use main 5.0 tree from bzr? I can't repeat this with recent one on Mac OS X:

valeriy-kravchuks-macbook-pro:mysql-test openxs$ ./mtr mysql_client_test
Logging: ./mtr mysql_client_test
MySQL Version 5.0.80
Using ndbcluster when necessary, mysqld supports it
Setting mysqld to support SSL connections
Binaries are debug compiled
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       = 9311
Using IM_PORT               = 9313
Using IM_MYSQLD1_PORT       = 9314
Using IM_MYSQLD2_PORT       = 9315
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

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

mysql_client_test              [ pass ]          52001
-------------------------------------------------------
Stopping All Servers
skipped 9 bytes from file: socket (3)
All 1 tests were successful.
The servers were restarted 1 times
Spent 52.001 of 54 seconds executing testcases

So, either this is in different tree or it is Linux-specific problem.

See bug #44348 also

I used 5.0-bugteam. I'll check 5.0-main on Monday (May 1st is holiday here in Norway).

I couldn't repeat on 5.0-bugteam too:

Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
=======================================================
Starting Tests in the 'main' suite

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

mysql_client_test              [ pass ]         116857
-------------------------------------------------------
Stopping All Servers
skipped 9 bytes from file: socket (3)
All 1 tests were successful.
The servers were restarted 1 times
Spent 116.857 of 123 seconds executing testcases

miguel@txg:~/bzr/mysql-5.0-bugteam$ bzr revno
2733
miguel@txg:~/bzr/mysql-5.0-bugteam$ cat /etc/issue
Ubuntu 8.10 \n \l

After bzr pull today, the test passeson both 5.0-main and 5.0-bugteam. Close as "Not a bug".