Debian Codegraph @

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

raw
1 #
2 # MDEV-37412 Corrupted page during recovery aborts the server
3 #
4 call mtr.add_suppression("InnoDB: OPT_PAGE_CHECKSUM mismatch on \\[page id: space=127, page number=0\\]");
5 call mtr.add_suppression("InnoDB: Set innodb_force_recovery=1");
6 call mtr.add_suppression("InnoDB: Cannot apply log to \\[page id: space=127, page number=0\\] of corrupted file '.*test/t\\.ibd");
7 call mtr.add_suppression("(InnoDB: Plugin|Plugin 'InnoDB')");
8 call mtr.add_suppression("InnoDB: Page .* Current system log sequence number 123(38|54)");
9 SET GLOBAL innodb_fast_shutdown=0;
10 # restart
11 SELECT * FROM INFORMATION_SCHEMA.ENGINES
12 WHERE engine = 'innodb'
13 AND support IN ('YES', 'DEFAULT', 'ENABLED');
14 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
15 NOT FOUND /InnoDB: Page .* Current system log sequence number/ in mysqld.1.err
16 # restart: --innodb-force-recovery=1
17 SELECT * FROM INFORMATION_SCHEMA.ENGINES
18 WHERE engine = 'innodb'
19 AND support IN ('YES', 'DEFAULT', 'ENABLED');
20 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
21 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
22 FOUND 1 /InnoDB: Page .* Current system log sequence number/ in mysqld.1.err
23 FOUND 2 /InnoDB: OPT_PAGE_CHECKSUM mismatch on \[page id: space=127, page number=0\]/ in mysqld.1.err
24 FOUND 1 /InnoDB: Cannot apply log to \[page id: space=127, page number=0\] of corrupted file .*test/t\.ibd/ in mysqld.1.err
25 # restart
26 SELECT * FROM INFORMATION_SCHEMA.ENGINES
27 WHERE engine = 'innodb'
28 AND support IN ('YES', 'DEFAULT', 'ENABLED');
29 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
30 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES