Debian Codegraph @

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

raw
1 --echo #
2 --echo # InnoDB supports CREATE/ALTER/DROP UNDO TABLESPACE
3 --echo # Show that up to 125 explicit undo tablespaces can be created.
4 --echo #
5
6 --source include/big_test.inc
7 --source include/have_innodb_default_undo_tablespaces.inc
8
9 let $cnt = 3;
10 while ($cnt <= 127)
11 {
12 let $undo_space_name = undo_$cnt;
13 let $datafile = undo_$cnt.ibu;
14 eval CREATE UNDO TABLESPACE $undo_space_name ADD DATAFILE '$datafile';
15 inc $cnt;
16 }
17
18 --error ER_CREATE_FILEGROUP_FAILED
19 CREATE UNDO TABLESPACE undo_128 ADD DATAFILE 'undo_128.ibu';
20 SHOW WARNINGS;
21
22 let $cnt = 3;
23 while ($cnt <= 127)
24 {
25 let $undo_space_name = undo_$cnt;
26 eval ALTER UNDO TABLESPACE $undo_space_name SET INACTIVE;
27 inc $cnt;
28 }
29
30 --echo # Wait for all explicit undo tablespaces to become empty.
31 let $cnt = 3;
32 while ($cnt <= 127)
33 {
34 let $inactive_undo_space = undo_$cnt;
35 source include/wait_until_undo_space_is_empty.inc;
36 inc $cnt;
37 }
38
39 --echo # Drop all explicit undo tablespaces.
40 let $cnt = 3;
41 while ($cnt <= 127)
42 {
43 let $undo_space_name = undo_$cnt;
44 eval DROP UNDO TABLESPACE $undo_space_name;
45 inc $cnt;
46 }
47
48 --disable_query_log
49 call mtr.add_suppression("\\[Warning\\] .* Log writer is waiting for checkpointer to to catch up lag");
50 call mtr.add_suppression("\\[ERROR\\] .* Cannot create undo tablespace undo_128 at undo_128.ibu because 127 undo tablespaces already exist");
51 --enable_query_log
52