Bug #37879 | Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (1) | ||
---|---|---|---|
Submitted: | 4 Jul 2008 15:44 | Modified: | 7 Aug 2008 16:56 |
Reporter: | Joerg Bruehe | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Tests: Replication | Severity: | S7 (Test Cases) |
Version: | 5.1.26-rc | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | disabled, pushbuild, sporadic, test failure |
[4 Jul 2008 15:44]
Joerg Bruehe
[4 Jul 2008 16:55]
Joerg Bruehe
The other failures of this test are reported as bug#37882, bug#37883, and bug#37884. The very same symptom occurs in test "rpl_row_basic_3innodb", the only difference being the path names (obviously) and the exact distribution of occurrences across the platforms. But also in that test, - this symptom is the most frequent one (94 times of 121 failures of that test), - it is typical for Linux (x86 + x86_64) and Windows-64.
[15 Jul 2008 15:23]
Joe Grasse
Changed rpl_row_basic.test, added sync_slave_with_master before diff tests
Attachment: rpl_row_basic.test (application/octet-stream, text), 12.44 KiB.
[15 Jul 2008 15:25]
Joe Grasse
I too was having this error about 99% of the time. I never came across this error in 5.1.25-rc. I am on an x86_64 box. After looking into the differences between the test in 5.1.25 and 5.1.26, I noticed that 5.1.26 has added checks for bug#37426. It is here were I keep running into problems. As far as I can tell it looks like the test is checking the tables on the slave before all of the changes have been replicated over. I believe the correct fix for this is to add sync_slave_with_master before the diff test on the master and slave tables, in mysql-test/extra/rpl_tests/rpl_row_basic.test. I have attached the fixed test file.
[7 Aug 2008 16:56]
Sven Sandberg
duplicate of BUG#37884