Debian Codegraph @

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

raw
1 CREATE TABLE t_2_9(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
2 INSERT INTO t_2_9 SET a = 10;
3 CREATE TABLE t_2_8(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
4 INSERT INTO t_2_8 SET a = 10;
5 CREATE TABLE t_2_7(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
6 INSERT INTO t_2_7 SET a = 10;
7 CREATE TABLE t_2_6(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
8 INSERT INTO t_2_6 SET a = 10;
9 CREATE TABLE t_2_5(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
10 INSERT INTO t_2_5 SET a = 10;
11 CREATE TABLE t_2_4(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
12 INSERT INTO t_2_4 SET a = 10;
13 CREATE TABLE t_2_3(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
14 INSERT INTO t_2_3 SET a = 10;
15 CREATE TABLE t_2_2(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
16 INSERT INTO t_2_2 SET a = 10;
17 CREATE TABLE t_2_1(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
18 INSERT INTO t_2_1 SET a = 10;
19 CREATE TABLE t_1_0(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
20 INSERT INTO t_1_0 SET a = 10;
21 CREATE TABLE t_2_0(a INT primary key) Engine=InnoDB STATS_PERSISTENT=0;
22 INSERT INTO t_2_0 SET a = 10;
23 InnoDB 0 transactions not purged
24 connect prevent_purge,localhost,root,,;
25 START TRANSACTION WITH CONSISTENT SNAPSHOT;
26 SET GLOBAL DEBUG_DBUG ="+d,assign_same_rseg";
27 connection default;
28 UPDATE t_2_1 SET a=150;
29 connect con_1_0, localhost,root,,;
30 BEGIN;
31 UPDATE t_1_0 SET a=15;
32 connect con_2_0, localhost,root,,;
33 BEGIN;
34 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_0 WAIT_FOR cont_0";
35 SET DEBUG_SYNC="after_undo_log_trx_id_write SIGNAL after_0";
36 UPDATE t_2_0 SET a=15;
37 connection con_1_0;
38 SET DEBUG_SYNC="now WAIT_FOR before_0";
39 connect con_2_1, localhost,root,,;
40 BEGIN;
41 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_1 WAIT_FOR cont_1";
42 UPDATE t_2_1 SET a=15;
43 connection default;
44 SET DEBUG_SYNC="now WAIT_FOR before_1";
45 connect con_2_2, localhost,root,,;
46 BEGIN;
47 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_2 WAIT_FOR cont_2";
48 UPDATE t_2_2 SET a=15;
49 connection default;
50 SET DEBUG_SYNC="now WAIT_FOR before_2";
51 connect con_2_3, localhost,root,,;
52 BEGIN;
53 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_3 WAIT_FOR cont_3";
54 UPDATE t_2_3 SET a=15;
55 connection default;
56 SET DEBUG_SYNC="now WAIT_FOR before_3";
57 connect con_2_4, localhost,root,,;
58 BEGIN;
59 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_4 WAIT_FOR cont_4";
60 UPDATE t_2_4 SET a=15;
61 connection default;
62 SET DEBUG_SYNC="now WAIT_FOR before_4";
63 connect con_2_5, localhost,root,,;
64 BEGIN;
65 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_5 WAIT_FOR cont_5";
66 UPDATE t_2_5 SET a=15;
67 connection default;
68 SET DEBUG_SYNC="now WAIT_FOR before_5";
69 connect con_2_6, localhost,root,,;
70 BEGIN;
71 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_6 WAIT_FOR cont_6";
72 UPDATE t_2_6 SET a=15;
73 connection default;
74 SET DEBUG_SYNC="now WAIT_FOR before_6";
75 connect con_2_7, localhost,root,,;
76 BEGIN;
77 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_7 WAIT_FOR cont_7";
78 UPDATE t_2_7 SET a=15;
79 connection default;
80 SET DEBUG_SYNC="now WAIT_FOR before_7";
81 connect con_2_8, localhost,root,,;
82 BEGIN;
83 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_8 WAIT_FOR cont_8";
84 UPDATE t_2_8 SET a=15;
85 connection default;
86 SET DEBUG_SYNC="now WAIT_FOR before_8";
87 connect con_2_9, localhost,root,,;
88 BEGIN;
89 SET DEBUG_SYNC="before_undo_log_trx_id_write SIGNAL before_9 WAIT_FOR cont_9";
90 UPDATE t_2_9 SET a=15;
91 connection default;
92 SET DEBUG_SYNC="now WAIT_FOR before_9";
93 connection con_1_0;
94 COMMIT;
95 SET DEBUG_SYNC="now SIGNAL cont_0";
96 SET DEBUG_SYNC="now WAIT_FOR after_0";
97 # Kill and restart
98 INSERT INTO t_2_1 SET a = 20;
99 INSERT INTO t_2_1 SET a = 30;
100 INSERT INTO t_2_1 SET a = 40;
101 INSERT INTO t_2_1 SET a = 50;
102 INSERT INTO t_2_1 SET a = 60;
103 SET GLOBAL innodb_max_purge_lag_wait=0;
104 DROP TABLE t_2_9;
105 DROP TABLE t_2_8;
106 DROP TABLE t_2_7;
107 DROP TABLE t_2_6;
108 DROP TABLE t_2_5;
109 DROP TABLE t_2_4;
110 DROP TABLE t_2_3;
111 DROP TABLE t_2_2;
112 DROP TABLE t_2_1;
113 DROP TABLE t_1_0;
114 DROP TABLE t_2_0;