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

perfschema.bad_option_3 fails with timeout : innodb hangs on shutdown, waiting for thd_destructor_proxy

    XMLWordPrintable

Details

    Description

      can be seen e.g in
      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/16348/steps/mtr_nm/logs/stdio

      "shutdown" thread waits for thd_destructor_thread

      #4  0x00007ff8577e598d in pthread_join () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5  0x000055e84b65e776 in innobase_end () at /home/buildbot/buildbot/build/mariadb-10.4.2/storage/innobase/handler/ha_innodb.cc:4350
      #6  0x000055e84b416004 in ha_finalize_handlerton (plugin=0x55e84df93a98) at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/handler.cc:462
      #7  0x000055e84b231f84 in plugin_deinitialize (plugin=0x55e84df93a98, ref_check=ref_check@entry=true) at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/sql_plugin.cc:1240
      #8  0x000055e84b236cae in reap_plugins () at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/sql_plugin.cc:1316
      #9  0x000055e84b237d15 in plugin_shutdown () at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/sql_plugin.cc:1982
      #10 0x000055e84b163f68 in clean_up (print_message=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/mysqld.cc:2140
      #11 0x000055e84b166536 in clean_up (print_message=<optimized out>) at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/mysqld.cc:8223
      #12 unireg_abort (exit_code=2) at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/mysqld.cc:2052
      #13 0x000055e84b168d24 in init_server_components () at /home/buildbot/buildbot/build/mariadb-10.4.2/sql/mysqld.cc:5382
      

      correspondng code

      		if (!srv_read_only_mode) {
      			pthread_join(thd_destructor_thread, NULL);
      		}
      
      

      thd_destructor_thread at the same time waits for a condition

      Thread 8 (Thread 0x7ff8157fa700 (LWP 27940)):
      #0  0x00007ff8577ea360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
      #1  0x000055e84b65ea43 in inline_mysql_cond_wait (src_file=0x55e84bb376e0 "/home/buildbot/buildbot/build/mariadb-10.4.2/storage/innobase/handler/ha_innodb.cc", src_line=303, mutex=0x7ff8157f9cf0, that=0x7ff8157f9d20) at /home/buildbot/buildbot/build/mariadb-10.4.2/include/mysql/psi/mysql_thread.h:1178
      #2  thd_destructor_proxy () at /home/buildbot/buildbot/build/mariadb-10.4.2/storage/innobase/handler/ha_innodb.cc:303
      #3  0x00007ff8577e46ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #4  0x00007ff856e8f82d in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      corresponding code

      	/* wait until the server wakes the THD to abort and die */
      	while (!myvar->abort)
      		mysql_cond_wait(&thd_destructor_cond, &thd_destructor_mutex);
      

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.