Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: Header page consists of zero bytes in datafile:");
2 FLUSH TABLES;
3 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
4 # restart
5 CREATE TABLE t3(a INT PRIMARY KEY) ENGINE=InnoDB;
6 BEGIN;
7 INSERT INTO t3 VALUES (33101),(347);
8 INSERT INTO t1 VALUES (42),(9),(101);
9 RENAME TABLE t1 TO t2;
10 UPDATE t2 SET a=347 where a=42;
11 COMMIT;
12 # Kill the server
13 # Fault 0 (no real fault): Orphan file with duplicate space_id.
14 # Fault 1: Two dirty files with the same space_id.
15 # restart
16 SELECT * FROM INFORMATION_SCHEMA.ENGINES
17 WHERE engine = 'innodb'
18 AND support IN ('YES', 'DEFAULT', 'ENABLED');
19 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
20 FOUND 1 /InnoDB: Ignoring data file '.*t2.ibd' with space ID \d+. Another data file called .*t1.ibd exists with the same space ID/ in mysqld.1.err
21 # Fault 4: Missing data file
22 # restart
23 SELECT * FROM INFORMATION_SCHEMA.ENGINES
24 WHERE engine = 'innodb'
25 AND support IN ('YES', 'DEFAULT', 'ENABLED');
26 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
27 FOUND 1 /InnoDB: Tablespace \d+ was not found at .*t[12].ibd.
28 .*InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace/ in mysqld.1.err
29 # Fault 5: Wrong type of data file
30 # restart
31 SELECT * FROM INFORMATION_SCHEMA.ENGINES
32 WHERE engine = 'innodb'
33 AND support IN ('YES', 'DEFAULT', 'ENABLED');
34 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
35 # restart
36 SELECT * FROM INFORMATION_SCHEMA.ENGINES
37 WHERE engine = 'innodb'
38 AND support IN ('YES', 'DEFAULT', 'ENABLED');
39 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
40 NOT FOUND /\[Note\] InnoDB: Cannot read first page of .*t2.ibd/ in mysqld.1.err
41 FOUND 1 /.*\[ERROR\] InnoDB: Cannot apply log to \[page id: space=[1-9][0-9]*, page number=3\] of corrupted file './test/t2\.ibd'/ in mysqld.1.err
42 # Fault 2: Wrong space_id in a dirty file, and a missing file.
43 # restart
44 SELECT * FROM t2;
45 a
46 9
47 101
48 347
49 SELECT * FROM t3;
50 a
51 347
52 33101
53 SHOW TABLES;
54 Tables_in_test
55 t2
56 t3
57 DROP TABLE t2,t3;
58 CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
59 ERROR HY000: Can't create table `test`.`t0` (errno: 184 "Tablespace already exists")
60 CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
61 ERROR HY000: Can't create table `test`.`t0` (errno: 184 "Tablespace already exists")
62 CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
63 DROP TABLE t0;
64 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
65 ERROR HY000: Can't create table `test`.`t1` (errno: 184 "Tablespace already exists")
66 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
67 ERROR HY000: Can't create table `test`.`t1` (errno: 184 "Tablespace already exists")
68 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
69 DROP TABLE t1;
70 SET GLOBAL innodb_max_purge_lag_wait=0;
71 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
72 SET GLOBAL innodb_max_dirty_pages_pct=0.0;
73 SET GLOBAL innodb_max_dirty_pages_pct=90.0;
74 CREATE TABLE u1(a INT PRIMARY KEY) ENGINE=InnoDB;
75 CREATE TABLE u2(a INT PRIMARY KEY) ENGINE=InnoDB;
76 CREATE TABLE u3(a INT PRIMARY KEY) ENGINE=InnoDB;
77 CREATE TABLE u4(a INT PRIMARY KEY) ENGINE=InnoDB;
78 INSERT INTO u4 VALUES(1);
79 RENAME TABLE u4 TO u5;
80 RENAME TABLE u5 TO u6;
81 INSERT INTO u6 VALUES(2);
82 # Kill the server
83 # Fault 6: All-zero data file and innodb_force_recovery
84 # restart: --innodb-force-recovery=1
85 DROP TABLE u1,u2,u3,u6;
86 # List of files:
87 db.opt
88 SHOW TABLES;
89 Tables_in_test