Bug #36747 Allocating a large query cache is not deterministic
Submitted: 16 May 2008 4:08 Modified: 17 Jul 2008 13:07
Reporter: Davi Arnaut
Status: Verified
Category:Server Severity:S3 (Non-critical)
Version:6.0,5.4 OS:Any
Assigned to: Target Version:5.4+
Tags: disabled
Triage: Triaged: D3 (Medium)

[16 May 2008 4:08] Davi Arnaut 
Description:
Setting query_cache_size to larger values might fail depending on the memory pressure
being put on the system. This can be seen on pushbuild as the test case
query_cache_size_basic tries to allocate a +3GB query cache, which succeeds in some
machines and fails in others.

How to repeat:
Sporadic failures of test cases query_cache_size_basic_32 and query_cache_size_basic_64
on PB.
[16 May 2008 8:27] Georgi Kodinov 
Duplicate of Bug#36733
[19 May 2008 18:27] Georgi Kodinov 
Not a duplicate
[17 Jul 2008 13:00] Horst Hunger 
As I have not found that bug I reported another one Bug#38164, for which a patch is
queued. So it is a duplicate of that bug.
[17 Jul 2008 13:09] Horst Hunger 
It is not a duplicate, as that bug is for "query_prealloc_size".
[31 Aug 19:15] Sergei Golubchik 
transaction_prealloc_size_basic_32 and transaction_prealloc_size_basic_64 also doing this