[MDEV-15805] Test failure on galera.query_cache - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 10.1(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: N/A
Component/s: Galera, Tests
Labels:
- Test_disabled
- test_disabled_ES

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

Attachments

Issue Links

duplicates

MDEV-18137 Galera test failure on query_cache

Closed

is duplicated by

MDEV-13883 galera.query_cache fails in buildbot with wrong result

Closed

Activity

Ascending order - Click to sort in descending order

Jan Lindström (Inactive) created issue - 2018-04-08 05:16

Jan Lindström (Inactive) made changes - 2018-04-08 05:35

Field	Original Value	New Value
Link		This issue blocks ~~MDEV-13549~~ [ ~~MDEV-13549~~ ]

Jan Lindström (Inactive) added a comment - 2018-09-13 11:27

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

Jan Lindström (Inactive) added a comment - 2018-09-13 11:27 Could not find recent failure from cross reference so assuming as fixed.

Jan Lindström (Inactive) made changes - 2018-09-13 11:27

issue.field.resolutiondate

2018-09-13 11:27:07.0

2018-09-13 11:27:07.661

Jan Lindström (Inactive) made changes - 2018-09-13 11:27

Component/s		Tests [ 10800 ]
Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.1 [ 16100 ]
Assignee	Daniele Sciascia [ sciascid ]	Jan Lindström [ jplindst ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Jan Lindström (Inactive) added a comment - 2018-09-17 13:11

Not stable yet.

Jan Lindström (Inactive) added a comment - 2018-09-17 13:11 Not stable yet.

Jan Lindström (Inactive) made changes - 2018-09-17 13:11

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Jan Lindström (Inactive) made changes - 2018-09-19 10:41

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2018-09-23 10:40

issue.field.resolutiondate

2018-09-23 10:40:58.0

2018-09-23 10:40:58.008

Jan Lindström (Inactive) made changes - 2018-09-23 10:40

Fix Version/s		10.2.18 [ 23112 ]
Fix Version/s		10.3.10 [ 23140 ]
Fix Version/s		10.1.37 [ 23204 ]
Fix Version/s	N/A [ 14700 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Aleksey Midenkov made changes - 2018-10-24 17:39

Link

This issue is duplicated by ~~MDEV-13883~~ [ ~~MDEV-13883~~ ]

Aleksey Midenkov added a comment - 2018-10-24 17:41

Still fails in 10.4:

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

Aleksey Midenkov added a comment - 2018-10-24 17:41 Still fails in 10.4: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-ppc64le/builds/3418

Aleksey Midenkov made changes - 2018-10-24 17:41

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Aleksey Midenkov made changes - 2018-10-24 17:44

Affects Version/s

10.4 [ 22408 ]

Sergei Golubchik added a comment - 2018-10-29 10:30

Latest failures in the main trees:

2018-10-26 09:45:59	10.2	http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/12649
2018-10-20 16:34:01	10.3	http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/8405
2018-10-25 01:40:04	10.4	http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/5230

Sergei Golubchik added a comment - 2018-10-29 10:30 Latest failures in the main trees: 2018-10-26 09:45:59 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/12649 2018-10-20 16:34:01 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/8405 2018-10-25 01:40:04 10.4 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/5230

Sergei Golubchik made changes - 2018-10-29 10:31

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s	10.2.18 [ 23112 ]
Fix Version/s	10.3.10 [ 23140 ]
Fix Version/s	10.1.37 [ 23204 ]

Jan Lindström (Inactive) made changes - 2018-11-19 09:04

Assignee

Jan Lindström [ jplindst ]

Mario Karuza [ mkaruza ]

Jan Lindström (Inactive) added a comment - 2018-11-19 09:04

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

Jan Lindström (Inactive) added a comment - 2018-11-19 09:04 mkaruza Can you have a look, for some reason there is consistent difference on results sometimes.

Mario Karuza (Inactive) made changes - 2019-01-07 09:10

Link

This issue duplicates ~~MDEV-18137~~ [ ~~MDEV-18137~~ ]

Sergei Golubchik made changes - 2019-03-29 12:04

Fix Version/s

10.4 [ 22408 ]

Aleksey Midenkov made changes - 2019-08-11 14:06

Affects Version/s

10.3 [ 22126 ]

Aleksey Midenkov added a comment - 2019-08-11 14:09

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;

Aleksey Midenkov added a comment - 2019-08-11 14:09 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;

Julien Fritsch made changes - 2019-10-16 09:53

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

Julien Fritsch made changes - 2019-10-16 09:53

Link

This issue blocks ~~MDEV-13549~~ [ ~~MDEV-13549~~ ]

Stepan Patryshev (Inactive) added a comment - 2020-01-13 14:43

Closing as not reproduced.

Stepan Patryshev (Inactive) added a comment - 2020-01-13 14:43 Closing as not reproduced.

Stepan Patryshev (Inactive) made changes - 2020-01-13 14:43

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Cannot Reproduce [ 5 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) added a comment - 2020-01-13 16:18

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

Stepan Patryshev (Inactive) added a comment - 2020-01-13 16:18 Reopening since it has not been reproduced because it is disabled.

Stepan Patryshev (Inactive) made changes - 2020-01-13 16:18

Resolution	Cannot Reproduce [ 5 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Stepan Patryshev (Inactive) made changes - 2020-01-22 09:41

Labels

disabled

Stepan Patryshev (Inactive) made changes - 2020-01-22 09:41

Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s	N/A [ 14700 ]

Julien Fritsch made changes - 2020-03-02 16:57

Labels

disabled

Test_disabled disabled

Julien Fritsch made changes - 2020-03-02 16:59

Labels

Test_disabled disabled

Test_disabled

Stepan Patryshev (Inactive) made changes - 2020-03-04 11:47

Labels

Test_disabled

Test_disabled test_disabled_ES

Julien Fritsch made changes - 2020-12-01 12:39

Fix Version/s

10.1 [ 16100 ]

Mario Karuza (Inactive) made changes - 2021-03-30 19:16

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Mario Karuza (Inactive) made changes - 2021-03-31 08:08

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Mario Karuza (Inactive) made changes - 2021-03-31 08:08

Assignee

Mario Karuza [ mkaruza ]

Jan Lindström [ jplindst ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 86427 ]

MariaDB v4 [ 143538 ]

Jan Lindström (Inactive) made changes - 2022-10-28 06:13

issue.field.resolutiondate

2022-10-28 06:13:40.0

2022-10-28 06:13:40.501

Jan Lindström (Inactive) made changes - 2022-10-28 06:13

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Cannot Reproduce [ 5 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Julien Fritsch made changes - 2022-10-28 13:10

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Jan Lindström (Inactive)

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2018-04-08 05:16

Updated:: 2022-10-28 13:10

Resolved:: 2022-10-28 06:13

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration