Bug #62154 federated.federated_server test fails with run --repeat=2
Submitted: 12 Aug 2011 15:52 Modified: 14 Jan 2013 11:11
Reporter: Oleg Tsarev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.58, 5.1.59 OS:Any
Assigned to: CPU Architecture:Any

[12 Aug 2011 15:52] Oleg Tsarev 
Description:
CURRENT_TEST: federated.federated_server
--- /storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/suite/federated/federated_server.result	2011-07-01 18:36:14.000000000 +0300
+++ /storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/suite/federated/federated_server.reject	2011-08-12 18:50:02.227794509 +0300
@@ -56,8 +56,8 @@
 OWNER 'root');
 select * from mysql.servers;
 Server_name	Host	Db	Username	Password	Port	Socket	Wrapper	Owner
-server_one	127.0.0.1	first_db	root		SLAVE_PORT		mysql	root
 server_two	127.0.0.1	second_db	root		SLAVE_PORT		mysql	root
+server_one	127.0.0.1	first_db	root		SLAVE_PORT		mysql	root
 DROP TABLE IF EXISTS federated.old;
 Warnings:
 Note	1051	Unknown table 'old'

mysqltest: Result content mismatch

How to repeat:
./mysql-test-run federated.federated_server --repeat=2

Suggested fix:
https://code.launchpad.net/~tsarev/percona-server/federated_server_repeatable_fix/+merge/7...
[12 Aug 2011 16:48] Valeriy Kravchuk 
Verified just as described with current mysql-5.1 from bzr on Mac OS X:

macbook-pro:mysql-test openxs$ ./mtr federated.federated_server --repeat=2
Logging: ./mtr  federated.federated_server --repeat=2
110812 19:42:10 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/dX/dXCzvuSlHX4Op1g-o1jIWk+++TI/-Tmp-/7IGFlDdolY/ is case insensitive
110812 19:42:10 [Note] Plugin 'FEDERATED' is disabled.
110812 19:42:10 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.1.59
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
Collecting tests...
vardir: /Users/openxs/dbs/5.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/Users/openxs/dbs/5.1/mysql-test/var'...
Installing system database...
Using server port 54936

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

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

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
federated.federated_server               [ pass ]   9338
federated.federated_server               [ fail ]
        Test ended at 2011-08-12 19:42:38

CURRENT_TEST: federated.federated_server
--- /Users/openxs/dbs/5.1/mysql-test/suite/federated/federated_server.result	2011-08-10 22:51:11.000000000 +0300
+++ /Users/openxs/dbs/5.1/mysql-test/suite/federated/federated_server.reject	2011-08-12 19:42:38.000000000 +0300
@@ -56,8 +56,8 @@
 OWNER 'root');
 select * from mysql.servers;
 Server_name	Host	Db	Username	Password	Port	Socket	Wrapper	Owner
-server_one	127.0.0.1	first_db	root		SLAVE_PORT	mysql	root
 server_two	127.0.0.1	second_db	root		SLAVE_PORT	mysql	root
+server_one	127.0.0.1	first_db	root		SLAVE_PORT	mysql	root
 DROP TABLE IF EXISTS federated.old;
 Warnings:
 Note	1051	Unknown table 'old'

mysqltest: Result content mismatch

 - saving '/Users/openxs/dbs/5.1/mysql-test/var/log/federated.federated_server/' to '/Users/openxs/dbs/5.1/mysql-test/var/log/federated.federated_server/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 9.338 of 31 seconds executing testcases

Completed: Failed 1/2 tests, 50.00% were successful.

Failing test(s): federated.federated_server

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
[14 Jan 2013 11:11] Erlend Dahl 
Fixed in 5.1.62, 5.5.21, 5.6.5