Percona Server with XtraDB

main.query_cache fails on 11.6, hardy

Reported by Aleksandr Kuzminsky on 2010-11-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
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

The test fails due to low memory

Changed in percona-server:
assignee: nobody → Aleksandr Kuzminsky (akuzminsky)
Changed in percona-server:
status: New → Fix Committed

- 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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers