| Bug #53392 | Tests: perfschema.query_cache fails | ||
|---|---|---|---|
| Submitted: | 3 May 2010 20:14 | Modified: | 4 Aug 2010 20:07 |
| Reporter: | Guilhem Bichot | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | next-mr-bugfixing,6.0-codebase-bugfixing | OS: | Linux (64) |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[3 May 2010 20:18]
Guilhem Bichot
I verified it in next-mr-bugfixing alik@sun.com-20100324081557-wgupgg1xg1qs1l9s (ok, quite old).
[3 May 2010 23:51]
MySQL Verification Team
Thank you for the bug eport.
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.query_cache_with_views [ pass ] 69
perfschema.query_cache [ fail ]
Test ended at 2010-05-03 20:50:36
CURRENT_TEST: perfschema.query_cache
--- /home/miguel/bzr/6.0-bugfix/mysql-test/suite/perfschema/r/query_cache.result 2010-05-04 02:38:26.975243000 +0300
+++ /home/miguel/bzr/6.0-bugfix/mysql-test/suite/perfschema/r/query_cache.reject 2010-05-04 02:50:36.082515374 +0300
@@ -14,10 +14,10 @@
Qcache_queries_in_cache 1
[4 May 2010 7:44]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/107244 3162 Marc Alff 2010-05-04 Bug#53392 Tests: perfschema.query_cache fails Before this fix, the test perfschema.query_cache could fail with spurious failures, depending on which test was executed in the same MTR run. With this fix, the test perfschema.query_cache resets the server status variables, to be independent of previous runs. In particular, Qcache_hit now has a predictable value.
[4 May 2010 8:47]
Marc ALFF
Queued into: - mysql-next-mr-bugfixing - mysql-6.0-codebase-bugfixing Doc team: Fixed test script spurious failure only, no impact on the server
[7 May 2010 9:20]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100507091908-vqyhpwf2km0aokno) (version source revid:alik@sun.com-20100507091737-12vceffs11elb25g) (merge vers: 6.0.14-alpha) (pib:16)
[7 May 2010 9:22]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100507091823-nzao4h3qosau4tin) (version source revid:alik@sun.com-20100507091720-ib9r8uny2aeazvas) (pib:16)
[8 May 2010 17:19]
Paul DuBois
Changes for test case. No changelog entry needed.
[16 Jul 2010 13:14]
Marc ALFF
This fix is tagged SR55TEST, but was not merged in 5.5 Changing to need merge
[16 Jul 2010 13:28]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/113759 3123 Marc Alff 2010-07-16 Bug#53392 Tests: perfschema.query_cache fails Backport from mysql-next-mr (5.6) to mysql-trunk (5.5)
[16 Jul 2010 19:26]
Marc ALFF
Backported in mysql-trunk-bugfixing (5.5)
[22 Jul 2010 16:12]
Paul DuBois
No changelog entry needed.
[23 Jul 2010 12:23]
Bugs System
Pushed into mysql-trunk 5.5.6-m3 (revid:alik@sun.com-20100723121820-jryu2fuw3pc53q9w) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:18)
[23 Jul 2010 12:30]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100723121929-90e9zemk3jkr2ocy) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (pib:18)
[4 Aug 2010 8:04]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:20]
Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100507093958-2y0wy6svnc3zfgqb) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 20:07]
Paul DuBois
No changelog entry needed.
Description: I have not checked next-mr. I have tor.didriksen@sun.com-20100501100508-snbetlcd63sr7vsp ./mtr --mem --no-reorder main.query_cache_with_views perfschema.query_cache perfschema.query_cache [ fail ] Test ended at 2010-05-03 22:13:40 CURRENT_TEST: perfschema.query_cache --- /home/mysql_src/bzrrepos/mysql-6.0-codebase-bugfixing2/mysql-test/suite/perfschema/r/query_cache.result 2010-03-05 14:17:22.000000000 +0300 +++ /home/mysql_src/bzrrepos/mysql-6.0-codebase-bugfixing2/mysql-test/suite/perfschema/r/query_cache.reject 2010-05-03 23:13:40.000000000 +0300 @@ -14,10 +14,10 @@ Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value -Qcache_inserts 1 +Qcache_inserts 3 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 0 +Qcache_hits 2 etc How to repeat: ./mtr --mem --no-reorder main.query_cache_with_views perfschema.query_cache it is repeatable Suggested fix: no clue. No idea whether the bug is in Query cache or Performance Schema.