| Bug #72640 | rpl.rpl_circular_for_4_hosts fails with result mismatch nondeterministic results | ||
|---|---|---|---|
| Submitted: | 14 May 2014 6:05 | Modified: | 8 Jul 2014 9:19 |
| Reporter: | Vinay Fisrekar | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[8 Jul 2014 9:19]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.
Fixed in MySQL 5.7.5.
Affects testing only, so no changelog entry is needed. Closed.
If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at
http://dev.mysql.com/doc/en/installing-source.html
Description: rpl_circular_for_4_hosts failing sporadically in pb2 regression runs. Test lead to nondeterministic results in case of lower performance. If the lock of the table will be later than the inert in next session then the result may differ from the expected one. rpl.rpl_circular_for_4_hosts \'row\' w2 [ fail ] Test ended at 2014-05-11 11:58:28 CURRENT_TEST: rpl.rpl_circular_for_4_hosts \'diff\' is not recognized as an internal or external command, operable program or batch file. --- F:/pb2/test/sb_1-12155788-1399752138.72/mysql-5.7.5-m15-winx64/mysql-test/suite/rpl/r/rpl_circular_for_4_hosts.result 2014-05-10 18:20:52.000000000 +0300 +++ R:\\var-MTS-debug-big-lc\\2\\log\\rpl_circular_for_4_hosts.reject 2014-05-11 12:58:27.935834600 +0300 @@ -111,7 +111,6 @@ SELECT \'Master A\',a,b FROM t1 WHERE c = 2 ORDER BY a,b; Master A a b Master A 5 A -Master A 6 B Master A 8 D SELECT \'Master B\',a,b FROM t1 WHERE c = 2 ORDER BY a,b; Master B a b @@ -124,7 +123,6 @@ SELECT \'Master D\',a,b FROM t1 WHERE c = 2 ORDER BY a,b; Master D a b Master D 5 A -Master D 6 B Master D 8 D http://pb2.no.oracle.com/?template=mysql_show_test_failure&search=yes&push_id=6619705&test... How to repeat: command from pb2: mysql-test-run.pl --timer --force --big-test --testcase-timeout=60 --debug-server --parallel=8 --comment=MTS-debug-big-lc --vardir=R:/var-MTS-debug-big-lc --suite=rpl --experimental=collections/default.experimental --skip-test-list=collections/disabled-per-push.list --mysqld=--slave-parallel-workers=4 --mysqld=--slave-transaction-retries=0 --mysqld=--slave-parallel-type=logical_clock --skip-test-list=collection/disabled-weekly.list