Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: Cannot free the unused segments in system tablespace because a previous shutdown was not with innodb_fast_shutdown=0");
2 call mtr.add_suppression("InnoDB: :autoshrink failed to read the used segment");
3 call mtr.add_suppression("InnoDB: :autoshrink failed due to .* in FSP_SEG_INODES_FULL list");
4 call mtr.add_suppression("InnoDB: :autoshrink failed due to .* in FSP_SEG_INODES_FREE list");
5 call mtr.add_suppression("InnoDB: :autoshrink failed to free the segment");
6 call mtr.add_suppression("Found .* prepared XA transactions");
7 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
8 NAME FILE_SIZE
9 innodb_system 10485760
10 SET GLOBAL INNODB_FILE_PER_TABLE=0;
11 Warnings:
12 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
13 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL)STATS_PERSISTENT=0, ENGINE=InnoDB;
14 XA START 'x';
15 insert into t1 values (1, 1);
16 XA END 'x';
17 XA PREPARE 'x';
18 set GLOBAL innodb_fast_shutdown=0;
19 # restart
20 # Fail to free the segment due to XA PREPARE transaction
21 FOUND 2 /InnoDB: Cannot free the unused segments in system tablespace because a previous shutdown was not with innodb_fast_shutdown=0/ in mysqld.1.err
22 XA COMMIT 'x';
23 DROP TABLE t1;
24 # restart: --debug_dbug=d,undo_segment_leak
25 SET GLOBAL INNODB_FILE_PER_TABLE=0;
26 Warnings:
27 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
28 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL)STATS_PERSISTENT=0, ENGINE=InnoDB;
29 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
30 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
31 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
32 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
33 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
34 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
35 UPDATE t1 SET f1 = f1 + 1 WHERE f1 > 1000;
36 UPDATE t1 SET f2 = f2 + 1 WHERE f1 > 1000;
37 UPDATE t1 SET f1 = f2 + 1 WHERE f1 > 1000;
38 UPDATE t1 SET f2 = f1 + 1 WHERE f1 > 1000;
39 DELETE FROM t1;
40 DROP TABLE t1;
41 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
42 NAME FILE_SIZE
43 innodb_system 77594624
44 # restart: --debug_dbug=d,unused_undo_free_fail_1
45 # Fail to free the segment due to previous shutdown
46 FOUND 1 /InnoDB: Cannot free the unused segments in system tablespace because a previous shutdown was not with innodb_fast_shutdown=0.*/ in mysqld.1.err
47 SELECT NAME, IF(file_size>=14680064,'ok',file_size)
48 FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
49 NAME IF(file_size>=14680064,'ok',file_size)
50 innodb_system ok
51 SET GLOBAL innodb_fast_shutdown= 0;
52 # Fail to free the segment while finding the used segments
53 # restart: --debug_dbug=d,unused_undo_free_fail_2
54 SELECT IF(file_size>10485760,'ok',file_size) FROM information_schema.innodb_sys_tablespaces WHERE space=0;
55 IF(file_size>10485760,'ok',file_size)
56 ok
57 FOUND 1 /InnoDB: :autoshrink failed to read the used segment/ in mysqld.1.err
58 FOUND 1 /InnoDB: :autoshrink failed due to .* in FSP_SEG_INODES_FULL list/ in mysqld.1.err
59 SET GLOBAL innodb_fast_shutdown= 0;
60 # Fail to free the segment while finding the used segments
61 # restart: --debug_dbug=d,unused_undo_free_fail_3
62 SELECT IF(file_size>10485760,'ok',file_size) FROM information_schema.innodb_sys_tablespaces WHERE space=0;
63 IF(file_size>10485760,'ok',file_size)
64 ok
65 FOUND 1 /InnoDB: :autoshrink failed due to .* in FSP_SEG_INODES_FREE list/ in mysqld.1.err
66 SET GLOBAL innodb_fast_shutdown= 0;
67 # Fail to free the segment while freeing the unused segments
68 # restart: --debug_dbug=d,unused_undo_free_fail_4
69 SELECT IF(file_size>10485760,'ok',file_size) FROM information_schema.innodb_sys_tablespaces WHERE space=0;
70 IF(file_size>10485760,'ok',file_size)
71 ok
72 FOUND 1 /InnoDB: :autoshrink failed to free the segment .* in page .*/ in mysqld.1.err
73 SET GLOBAL innodb_fast_shutdown= 0;
74 # Fail to free the segment while freeing the used segments
75 # restart: --debug_dbug=d,unused_undo_free_fail_5
76 SELECT IF(file_size>10485760,'ok',file_size) FROM information_schema.innodb_sys_tablespaces WHERE space=0;
77 IF(file_size>10485760,'ok',file_size)
78 ok
79 FOUND 1 /InnoDB: :autoshrink failed to free the segment .* in page .*/ in mysqld.1.err
80 SET GLOBAL innodb_fast_shutdown= 0;
81 # restart
82 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
83 NAME FILE_SIZE
84 innodb_system 10485760
85 # Fail to reset the TRX_SYS_FSEG_HEADER during undo tablespace
86 # reinitialization. garbage_collect() shouldn't free the
87 # TRX_SYS_FSEG_HEADER index node
88 set global innodb_fast_shutdown=0;
89 # restart: --innodb_undo_tablespaces=2 --debug_dbug=d,sys_fseg_header_fail
90 FOUND 1 /InnoDB: :autoshrink freed the segment .* in page .*/ in mysqld.1.err
91 set global innodb_fast_shutdown=0;
92 # restart
93 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
94 NAME FILE_SIZE
95 innodb_system 10485760