Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug-13628249.result

raw
1 # Restart the server in force recovery mode (2)
2 # restart: --innodb-force-recovery=2
3 SELECT @@innodb_force_recovery;
4 @@innodb_force_recovery
5 2
6 # Restart server in normal mode
7 # restart
8 SELECT @@innodb_force_recovery;
9 @@innodb_force_recovery
10 0
11 CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=0;
12 BEGIN;
13 INSERT INTO t1 VALUES(1), (2), (3), (4);
14 CREATE TABLE t2(c2 INT PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=0;
15 DROP TABLE t2;
16 # Restart the server in force recovery mode (3)
17 # Kill and restart: --innodb-force-recovery=3
18 SELECT @@innodb_force_recovery;
19 @@innodb_force_recovery
20 3
21 SELECT COUNT(*) IN (0,4) yes FROM t1;
22 yes
23 1
24 # Restart the server in force recovery mode (5)
25 # restart: --innodb-force-recovery=5
26 SELECT @@innodb_force_recovery;
27 @@innodb_force_recovery
28 5
29 SELECT COUNT(*) IN (0,4) yes FROM t1;
30 yes
31 1
32 # Restart server in normal mode
33 # restart
34 SELECT @@innodb_force_recovery;
35 @@innodb_force_recovery
36 0
37 SELECT COUNT(*) IN (0,4) yes FROM t1;
38 yes
39 1
40 DROP TABLE t1;