summaryrefslogtreecommitdiff
path: root/mysql-test/suite/maria/maria-recovery-bitmap.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/maria/maria-recovery-bitmap.result')
-rw-r--r--mysql-test/suite/maria/maria-recovery-bitmap.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-recovery-bitmap.result b/mysql-test/suite/maria/maria-recovery-bitmap.result
index e3697334239..c6d0e2cb4e1 100644
--- a/mysql-test/suite/maria/maria-recovery-bitmap.result
+++ b/mysql-test/suite/maria/maria-recovery-bitmap.result
@@ -1,17 +1,27 @@
drop database if exists mysqltest;
create database mysqltest;
+connect admin, localhost, root,,mysqltest,,;
+connection default;
use mysqltest;
+connection default;
+connection admin;
* shut down mysqld, removed logs, restarted it
+connection default;
create table t1 (a varchar(10000)) engine=aria;
* TEST of over-allocated bitmap not flushed by checkpoint
insert into t1 values ("bbbbbbb");
+connection admin;
flush table t1;
* copied t1 for comparison
+connection default;
insert into t1 values ("bbbbbbb");
delete from t1 limit 1;
+connect extra, localhost, root,,mysqltest,,;
set session debug_dbug="+d,info,enter,exit,maria_over_alloc_bitmap";
insert into t1 values ("aaaaaaaaa");
+connection admin;
set global aria_checkpoint_interval=1;
+connection admin;
SET SESSION debug_dbug="+d,maria_crash";
* crashing mysqld intentionally
set global aria_checkpoint_interval=1;
@@ -23,12 +33,17 @@ mysqltest.t1 check status OK
* testing that checksum after recovery is as expected
Checksum-check
ok
+connection default;
use mysqltest;
+connection default;
* TEST of bitmap flushed without REDO-UNDO in the log (WAL violation)
+connection admin;
flush table t1;
* copied t1 for comparison
+connection default;
lock tables t1 write;
insert into t1 values (REPEAT('a', 6000));
+connection admin;
SET SESSION debug_dbug="+d,maria_flush_bitmap,maria_crash";
* crashing mysqld intentionally
set global aria_checkpoint_interval=1;
@@ -40,6 +55,7 @@ mysqltest.t1 check status OK
* testing that checksum after recovery is as expected
Checksum-check
ok
+connection default;
use mysqltest;
drop table t1;
drop database mysqltest_for_comparison;