| 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; |