[MDEV-12895] main.query_cache failed in buildbot with wrong result Created: 2017-05-24  Updated: 2023-11-29  Resolved: 2023-11-29

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

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

kvm-bintar-centos5-x86 e1efeaa5502f640102881f415d604cc1



 Description   

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

main.query_cache                         w2 [ fail ]
        Test ended at 2017-05-08 12:45:01
 
CURRENT_TEST: main.query_cache
--- /usr/local/mariadb-10.1.24-linux-i686/mysql-test/r/query_cache.result	2017-05-08 11:15:53.000000000 +0200
+++ /usr/local/mariadb-10.1.24-linux-i686/mysql-test/r/query_cache.reject	2017-05-08 12:45:01.000000000 +0200
@@ -1820,7 +1820,7 @@
 BETWEEN 0 AND @max_acceptable_delay;
 SELECT @aux1 AS "Expect 1";
 Expect 1
-1
+0
 # Test 2: Does the query with SLEEP need a reasonable time even in case
 #         of the non first execution?
 SELECT COUNT(*) >= 4 - 1 - 1 INTO @aux2 FROM t_history
@@ -1836,6 +1836,13 @@
 SELECT @aux3 AS "Expect 1";
 Expect 1
 1
+# Some tests failed, dumping the content of t_history
+SELECT * FROM t_history;
+attempt	start_ts	end_ts	start_cached	end_cached
+1	2017-05-08 12:44:47	2017-05-08 12:44:50	0	0
+2	2017-05-08 12:44:50	2017-05-08 12:44:54	0	0
+3	2017-05-08 12:44:54	2017-05-08 12:44:58	0	0
+4	2017-05-08 12:44:58	2017-05-08 12:45:01	0	0
 DROP TABLE t1;
 DROP TEMPORARY TABLE t_history;
 SET @@global.query_cache_size = default;
 
mysqltest: Result length mismatch


Generated at Thu Feb 08 08:01:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.