Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
10.2.14
Description
--source include/have_innodb.inc
|
|
create table t1 (i int) engine=InnoDB;
|
|
uninstall soname 'ha_innodb';
|
|
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
--shutdown_server 60
|
--source include/wait_until_disconnected.inc
|
|
--cat_file $MYSQLTEST_VARDIR/log/mysqld.1.err
|
|
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
--enable_reconnect
|
--source include/wait_until_connected_again.inc
|
|
drop table t1;
|
The test takes 60+ seconds (after which MTR just kills the server); and the log shows that shutdown didn't finish.
Stack trace from the running server, 10.0 commit 0880284bf |
#1 0x00007f44d6fc85db in os_thread_sleep (tm=100000) at 10.0/storage/innobase/os/os0thread.cc:261
|
#2 0x00007f44d6fad1e5 in logs_empty_and_mark_files_at_shutdown () at 10.0/storage/innobase/log/log0log.cc:3226
|
#3 0x00007f44d7093d4d in innobase_shutdown_for_mysql () at 10.0/storage/innobase/srv/srv0start.cc:2961
|
#4 0x00007f44d6f453c3 in innobase_end (hton=0x7f44d9ff2270, type=HA_PANIC_CLOSE) at 10.0/storage/innobase/handler/ha_innodb.cc:3475
|
#5 0x000000000086de63 in ha_finalize_handlerton (plugin=0x7f44d9feb7b0) at 10.0/sql/handler.cc:440
|
#6 0x0000000000690f54 in plugin_deinitialize (plugin=0x7f44d9feb7b0, ref_check=true) at 10.0/sql/sql_plugin.cc:1175
|
#7 0x000000000069131b in reap_plugins () at 10.0/sql/sql_plugin.cc:1248
|
#8 0x000000000069161d in plugin_unlock (thd=0x0, plugin=0x7f44cb8511f0) at 10.0/sql/sql_plugin.cc:1320
|
#9 0x0000000000752ebd in TABLE_SHARE::destroy (this=0x7f44cb864a88) at 10.0/sql/table.cc:429
|
#10 0x000000000075304e in free_table_share (share=0x7f44cb864a88) at 10.0/sql/table.cc:470
|
#11 0x00000000007fd854 in tdc_delete_share_from_hash (share=0x7f44cb864a88) at 10.0/sql/table_cache.cc:452
|
#12 0x00000000007fdca0 in tdc_purge (all=true) at 10.0/sql/table_cache.cc:586
|
#13 0x00000000006190ce in close_cached_tables (thd=0x0, tables=0x0, wait_for_refresh=false, timeout=31536000) at 10.0/sql/sql_base.cc:451
|
#14 0x00000000007fda55 in tdc_start_shutdown () at 10.0/sql/table_cache.cc:519
|
#15 0x00000000005bed6b in clean_up (print_message=true) at 10.0/sql/mysqld.cc:2028
|
#16 0x00000000005beb20 in unireg_end () at 10.0/sql/mysqld.cc:1936
|
#17 0x00000000005bea42 in kill_server (sig_ptr=0x0) at 10.0/sql/mysqld.cc:1864
|
#18 0x00000000005bea5f in kill_server_thread (arg=0x7f44e0648e28) at 10.0/sql/mysqld.cc:1887
|
#19 0x0000000000cd7363 in pfs_spawn_thread (arg=0x7f44cb42c0f0) at 10.0/storage/perfschema/pfs.cc:1860
|
#20 0x00007f44e0239b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#21 0x00007f44de4ef95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
Attachments
Issue Links
- relates to
-
MDEV-14648 Restore fix for MySQL BUG#39053 - UNISTALL PLUGIN does not allow the storage engine to cleanup open connections
- Closed
-
MDEV-15554 InnoDB page_cleaner shutdown sometimes hangs
- Closed