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:S2 (Serious)
Version:5.6.1 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: pb2, sporadic, test failure
Triage: Triaged: D3 (Medium)

[1 Jun 2010 3:23] Alexander Nozdrin
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
[1 Jun 2010 5:36] Sveta Smirnova
Thank you for the report.

Verified using PB link. Not repeatable in my environment.
[21 Jun 2010 6:03] Alexander Nozdrin
It seems, it fails pretty regularly on FreeBSD:
https://central.sun.net/http://pb2.norway.sun.com/?action=archive_download&archive_id=1955...
[24 Dec 2010 7:45] Alexander Nozdrin
Recent failures: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...
[6 May 2011 9:02] Jon Stephens
Test only. Closed without further action.