summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/purge_thread_shutdown.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/r/purge_thread_shutdown.result')
-rw-r--r--mysql-test/suite/innodb/r/purge_thread_shutdown.result27
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/purge_thread_shutdown.result b/mysql-test/suite/innodb/r/purge_thread_shutdown.result
new file mode 100644
index 00000000..85ac77e6
--- /dev/null
+++ b/mysql-test/suite/innodb/r/purge_thread_shutdown.result
@@ -0,0 +1,27 @@
+connect con1, localhost, root;
+create table t1 (a int) engine=innodb;
+insert t1 values (1),(2),(3),(4);
+delete from t1 where a=1;
+select user,state from information_schema.processlist order by 2;
+user state
+root
+root Filling schema table
+set global debug_dbug='+d,only_kill_system_threads';
+set global innodb_fast_shutdown=0;
+shutdown;
+connection default;
+disconnect con1;
+select user,state from information_schema.processlist order by 2;
+user state
+root Filling schema table
+set global innodb_fast_shutdown=1;
+select user,state from information_schema.processlist order by 2;
+user state
+root Filling schema table
+delete from t1 where a=3;
+set global innodb_fast_shutdown=0;
+ERROR 42000: Variable 'innodb_fast_shutdown' can't be set to the value of '0'
+kill ID;
+ERROR 70100: Connection was killed
+# restart
+drop table t1;