| 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 |