Debian Codegraph @

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

raw
1 CREATE TABLE t1(a BIGINT PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES(1);
3 CREATE TABLE t2(a BIGINT PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES(2);
5 SET GLOBAL innodb_flush_log_at_trx_commit=1;
6 INSERT INTO t2 VALUES(1);
7 # Kill the server
8 # Corrupt the pages
9 SELECT * FROM t1;
10 ERROR 42000: Unknown storage engine 'InnoDB'
11 FOUND 1 /InnoDB: Page \[page id: space=[1-9][0-9]*, page number=3\] log sequence number 1311768467463790320 is in the future!/ in mysqld.1.err
12 SELECT * FROM t1;
13 a
14 1
15 SELECT * FROM t2;
16 a
17 1
18 CHECK TABLE t2;
19 Table Op Msg_type Msg_text
20 test.t2 check status OK
21 DROP TABLE t1, t2;
22 CREATE TABLE t1(pk SERIAL) ENGINE=InnoDB;
23 INSERT INTO t1 VALUES (1),(2),(3);
24 connect con1,localhost,root,,;
25 BEGIN;
26 DELETE FROM t1 WHERE pk=1;
27 connection default;
28 SET GLOBAL innodb_flush_log_at_trx_commit=1;
29 DELETE FROM t1 WHERE pk=3;
30 # Kill the server
31 disconnect con1;
32 # Corrupt the page
33 SELECT * FROM t1;
34 pk
35 1
36 2
37 DROP TABLE t1;