Bug #39593 rpl.rpl_row_stop_middle fails sporadically on Windows in "row" mode
Submitted: 22 Sep 2008 17:36 Modified: 10 Nov 2008 17:41
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0-TRUNK, 5.1 OS:Microsoft Windows
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[22 Sep 2008 17:36] Alexander Nozdrin
Description:
Symptoms:
---------------------------------------------------------------
--- C:/cygwin/home/pushbuild/pb1/pb/bzr_mysql-6.0/67/mysql-6.0.8-alpha-pb67/mysql-test/suite/rpl/r/rpl_row_stop_middle.result	2008-09-22 17:53:01.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\bzr_mysql-6.0\67\mysql-6.0.8-alpha-pb67\mysql-test\suite\rpl\r\rpl_row_stop_middle.reject	2008-09-22 20:11:32.218750000 +0300
@@ -21,6 +21,7 @@
 INSERT INTO t1 (a) SELECT null FROM t1;
 INSERT INTO t1 (a) SELECT null FROM t1;
 start slave;
+Timeout in wait_condition.inc for SELECT COUNT(*) >= 10 FROM t1
 stop slave;
 drop table t1;
 drop table t1;
---------------------------------------------------------------

Reported after the failure in mysql-6.0 on Sep-22:
http://tinyurl.com/52z3h4

How to repeat:
http://tinyurl.com/54jj5t
[1 Oct 2008 18:52] Serge Kozlov
Is it not a test bug. The test lost connection to master twice and so test was failed:
[ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
[2 Oct 2008 15:50] Serge Kozlov
The conclusion after discuss between Serge Kozlov and Sven Sandberg is:

(1) There is not enough debug info to figure out what caused the bug. We can't spend too much time with that. 
(2) The test is wrongly written since it contains a race. It should be rewritten to get rid of the race. But before rewriting we need to know real reasons of the bugs and fix them in test code. see (1)
(3) Test should be disabled.
(4) There is a possible solution: use debug sync, but it's not completely satisfactory since it won't run on all platforms (Most of used platforms of PB compile non-debug builds).
[16 Oct 2008 18:45] 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/56411

2673 Serge Kozlov	2008-10-16
      Bug#39593. Removed test case rpl_row_stop_middle with result file
[16 Oct 2008 18:49] 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/56413

2882 Serge Kozlov	2008-10-16 [merge]
      Bug#39593. Removed test case rpl_row_stop_middle with result file
[10 Nov 2008 10:53] Bugs System
Pushed into 6.0.8-alpha  (revid:skozlov@mysql.com-20081016184917-grb7lh0h8ae4j70s) (version source revid:skozlov@mysql.com-20081016184917-grb7lh0h8ae4j70s) (pib:5)
[10 Nov 2008 11:37] Bugs System
Pushed into 5.1.30  (revid:skozlov@mysql.com-20081016184015-misf69xf1ruv6cog) (version source revid:skozlov@mysql.com-20081016184015-misf69xf1ruv6cog) (pib:5)
[10 Nov 2008 17:41] Paul Dubois
Test case changes. No changelog entry needed.
[19 Jan 2009 11:32] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:09] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:15] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)