Debian Codegraph @

mysql-test/suite/innodb/t/undo_upgrade_debug.test

raw
1 --source include/have_innodb.inc
2 --source include/innodb_page_size.inc
3 --source include/have_debug.inc
4 --source include/not_embedded.inc
5
6 --echo #
7 --echo # MDEV-19229 Allow innodb_undo_tablespaces to be changed
8 --echo # after database creation
9 --echo #
10 let $MYSQLD_DATADIR= `select @@datadir`;
11 call mtr.add_suppression("InnoDB: Plugin initialization aborted");
12 call mtr.add_suppression("Plugin 'InnoDB' init function returned error");
13 call mtr.add_suppression("Plugin 'InnoDB' registration as a STORAGE ENGINE failed");
14
15 set global innodb_fast_shutdown=0;
16
17 --echo # case 1: Abort after resetting TRX_SYS page rollback segments
18 let $restart_parameters=--innodb_undo_tablespaces=4 --debug_dbug="+d,after_rseg_reset_abort";
19
20 --source include/restart_mysqld.inc
21
22 let $restart_parameters=--innodb_undo_tablespaces=4;
23 --source include/restart_mysqld.inc
24
25 --echo # Should list 4 undo log tablespaces
26 list_files $MYSQLD_DATADIR undo*;
27
28 --echo # case 2: Abort after deleting the old undo tablespaces
29 let $restart_parameters=--innodb_undo_tablespaces=2 --debug_dbug="+d,after_deleting_old_undo_abort";
30
31 --source include/restart_mysqld.inc
32
33 let $restart_parameters=--innodb_undo_tablespaces=2;
34 --source include/restart_mysqld.inc
35
36 --echo # Should list 2 undo log tablespaces
37 list_files $MYSQLD_DATADIR undo*;
38
39 --echo # case 3: Abort after successfully deleting the old undo tablespace
40 let $restart_parameters=--innodb_undo_tablespaces=3 --debug_dbug="+d,after_deleting_old_undo_success";
41
42 --source include/restart_mysqld.inc
43
44 let $restart_parameters=--innodb_undo_tablespaces=3;
45 --source include/restart_mysqld.inc
46
47 --echo # Should list 3 undo log tablespaces
48 list_files $MYSQLD_DATADIR undo*;
49
50 let $restart_parameters=--innodb_undo_tablespaces=4;
51 --source include/restart_mysqld.inc
52
53 --echo # Should list 4 undo log tablespaces
54 list_files $MYSQLD_DATADIR undo*;
55
56 let $restart_parameters=--innodb_undo_tablespaces=2;
57 --source include/restart_mysqld.inc
58
59 --echo # Should list 2 undo log tablespaces
60 list_files $MYSQLD_DATADIR undo*;