Debian Codegraph @

mysql-test/suite/innodb/r/flush-hang.result

raw
1 #
2 #Bug #21133329 HANGING "SYSTEM LOCK" WHEN EXECUTING "FLUSH TABLE ... FOR EXPORT"
3 #
4 CREATE TABLE t1 (
5 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
6 c2 BIGINT,
7 c3 VARCHAR(2048),
8 c4 VARCHAR(2048),
9 INDEX idx1(c2),
10 INDEX idx2(c3(512)),
11 INDEX idx3(c4(512))) Engine=InnoDB charset latin1;
12 CREATE TABLE t2 ( f1 int PRIMARY KEY) engine=innodb;
13 SET GLOBAL INNODB_PURGE_STOP_NOW=ON;
14 SET GLOBAL innodb_disable_background_merge=ON;
15 SET GLOBAL innodb_stats_persistent=OFF;
16 show variables like '%innodb_stats_persistent%';
17 Variable_name Value
18 innodb_stats_persistent OFF
19 innodb_stats_persistent_sample_pages 20
20 INSERT INTO t1(c2, c3, c4) VALUES
21 (1, REPEAT('a', 2048), REPEAT('a', 2048)),
22 (2, REPEAT('b', 2048), REPEAT('b', 2048)),
23 (3, REPEAT('c', 2048), REPEAT('c', 2048)),
24 (4, REPEAT('d', 2048), REPEAT('d', 2048));
25 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
26 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
27 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
28 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
29 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
30 INSERT INTO t1(c2, c3, c4) SELECT c2, c3, c4 FROM t1;
31 FLUSH TABLES t2 FOR EXPORT;
32 UNLOCK TABLES;
33 SET GLOBAL innodb_disable_background_merge=OFF;
34 SET GLOBAL INNODB_PURGE_RUN_NOW=ON;
35 SET GLOBAL innodb_stats_persistent=ON;
36 DROP TABLE t1,t2;