main.percona_query_cache_with_comments fails on 5.1.52-rel11.6 on CentOS-5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Critical
|
Oleg Tsarev |
Bug Description
Not always, but sometimes the test fails:
main.percona_
Test ended at 2010-11-10 16:50:18
CURRENT_TEST: main.percona_
--- /home/buildbot/
+++ /home/buildbot/
@@ -337,25 +337,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 20
+Qcache_hits 19
------
select */* internal comment */ from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 20
+Qcache_hits 19
select */* internal comment */ from t1;
a
1
@@ -368,25 +368,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 22
+Qcache_hits 21
------
select */* internal comment */from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 22
+Qcache_hits 21
select */* internal comment */from t1;
a
1
@@ -399,25 +399,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 24
+Qcache_hits 23
------
select * /* internal comment with "quote" */ from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 24
+Qcache_hits 23
select * /* internal comment with "quote" */ from t1;
a
1
@@ -430,25 +430,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 26
+Qcache_hits 25
------
select */* internal comment with "quote" */ from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 26
+Qcache_hits 25
select */* internal comment with "quote" */ from t1;
a
1
@@ -461,25 +461,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 28
+Qcache_hits 27
------
select */* internal comment with "quote" */from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 28
+Qcache_hits 27
select */* internal comment with "quote" */from t1;
a
1
@@ -492,26 +492,26 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 30
+Qcache_hits 29
------
select * from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 30
+Qcache_hits 29
select * from t1
;
a
@@ -526,25 +526,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 32
+Qcache_hits 31
------
select * from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 32
+Qcache_hits 31
select * from t1 ;
a
1
@@ -557,25 +557,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 34
+Qcache_hits 33
------
select * from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 34
+Qcache_hits 33
select * from t1 ;
a
1
@@ -588,26 +588,26 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 36
+Qcache_hits 35
------
select * from t1
/* comment in the end */
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 36
+Qcache_hits 35
select * from t1
/* comment in the end */;
a
@@ -622,26 +622,26 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 38
+Qcache_hits 37
------
select * from t1
/* *\/ */
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 38
+Qcache_hits 37
select * from t1
/* *\/ */;
a
@@ -656,13 +656,13 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 40
+Qcache_hits 39
------
select * from t1
/* comment in the end */
@@ -670,13 +670,13 @@
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 40
+Qcache_hits 39
select * from t1
/* comment in the end */
;
@@ -693,25 +693,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 42
+Qcache_hits 41
------
select * from t1 #comment in the end
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 42
+Qcache_hits 41
select * from t1 #comment in the end;
a
1
@@ -724,26 +724,26 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 44
+Qcache_hits 43
------
select * from t1 #comment in the end
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 44
+Qcache_hits 43
select * from t1 #comment in the end
;
a
@@ -758,25 +758,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 46
+Qcache_hits 45
------
select * from t1 -- comment in the end
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 46
+Qcache_hits 45
select * from t1 -- comment in the end;
a
1
@@ -789,26 +789,26 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 48
+Qcache_hits 47
------
select * from t1 -- comment in the end
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 48
+Qcache_hits 47
select * from t1 -- comment in the end
;
a
@@ -823,25 +823,25 @@
3
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 50
+Qcache_hits 49
------
select ' \' ' from t1
------
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 1
+Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 50
+Qcache_hits 49
select ' \' ' from t1;
'
'
@@ -854,13 +854,13 @@
'
show status like "Qcache_
Variable_name Value
-Qcache_
+Qcache_
show status like "Qcache_inserts";
Variable_name Value
-Qcache_inserts 2
+Qcache_inserts 3
show status like "Qcache_hits";
Variable_name Value
-Qcache_hits 51
+Qcache_hits 50
DROP TABLE t1;
SET GLOBAL query_cache_
set global query_cache_
mysqltest: Result content mismatch
Related branches
- Percona: Approve
-
Diff: 20 lines (+2/-1)1 file modifiedquery_cache_enhance.patch (+2/-1)
- Alexey Kopytov (community): Approve
-
Diff: 8 lines (+1/-0)1 file modifiedmysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test (+1/-0)
Changed in percona-server: | |
milestone: | none → 11.6 |
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
Changed in percona-server: | |
status: | New → Triaged |
importance: | Undecided → Critical |
Changed in percona-server: | |
status: | Triaged → Fix Committed |
status: | Fix Committed → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
disable ps-protocol as temporary solution /bugs.launchpad .net/percona- server/ +bug/676938
see bug:
https:/