Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3
4 --echo # MDEV-33101 Server crashes when starting the server with
5 --echo # innodb-force-recovery=6 and enabling the
6 --echo # innodb_truncate_temporary_tablespace_now variable
7
8 --let $restart_parameters=--innodb-force-recovery=6
9 --source include/restart_mysqld.inc
10 SHOW VARIABLES LIKE "innodb_read_only";
11 SET GLOBAL innodb_truncate_temporary_tablespace_now=1;
12
13 --let $restart_parameters=
14 --source include/restart_mysqld.inc
15 CREATE TEMPORARY TABLE t1(f1 INT NOT NULL,
16 f2 INT NOT NULL)ENGINE=InnoDB;
17 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_65536;
18 DROP TABLE t1;
19 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
20 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 0;
21 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
22 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1;
23 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294;
24
25 # Concurrent session has open transaction for temporary tables
26 CREATE TEMPORARY TABLE t1(f1 INT NOT NULL,
27 f2 INT NOT NULL)ENGINE=InnoDB;
28 BEGIN;
29 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_65536;
30
31 # Concurrent session has open transaction for temporary tables
32 connect(con1,localhost,root,,,);
33 CREATE TEMPORARY TABLE t2(f1 INT NOT NULL,
34 f2 INT NOT NULL)ENGINE=InnoDB;
35 INSERT INTO t2 SELECT seq, seq FROM seq_1_to_65536;
36 DROP TABLE t2;
37 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
38 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1;
39 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294;
40
41 connection default;
42 COMMIT;
43 SELECT COUNT(*) FROM t1;
44 DROP TABLE t1;