>Any possibility you use a UDF that could rewrite the value of myquery?
>If you wrap the check in try/catch and cfdump myquery, what do you
>see?
>
>On 12/10/05, Terry Ford <[EMAIL PROTECTED]> wrote:
>>
Hey Ray,
myquery is not modified in any way whatsoever by any code in any template.
I'll try wrapping with try/catch for next time it happens. In trying to debug
this problem in the past I have used an isdefined("myquery") after the CFQUERY
and it has returned false. So it's as if the <CFQUERY> is sometimes returning
no query object whatsoever.
The actual code is:
..... do some stuff ...
<cfinclude template="/thequery.cfm">
<cfif myquery.recordcount eq 0>
...
</cfif>
Template "thequery.cfm" contains the cfquery returning myquery, and only the
cfquery. I'm not sure if the fact that the query code is being included has
anything to do with this problem, but I include is as a possibility.
This problem only occcurs on a couple of queries that:
(a) are executed often (tens of thousands of times a day)
(b) have relatively long execution times (up to 2 seconds) when non-cached, and
(c) are cached via cf query caching
In addition, once this error occurs on a query, that identical query will
return no query object in subsequent executions of that template for some time
after the initial error occurred. That leads me to believe that it's a query
caching issue.
In addition, this problem seems to occur most often during peak times of the
day when traffic is the heaviest and a lot of threads are active, leaving me to
wonder if this problem is the symptom of some obscure race condition that is
corrupting the query cache.
Regards,
Terry
Here's an instance of the error that I caught in the exception log:
"Error","jrpp-259","12/08/05","04:08:49","cfap","Element RECORDCOUNT is
undefined in QNS. The specific sequence of files included or processed is:
/home/trivia/www/private/play.cfm "
coldfusion.runtime.UndefinedElementException: Element RECORDCOUNT is undefined
in QNS.
at
coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1049)
at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1004)
at
coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1111)
at cfplay2ecfm1467329454.runPage(/home/trivia/www/private/play.cfm:134)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226726
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
