Bug #37883 Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (3)
Submitted: 4 Jul 2008 16:24 Modified: 7 Aug 2008 16:59
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 16:24] Joerg Bruehe
Detected in the build of 5.1.26-rc.

Sadly, 5.1.24 and 5.1.25 have not been checked in comparable depth,
so I cannot say whether these failures are new or just un-reported.

In the logs evaluated till now, test "rpl_row_basic_2myisam" (in row mode)
was run 490 times, of which 363 passed and 127 failed.

I file separate reports for failures which show distinct symptoms,
I cannot say how close they are related.

This is the second symptom, for the previous ones see bug#37879 + bug#37882.

rpl.rpl_row_basic_2myisam 'row' [ fail ]

mysqltest: In included file "./include/diff_tables.inc": At line 117: command "diff_files" failed with error 2

The result from queries just before the failure was:
< snip >
[expecting slave to replicate correctly]
INSERT INTO t2 VALUES (1, "", 1);
INSERT INTO t2 VALUES (2, repeat(_utf8'a', 16), 2);
Comparing tables master:test.t2 and slave:test.t2
[expecting slave to stop]
INSERT INTO t3 VALUES (1, "", 1);
INSERT INTO t3 VALUES (2, repeat(_utf8'a', 128), 2);
Table definition on master and slave does not match: Column 1 size mismatch - master has size 384, test.t3 on
slave has size 49. Master's column size should be <= the slave's column size.
[expecting slave to replicate correctly]
INSERT INTO t4 VALUES (1, "", 1);
INSERT INTO t4 VALUES (2, repeat(_utf8'a', 128), 2);
Comparing tables master:test.t4 and slave:test.t4
--- /PATH/mysql-test/var/tmp/diff_table_1
+++ /PATH/mysql-test/var/tmp/diff_table_2
@@ -1,2 +1 @@
 1              1
-2      aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaa      2

9 occurrences in total, among them
Solaris 9 Sparc (64 bit) + Solaris 10 (x86 + x86_64).

How to repeat:
Run the test suite.
[4 Jul 2008 17:01] Joerg Bruehe
The other failures of this test are reported as
bug#37879, bug#37882, 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.

10 of the 121 failures of that test look like shown here.
[15 Jul 2008 15:32] Joe Grasse
I too was having this problem, and I have posted my observations and
a fixed test file to bug#37879. These bugs are caused by the same 
problem, IMHO.
[7 Aug 2008 16:59] Sven Sandberg
duplicate of BUG#37882, BUG#37884, BUG#37879