Bug #57422 rpl_row_sp003 sporadically fails under heavy load
Submitted: 13 Oct 2010 6:36 Modified: 15 Nov 2010 19:41
Reporter: Dmitry Lenev Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.5.7-bzr OS:Any
Assigned to:
Triage: Triaged: D3 (Medium)

[13 Oct 2010 6:36] Dmitry Lenev
Description:
rpl_row_sp003.test from rpl suite sporadically fails under heavy load or when executed on slow hardware. For example it often fails on my laptop when I run ./mtr for the full test suite with --parallel=8 --mem options.
Indeed after inspecting extra/rpl_tests/rpl_row_sp003.test contents one can see that there are several places in this test where races can occur.

How to repeat:
Do ./mtr --mem --parallel=8 --force --suite=rpl on fairly slow machine.

Observe:

rpl.rpl_row_drop_create_temp_table 'row' w3 [ pass ]  38792
rpl.rpl_row_sp003 'row'                  w4 [ fail ]
        Test ended at 2010-10-13 10:23:33

CURRENT_TEST: rpl.rpl_row_sp003
--- /home/dlenev/src/bzr/mysql-5.5-runtime/mysql-test/suite/rpl/r/rpl_row_sp003.result  2010-10-07 19:50:55.000000000 +0300
+++ /home/dlenev/src/bzr/mysql-5.5-runtime/mysql-test/suite/rpl/r/rpl_row_sp003.reject  2010-10-13 09:23:31.000000000 +0300
@@ -37,7 +37,7 @@
 CALL test.p2();
 CALL test.p1();
 get_lock("test", 100)
-0
+1
 SELECT * FROM test.t1;
 a
 8
[13 Oct 2010 7: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/120623

3162 Dmitry Lenev	2010-10-13
      Fix for bug #57422 "rpl_row_sp003 sporadically fails under
      heavy load".
      
      rpl_row_sp003.test has sporadically failed when run on machine
      under heavy load or on slow hardware.
      
      This patch fixes races in the test which were causing these
      failures and also removes unnecessary 100 second wait from it.
[13 Oct 2010 11:22] 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/120672

3163 Dmitry Lenev	2010-10-13
      Fix for bug #57422 "rpl_row_sp003 sporadically fails under
      heavy load".
      
      rpl_row_sp003.test has sporadically failed when run on machine
      under heavy load or on slow hardware.
      
      This patch fixes races in the test which were causing these
      failures and also removes unnecessary 100 second wait from it.
[13 Oct 2010 11:23] Dmitry Lenev
Fix for this problem was queued into mysql-5.5-runtime tree.
[29 Oct 2010 17:11] Jon Stephens
Tests only. Closed without further action.
[4 Nov 2010 15:48] Jon Stephens
Affects testing only. Closed without further action.
[13 Nov 2010 16:27] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:42] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (pib:21)
[15 Nov 2010 19:41] Jon Stephens
Set back to Closed. See previous comment.
[16 Dec 2010 22:35] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)