[MDEV-10311] funcs_1.processlist_priv_no_prot fails sporadically Created: 2016-06-30  Updated: 2016-06-30  Resolved: 2016-06-30

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5.50, 10.0.26, 10.1.14, 10.2.0
Fix Version/s: 5.5.51, 10.1.16, 10.0.27, 10.2.2

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Sergey Vojtovich
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 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();


Generated at Thu Feb 08 07:41:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.