Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8188

Server hangs on shutdown in logs_empty_and_mark_files_at_shutdown

    XMLWordPrintable

Details

    • 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

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.