diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/purge_thread_shutdown.result')
-rw-r--r-- | mysql-test/suite/innodb/r/purge_thread_shutdown.result | 27 |
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; |