[MDEV-11223] funcs_1.processlist_val_no_prot fails sporadically in buildbot Created: 2016-11-02  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Attachments: Text File 10.0_errlog.txt     Text File 10.0_stdio.txt    
Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/5413/steps/test/logs/stdio

funcs_1.processlist_val_no_prot          w3 [ fail ]
        Test ended at 2016-09-26 09:04:47
 
CURRENT_TEST: funcs_1.processlist_val_no_prot
--- /usr/local/mariadb-10.1.18-linux-i686/mysql-test/suite/funcs_1/r/processlist_val_no_prot.result	2016-09-26 08:02:12.000000000 +0200
+++ /usr/local/mariadb-10.1.18-linux-i686/mysql-test/suite/funcs_1/r/processlist_val_no_prot.reject	2016-09-26 09:04:46.000000000 +0200
@@ -87,7 +87,7 @@
 SHOW FULL PROCESSLIST;
 Id	User	Host	db	Command	Time	State	Info	Progress
 <ID>	root	<HOST_NAME>	information_schema	Query	<TIME>	init	SHOW FULL PROCESSLIST	0.000
-<ID>	test_user	<HOST_NAME>	information_schema	Sleep	<TIME>		NULL	0.000
+<ID>	test_user	<HOST_NAME>	information_schema	Sleep	<TIME>	NULL	NULL	0.000
 SELECT ID,TIME INTO @test_user_con1_id,@time FROM INFORMATION_SCHEMA.PROCESSLIST
 WHERE COMMAND = 'Sleep' AND USER = 'test_user';
 SELECT @test_user_con1_id = @default_id + 1
@@ -107,7 +107,7 @@
 AND USER = 'test_user' AND DB = 'information_schema'
      AND Command = 'Sleep' AND State = '' AND INFO IS NULL;
 Expect 1
-1
+0
 # Ensure that the user test_user sees only connections with his username
 # because he has not the PROCESS privilege.
 #----------------------------------------------------------------------------
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-11-05 ]

10.0:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/3418/steps/test/logs/stdio

funcs_1.processlist_val_no_prot          w2 [ fail ]
        Test ended at 2017-11-05 19:45:08
 
CURRENT_TEST: funcs_1.processlist_val_no_prot
--- /usr/local/mariadb-10.0.34-linux-i686/mysql-test/suite/funcs_1/r/processlist_val_no_prot.result	2017-11-05 18:45:28.000000000 +0000
+++ /usr/local/mariadb-10.0.34-linux-i686/mysql-test/suite/funcs_1/r/processlist_val_no_prot.reject	2017-11-05 19:45:08.658725062 +0000
@@ -85,7 +85,7 @@
 SHOW FULL PROCESSLIST;
 Id	User	Host	db	Command	Time	State	Info	Progress
 <ID>	root	<HOST_NAME>	information_schema	Query	<TIME>	init	SHOW FULL PROCESSLIST	0.000
-<ID>	test_user	<HOST_NAME>	information_schema	Sleep	<TIME>		NULL	0.000
+<ID>	test_user	<HOST_NAME>	information_schema	Sleep	<TIME>	NULL	NULL	0.000
 SELECT ID,TIME INTO @test_user_con1_id,@time FROM INFORMATION_SCHEMA.PROCESSLIST
 WHERE COMMAND = 'Sleep' AND USER = 'test_user';
 SELECT @test_user_con1_id = @default_id + 1
 
mysqltest: Result length mismatch

10.0_errlog.txt 10.0_stdio.txt

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