Debian Codegraph @

mysql-test/suite/innodb/r/group_commit_binlog_pos.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 EXECUTE 3";
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 INSERT INTO t1 VALUES (2);
15 connection con3;
16 SET DEBUG_SYNC= "now WAIT_FOR con2_queued";
17 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL con3_queued";
18 INSERT INTO t1 VALUES (3);
19 connection default;
20 SET DEBUG_SYNC= "now WAIT_FOR con1_loop";
21 SET DEBUG_SYNC= "now SIGNAL con1_loop_cont";
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 SELECT * FROM t1 ORDER BY a;
26 a
27 0
28 1
29 2
30 connection con2;
31 connection default;
32 SET SESSION debug_dbug="+d,crash_dispatch_command_before";
33 SELECT 1;
34 Got one of the listed errors
35 connection con1;
36 Got one of the listed errors
37 connection con3;
38 Got one of the listed errors
39 connection default;
40 SELECT * FROM t1 ORDER BY a;
41 a
42 0
43 1
44 2
45 3
46 InnoDB: Last binlog file './master-bin.000001', position <pos>
47 SET DEBUG_SYNC= 'RESET';
48 DROP TABLE t1;