| 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: | |
| Category: | Tests: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.5.7-bzr | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[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)
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