Bug #32673 rpl_row_sp002_innodb.test fails randomly
Submitted: 23 Nov 2007 17:23 Modified: 30 Jan 2009 16:57
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:6.0.4 OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: pbfail

[23 Nov 2007 17:23] Ingo Strüwing
Description:
rpl.rpl_row_sp002_innodb       [ fail ]

--- /data0/pushbuild/pb/mysql-6.0-engines/42/mysql-6.0-engines-exp/mysql-test/suite/rpl/r/rpl_row_sp002_innodb.result	2007-11-21 22:48:08.000000000 +0300
+++ /data0/pushbuild/pb/mysql-6.0-engines/42/mysql-6.0-engines-exp/mysql-test/suite/rpl/r/rpl_row_sp002_innodb.reject	2007-11-22 12:29:32.000000000 +0300
@@ -93,6 +93,9 @@
 6	MySQL
 SELECT * FROM test.t2;
 a	f
+1	1
+2	2
+3	3
 4	4
 5	5
 6	6
@@ -188,19 +191,19 @@
 SELECT * FROM test.t1;
 a	t
 1	texas
-3	next
-5	OK
 20	Live
+3	next
 40	to
+5	OK
 60	MySQL
 SELECT * FROM test.t2;
 a	f
 1	6
+2	6
 3	6
+4	6
 5	6
-20	6
-40	6
-60	6
+6	6
 
 < -- End test 2 Begin test 3 -- >
 ---------------------------------

mysqltest: Result content mismatch

Stopping All Servers

Disabling test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-6.0-engines
log https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-engines&entry=istruewi...
See also https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[28 Nov 2007 10:24] Bugs System
Pushed into 6.0.4-alpha
[3 Apr 2008 20:59] Serge Kozlov
Since currently no log files exist the possible reasons are following:
1. Seems FOREIGN_KEY_CHECKS on slave is off (when deleted rows appears in t2  even they should be removed because of FK between t1 an t2) 
2. Sort order isn't defined for all SELECT.
[3 Apr 2008 21:07] 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/44889

ChangeSet@1.2626, 2008-04-04 01:05:25+04:00, skozlov@mysql.com +3 -0
  Bug#32673.
  1. Added ORDER BY for all SELECT.
  2. Set FOREIGN_KEY_CHECKS variable on slave to avoid issues with FK updates.
[21 Apr 2008 9: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/45745

ChangeSet@1.2626, 2008-04-21 13:31:29+04:00, skozlov@mysql.com +3 -0
  Bug#32673, added --sorted_result for SELECT
[21 Apr 2008 13:11] Serge Kozlov
Jeb: replace for *all* SELECT statements
[23 Apr 2008 9: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/45874

ChangeSet@1.2626, 2008-04-23 13:50:50+04:00, skozlov@mysql.com +3 -0
  Bug#32673, added sorting for SELECT via ORDER BY and --sorted_result
[23 Apr 2008 10:11] Ingo Strüwing
Hi Jeb, you set the bug to "Need feedback". But I don't see a question for me. What kind of feedback do you need? Regards Ingo
[23 Apr 2008 10:23] Ingo Strüwing
Hrm. I wanted to set it back to verified. It ended up as open. Retrying.
[23 Apr 2008 10:35] Ingo Strüwing
Hrm. No. In fact I didn't want to change the status at all. I just wanted to ask why it was set to "need feedback", nothing else. BugDB seems to changed it automatically whan the bug reporter adds a comment when in "need feedback" status. I guess "patch pending" or "in review" would be appropriate states. Please fix it accordingly. Regards Ingo
[11 May 2008 11:48] 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/46600

ChangeSet@1.2652, 2008-05-11 15:47:48+04:00, skozlov@mysql.com +1 -0
  Bug#32673, removed from disabled.def
[30 Jan 2009 13:29] 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 16:57] Paul DuBois
Test case changes. No changelog entry needed.