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

Bug #37882	Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (2)
Submitted:	4 Jul 2008 16:12	Modified:	7 Aug 2008 16:58
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 first one see bug#37879.

::::::::::::::
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 >
CREATE TABLE t6 (i INT NOT NULL,
c CHAR(255) CHARACTER SET utf8 NOT NULL,
j INT NOT NULL);
ALTER TABLE t6 MODIFY c CHAR(128) CHARACTER SET utf8 NOT NULL;
CREATE TABLE t7 (i INT NOT NULL,
c CHAR(255) CHARACTER SET utf8 NOT NULL,
j INT NOT NULL);
[expecting slave to replicate correctly]
INSERT INTO t1 VALUES (1, "", 1);
INSERT INTO t1 VALUES (2, repeat(_utf8'a', 16), 2);
Comparing tables master:test.t1 and slave:test.t1
[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
--- /PATH/mysql-test/var/tmp/diff_table_1
+++ /PATH/mysql-test/var/tmp/diff_table_2
@@ -1,2 +0,0 @@
-1              1
-2      aaaaaaaaaaaaaaaa        2
::::::::::::::

There is no clear pattern among the platforms where it occurred,
I had it 19 times in total, including
- Linux/s390 (5 times),
- HP-UX 11.23 IA64 (2 of 2 runs),
- Linux RPM builds (8 in total, on all 3 CPUs).

How to repeat:
Run the test suite.

The other failures of this test are reported as
bug#37879, 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.

For that test, this symptom occurred in 13 of 121 failures.

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#37879, BUG#37884