[MDEV-12177] perfschema.threads_mysql fails in buildbot after sequence of tests Created: 2017-03-03  Updated: 2017-03-03  Resolved: 2017-03-03

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.30

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

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled
relates to MDEV-11221 main.events_restart failed in buildbo... Closed

 Description   

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

perfschema.threads_mysql                 w2 [ fail ]
        Test ended at 2017-03-01 12:42:08
 
CURRENT_TEST: perfschema.threads_mysql
--- /usr/local/mariadb-10.0.30-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.result	2017-03-01 07:49:48.000000000 +0000
+++ /usr/local/mariadb-10.0.30-linux-x86_64/mysql-test/suite/perfschema/r/threads_mysql.reject	2017-03-01 12:42:08.092628135 +0000
@@ -57,16 +57,6 @@
 WHERE name LIKE 'thread/sql%'
   AND thread_id NOT IN (SELECT thread_id FROM t1)
 ORDER BY name;
-name	thread/sql/event_scheduler
-type	FOREGROUND
-processlist_user	root
-processlist_host	localhost
-processlist_db	NULL
-processlist_command	Sleep
-processlist_info	NULL
-unified_parent_thread_id	unified parent_thread_id
-role	NULL
-instrumented	YES
 TRUNCATE t1;
 INSERT INTO t1
 SELECT thread_id FROM performance_schema.threads
@@ -85,6 +75,16 @@
 WHERE name LIKE 'thread/sql%'
   AND thread_id NOT IN (SELECT thread_id FROM t1)
 ORDER BY name;
+name	thread/sql/event_scheduler
+type	FOREGROUND
+processlist_user	root
+processlist_host	localhost
+processlist_db	NULL
+processlist_command	Sleep
+processlist_info	NULL
+unified_parent_thread_id	unified parent_thread_id
+role	NULL
+instrumented	YES
 name	thread/sql/event_worker
 type	FOREGROUND
 processlist_user	root
 
mysqltest: Result content mismatch

in all cases the sequence of tests was

main.events_bugs main.events_restart perfschema.selects perfschema.threads_mysql



 Comments   
Comment by Sergey Vojtovich [ 2017-03-03 ]

Fix: https://github.com/MariaDB/server/commit/71f53bf72d918d99910f4a3e8cadbd5ed98a3021

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