Debian Codegraph @

mysql-test/suite/innodb/r/sys_truncate_debug.result

raw
1 call mtr.add_suppression("InnoDB: Cannot shrink the system tablespace");
2 call mtr.add_suppression("InnoDB: Plugin initialization aborted");
3 call mtr.add_suppression("Plugin 'InnoDB' init function returned error");
4 call mtr.add_suppression("Plugin 'InnoDB' registration as a STORAGE ENGINE failed");
5 SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG=2;
6 SET GLOBAL INNODB_FILE_PER_TABLE= 0;
7 Warnings:
8 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
9 SET UNIQUE_CHECKS=0, FOREIGN_KEY_CHECKS=0;
10 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
11 f3 INT NOT NULL, INDEX(f1),
12 INDEX(f2), INDEX(f3))STATS_PERSISTENT=0 ENGINE=InnoDB;
13 BEGIN;
14 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
15 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
16 COMMIT;
17 DROP TABLE t1;
18 InnoDB 0 transactions not purged
19 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE = 0;
20 NAME FILE_SIZE
21 innodb_system 540016640
22 # restart: --debug_dbug=+d,traversal_extent_fail
23 FOUND 1 /\[Warning\] InnoDB: Cannot shrink the system tablespace/ in mysqld.1.err
24 SELECT * FROM INFORMATION_SCHEMA.ENGINES
25 WHERE engine = 'innodb'
26 AND support IN ('YES', 'DEFAULT', 'ENABLED');
27 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
28 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
29 # restart: --debug_dbug=+d,shrink_buffer_pool_full
30 FOUND 2 /\[Warning\] InnoDB: Cannot shrink the system tablespace/ in mysqld.1.err
31 SELECT * FROM INFORMATION_SCHEMA.ENGINES
32 WHERE engine = 'innodb'
33 AND support IN ('YES', 'DEFAULT', 'ENABLED');
34 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
35 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
36 # restart: --debug_dbug=+d,mtr_log_max_size
37 FOUND 1 /\[ERROR\] InnoDB: Cannot shrink the system tablespace/ in mysqld.1.err
38 SELECT * FROM INFORMATION_SCHEMA.ENGINES
39 WHERE engine = 'innodb'
40 AND support IN ('YES', 'DEFAULT', 'ENABLED');
41 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
42 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
43 # restart: --debug_dbug=+d,crash_after_sys_truncate
44 SELECT * FROM INFORMATION_SCHEMA.ENGINES
45 WHERE engine = 'innodb'
46 AND support IN ('YES', 'DEFAULT', 'ENABLED');
47 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
48 # restart: --innodb_buffer_pool_size=5M
49 SELECT * FROM INFORMATION_SCHEMA.ENGINES
50 WHERE engine = 'innodb'
51 AND support IN ('YES', 'DEFAULT', 'ENABLED');
52 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
53 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
54 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=0;
55 NAME FILE_SIZE
56 innodb_system 3145728
57 #
58 # MDEV-38412 System tablespace fails to shrink due to legacy tables
59 #
60 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/old_datadir --debug_dbug=d,create_sys_tablespaces
61 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE= 0;
62 NAME
63 SYS_FOREIGN
64 SYS_FOREIGN_COLS
65 SYS_TABLESPACES
66 SYS_VIRTUAL
67 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE SPACE=0 AND NAME LIKE 'DUMMY_IND%';
68 NAME
69 DUMMY_IND
70 DUMMY_IND_1
71 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS WHERE NAME LIKE 'DUMMY_ID%';
72 NAME
73 DUMMY_ID
74 DUMMY_ID_1
75 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE NAME LIKE 'DUMMY_ID%';
76 NAME
77 DUMMY_ID
78 DUMMY_ID_1
79 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/old_datadir --innodb_data_file_path=ibdata1:10M:autoextend:autoshrink --innodb_fast_shutdown=0
80 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE= 0;
81 NAME
82 SYS_FOREIGN
83 SYS_FOREIGN_COLS
84 SYS_VIRTUAL
85 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES WHERE SPACE=0 AND NAME LIKE 'DUMMY_IND%';
86 NAME
87 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS WHERE NAME LIKE 'DUMMY_ID%';
88 NAME
89 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS WHERE NAME LIKE 'DUMMY_ID%';
90 NAME
91 FOUND 1 /InnoDB: Found an unknown table SYS_TABLESPACES/ in mysqld.1.err
92 FOUND 1 /InnoDB: Found orphaned index for table_id .*/ in mysqld.1.err
93 FOUND 1 /InnoDB: Dropping 2 orphaned table/ in mysqld.1.err
94 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/old_datadir --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/old_datadir --innodb_data_file_path=ibdata1:10M:autoextend:autoshrink
95 # restart