Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: innodb_open_files=.* is exceeded");
2 SET @save_tdc= @@GLOBAL.table_definition_cache;
3 SET @save_toc= @@GLOBAL.table_open_cache;
4 SET GLOBAL table_definition_cache= 400;
5 SET GLOBAL table_open_cache= 1024;
6 CREATE TABLE to_be_evicted(a INT PRIMARY KEY, b INT NOT NULL) ENGINE=InnoDB;
7 INSERT INTO to_be_evicted VALUES(1,2),(2,1);
8 connect ddl,localhost,root,,;
9 SET DEBUG_SYNC = 'row_log_apply_before SIGNAL scanned WAIT_FOR got_duplicate';
10 ALTER TABLE to_be_evicted ADD UNIQUE INDEX(b);
11 connection default;
12 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
13 BEGIN;
14 INSERT INTO to_be_evicted VALUES(3, 2);
15 COMMIT;
16 SET DEBUG_SYNC = 'now SIGNAL got_duplicate';
17 connection ddl;
18 ERROR 23000: Duplicate entry '2' for key 'b'
19 disconnect ddl;
20 connection default;
21 COMMIT;
22 SET DEBUG_SYNC = RESET;
23 FLUSH TABLES;