main.query_cache fails on 11.6, hardy

Bug #676158 reported by Aleksandr Kuzminsky
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Aleksandr Kuzminsky

Bug Description

main.query_cache [ fail ]
        Test ended at 2010-11-16 14:00:05

CURRENT_TEST: main.query_cache
--- /var/lib/buildbot/slaves/percona-server-51-11/DEB_Ubuntu_hardy_amd64/work/percona-server-5.1.52-11.6-138.hardy/mysql-test/r/query_cache.result 2010-10-12 00:06:46.000000000 +0300
+++ /var/lib/buildbot/slaves/percona-server-51-11/DEB_Ubuntu_hardy_amd64/work/percona-server-5.1.52-11.6-138.hardy/mysql-test/r/query_cache.reject 2010-11-16 17:00:05.000000000 +0300
@@ -1709,6 +1709,8 @@
 SET GLOBAL query_cache_size= default;
 End of 5.0 tests
 SET GLOBAL query_cache_size=1024*1024*512;
+Warnings:
+Warning 1282 Query cache failed to set size 536870912; new query cache size is 0
 CREATE TABLE t1 (a ENUM('rainbow'));
 INSERT INTO t1 VALUES (),(),(),(),();
 SELECT 1 FROM t1 GROUP BY (SELECT 1 FROM t1 ORDER BY AVG(LAST_INSERT_ID()));

mysqltest: Result content mismatch

Changed in percona-server:
milestone: none → 11.6
Revision history for this message
Aleksandr Kuzminsky (akuzminsky) wrote :

The test fails due to low memory

Changed in percona-server:
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
status: New → Fix Committed
Revision history for this message
Aleksandr Kuzminsky (akuzminsky) wrote :

- The test check of bug 31157 is declared to be moved to subselect.test(according to http://bazaar.launchpad.net/~mysql/mysql-server/mysql-5.1/revision/3187), but actually it wasn't moved.
- Setting query cache size to 512M regardless of available amount of memory causes the test failure.

Changed in percona-server:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2571

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.