| 1 |
# |
| 2 |
# BUG#19316315 CRASH RECOVERY FAILS AFTER ONLINE ADD INDEX |
| 3 |
# |
| 4 |
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT) ENGINE=InnoDB; |
| 5 |
INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5); |
| 6 |
SET DEBUG_SYNC = 'RESET'; |
| 7 |
SET DEBUG_SYNC = 'row_log_apply_after SIGNAL apply_after WAIT_FOR insert_after'; |
| 8 |
ALTER TABLE t1 ADD UNIQUE INDEX(c2); |
| 9 |
SET DEBUG_SYNC = 'now WAIT_FOR apply_after'; |
| 10 |
INSERT INTO t1 VALUES(6, 6); |
| 11 |
# Kill and restart |
| 12 |
SELECT * FROM t1; |
| 13 |
c1 c2 |
| 14 |
1 1 |
| 15 |
2 2 |
| 16 |
3 3 |
| 17 |
4 4 |
| 18 |
5 5 |
| 19 |
6 6 |
| 20 |
DROP TABLE t1; |