MySQL Bugs: #37883: Failures in rowbased replication: Test "rpl_row_basic

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:	None
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

Description:
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);
Last_SQL_Error
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.
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=8;
START SLAVE;
[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.

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.

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.

duplicate of BUG#37882, BUG#37884, BUG#37879