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