Debian Codegraph @

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

raw
1 #
2 # MDEV-32242 innodb.doublewrite test case always is skipped
3 #
4 create table t1 (f1 int primary key, f2 blob) stats_persistent=0, engine=innodb;
5 start transaction;
6 insert into t1 values(1, repeat('#',12));
7 insert into t1 values(2, repeat('+',12));
8 insert into t1 values(3, repeat('/',12));
9 insert into t1 values(4, repeat('-',12));
10 insert into t1 values(5, repeat('.',12));
11 commit work;
12 SET GLOBAL innodb_fast_shutdown = 0;
13 # restart
14 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0,innodb_max_dirty_pages_pct=0;
15 SET GLOBAL innodb_max_dirty_pages_pct=99;
16 connect dml,localhost,root,,;
17 XA START 'x';
18 insert into t1 values(6, repeat('%', @@innodb_page_size/2));
19 XA END 'x';
20 XA PREPARE 'x';
21 disconnect dml;
22 connection default;
23 flush table t1 for export;
24 # Kill the server
25 # restart
26 FOUND 1 /InnoDB: Recovered page \[page id: space=[1-9][0-9]*, page number=0\]/ in mysqld.1.err
27 # restart
28 check table t1;
29 Table Op Msg_type Msg_text
30 test.t1 check status OK
31 select f1, f2 from t1;
32 f1 f2
33 1 ############
34 2 ++++++++++++
35 3 ////////////
36 4 ------------
37 5 ............
38 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0,innodb_max_dirty_pages_pct=0;
39 SET GLOBAL innodb_max_dirty_pages_pct=99;
40 XA ROLLBACK 'x';
41 FLUSH TABLE t1 FOR EXPORT;
42 # Kill the server
43 # restart
44 FOUND 4 /InnoDB: Recovered page \[page id: space=[1-9][0-9]*, page number=[03]\]/ in mysqld.1.err
45 check table t1;
46 Table Op Msg_type Msg_text
47 test.t1 check status OK
48 select f1, f2 from t1;
49 f1 f2
50 1 ############
51 2 ++++++++++++
52 3 ////////////
53 4 ------------
54 5 ............
55 drop table t1;
56 # End of 10.5 tests