Edit File: innodb_force_recovery.result
call mtr.add_suppression('InnoDB: Failed to find tablespace for table \'".*".".*"\' in the cache'); call mtr.add_suppression('InnoDB: Allocated tablespace [0-9]+, old maximum was [0-9]+'); create table t1(f1 int not null, f2 int not null, index idx(f2))engine=innodb; create table t2(f1 int not null, f2 int not null, index idx(f2))engine=innodb; insert into t1 values(1, 2); insert into t2 values(1, 2); SET GLOBAL innodb_fast_shutdown = 0; # Stop server # Restart server. select * from t1; f1 f2 1 2 insert into t1 values(2, 3); ERROR HY000: Table 't1' is read only alter table t1 add f3 int not null, algorithm=copy; ERROR HY000: InnoDB is in read only mode. alter table t1 add f3 int not null, algorithm=inplace; ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Running in read-only mode. Try ALGORITHM=COPY. drop index idx on t1; ERROR HY000: InnoDB is in read only mode. update t1 set f1=3 where f2=2; ERROR HY000: Table 't1' is read only create table t3(f1 int not null)engine=innodb; ERROR HY000: InnoDB is in read only mode. drop table t3; ERROR 42S02: Unknown table 'test.t3' rename table t1 to t3; ERROR HY000: Error on rename of './test/t1' to './test/t3' (errno: 165 - Table is read only) truncate table t1; ERROR HY000: Table 't1' is read only drop table t1; show tables; Tables_in_test t2 # Stop server # Restart server. select * from t2; f1 f2 1 2 insert into t2 values(2, 3); ERROR HY000: Table 't2' is read only alter table t2 add f3 int not null, algorithm=copy; ERROR HY000: InnoDB is in read only mode. alter table t2 add f3 int not null, algorithm=inplace; ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Running in read-only mode. Try ALGORITHM=COPY. drop index idx on t2; ERROR HY000: InnoDB is in read only mode. update t2 set f1=3 where f2=2; ERROR HY000: Table 't2' is read only create table t4(f1 int not null)engine=innodb; ERROR HY000: InnoDB is in read only mode. drop table t4; ERROR 42S02: Unknown table 'test.t4' rename table t2 to t3; ERROR HY000: Error on rename of './test/t2' to './test/t3' (errno: 165 - Table is read only) truncate table t2; ERROR HY000: Table 't2' is read only drop table t2; ERROR 42S02: Unknown table 'test.t2' show tables; Tables_in_test t2 # Stop server # Restart server. select * from t2; f1 f2 1 2 insert into t2 values(2, 3); ERROR HY000: Can't lock file (errno: 165 - Table is read only) alter table t2 add f3 int not null, algorithm=copy; ERROR HY000: Can't lock file (errno: 165 - Table is read only) alter table t2 add f3 int not null, algorithm=inplace; ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Running in read-only mode. Try ALGORITHM=COPY. drop index idx on t2; ERROR HY000: Can't lock file (errno: 165 - Table is read only) update t2 set f1=3 where f2=2; ERROR HY000: Can't lock file (errno: 165 - Table is read only) create table t4(f1 int not null)engine=innodb; ERROR HY000: InnoDB is in read only mode. drop table t4; ERROR 42S02: Unknown table 'test.t4' rename table t2 to t3; ERROR HY000: Error on rename of './test/t2' to './test/t3' (errno: 165 - Table is read only) truncate table t2; ERROR HY000: Table 't2' is read only drop table t2; ERROR 42S02: Unknown table 'test.t2' show tables; Tables_in_test t2 # Stop server # Restart server. drop table t2; show tables; Tables_in_test