[MDEV-7558] analyze_stmt_slow_query_log fails sporadically in buildbot Created: 2015-02-07  Updated: 2016-12-21  Resolved: 2016-12-21

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: 10.1.21

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

It used to fail (MDEV-7229), then it was fixed, now it failed again.

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

main.analyze_stmt_slow_query_log         w4 [ fail ]
 
        Test ended at 2015-02-07 14:36:17
 
 
 
CURRENT_TEST: main.analyze_stmt_slow_query_log
 
--- /usr/local/mariadb-10.1.3-linux-i686/mysql-test/r/analyze_stmt_slow_query_log.result	2015-02-07 10:52:43.000000000 +0200
 
+++ /usr/local/mariadb-10.1.3-linux-i686/mysql-test/r/analyze_stmt_slow_query_log.reject	2015-02-07 14:36:17.046996198 +0200
 
@@ -11,5 +11,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	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
 
 



 Comments   
Comment by Elena Stepanova [ 2016-08-27 ]

Relatively fresh log (July 2016)
http://buildbot.askmonty.org/buildbot/builders/p8-xenial-bintar/builds/38/steps/test/logs/stdio

main.analyze_stmt_slow_query_log         w4 [ fail ]
 
        Test ended at 2016-07-03 05:30:08
 
 
 
CURRENT_TEST: main.analyze_stmt_slow_query_log
 
--- /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.result	2016-06-30 18:39:27.560815885 -0400
 
+++ /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/r/analyze_stmt_slow_query_log.reject	2016-07-03 05:30:08.609194008 -0400
 
@@ -11,5 +11,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

Comment by Michael Widenius [ 2016-12-21 ]

The reason was that the test was reusing the same log file without deleting it between tests.
Fixed by creating a new log file as part of the test

Comment by Michael Widenius [ 2016-12-21 ]

Pushed into 10.1

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