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

funcs_1.processlist_priv_no_prot fails sporadically

    Details

      Description

      Fails in buildbot: http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/5507/steps/test_6/logs/stdio

      Failures are like:

      CURRENT_TEST: funcs_1.processlist_priv_no_prot
      --- /home/svoj/devel/maria/mariadb/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.result	2016-06-29 19:09:37.754916088 +0400
      +++ /home/svoj/devel/maria/mariadb/mysql-test/suite/funcs_1/r/processlist_priv_no_prot.reject	2016-06-30 12:08:12.884297174 +0400
      @@ -38,15 +38,15 @@
       SHOW processlist;
       Id	User	Host	db	Command	Time	State	Info	Progress
       ID	root	HOST_NAME	information_schema	Query	TIME	NULL	SHOW processlist	TIME_MS
      -ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME		NULL	TIME_MS
      +ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME	NULL	NULL	TIME_MS
       SELECT * FROM processlist  ORDER BY id;
       ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO	TIME_MS	STAGE	MAX_STAGE	PROGRESS
       ID	root	HOST_NAME	information_schema	Query	TIME	Filling schema table	SELECT * FROM processlist  ORDER BY id	TIME_MS	0	0	0.000
      -ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME		NULL	TIME_MS	0	0	0.000
      +ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME	NULL	NULL	TIME_MS	0	0	0.000
       SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS FROM processlist  ORDER BY id;
       ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO	TIME_MS	STAGE	MAX_STAGE	PROGRESS
       ID	root	HOST_NAME	information_schema	Query	TIME	Filling schema table	SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS, STAGE, MAX_STAGE, PROGRESS FROM processlist  ORDER BY id	TIME_MS	0	0	0.000
      -ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME		NULL	TIME_MS	0	0	0.000
      +ID	ddicttestuser1	HOST_NAME	information_schema	Sleep	TIME	NULL	NULL	TIME_MS	0	0	0.000
       CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
       UPDATE test.t_processlist SET user='horst' WHERE id=1  ;
       INSERT INTO processlist SELECT * FROM test.t_processlist;
      

      Easily reproducible with the following patch:

      diff --git a/sql/sql_connect.cc b/sql/sql_connect.cc
      index 61f8b40..15ff8d4 100644
      --- a/sql/sql_connect.cc
      +++ b/sql/sql_connect.cc
      @@ -1115,6 +1115,7 @@ void prepare_new_connection_state(THD* thd)
         */
         thd->proc_info= 0;
         thd->command= COM_SLEEP;
      +  sleep(1);
         thd->set_time();
         thd->init_for_queries();
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                svoj Sergey Vojtovich
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: