MySQL Bugs: #54122: Race condition in mysqlbinlog_raw

Bug #54122	Race condition in mysqlbinlog_raw_mode
Submitted:	1 Jun 2010 3:23	Modified:	6 May 2011 9:02
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S7 (Test Cases)
Version:	5.6.1	OS:	Any
Assigned to:	Andrei Elkin	CPU Architecture:	Any
Tags:	pb2, sporadic, test failure

Description:
mysqlbinlog_raw_mode fails sporadically in PB when MTR run
in parallel mode (4 threads).

So far the failure has been seen in mysql-next-mr-bugfixing only.

Symptoms:

main.mysqlbinlog_raw_mode                w1 [ fail ]
        Test ended at 2010-05-31 17:44:55

CURRENT_TEST: main.mysqlbinlog_raw_mode
mysqltest: At line 15: command "diff_files" failed, file '/export/home/pb2/test/sb_0-1874931-1275318914.47/mysql-5.6.99-m4-solaris10-sparc-64bit-test/mysql-test/var-n_mix/1/tmp/master-bin.000002' does not exist

The result from queries just before the failure was:
< snip >
CREATE TABLE t1 (c78 SET('a','b','c','d','e','f'));
INSERT INTO t1 VALUES ('a,b');
INSERT INTO t1 VALUES ('a,c');
INSERT INTO t1 VALUES ('b,c');
INSERT INTO t1 VALUES ('a,b,c');
INSERT INTO t1 VALUES ('a,b,c,d');
INSERT INTO t1 VALUES ('a,b,c,d,e');
INSERT INTO t1 VALUES ('a,b,c,d,e,f');
DELETE FROM t1 WHERE c78='a,b';
DROP TABLE t1;
CREATE TABLE t1 (a int NOT NULL DEFAULT 0, b int NOT NULL DEFAULT 0);
CREATE TABLE t2 (a int NOT NULL DEFAULT 0, b int NOT NULL DEFAULT 0);
INSERT INTO t1 SET a=1;
INSERT INTO t1 SET b=1;
INSERT INTO t2 SET a=1;
INSERT INTO t2 SET b=1;
UPDATE t1, t2 SET t1.a=10, t2.a=20;
DROP TABLE t1,t2;
flush logs;
CREATE TABLE raw_mode_exit (exit_code INT);

How to repeat:
Reported after failure on 2010-05-31 15:44:39 in mysql-next-mr-bugfixing.
Log: http://tinyurl.com/37m9rh3

Thank you for the report.

Verified using PB link. Not repeatable in my environment.

It seems, it fails pretty regularly on FreeBSD:
https://central.sun.net/http://pb2.norway.sun.com/?action=archive_download&archive_id=1955...

Recent failures: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...

Test only. Closed without further action.