Bug #38184 main.federated fails sporadically
Submitted: 16 Jul 2008 19:16 Modified: 19 Feb 2009 19:26
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:6.0-BK OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[16 Jul 2008 19:16] Alexander Nozdrin 
Description:
There are different symptoms like:

------------------------------------------------------------------------------
@@ -2088,7 +2088,6 @@
 1
 1
 1
-1
 drop table t1;
 drop table t1;
 drop view v1;
------------------------------------------------------------------------------

------------------------------------------------------------------------------
@@ -1618,18 +1618,8 @@
 select * from federated.t1 where fld_parentid=0 and fld_delt=0
 order by fld_name;
 fld_cid	fld_name	fld_parentid	fld_delt
-1	Mats	0	0
-3	Sigvard	0	0
-2	Sivert	0	0
-4	Torgny	0	0
-5	Torkel	0	0
 select * from federated.t1 where fld_parentid=0 and fld_delt=0;
 fld_cid	fld_name	fld_parentid	fld_delt
-1	Mats	0	0
-2	Sivert	0	0
-3	Sigvard	0	0
-4	Torgny	0	0
-5	Torkel	0	0
 DROP TABLE federated.t1;
 DROP TABLE federated.bug_17377_table;
 DROP TABLE IF EXISTS federated.test;
------------------------------------------------------------------------------

------------------------------------------------------------------------------
@@ -2096,22 +2085,14 @@
 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1';
 SELECT * FROM t1 WHERE a IS NULL;
 a	b
-NULL	NULL
-NULL	1
 SELECT * FROM t1 WHERE a IS NOT NULL;
 a	b
-1	NULL
-1	1
-2	2
 SELECT * FROM t1 WHERE a=1 AND b=1;
 a	b
-1	1
 SELECT * FROM t1 WHERE a IS NULL AND b=1;
 a	b
-NULL	1
 SELECT * FROM t1 WHERE a IS NOT NULL AND b=1;
 a	b
-1	1
 DROP TABLE t1;
 DROP TABLE t1;
 CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://';
------------------------------------------------------------------------------

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.federated
[27 Aug 2008 18:01] Matthias Leich 
xref shows that federated.test fails sporadically also
in 5.1. Therefore the fix must start at least in 5.1.

Preliminary classification of bad effects:
1. @@ -780,8 +780,8 @@
 10     10      Tenth ten TEN   1010101 1010
 SELECT * FROM federated.t1 WHERE col2 LIKE 's%';
 id     col1    col2    col3    col4
-7      7       seven Sevenseven        77777   7777
 6      6       six six Sixsix  6666    6
+7      7       seven Sevenseven        77777   7777

   The test expects a certain result set order.
   This is wrong in case of SELECTs without
   appropriate ORDER BY.
   --> Insert "--sorted_result" before every SELECT
       without ORDER BY

2. @@ -2088,7 +2088,6 @@
 1
 1
 1
-1
 drop table t1;
 drop table t1;
 drop view v1;
 So sometimes parts of result sets are missing.
 Maybe they have to be pulled from another server
 but this other server
 - is the wrong one (= not maintained/controlled
   by our corresponding mysql-test-run.pl)
 - maintains the data (Insert/Update/...) to be 
   expected somehow asynchronous and our SELECT
   just runs before completion of such an operation

3. @@ -781,6 +781,7 @@
 SELECT * FROM federated.t1 WHERE col2 LIKE 's%';
 id     col1    col2    col3    col4
 6      6       six six Sixsix  6666    6
