[MDEV-10677] perfschema.threads_mysql fails in buildbot (type=BACKGROUND mismatch) Created: 2016-08-27  Updated: 2024-02-05  Resolved: 2023-11-29

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

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

Issue Links:
Duplicate
is duplicated by MDEV-14484 perfschema.threads_mysql failed in bu... Closed
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

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

perfschema.threads_mysql                 w2 [ fail ]
 
        Test ended at 2016-06-02 15:00:59
 
 
 
CURRENT_TEST: perfschema.threads_mysql
 
--- /usr/local/mariadb-10.1.15-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result	2016-06-02 10:52:08.000000000 +0200
 
+++ /usr/local/mariadb-10.1.15-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject	2016-06-02 15:00:59.000000000 +0200
 
@@ -21,6 +21,16 @@
 
 type	FOREGROUND
 
 processlist_user	root
 
 processlist_host	localhost
 
+processlist_db	mtr
 
+processlist_command	Sleep
 
+processlist_info	NULL
 
+unified_parent_thread_id	unified parent_thread_id
 
+role	NULL
 
+instrumented	YES
 
+name	thread/sql/one_connection
 
+type	FOREGROUND
 
+processlist_user	root
 
+processlist_host	localhost
 
 processlist_db	test
 
 processlist_command	Query
 
 processlist_info	SELECT name, type, processlist_user, processlist_host, processlist_db,



 Comments   
Comment by Elena Stepanova [ 2017-12-20 ]

10.1 892cf2de13e1dc01ee47afc244deb861
logs not available

perfschema.threads_mysql                 w1 [ fail ]
 
        Test ended at 2017-10-31 16:42:55
 
 
 
CURRENT_TEST: perfschema.threads_mysql
 
--- /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result	2017-10-31 13:50:57.000000000 +0200
 
+++ /usr/local/mariadb-10.1.29-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject	2017-10-31 16:42:55.019538132 +0200
 
@@ -68,11 +68,11 @@
 
   AND thread_id NOT IN (SELECT thread_id FROM t1)
 
 ORDER BY name;
 
 name	thread/sql/event_scheduler
 
-type	FOREGROUND
 
+type	BACKGROUND
 
 processlist_user	root
 
 processlist_host	localhost
 
 processlist_db	NULL
 
-processlist_command	Sleep
 
+processlist_command	NULL
 
 processlist_info	NULL
 
 unified_parent_thread_id	unified parent_thread_id
 
 role	NULL
 
 
 
mysqltest: Result length mismatch

It appears to be a unique occurrence so far.

Comment by Elena Stepanova [ 2017-12-29 ]

Not unique anymore – 10.2:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-x86/builds/4100/steps/test/logs/stdio

perfschema.threads_mysql                 w2 [ fail ]
 
        Test ended at 2017-12-25 05:23:04
 
 
 
CURRENT_TEST: perfschema.threads_mysql
 
--- /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.result	2017-12-25 04:41:21.000000000 +0000
 
+++ /usr/local/mariadb-10.2.12-linux-i686/mysql-test/suite/perfschema/r/threads_mysql.reject	2017-12-25 05:23:04.060758441 +0000
 
@@ -68,11 +68,11 @@
 
   AND thread_id NOT IN (SELECT thread_id FROM t1)
 
 ORDER BY name;
 
 name	thread/sql/event_scheduler
 
-type	FOREGROUND
 
+type	BACKGROUND
 
 processlist_user	root
 
 processlist_host	localhost
 
 processlist_db	NULL
 
-processlist_command	Sleep
 
+processlist_command	NULL
 
 processlist_info	NULL
 
 unified_parent_thread_id	unified parent_thread_id
 
 role	NULL
 
 
 
mysqltest: Result length mismatch

Comment by Otto Kekäläinen [ 2024-02-05 ]

Seen on MariaDB 10.11 in https://launchpadlibrarian.net/712871094/buildlog_ubuntu-noble-ppc64el.mariadb_1%3A10.11.6-3~bpo24.04.1~1707078933.a3220971295+feature.extend.mtr.to.big_BUILDING.txt.gz

perfschema.threads_mysql                 w1 [ fail ]
 
        Test ended at 2024-02-04 21:36:09
 
 
 
CURRENT_TEST: perfschema.threads_mysql
 
--- /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.result	2023-11-08 15:46:47.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/suite/perfschema/r/threads_mysql.reject	2024-02-04 21:36:09.069412843 +0000
 
@@ -72,11 +72,11 @@
 
   AND thread_id NOT IN (SELECT thread_id FROM t1)
 
 ORDER BY name;
 
 name	thread/sql/event_scheduler
 
-type	FOREGROUND
 
+type	BACKGROUND
 
 processlist_user	root
 
 processlist_host	localhost
 
 processlist_db	NULL
 
-processlist_command	Sleep
 
+processlist_command	NULL
 
 processlist_info	NULL
 
 unified_parent_thread_id	unified parent_thread_id
 
 role	NULL
 
 
 
mysqltest: Result length mismatch

Seems sporadic.

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