Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Critical 
- 
    Resolution: Fixed
- 
    10.6, 10.11, 11.4, 11.8, 12.2
- 
        Can result in data loss
- 
        When innodb_buffer_pool_size is not large enough to buffer all log records during crash recovery, InnoDB may fail to recover a page from the doublewrite buffer.
Description
| CURRENT_TEST: innodb.innodb-index | 
| mysqltest: At line 1115: query 'SELECT * FROM t1' failed: 1286: Unknown storage engine 'InnoDB' | 
|  | 
| The result from queries just before the failure was: | 
| < snip > | 
| insert into t1 values(1,1,2),(2,2,1); | 
| alter table t1 add n1 int not null, drop primary key, add primary key(o1,n1,o2), lock=none; | 
| drop table t1; | 
| create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb; | 
| insert into t1 values(1,1,2),(2,2,1); | 
| alter table t1 drop primary key, add primary key(o1), lock=none; | 
| drop table t1; | 
| # | 
| # MDEV-15325 Incomplete validation of missing tablespace during recovery | 
| # | 
| CREATE TABLE t1(f1 INT PRIMARY KEY)ENGINE=InnoDB; | 
| CREATE TABLE t2(f1 INT PRIMARY KEY)ENGINE=InnoDB; | 
| # Kill the server | 
| # Wrong space_id in a dirty file and a missing file | 
| SELECT * FROM INFORMATION_SCHEMA.ENGINES | 
| WHERE engine = 'innodb' | 
| AND support IN ('YES', 'DEFAULT', 'ENABLED'); | 
| ENGINE	SUPPORT	COMMENT	TRANSACTIONS	XA	SAVEPOINTS | 
| # Restore t1 and t2 | 
| SELECT * FROM t1; | 
|  | 
| More results from queries before failure can be found in /dev/shm/var/4/log/innodb-index.log | 
|  | 
|  - skipping '/dev/shm/var/4/log/innodb.innodb-index-innodb/' | 
|  | 
| Retrying test innodb.innodb-index, attempt(2/3)...
 | 
The failure appears since 2018-08-10 11:34:21 in 10.2, you may check cross-reference by making Limit 1000 and scrolling to the end (it appears to be sorted in chronological order): https://buildbot.mariadb.net/ci/reports/cross_reference#branch=&revision=&platform=&fail_name=innodb.innodb-index&fail_variant=&fail_info_full=Unknown+storage+engine&typ=&info=&dt=&limit=1000&fail_info_short=
Attachments
Issue Links
- is caused by
- 
                    MDEV-34830 LSN in the future is not being treated as serious corruption -         
- Closed
 
-         
- relates to
- 
                    MDEV-29986 Set innodb_undo_tablespaces=3 by default -         
- Closed
 
-