[MDEV-12237] main.analyze_stmt_slow_query_log failed in buildbot Created: 2017-03-11  Updated: 2023-12-07

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://askmonty.org/buildbot/builders/kvm-fulltest2/builds/7035

main.analyze_stmt_slow_query_log         w1 [ fail ]
 
        Test ended at 2017-02-06 18:29:16
 
 
 
CURRENT_TEST: main.analyze_stmt_slow_query_log
 
--- /mnt/buildbot/build/mariadb-10.1.22/mysql-test/r/analyze_stmt_slow_query_log.result	2017-02-06 15:57:22.000000000 +0200
 
+++ /mnt/buildbot/build/mariadb-10.1.22/mysql-test/r/analyze_stmt_slow_query_log.reject	2017-02-06 18:29:15.000000000 +0200
 
@@ -14,5 +14,3 @@
 
 # explain: 1	INSERT	t1	ALL	NULL	NULL	NULL	NULL	NULL	NULL	100.00	100.00	NULL
 
 # explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
 
 # explain: 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	30.00	Using where
 
-# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
 
-# explain: 1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Alice Sherepa [ 2017-11-13 ]

recent on 10.1, sporadic http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/3103/steps/mtr/logs/stdio

Comment by Otto Kekäläinen [ 2023-10-09 ]

I saw a variation of this in https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=hppa&ver=1%3A10.11.5-2&stamp=1696821455&raw=0 (hppa build of Debian 1:10.11.5-2):

main.analyze_stmt_slow_query_log         w2 [ fail ]
 
        Test ended at 2023-10-09 03:08:38
 
 
 
CURRENT_TEST: main.analyze_stmt_slow_query_log
 
--- /<<PKGBUILDDIR>>/mysql-test/main/analyze_stmt_slow_query_log.result	2023-08-11 06:35:40.000000000 +0000
 
+++ /<<PKGBUILDDIR>>/mysql-test/main/analyze_stmt_slow_query_log.reject	2023-10-09 03:08:37.401015684 +0000
 
@@ -12,7 +12,3 @@
 
 drop table t1;
 
 # explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
 
 # explain: 1	INSERT	t1	ALL	NULL	NULL	NULL	NULL	NULL	NULL	100.00	100.00	NULL
 
-# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
 
-# explain: 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	30.00	Using where
 
-# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
 
-# explain: 1	SIMPLE	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	No tables used
 
 
 
mysqltest: Result length mismatch

Comment by Yuchen Pei [ 2023-12-07 ]

Encountered today in https://buildbot.mariadb.org/#/builders/221/builds/28390

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