Debian Codegraph @

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

raw
1 #
2 # Try various things when InnoDB runs out of free undo logs.
3 #
4 # These first three injection points are during DDL_Log removal
5 # after a CREATE TABLE
6 # Inject error #1
7 SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_1';
8 CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
9 ERROR HY000: Too many active concurrent transactions
10 SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_1';
11 # Try more DDL, restart, try more DDL
12 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
13 DROP TABLE t9;
14 # restart
15 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
16 DROP TABLE t9;
17 # Inject error #2
18 SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_2';
19 CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
20 ERROR HY000: Too many active concurrent transactions
21 SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_2';
22 # Try more DDL, restart, try more DDL
23 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
24 DROP TABLE t9;
25 # restart
26 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
27 DROP TABLE t9;
28 # Inject error #3
29 SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_3';
30 CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
31 ERROR HY000: Too many active concurrent transactions
32 SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_3';
33 # Try more DDL, restart, try more DDL
34 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
35 DROP TABLE t9;
36 # restart
37 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
38 DROP TABLE t9;
39 # These next two injection points are during DDL_Log removal
40 # after a RENAME TABLE
41 CREATE TABLE t1 (f1 INT, f2 CHAR(6), KEY(f2));
42 # Inject error #4
43 SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_4';
44 ALTER TABLE t1 RENAME TO t2;
45 ERROR HY000: Error on rename of 'OLD_FILE_NAME' to 'NEW_FILE_NAME' (errno: 177 - Too many active concurrent transactions)
46 SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_4';
47 ALTER TABLE t1 RENAME TO t2;
48 # Try more DDL, restart, try more DDL
49 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
50 DROP TABLE t9;
51 # restart
52 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
53 DROP TABLE t9;
54 # Inject error #5
55 SET GLOBAL DEBUG='+d,DDL_Log_remove_inject_error_5';
56 ALTER TABLE t2 RENAME TO t1;
57 ERROR HY000: Error on rename of 'OLD_FILE_NAME' to 'NEW_FILE_NAME' (errno: 177 - Too many active concurrent transactions)
58 SET GLOBAL DEBUG='-d,DDL_Log_remove_inject_error_5';
59 ALTER TABLE t2 RENAME TO t1;
60 DROP TABLE t1;
61 # Try more DDL, restart, try more DDL
62 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
63 DROP TABLE t9;
64 # restart
65 CREATE TABLE t9 (f1 INT, f2 CHAR(6), KEY(f2));
66 DROP TABLE t9;