Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.2.44
-
None
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-15325 Incomplete validation of missing tablespace during recovery
-
- Closed
-