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

main.show_check fails sporadically

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      Test failure:

      @@ -1562,12 +1562,30 @@
       connection default;
       SHOW PROCESSLIST;
       Id	User	Host	db	Command	Time	State	Info	Progress
      +###	root	###	NULL	Killed	###	###	NULL	0.000
       ###	root	###	test	Query	###	###	SHOW PROCESSLIST	0.000
      +###	mysqltest_1	###	mysqltest	Killed	###	###	NULL	0.000
      +###	mysqltest_2	###	NULL	Killed	###	###	NULL	0.000
      +###	mysqltest_3	###	NULL	Killed	###	###	NULL	0.000
      +###	mysqltest_4	###	mysqltest	Killed	###	###	NULL	0.000
      +###	test_u	###	NULL	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
       ###	root	###	test	Query	###	###	SELECT GET_LOCK('t',1000) AS 'óóóó'	0.000
       SET NAMES utf8;
       SHOW PROCESSLIST;
       Id	User	Host	db	Command	Time	State	Info	Progress
      +###	root	###	NULL	Killed	###	###	NULL	0.000
       ###	root	###	test	Query	###	###	SHOW PROCESSLIST	0.000
      +###	mysqltest_1	###	mysqltest	Killed	###	###	NULL	0.000
      +###	mysqltest_2	###	NULL	Killed	###	###	NULL	0.000
      +###	mysqltest_3	###	NULL	Killed	###	###	NULL	0.000
      +###	mysqltest_4	###	mysqltest	Killed	###	###	NULL	0.000
      +###	test_u	###	NULL	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
      +###	root	###	test	Killed	###	###	NULL	0.000
       ###	root	###	test	Query	###	###	SELECT GET_LOCK('t',1000) AS 'óóóó'	0.000
       SELECT RELEASE_LOCK('t');
       RELEASE_LOCK('t')
      

      Reproducible with:

      diff --git a/sql/sql_connect.cc b/sql/sql_connect.cc
      index c279f2663c8..c227fee943e 100644
      --- a/sql/sql_connect.cc
      +++ b/sql/sql_connect.cc
      @@ -1483,6 +1483,7 @@ void do_handle_one_connection(CONNECT *connect, bool put_in_cache)
           if (thd->userstat_running)
             update_global_user_stats(thd, create_user, time(NULL));
       
      +    sleep(1);
           unlink_thd(thd);
           if (IF_WSREP(thd->wsrep_applier, false) || !put_in_cache ||
               !(connect= thread_cache.park()))
      

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: