Debian Codegraph @

mysql-test/suite/innodb/r/group_commit_binlog_pos_no_optimize_thread.result

raw
1 SET GLOBAL innodb_flush_log_at_trx_commit=3;
2 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
3 INSERT INTO t1 VALUES (0);
4 connect con1,localhost,root,,;
5 connect con2,localhost,root,,;
6 connect con3,localhost,root,,;
7 connection con1;
8 SET DEBUG_SYNC= "commit_after_get_LOCK_log SIGNAL con1_waiting WAIT_FOR con3_queued";
9 SET DEBUG_SYNC= "commit_loop_entry_commit_ordered SIGNAL con1_loop WAIT_FOR con1_loop_cont";
10 INSERT INTO t1 VALUES (1);
11 connection con2;
12 SET DEBUG_SYNC= "now WAIT_FOR con1_waiting";
13 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL con2_queued";
14 SET DEBUG_SYNC= "commit_loop_entry_commit_ordered SIGNAL con1_loop WAIT_FOR con1_loop_cont";
15 INSERT INTO t1 VALUES (2);
16 connection con3;
17 SET DEBUG_SYNC= "now WAIT_FOR con2_queued";
18 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL con3_queued";
19 SET DEBUG_SYNC= "commit_loop_entry_commit_ordered SIGNAL con1_loop WAIT_FOR con1_loop_cont";
20 INSERT INTO t1 VALUES (3);
21 connection default;
22 SET DEBUG_SYNC= "now WAIT_FOR con1_loop";
23 SET DEBUG_SYNC= "now SIGNAL con1_loop_cont";
24 SET DEBUG_SYNC= "now WAIT_FOR con1_loop";
25 SET DEBUG_SYNC= "now SIGNAL con1_loop_cont";
26 SET DEBUG_SYNC= "now WAIT_FOR con1_loop";
27 SELECT * FROM t1 ORDER BY a;
28 a
29 0
30 1
31 2
32 connection con1;
33 connection con2;
34 connection default;
35 SET SESSION debug_dbug="+d,crash_dispatch_command_before";
36 SELECT 1;
37 Got one of the listed errors
38 connection con3;
39 Got one of the listed errors
40 connection default;
41 SELECT * FROM t1 ORDER BY a;
42 a
43 0
44 1
45 2
46 3
47 InnoDB: Last binlog file './master-bin.000001', position <pos>
48 SET DEBUG_SYNC= 'RESET';
49 DROP TABLE t1;