Debian Codegraph @

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

raw
1 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
2 # Kill the server
3 # Fault 1: Extra file in innodb_data_file_path
4 SHOW TABLES;
5 Tables_in_test
6 t1
7 # Recovery and clean shutdown with old data file path
8 Pattern "\[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option'" found
9 # Start with new data file path
10 INSERT INTO t1 VALUES (1);
11 # Kill the server
12 # Fault 2: Missing file in innodb_data_file_path
13 SHOW TABLES;
14 Tables_in_test
15 t1
16 # Recovery and shutdown with innodb-force-recovery (ignore unknown file)
17 Pattern "\[ERROR\] \[[^]]*\] \[[^]]*\] unknown option '--innodb-nonexistent-option'" found
18 # Cleanup
19 # No log should be generated while persistent tablespaces are idle
20 # FIXME: Something occasionally violates this (log_write_requests=1)
21 CREATE TEMPORARY TABLE t (a SERIAL) ENGINE=InnoDB;
22 SELECT * FROM t1;
23 a
24 1
25 DROP TABLE t1;
26 SELECT count>0 FROM information_schema.innodb_metrics
27 WHERE name='log_write_requests';
28 count>0
29 1
30 # restart
31 #
32 # Bug#33508534: ADDITION OF A NEW DATAFILE TO SYSTEM TABLESPACE IS NOT
33 # REFLECTED IN I_S.FILES
34 #
35 SELECT @@innodb_data_file_path;
36 @@innodb_data_file_path
37 ibdata1:12M:autoextend
38 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
39 WHERE TABLESPACE_NAME='innodb_system';
40 FILE_NAME
41 ./ibdata1
42 # restart: --datadir=MYSQLTEST_VARDIR/tmp/mydatadir --log-error=MYSQLD_LOG --innodb-data-file-path=ibdata1:12M;ibdata2:12M:autoextend
43 SELECT @@innodb_data_file_path;
44 @@innodb_data_file_path
45 ibdata1:12M;ibdata2:12M:autoextend
46 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
47 WHERE TABLESPACE_NAME='innodb_system';
48 FILE_NAME
49 ./ibdata1
50 ./ibdata2
51 Pattern "\[ERROR\] .* File .*foo: 'open' returned OS error 71. Cannot continue operation" found
52 # restart: