Debian Codegraph @

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

raw
1 CREATE TABLE t1 (pk INT PRIMARY KEY, c CHAR(255))ENGINE=InnoDB STATS_PERSISTENT=0;
2 SET GLOBAL INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG = 2;
3 INSERT INTO t1 VALUES(1, 'sql'), (2, 'server'), (3, 'mariadb'),
4 (4, 'mariadb'), (5, 'test1'), (6, 'test2'), (7, 'test3'),
5 (8, 'test4'), (9, 'test5'), (10, 'test6'), (11, 'test7'),
6 (12, 'test8');
7 SELECT COUNT(*) FROM t1;
8 COUNT(*)
9 12
10 UPDATE t1 SET c='best8' WHERE pk=12;
11 # Kill the server
12 # Corrupt the pages
13 SELECT * FROM t1 WHERE PK = 1;
14 ERROR 42000: Unknown storage engine 'InnoDB'
15 SELECT * FROM t1 WHERE PK = 1;
16 pk c
17 1 sql
18 SELECT * FROM t1 WHERE pk = 12;
19 ERROR HY000: Index for table 't1' is corrupt; try to repair it
20 CHECK TABLE t1;
21 Table Op Msg_type Msg_text
22 test.t1 check Warning InnoDB: The B-tree of index PRIMARY is corrupted.
23 test.t1 check error Corrupt
24 DROP TABLE t1;