Debian Codegraph @

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

raw
1 call mtr.add_suppression("Unable to use user mysql.session account when connecting the server for internal plugin requests");
2 call mtr.add_suppression("Failed to find tablespace for table .* in the cache. Attempting to load the tablespace with space id");
3 create table t1(f1 int not null, f2 int not null, index idx(f2))engine=innodb;
4 create table t2(f1 int not null, f2 int not null, index idx(f2))engine=innodb;
5 insert into t1 values(1, 2);
6 insert into t2 values(1, 2);
7 SET GLOBAL innodb_fast_shutdown = 0;
8 # restart: --innodb-force-recovery=4
9 select * from t1;
10 f1 f2
11 1 2
12 insert into t1 values(2, 3);
13 ERROR HY000: Table 't1' is read only
14 alter table t1 add f3 int not null, algorithm=copy;
15 ERROR HY000: InnoDB is in read only mode.
16 alter table t1 add f3 int not null, algorithm=inplace;
17 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
18 drop index idx on t1;
19 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
20 update t1 set f1=3 where f2=2;
21 ERROR HY000: Table 't1' is read only
22 create table t3(f1 int not null)engine=innodb;
23 ERROR HY000: Running in read-only mode
24 drop table t3;
25 ERROR 42S02: Unknown table 'test.t3'
26 rename table t1 to t3;
27 ERROR HY000: Error on rename of './test/t1' to './test/t3' (errno: 165 - Table is read only)
28 truncate table t1;
29 ERROR HY000: Table 't1' is read only
30 create tablespace t4 add datafile 't1.ibd' Engine=InnoDB;
31 ERROR HY000: Running in read-only mode
32 # restart
33 drop table t1;
34 show tables;
35 Tables_in_test
36 t2
37 # Restart the server with innodb_force_recovery as 5.
38 # restart: --innodb-force-recovery=5
39 select * from t2;
40 f1 f2
41 1 2
42 insert into t2 values(2, 3);
43 ERROR HY000: Table 't2' is read only
44 alter table t2 add f3 int not null, algorithm=copy;
45 ERROR HY000: InnoDB is in read only mode.
46 alter table t2 add f3 int not null, algorithm=inplace;
47 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
48 drop index idx on t2;
49 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
50 update t2 set f1=3 where f2=2;
51 ERROR HY000: Table 't2' is read only
52 create table t1(f1 int not null)engine=innodb;
53 ERROR HY000: Running in read-only mode
54 drop table t1;
55 ERROR 42S02: Unknown table 'test.t1'
56 rename table t2 to t3;
57 ERROR HY000: Error on rename of './test/t2' to './test/t3' (errno: 165 - Table is read only)
58 truncate table t2;
59 ERROR HY000: Table 't2' is read only
60 create tablespace t1 add datafile 't1.ibd' Engine=InnoDB;
61 ERROR HY000: Running in read-only mode
62 drop table t2;
63 ERROR HY000: Storage engine can't drop table 'test.t2'
64 show tables;
65 Tables_in_test
66 t2
67 # Restart the server with innodb_force_recovery as 6.
68 # restart: --innodb-force-recovery=6
69 select * from t2;
70 f1 f2
71 1 2
72 insert into t2 values(2, 3);
73 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
74 alter table t2 add f3 int not null, algorithm=copy;
75 ERROR HY000: InnoDB is in read only mode.
76 alter table t2 add f3 int not null, algorithm=inplace;
77 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
78 drop index idx on t2;
79 ERROR HY000: Operation not allowed when innodb_force_recovery > 0.
80 update t2 set f1=3 where f2=2;
81 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
82 create table t1(f1 int not null)engine=innodb;
83 ERROR HY000: Running in read-only mode
84 drop table t1;
85 ERROR 42S02: Unknown table 'test.t1'
86 rename table t2 to t3;
87 ERROR HY000: Error on rename of './test/t2' to './test/t3' (errno: 165 - Table is read only)
88 truncate table t2;
89 ERROR HY000: Table 't2' is read only
90 create tablespace t1 add datafile 't1.ibd' Engine=InnoDB;
91 ERROR HY000: Running in read-only mode
92 drop table t2;
93 ERROR HY000: Storage engine can't drop table 'test.t2'
94 show tables;
95 Tables_in_test
96 t2
97 # restart
98 drop table t2;
99 show tables;
100 Tables_in_test