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: | |
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
[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