mirror of
https://github.com/MariaDB/server.git
synced 2025-04-17 20:55:45 +02:00
900bbbe4a8
When the first attempt of XA ROLLBACK is expected to fail, some recovered changes could be written back through the doublewrite buffer. Should that happen, the next recovery attempt (after mangling the data file t1.ibd further) could fail because no copy of the affected pages would be available in the doublewrite buffer. To prevent this from happening, ensure that the doublewrite buffer will not be used and no log checkpoint occurs during the previous failed recovery attempt. Also, let a successful XA ROLLBACK serve the additional purpose of freeing a BLOB page and therefore rewriting page 0, which we must then be able to recover despite induced corruption. In the last restart step, we will tolerate an unexpected checkpoint, because one is frequently occurring on FreeBSD and AIX, despite our efforts to force a buffer pool flush before each "no checkpoint" section.
56 lines
1.5 KiB
Text
56 lines
1.5 KiB
Text
#
|
|
# MDEV-32242 innodb.doublewrite test case always is skipped
|
|
#
|
|
create table t1 (f1 int primary key, f2 blob) stats_persistent=0, engine=innodb;
|
|
start transaction;
|
|
insert into t1 values(1, repeat('#',12));
|
|
insert into t1 values(2, repeat('+',12));
|
|
insert into t1 values(3, repeat('/',12));
|
|
insert into t1 values(4, repeat('-',12));
|
|
insert into t1 values(5, repeat('.',12));
|
|
commit work;
|
|
SET GLOBAL innodb_fast_shutdown = 0;
|
|
# restart
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0,innodb_max_dirty_pages_pct=0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=99;
|
|
connect dml,localhost,root,,;
|
|
XA START 'x';
|
|
insert into t1 values(6, repeat('%', @@innodb_page_size/2));
|
|
XA END 'x';
|
|
XA PREPARE 'x';
|
|
disconnect dml;
|
|
connection default;
|
|
flush table t1 for export;
|
|
# Kill the server
|
|
# restart
|
|
FOUND 1 /InnoDB: Recovered page \[page id: space=[1-9][0-9]*, page number=0\]/ in mysqld.1.err
|
|
# restart
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
select f1, f2 from t1;
|
|
f1 f2
|
|
1 ############
|
|
2 ++++++++++++
|
|
3 ////////////
|
|
4 ------------
|
|
5 ............
|
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0,innodb_max_dirty_pages_pct=0;
|
|
SET GLOBAL innodb_max_dirty_pages_pct=99;
|
|
XA ROLLBACK 'x';
|
|
FLUSH TABLE t1 FOR EXPORT;
|
|
# Kill the server
|
|
# restart
|
|
FOUND 4 /InnoDB: Recovered page \[page id: space=[1-9][0-9]*, page number=[03]\]/ in mysqld.1.err
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
select f1, f2 from t1;
|
|
f1 f2
|
|
1 ############
|
|
2 ++++++++++++
|
|
3 ////////////
|
|
4 ------------
|
|
5 ............
|
|
drop table t1;
|
|
# End of 10.5 tests
|