+7      7       seven Sevenseven        77777   7777

   Complete strange because we have cases (-> 1.where
   two rows are expected (per federated.results) but
   the row order within the result set was unexpected.
   Maybe that federated.results had over some time a
   wrong content.

4. @@ -2129,11 +2128,11 @@
 test.t1        2465757603
 DROP TABLE t1;
 DROP TABLE t1;
-DROP TABLE IF EXISTS federated.t1;
-DROP DATABASE IF EXISTS federated;
-DROP TABLE IF EXISTS federated.t1;
-DROP DATABASE IF EXISTS federated;
 End of 5.0 tests
 create server 's1' foreign data wrapper 'mysql' options (port 3306);
 drop server 's1';
 End of 5.1 tests
+DROP TABLE IF EXISTS federated.t1;
+DROP DATABASE IF EXISTS federated;
+DROP TABLE IF EXISTS federated.t1;
+DROP DATABASE IF EXISTS federated;

 Temporary wrong content of federated.results?
[29 Aug 2008 18:52] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52935
[1 Sep 2008 11:58] Matthias Leich 
Hi!
1. The fix will start in 5.0.
   Some improvements (they avoid random failures like
   this bug reports) which already exist in 5.1 will be
   ported to 5.0.
2. The changeset to be reviewed ist to be applied in 5.1.
[3 Sep 2008 1:55] Patrick Crews 
Ok to push.

Tested on Mac OSX 10.5 and Windows XP pro 32 bit.
[4 Sep 2008 17:02] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53278
[4 Sep 2008 17:41] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53282
[4 Sep 2008 20:17] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53289
[4 Sep 2008 20:28] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53290
[4 Sep 2008 20:36] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53291
[5 Sep 2008 12:28] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53336
[5 Sep 2008 12:51] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53340
[10 Sep 2008 16:31] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53712
[10 Sep 2008 17:24] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53716
[10 Sep 2008 17:35] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53719
[16 Sep 2008 17:05] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54220
[16 Sep 2008 17:27] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54221
[18 Sep 2008 14:26] Matthias Leich 
Fix pushed to
mysql-5.0-bugteam
mysql-5.1-bugteam
mysql-6.0-bugteam
[9 Oct 2008 18:13] Bugs System 
Pushed into 5.1.30  (revid:matthias.leich@sun.com-20080916172654-pu1b90na0qnq7ya1) (version source revid:matthias.leich@sun.com-20080916172654-pu1b90na0qnq7ya1) (pib:4)
[15 Oct 2008 15:08] Paul DuBois 
This is actually pushed to 5.1.29, not 5.1.30.
[15 Oct 2008 17:38] Paul DuBois 
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 5.0.x, 6.0.x.
[17 Oct 2008 16:44] Bugs System 
Pushed into 6.0.8-alpha  (revid:matthias.leich@sun.com-20080916180046-vm8j8qg6qeikam5n) (version source revid:matthias.leich@sun.com-20080916180046-vm8j8qg6qeikam5n) (pib:5)
[17 Oct 2008 17:52] Paul DuBois 
Setting report to NDI pending push into 5.0.x
[28 Oct 2008 21:02] Bugs System 
Pushed into 5.1.29-ndb-6.2.17  (revid:matthias.leich@sun.com-20080916172654-pu1b90na0qnq7ya1) (version source revid:tomas.ulin@sun.com-20081028140209-u4emkk1xphi5tkfb) (pib:5)
[28 Oct 2008 22:21] Bugs System 
Pushed into 5.1.29-ndb-6.3.19  (revid:matthias.leich@sun.com-20080916172654-pu1b90na0qnq7ya1) (version source revid:tomas.ulin@sun.com-20081028194045-0353yg8cvd2c7dd1) (pib:5)
[29 Oct 2008 15:04] Paul DuBois 
Setting report to NDI pending push into 5.0.x
[1 Nov 2008 9:46] Bugs System 
Pushed into 5.1.29-ndb-6.4.0  (revid:matthias.leich@sun.com-20080916172654-pu1b90na0qnq7ya1) (version source revid:jonas@mysql.com-20081101082305-qx5a1bj0z7i8ueys) (pib:5)
[1 Nov 2008 16:47] Paul DuBois 
Setting report to NDI pending push into 5.0.x
[19 Feb 2009 19:26] Paul DuBois 
No changelog entry needed.