Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/not_embedded.inc
4 --source include/have_debug.inc
5 --source include/not_windows.inc
6 # This test is extremely slow on Valgrind (exceeding 4 hours).
7 --source include/not_valgrind.inc
8
9 call mtr.add_suppression("InnoDB: Cannot shrink the system tablespace");
10 call mtr.add_suppression("InnoDB: Plugin initialization aborted");
11 call mtr.add_suppression("Plugin 'InnoDB' init function returned error");
12 call mtr.add_suppression("Plugin 'InnoDB' registration as a STORAGE ENGINE failed");
13
14 SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=2;
15 SET GLOBAL INNODB_FILE_PER_TABLE= 0;
16 SET UNIQUE_CHECKS=0, FOREIGN_KEY_CHECKS=0;
17 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
18 f3 INT NOT NULL, INDEX(f1),
19 INDEX(f2), INDEX(f3))STATS_PERSISTENT=0 ENGINE=InnoDB;
20 BEGIN;
21 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
22 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
23 COMMIT;
24 DROP TABLE t1;
25 --source include/wait_all_purged.inc
26 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE = 0;
27
28 # Corruption during traversal of extent
29 let $restart_parameters=--debug_dbug=+d,traversal_extent_fail;
30 --source include/restart_mysqld.inc
31
32 --let SEARCH_PATTERN= \[Warning\] InnoDB: Cannot shrink the system tablespace
33 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
34 --source include/search_pattern_in_file.inc
35
36 SELECT * FROM INFORMATION_SCHEMA.ENGINES
37 WHERE engine = 'innodb'
38 AND support IN ('YES', 'DEFAULT', 'ENABLED');
39
40 # Ran out of buffer pool
41 let $restart_parameters=--debug_dbug=+d,shrink_buffer_pool_full;
42 --source include/restart_mysqld.inc
43
44 --let SEARCH_PATTERN= \[Warning\] InnoDB: Cannot shrink the system tablespace
45 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
46 --source include/search_pattern_in_file.inc
47
48 SELECT * FROM INFORMATION_SCHEMA.ENGINES
49 WHERE engine = 'innodb'
50 AND support IN ('YES', 'DEFAULT', 'ENABLED');
51
52 # Ran out of mtr log size
53 let $restart_parameters=--debug_dbug=+d,mtr_log_max_size;
54 --source include/restart_mysqld.inc
55
56 --let SEARCH_PATTERN= \[ERROR\] InnoDB: Cannot shrink the system tablespace
57 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
58 --source include/search_pattern_in_file.inc
59
60 SELECT * FROM INFORMATION_SCHEMA.ENGINES
61 WHERE engine = 'innodb'
62 AND support IN ('YES', 'DEFAULT', 'ENABLED');
63
64 # Crash after shrinking the system tablespace
65 let $restart_parameters=--debug_dbug=+d,crash_after_sys_truncate;
66 --source include/restart_mysqld.inc
67 SELECT * FROM INFORMATION_SCHEMA.ENGINES
68 WHERE engine = 'innodb'
69 AND support IN ('YES', 'DEFAULT', 'ENABLED');
70
71 let $restart_parameters=--innodb_buffer_pool_size=5M;
72 --source include/restart_mysqld.inc
73 SELECT * FROM INFORMATION_SCHEMA.ENGINES
74 WHERE engine = 'innodb'
75 AND support IN ('YES', 'DEFAULT', 'ENABLED');
76 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=0;
77
78 --echo #
79 --echo # MDEV-38412 System tablespace fails to shrink due to legacy tables
80 --echo #
81 let bugdir= $MYSQLTEST_VARDIR/tmp/old_datadir;
82 --mkdir $bugdir
83 let $dirs= --innodb-data-home-dir=$bugdir --innodb-log-group-home-dir=$bugdir --innodb_undo_directory=$bugdir;
84 # Create a new data directory
85 let $restart_parameters=$dirs --debug_dbug=d,create_sys_tablespaces;
86 --source include/restart_mysqld.inc
87
88 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE= 0;
89 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE SPACE=0 AND NAME LIKE 'DUMMY_IND%';
90 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS WHERE NAME LIKE 'DUMMY_ID%';
91 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE NAME LIKE 'DUMMY_ID%';
92
93 # Drop the unknown table during slow shutdown
94 let $restart_parameters=$dirs --innodb_data_file_path=ibdata1:10M:autoextend:autoshrink --innodb_fast_shutdown=0;
95 --source include/restart_mysqld.inc
96
97 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE= 0;
98 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE SPACE=0 AND NAME LIKE 'DUMMY_IND%';
99 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS WHERE NAME LIKE 'DUMMY_ID%';
100 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE NAME LIKE 'DUMMY_ID%';
101
102 let SEARCH_PATTERN=InnoDB: Found an unknown table SYS_TABLESPACES;
103 --source include/search_pattern_in_file.inc
104
105 let SEARCH_PATTERN=InnoDB: Found orphaned index for table_id .*;
106 --source include/search_pattern_in_file.inc
107
108 let SEARCH_PATTERN=InnoDB: Dropping 2 orphaned table;
109 --source include/search_pattern_in_file.inc
110
111 # Shrink the system tablespace further
112 let $restart_parameters=$dirs --innodb_data_file_path=ibdata1:10M:autoextend:autoshrink;
113 --source include/restart_mysqld.inc
114
115 # Cleanup
116 let $restart_parameters=;
117 --source include/restart_mysqld.inc
118 rmdir $bugdir;