summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2019-09-26 12:44:04 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2019-09-26 13:03:40 +0300
commit23d675453f182becb3bc5811bfa7e2e310cbed1d (patch)
treef06531bd6dc31dfaec6cadc064b6dc4c59b4c610
parent574ff87f2ae6fd284ddb27c00d35c0431bb7219a (diff)
downloadmariadb-git-23d675453f182becb3bc5811bfa7e2e310cbed1d.tar.gz
MDEV-20675 Crash in SHOW ENGINE INNODB STATUS with innodb_force_recovery=5
Add a test case. MariaDB Server 10.2 is not affected.
-rw-r--r--mysql-test/suite/innodb/t/innodb_force_recovery.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_force_recovery.test b/mysql-test/suite/innodb/t/innodb_force_recovery.test
index b5b48281161..9d7cf9d80b7 100644
--- a/mysql-test/suite/innodb/t/innodb_force_recovery.test
+++ b/mysql-test/suite/innodb/t/innodb_force_recovery.test
@@ -19,6 +19,7 @@ SET GLOBAL innodb_fast_shutdown = 0;
--echo # Restart the server with innodb_force_recovery as 4.
--let $restart_parameters= --innodb-force-recovery=4
--source include/restart_mysqld.inc
+let $status=`SHOW ENGINE INNODB STATUS`;
select * from t1;
@@ -58,6 +59,7 @@ show tables;
--echo # Restart the server with innodb_force_recovery as 5.
--let $restart_parameters= --innodb-force-recovery=5
--source include/restart_mysqld.inc
+let $status=`SHOW ENGINE INNODB STATUS`;
select * from t2;
@@ -98,6 +100,7 @@ show tables;
--echo # Restart the server with innodb_force_recovery as 6.
--let $restart_parameters= --innodb-force-recovery=6
--source include/restart_mysqld.inc
+let $status=`SHOW ENGINE INNODB STATUS`;
select * from t2;
@@ -135,6 +138,7 @@ show tables;
--echo # Restart the server with innodb_force_recovery=2
--let $restart_parameters= --innodb-force-recovery=2
--source include/restart_mysqld.inc
+let $status=`SHOW ENGINE INNODB STATUS`;
select * from t2;
begin;
@@ -152,6 +156,7 @@ connection default;
--echo # Restart the server with innodb_force_recovery=3
--let $restart_parameters= --innodb-force-recovery=3
--source include/start_mysqld.inc
+let $status=`SHOW ENGINE INNODB STATUS`;
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
select * from t2;