I have seen this error occur when the following sequence occurs:
1. The query to be cached is run for the first time in
preparation for putting the results in memory.
2. Another request for the cached query comes in before the
first query are actually placed in memory. (Even if it is only a
matter of milliseconds before the results get to memory.)
3. The results of the first query are now actually placed in
memory.
It appears that the query is marked as cached at the START of the
execution of the query.
Generally, I only have seen this on longer running queries, but I
have seen it once or twice on a short-running query.
In cases where it becomes a problem, I have used CFTRY/CFCATCH to
trap the error and, if the retrieval of cached query failed"
error is generated, simply run the same SQL without the cache
request.
Hope this helps...
Chip Griffin
-----Original Message-----
From: Alistair Davidson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 9:49 AM
To: CF-Talk
Subject: "Retrieval of cached query failed" error
Hi all
The saga of our bizarre server errors continues........ anyone
seen (and
more importantly, FIXED!) this one before?
"Retrieval of cached query failed"
I've scoured the Allaire forums, and the only answers I found
were -
"This error typically happens in one of three cases:
1) If you were trying to insert a query into a full cache
where all of the queries were being used you'd get the
error.
2) Another place where this could happen is if the cache
max size is set to zero and you try to cache a query
3) Finally this occurs when global access to the cache is
granted initially, but because the page timeout has
been reached the retrieval fails."
Well, our server (Win2k, CF4.5.2) has 1.3Gb of RAM, of which only
400Meg or
so ever gets used, and we have the maximum number of cached
queries set to
1500 (yes, fifteen hundred) so I don't think 1 or 2 are likely.
The pages
where this is occurring are not slow-running pages, they usually
execute in
less than a second, and our timeout is set to ten seconds. The
server is not
even under particularly heavy load - less than 10,000 page
impressions a
day.
Any ideas?
Cheers,
Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
"There is no spoon"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
