1# redo log from before MariaDB 10.2.2/MySQL 5.7.9 2SELECT * FROM INFORMATION_SCHEMA.ENGINES 3WHERE engine = 'innodb' 4AND support IN ('YES', 'DEFAULT', 'ENABLED'); 5ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 6FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2\./ in mysqld.1.err 7# redo log from before MariaDB 10.2.2, with corrupted log checkpoint 8SELECT * FROM INFORMATION_SCHEMA.ENGINES 9WHERE engine = 'innodb' 10AND support IN ('YES', 'DEFAULT', 'ENABLED'); 11ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 12FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and we did not find a valid checkpoint/ in mysqld.1.err 13FOUND 2 /Plugin 'InnoDB' registration as a STORAGE ENGINE failed/ in mysqld.1.err 14# redo log from before MariaDB 10.2.2, with corrupted log block 15SELECT * FROM INFORMATION_SCHEMA.ENGINES 16WHERE engine = 'innodb' 17AND support IN ('YES', 'DEFAULT', 'ENABLED'); 18ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 19FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and it appears corrupted/ in mysqld.1.err 20# empty redo log from before MariaDB 10.2.2 21SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES 22WHERE engine = 'innodb' 23AND support IN ('YES', 'DEFAULT', 'ENABLED'); 24COUNT(*) 251 26FOUND 1 /InnoDB: Upgrading redo log:/ in mysqld.1.err 27# redo log from "after" MariaDB 10.2.2, but with invalid header checksum 28SELECT * FROM INFORMATION_SCHEMA.ENGINES 29WHERE engine = 'innodb' 30AND support IN ('YES', 'DEFAULT', 'ENABLED'); 31ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 32FOUND 1 /InnoDB: Invalid redo log header checksum/ in mysqld.1.err 33# distant future redo log format, with valid header checksum 34SELECT * FROM INFORMATION_SCHEMA.ENGINES 35WHERE engine = 'innodb' 36AND support IN ('YES', 'DEFAULT', 'ENABLED'); 37ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 38FOUND 1 /InnoDB: Unsupported redo log format. The redo log was created with malicious intentions, or perhaps\./ in mysqld.1.err 39# valid header, but old-format checkpoint blocks 40SELECT * FROM INFORMATION_SCHEMA.ENGINES 41WHERE engine = 'innodb' 42AND support IN ('YES', 'DEFAULT', 'ENABLED'); 43ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 44FOUND 1 /InnoDB: No valid checkpoint found .corrupted redo log/ in mysqld.1.err 45# valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2, invalid block checksum 46SELECT * FROM INFORMATION_SCHEMA.ENGINES 47WHERE engine = 'innodb' 48AND support IN ('YES', 'DEFAULT', 'ENABLED'); 49ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 50FOUND 1 /InnoDB: Invalid log block checksum. block: 2372 checkpoint no: 1 expected: 3362026715 found: 144444122/ in mysqld.1.err 51FOUND 1 /InnoDB: Missing MLOG_CHECKPOINT between the checkpoint 1213964 and the end 1213952\./ in mysqld.1.err 52# same, but with current-version header 53SELECT * FROM INFORMATION_SCHEMA.ENGINES 54WHERE engine = 'innodb' 55AND support IN ('YES', 'DEFAULT', 'ENABLED'); 56ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 57FOUND 2 /InnoDB: Invalid log block checksum. block: 2372 checkpoint no: 1 expected: 3362026715 found: 144444122/ in mysqld.1.err 58FOUND 2 /InnoDB: Missing MLOG_CHECKPOINT between the checkpoint 1213964 and the end 1213952\./ in mysqld.1.err 59# --innodb-force-recovery=6 (skip the entire redo log) 60SELECT * FROM INFORMATION_SCHEMA.ENGINES 61WHERE engine = 'innodb' 62AND support IN ('YES', 'DEFAULT', 'ENABLED'); 63ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 64InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES 65FOUND 1 /\[Note\] InnoDB: .* started; log sequence number 0/ in mysqld.1.err 66# valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2, invalid block number 67SELECT * FROM INFORMATION_SCHEMA.ENGINES 68WHERE engine = 'innodb' 69AND support IN ('YES', 'DEFAULT', 'ENABLED'); 70ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 71# --innodb-force-recovery=6 (skip the entire redo log) 72SELECT * FROM INFORMATION_SCHEMA.ENGINES 73WHERE engine = 'innodb' 74AND support IN ('YES', 'DEFAULT', 'ENABLED'); 75ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 76InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES 77# Test a corrupted MLOG_FILE_NAME record. 78# valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2 79SELECT * FROM INFORMATION_SCHEMA.ENGINES 80WHERE engine = 'innodb' 81AND support IN ('YES', 'DEFAULT', 'ENABLED'); 82ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 83FOUND 1 /InnoDB: Starting crash recovery from checkpoint LSN=1213964/ in mysqld.1.err 84FOUND 1 /InnoDB: MLOG_FILE_NAME incorrect:bogus/ in mysqld.1.err 85FOUND 1 /InnoDB: ############### CORRUPT LOG RECORD FOUND ##################/ in mysqld.1.err 86FOUND 1 /InnoDB: Log record type 55, page 151:488\. Log parsing proceeded successfully up to 1213973\. Previous log record type 56, is multi 0 Recv offset 9, prev 0/ in mysqld.1.err 87FOUND 1 /len 22. hex 38000000000012860cb7809781e80006626f67757300. asc 8 bogus / in mysqld.1.err 88FOUND 1 /InnoDB: Set innodb_force_recovery to ignore this error/ in mysqld.1.err 89# Test a corrupted MLOG_FILE_NAME record. 90# valid header, invalid checkpoint 1, valid checkpoint 2, invalid block 91SELECT * FROM INFORMATION_SCHEMA.ENGINES 92WHERE engine = 'innodb' 93AND support IN ('YES', 'DEFAULT', 'ENABLED'); 94ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 95FOUND 1 /InnoDB: Invalid log block checksum. block: 2372 checkpoint no: 1 expected: 2454333373 found: 150151/ in mysqld.1.err 96# valid header, invalid checkpoint 1, valid checkpoint 2, invalid log record 97SELECT * FROM INFORMATION_SCHEMA.ENGINES 98WHERE engine = 'innodb' 99AND support IN ('YES', 'DEFAULT', 'ENABLED'); 100ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 101FOUND 1 /InnoDB: MLOG_FILE_NAME incorrect:bigot/ in mysqld.1.err 102FOUND 1 /len 22; hex 38000000000012860cb7809781e800066269676f7400; asc 8 bigot ;/ in mysqld.1.err 103# 10.2 missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT 104SELECT * FROM INFORMATION_SCHEMA.ENGINES 105WHERE engine = 'innodb' 106AND support IN ('YES', 'DEFAULT', 'ENABLED'); 107ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 108FOUND 1 /InnoDB: Missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT for tablespace 42/ in mysqld.1.err 109# 10.3 missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT 110SELECT * FROM INFORMATION_SCHEMA.ENGINES 111WHERE engine = 'innodb' 112AND support IN ('YES', 'DEFAULT', 'ENABLED'); 113ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 114FOUND 2 /InnoDB: Missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT for tablespace 42/ in mysqld.1.err 115# Empty 10.3 redo log 116SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES 117WHERE engine = 'innodb' 118AND support IN ('YES', 'DEFAULT', 'ENABLED'); 119COUNT(*) 1201 121FOUND 1 /InnoDB: .* started; log sequence number 121397[09]/ in mysqld.1.err 122# Empty 10.2 redo log 123SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES 124WHERE engine = 'innodb' 125AND support IN ('YES', 'DEFAULT', 'ENABLED'); 126COUNT(*) 1271 128FOUND 3 /InnoDB: Upgrading redo log:/ in mysqld.1.err 129# Minimal MariaDB 10.1.21 encrypted redo log 130SELECT * FROM INFORMATION_SCHEMA.ENGINES 131WHERE engine = 'innodb' 132AND support IN ('YES', 'DEFAULT', 'ENABLED'); 133ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS 134FOUND 1 /InnoDB: Obtaining redo log encryption key version 1 failed/ in mysqld.1.err 135FOUND 1 /InnoDB: Decrypting checkpoint failed/ in mysqld.1.err 136ib_buffer_pool 137ib_logfile0 138ib_logfile1 139ibdata1 140