Debian Codegraph @

mysql-test/suite/innodb_undo/t/undo_tablespace_debug.test

raw
1 --echo #
2 --echo # Inject failures in order to get code coverage.
3 --echo # Use explicit undo tablespaces and make the implicit spaces inactive.
4 --echo #
5
6 --source include/have_debug.inc
7 --source include/have_innodb_default_undo_tablespaces.inc
8 LET $MYSQLD_DATADIR = `select @@datadir`;
9
10 # Do a slow shutdown and restart to clear out the undo logs
11 SET GLOBAL innodb_fast_shutdown = 0;
12 --let $shutdown_server_timeout = 300
13 --source include/restart_mysqld.inc
14
15 SET @old_truncate_frequency = @@innodb_purge_rseg_truncate_frequency;
16 SET GLOBAL innodb_purge_rseg_truncate_frequency=5;
17
18 --disable_query_log
19 call mtr.add_suppression("\\[Warning\\] .* Failed to truncate undo tablespace");
20 call mtr.add_suppression("\\[Warning\\] .* Purge reached the head of the history list");
21 call mtr.add_suppression("\\[ERROR\\] .* Error 65 opening newly created undo tablespace");
22 call mtr.add_suppression("\\[ERROR\\] .* Cannot create truncate log for undo tablespace");
23 --enable_query_log
24
25 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
26 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
27 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
28 ALTER UNDO TABLESPACE innodb_undo_001 SET INACTIVE;
29 let $inactive_undo_space = innodb_undo_001;
30 source include/wait_until_undo_space_is_empty.inc;
31 ALTER UNDO TABLESPACE innodb_undo_002 SET INACTIVE;
32 let $inactive_undo_space = innodb_undo_002;
33 source include/wait_until_undo_space_is_empty.inc;
34 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
35 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
36 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
37 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
38
39 --echo #
40 --echo # Bug#28966457: IF CREATE UNDO TABLESPACE FAILS, INCOMPLETE UNDO
41 --echo # TABLESPACE SHOULD BE CLEANED UP
42 --echo #
43 --list_files $MYSQLD_DATADIR/ undo_006.ibu
44 SET GLOBAL DEBUG="+d,ib_undo_tablespace_create_fail";
45 --error ER_CREATE_FILEGROUP_FAILED
46 CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu';
47 SET GLOBAL DEBUG="-d,ib_undo_tablespace_create_fail";
48 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
49 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
50 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
51 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
52 --echo # Make sure file is not left behind in datadir
53 --list_files $MYSQLD_DATADIR/ undo_006.ibu
54
55 --echo #
56 --echo # Inject a failure to open an undo tablespace after it is created.
57 --echo # The file remains on disk along with the truncate log file.
58 --echo #
59 --list_files $MYSQLD_DATADIR/ undo_006.ibu
60 SET GLOBAL DEBUG="+d,ib_undo_tablespace_open_fail";
61 --error ER_CREATE_FILEGROUP_FAILED
62 CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu';
63 SET GLOBAL DEBUG="-d,ib_undo_tablespace_open_fail";
64 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
65 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
66 SELECT TABLESPACE_NAME, FILE_TYPE, FILE_NAME FROM INFORMATION_SCHEMA.FILES
67 WHERE FILE_NAME LIKE '%undo%' ORDER BY TABLESPACE_NAME;
68 --echo # Make sure file is not left behind in datadir
69 --list_files $MYSQLD_DATADIR/ undo_006.ibu
70
71 --echo #
72 --echo # Inject a failure to get the MDL during undo truncate.
73 --echo #
74 SET GLOBAL DEBUG="+d,ib_undo_trunc_fail_get_mdl";
75 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
76 let $inactive_undo_space = undo_003;
77 source include/wait_until_undo_space_is_empty.inc;
78 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
79 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
80 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
81
82 --echo #
83 --echo # Inject a failure to locate the undo space during undo truncate.
84 --echo #
85 SET GLOBAL DEBUG="+d,ib_undo_trunc_fail_marked_space";
86 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
87 let $inactive_undo_space = undo_003;
88 source include/wait_until_undo_space_is_empty.inc;
89 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
90 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
91 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
92
93 --echo #
94 --echo # Inject a failure to write the undo trunc log file.
95 --echo #
96 SET GLOBAL DEBUG="+d,ib_undo_trunc_fail_start_logging";
97 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
98 let $inactive_undo_space = undo_003;
99 source include/wait_until_undo_space_is_empty.inc;
100 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
101 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
102 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
103
104 --echo #
105 --echo # Inject a simulated fast shutdown during undo truncate. The injection
106 --echo # does't really shutdown, it just does not finish the truncate.
107 --echo #
108 SET GLOBAL DEBUG="+d,ib_undo_trunc_fail_fast_shutdown";
109 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
110 let $inactive_undo_space = undo_003;
111 source include/wait_until_undo_space_is_empty.inc;
112 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
113 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
114 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
115
116 --echo #
117 --echo # Inject a failure to actually truncate the undo space.
118 --echo #
119 SET GLOBAL DEBUG="+d,ib_undo_trunc_fail_truncate";
120 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
121 let $inactive_undo_space = undo_003;
122 source include/wait_until_undo_space_is_empty.inc;
123 ALTER UNDO TABLESPACE undo_003 SET ACTIVE;
124 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
125 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
126
127 --echo #
128 --echo # Cleanup
129 --echo #
130 SET GLOBAL DEBUG="-d,ib_undo_trunc_fail_get_mdl";
131 SET GLOBAL DEBUG="-d,ib_undo_trunc_fail_marked_space";
132 SET GLOBAL DEBUG="-d,ib_undo_trunc_fail_start_logging";
133 SET GLOBAL DEBUG="-d,ib_undo_trunc_fail_fast_shutdown";
134 SET GLOBAL DEBUG="-d,ib_undo_trunc_fail_truncate";
135
136 ALTER UNDO TABLESPACE innodb_undo_001 SET ACTIVE;
137 ALTER UNDO TABLESPACE innodb_undo_002 SET ACTIVE;
138 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
139 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
140 ALTER UNDO TABLESPACE undo_005 SET INACTIVE;
141
142 let $inactive_undo_space = undo_003;
143 source include/wait_until_undo_space_is_empty.inc;
144 let $inactive_undo_space = undo_004;
145 source include/wait_until_undo_space_is_empty.inc;
146 let $inactive_undo_space = undo_005;
147 source include/wait_until_undo_space_is_empty.inc;
148
149 DROP UNDO TABLESPACE undo_003;
150 DROP UNDO TABLESPACE undo_004;
151 DROP UNDO TABLESPACE undo_005;
152
153 SET GLOBAL innodb_purge_rseg_truncate_frequency=@old_truncate_frequency;