Debian Codegraph @

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

raw
1 #
2 # Bug #17335427 INNODB CAN NOT USE THE DOUBLEWRITE BUFFER PROPERLY
3 # Bug #18144349 INNODB CANNOT USE THE DOUBLEWRITE BUFFER FOR THE FIRST
4 # PAGE OF SYSTEM TABLESPACE
5 #
6 show variables like 'innodb_doublewrite';
7 Variable_name Value
8 innodb_doublewrite ON
9 show variables like 'innodb_fil_make_page_dirty_debug';
10 Variable_name Value
11 innodb_fil_make_page_dirty_debug 0
12 show variables like 'innodb_saved_page_number_debug';
13 Variable_name Value
14 innodb_saved_page_number_debug 0
15 create table t1 (f1 int primary key, f2 blob) engine=innodb stats_persistent=0;
16 start transaction;
17 insert into t1 values(1, repeat('#',12));
18 insert into t1 values(2, repeat('+',12));
19 insert into t1 values(3, repeat('/',12));
20 insert into t1 values(4, repeat('-',12));
21 insert into t1 values(5, repeat('.',12));
22 commit work;
23 # Test Begin: Test if recovery works if 1st page and 2nd page
24 # of system tablespace is full of zeroes.
25 SET GLOBAL innodb_fast_shutdown = 0;
26 # restart: --debug_dbug=+d,ib_log_checkpoint_avoid_hard --innodb_flush_sync=0
27 begin;
28 insert into t1 values (6, repeat('%', 400));
29 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0, innodb_max_dirty_pages_pct=0;
30 # Make the first page dirty for system tablespace
31 set global innodb_saved_page_number_debug = 0;
32 set global innodb_fil_make_page_dirty_debug = 0;
33 # Make the second page dirty for system tablespace
34 set global innodb_saved_page_number_debug = 1;
35 set global innodb_fil_make_page_dirty_debug = 0;
36 # Kill the server
37 # Make the 1st page (page_no=0) and 2nd page (page_no=1)
38 # of the system tablespace all zeroes.
39 # restart
40 FOUND 1 /InnoDB: Recovered page \[page id: space=0, page number=0\]/ in mysqld.1.err
41 FOUND 1 /InnoDB: Recovered page \[page id: space=0, page number=1\]/ in mysqld.1.err
42 check table t1;
43 Table Op Msg_type Msg_text
44 test.t1 check status OK
45 select f1, f2 from t1;
46 f1 f2
47 1 ############
48 2 ++++++++++++
49 3 ////////////
50 4 ------------
51 5 ............
52 # Test End
53 # ---------------------------------------------------------------
54 # Test Begin: Test if recovery works if 1st page of
55 # system tablespace is corrupted and 2nd page as corrupted.
56 # restart: --debug_dbug=+d,ib_log_checkpoint_avoid_hard --innodb_flush_sync=0
57 begin;
58 insert into t1 values (6, repeat('%', 400));
59 # Make the first page dirty for system tablespace
60 set global innodb_saved_page_number_debug = 0;
61 set global innodb_fil_make_page_dirty_debug = 0;
62 # Make the second page dirty for system tablespace
63 set global innodb_saved_page_number_debug = 1;
64 set global innodb_fil_make_page_dirty_debug = 0;
65 set global innodb_buf_flush_list_now = 1;
66 # Kill the server
67 # Corrupt the 1st page (page_no=0) and 2nd page of the system tablespace.
68 # restart
69 FOUND 2 /InnoDB: Recovered page \[page id: space=0, page number=0\]/ in mysqld.1.err
70 FOUND 2 /InnoDB: Recovered page \[page id: space=0, page number=1\]/ in mysqld.1.err
71 check table t1;
72 Table Op Msg_type Msg_text
73 test.t1 check status OK
74 select f1, f2 from t1;
75 f1 f2
76 1 ############
77 2 ++++++++++++
78 3 ////////////
79 4 ------------
80 5 ............
81 drop table t1;
82 # Test End
83 # ---------------------------------------------------------------
84 #
85 # MDEV-12600 crash during install_db with innodb_page_size=32K
86 # and ibdata1=3M
87 #
88 # restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/doublewrite --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/doublewrite --innodb-undo-tablespaces=0 --innodb-data-file-path=ibdata1:1M;ibdata2:1M:autoextend
89 SELECT * FROM INFORMATION_SCHEMA.ENGINES
90 WHERE engine = 'innodb'
91 AND support IN ('YES', 'DEFAULT', 'ENABLED');
92 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
93 FOUND 1 /\[ERROR\] InnoDB: Cannot create doublewrite buffer/ in mysqld.1.err
94 # restart