[MDEV-15805] Test failure on galera.query_cache Created: 2018-04-08  Updated: 2022-10-28  Resolved: 2022-10-28

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 1
Labels: Test_disabled, test_disabled_ES

Issue Links:
Duplicate
duplicates MDEV-18137 Galera test failure on query_cache Closed
is duplicated by MDEV-13883 galera.query_cache fails in buildbot ... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/3924/steps/mtr/logs/stdio

galera.query_cache 'xtradb'              w1 [ fail ]
        Test ended at 2018-04-07 13:43:12
 
CURRENT_TEST: galera.query_cache
--- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result	2018-04-07 12:59:53.000000000 -0400
+++ /dev/shm/var/1/log/query_cache.reject	2018-04-07 13:43:11.566830604 -0400
@@ -1535,7 +1535,7 @@
 Qcache_queries_in_cache	0
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	46
+Qcache_inserts	45
 show status like "Qcache_hits";
 Variable_name	Value
 Qcache_hits	12
@@ -1548,7 +1548,7 @@
 Qcache_queries_in_cache	1
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	47
+Qcache_inserts	46
 show status like "Qcache_hits";
 Variable_name	Value
 Qcache_hits	13
 
mysqltest: Result content mismatch



 Comments   
Comment by Jan Lindström (Inactive) [ 2018-09-13 ]

Could not find recent failure from cross reference so assuming as fixed.

Comment by Jan Lindström (Inactive) [ 2018-09-17 ]

Not stable yet.

Comment by Aleksey Midenkov [ 2018-10-24 ]

Still fails in 10.4:

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/3418

Comment by Sergei Golubchik [ 2018-10-29 ]

Latest failures in the main trees:

Comment by Jan Lindström (Inactive) [ 2018-11-19 ]

mkaruza Can you have a look, for some reason there is consistent difference on results sometimes.

Comment by Aleksey Midenkov [ 2019-08-11 ]

Still fails in 10.3: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/7034

CURRENT_TEST: galera.query_cache
--- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result	2019-08-11 05:40:48.000000000 -0400
+++ /dev/shm/var/1/log/query_cache.reject	2019-08-11 07:43:35.203728955 -0400
@@ -1347,7 +1347,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	36
+Qcache_inserts	35
 drop table t1;
 #
 # Test of SQL_SELECT_LIMIT
@@ -1378,7 +1378,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	38
+Qcache_inserts	37
 SET SQL_SELECT_LIMIT=DEFAULT;
 # On node-2
 connection node_2;
@@ -1425,7 +1425,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	40
+Qcache_inserts	39
 lock table t1 write, t2 read;
 show status like "Qcache_queries_in_cache";
 Variable_name	Value
@@ -1451,7 +1451,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	41
+Qcache_inserts	40
 unlock table;
 drop view v1;
 set query_cache_wlock_invalidate=default;
@@ -1533,7 +1533,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	43
+Qcache_inserts	42
 set collation_connection=koi8r_bin;
 SELECT a,'Â','â'='Â' FROM t1;
 a	Â	'â'='Â'
@@ -1547,7 +1547,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	44
+Qcache_inserts	43
 set character_set_client=cp1251;
 SELECT a,'Â','â'='Â' FROM t1;
 a	�?	'�?'='�?'
@@ -1561,7 +1561,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	45
+Qcache_inserts	44
 set character_set_results=cp1251;
 SELECT a,'Â','â'='Â' FROM t1;
 a	�?	'â'='Â'
@@ -1575,7 +1575,7 @@
 Qcache_hits	12
 show status like "Qcache_inserts";
 Variable_name	Value
-Qcache_inserts	46
+Qcache_inserts	45
 SET NAMES default;
 # On node-2
 connection node_2;

Comment by Stepan Patryshev (Inactive) [ 2020-01-13 ]

Closing as not reproduced.

Comment by Stepan Patryshev (Inactive) [ 2020-01-13 ]

Reopening since it has not been reproduced because it is disabled.

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