Bug #33361 rpl_row_sp005 fails randomly
Submitted: 19 Dec 2007 9:29 Modified: 7 Feb 2008 10:14
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Magnus Blåudd CPU Architecture:Any

[19 Dec 2007 9:29] Magnus Blåudd 
Description:
rpl.rpl_row_sp005 'row'        [ fail ]

--- /data/msvensson/mysql/mysql-5.1-mtr-whopper/mysql-test/suite/rpl/r/rpl_row_sp005.result     2007-06-27 15:27:32.000000000 +0300
+++ /data/msvensson/mysql/mysql-5.1-mtr-whopper/mysql-test/suite/rpl/r/rpl_row_sp005.reject     2007-12-19 12:16:39.000000000 +0300
@@ -88,10 +88,6 @@
 ------------------------
 SELECT * FROM test.t3 ORDER BY id3;
 id3    c
-1      MySQL
-2      kyle
-3      Texas
-4      ROCKS
 ALTER PROCEDURE test.p1 MODIFIES SQL DATA;
 DROP PROCEDURE IF EXISTS test.p1;
 DROP PROCEDURE IF EXISTS test.p2;

mysqltest: Result content mismatch

How to repeat:
./mtr rpl_row_sp005

Suggested fix:
Add "wait for all 4 rows to arrive" on slave
[19 Dec 2007 9:30] 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/40184

ChangeSet@1.2662, 2007-12-19 10:30:05+01:00, msvensson@pilot.mysql.com +1 -0
  Bug#33361 rpl_row_sp005 fails randomly
[7 Feb 2008 10:14] Magnus Blåudd 
Fixed by Mats by adding missing "sync_wikh_master" before the "SELECT * FROM test.t3 ORDER BY id3;"
[30 Jan 2009 13:30] Bugs System 
Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)
[30 Jan 2009 15:10] Bugs System 
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:sp1r-msvensson@pilot.mysql.com-20080325174049-18586) (merge vers: 5.1.24-rc) (pib:6)
[17 Feb 2009 14:53] Bugs System 
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 16:41] Bugs System 
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 18:17] Bugs System 
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)