[MDEV-16180] main.query_cache failed in buildbot with wrong result Created: 2018-05-15  Updated: 2023-11-29  Resolved: 2023-11-29

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

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


 Description   

http://buildbot.askmonty.org/buildbot/builders/win32-packages/builds/8104

10.2 e44ca6cc9c300cbdf93c64110bd8cf2be8125379

main.query_cache                         w1 [ fail ]
        Test ended at 2018-05-07 13:31:37
 
CURRENT_TEST: main.query_cache
--- D:/win32-packages/build/src/mysql-test/r/query_cache.result	2018-05-07 12:45:39.000000000 +0000
+++ D:\win32-packages\build\src\mysql-test\r\query_cache.reject	2018-05-07 13:31:32.255510000 +0000
@@ -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	2018-05-07 13:31:03	2018-05-07 13:31:11	0	0
+2	2018-05-07 13:31:11	2018-05-07 13:31:15	0	0
+3	2018-05-07 13:31:15	2018-05-07 13:31:20	0	0
+4	2018-05-07 13:31:21	2018-05-07 13:31:28	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:26:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.