Cached Query Count exceeds the Maximum number of cached queries

[ComrzChris]

Hi,

The Server monitor in ColdFusion 10 is showing the Cached query count as 12212 (and rising) even though the Maximum number of cached queries is set at 9000, how can I stop the actual Cached Query count from exceeding this limit and just exponentially growing?

Many thanks,

Chris

[Adam Cameron.]

I tried to replicate this, Chris, and wasn't able to.

Silly question, but are you certain the limit is 9000?

--

Adam

[ComrzChris]

Hi Adam,

Thanks for your input, I double checked and can defintely confirm the limit is set at 9000 here is a screenshot from the same instance:

Any more ideas?  This seems to be happening across multiple instances but interestingly only on CF10 and not CF9

Chris

[Adam Cameron.]

Do you have multiple CF10 instances running on that box? I'm wondering ift hey're inadvertently sharing an ehcache, or whether the monitor is misreporting or something?

These are just wild guesses, I'm afraid.

--

Adam

[Miguel-F]

Adam Cameron. wrote:

Do you have multiple CF10 instances running on that box? I'm wondering ift hey're inadvertently sharing an ehcache, or whether the monitor is misreporting or something?

Or perhaps the server monitor is counting cached queries from all of the instances and not just that one???

EDIT

Sorry, I just re-read Adam's post (the one that I quoted) and see that he also mentioned the server monitor misreporting.  Oops!!  Must be too early in the morning. 

[ComrzChris]

Thanks for your input people, this happens on all CF10 instances I am running at the moment.  Some are on dedicated servers with one CF instance and others are running up to 4 CF instanances so it looks to be a problem across the board...

Very Strange!

[BKBK]

One theory is that ColdFusion had cached a lot of queries before the limit was set. In any case, 9000 is too large, let alone 12000. That might lead to excessive memory consumption, especially given that the number keeps rising. I would press the button to Clear Query Cache Now, enabling ColdFusion to rebuild the query cache.