Bug #58542 Test mysql fails
Submitted: 29 Nov 2010 1:08 Modified: 1 Dec 2010 12:16
Reporter: Floren Munteanu Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.53 OS:Linux (CentOS 5.5 64bits)
Assigned to: CPU Architecture:Any

[29 Nov 2010 1:08] Floren Munteanu 
Description:
While compiling the latest tarball, the main.mysql test fails.

How to repeat:
%configure \
	--with-readline \
	--with-ssl=/usr \
	--without-debug \
	--enable-shared \
	--with-embedded-server \
	--localstatedir=/var/lib/mysql \
	--with-unix-socket-path=/var/run/mysqld/mysqld.sock \
	--with-mysqld-user="mysql" \
	--with-extra-charsets=all \
	--with-big-tables \
	--with-pic \
	--with-plugin-innobase \
	--with-plugin-archive \
	--with-plugin-blackhole \
	--with-plugin-csv \
	--with-plugin-federated \
	--with-plugin-partition \
	--without-example-storage-engine \
	--without-plugin-daemon_example \
	--without-plugin-ftexample \
	--enable-local-infile \
	--enable-largefile \
	--enable-thread-safe-client \
	--disable-dependency-tracking
...
make test
...
main.myisam-system                       [ pass ]     92
main.myisampack                          [ pass ]    115
main.mysql                               [ fail ]
        Test ended at 2010-11-28 19:55:42

CURRENT_TEST: main.mysql
ERROR 1050 (42S01) at line 1: Table 't2' already exists
--- /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/r/mysql.result    2010-11-03 17:18:49.000000000 +0300
+++ /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/r/mysql.reject    2010-11-29 03:55:42.000000000 +0300
@@ -162,8 +162,8 @@
 ERROR 1049 (42000) at line 1: Unknown database 'invalid'
 Test connect with dbname + hostname
 Test connect with dbname + _invalid_ hostname
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
 The commands reported in the bug report
 ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
 Too long dbname
@@ -198,7 +198,7 @@
 1
 COUNT (*)
 1
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
 End of 5.0 tests
 WARNING: --server-arg option not supported in this configuration.
 Warning (Code 1286): Unknown table engine 'nonexistent'

mysqltest: Result content mismatch

 - saving '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var/log/main.mysql/' to '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var/log/main.mysql/'

Only  616  of 1035 completed.
mysql-test-run: *** ERROR: Not all tests completed
[29 Nov 2010 2:01] Floren Munteanu 
I run Selinux in permissive mode.
[29 Nov 2010 4:23] Valeriy Kravchuk 
This looks like a problem in the test suite itself. Please, check if main.mysql test fails when run alone:

cd mysql-test
./mtr main.mysql
[29 Nov 2010 15:45] Davi Arnaut 
"invalid_hostname" probably resolves to a ip address...
[30 Nov 2010 1:38] Floren Munteanu 
The test itself fails:

$ cd /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test
$ ./mtr main.mysql
Logging: ./mtr  main.mysql
101129 20:36:38 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.1.53
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
Collecting tests...
vardir: /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var
Removing old var directory...
Creating var directory '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var'...
Installing system database...
Using server port 34580

==============================================================================

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

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.mysql                               [ fail ]
        Test ended at 2010-11-29 20:36:42

CURRENT_TEST: main.mysql
ERROR 1050 (42S01) at line 1: Table 't2' already exists
--- /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/r/mysql.result    2010-11-03 17:18:49.000000000 +0300
+++ /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/r/mysql.reject    2010-11-30 04:36:41.000000000 +0300
@@ -162,8 +162,8 @@
 ERROR 1049 (42000) at line 1: Unknown database 'invalid'
 Test connect with dbname + hostname
 Test connect with dbname + _invalid_ hostname
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
 The commands reported in the bug report
 ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'cyril has found a bug :)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' (errno)
 Too long dbname
@@ -198,7 +198,7 @@
 1
 COUNT (*)
 1
-ERROR 2005 (HY000) at line 1: Unknown MySQL server host 'invalid_hostname' (errno)
+ERROR 2003 (HY000) at line 1: Can't connect to MySQL server on 'invalid_hostname' (errno)
 End of 5.0 tests
 WARNING: --server-arg option not supported in this configuration.
 Warning (Code 1286): Unknown table engine 'nonexistent'

mysqltest: Result content mismatch

 - saving '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var/log/main.mysql/' to '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var/log/main.mysql/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 4 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.mysql

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://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases
[30 Nov 2010 1:41] Floren Munteanu 
I just ran the previous test and it passes:

$ ./mtr main.myisampack
Logging: ./mtr  main.myisampack
101129 20:39:44 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.1.53
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
Collecting tests...
vardir: /home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/floren/redhat/BUILD/mysql-5.1.53/mysql-test/var'...
Installing system database...
Using server port 39355

==============================================================================

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

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.myisampack                          [ pass ]     99
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.099 of 1 seconds executing testcases

Completed: All 1 tests were successful.
[30 Nov 2010 1:48] Floren Munteanu 
I've included the main.mysql /var/log directory, just in case you need to see what exactly happened behind the scenes when I ran the test.
[30 Nov 2010 4:02] Floren Munteanu 
Patch that disables the 4 fail tests, while running main test suite only.

Attachment: mysql-disabled_tests.patch (text/x-patch), 915 bytes.
[1 Dec 2010 12:16] Sveta Smirnova 
Thank you for the report.

I assume you run this in same environment like bug #58578. This is not a bug in this case. See my comment to bug #58578