Skip to main content
Kevlar
Inspiring
May 31, 2013 11:30 PM UTC
Question

cfquery and cachedwithin yields variable undefined

This one is driving me nuts...

I have the following piece of code...

<cfquery datasource="#dsn#" name="q" cachedwithin="#createTimeSpan(0,0,30,0)#">

Some fancy SQL

</cfquery>

Today, the above stopped working.  The error was variable q was undefined.  Odd, figured the caching went wrong, so I changed it to this

<cfquery datasource="#dsn#" name="q" cachedwithin="#createTimeSpan(0,0,0,0)#">

Some fancy SQL

</cfquery>

to empty out the query cache for that query.  The query then started to work with the #createTimeSpan(0,0,0,0)#.  I change it back to #createTimeSpan(0,0,30,0)# and instantly it dies... variable q undefined.  Strange.  So I after running it again with #createTimeSpan(0,0,0,0)# it starts to work.  I bumped it to #createTimeSpan(0,0,5,0)# it works.  I bump it to #createTimeSpan(0,0,10,0)# it works.  I bump it to #createTimeSpan(0,0,15,0)# it dies... variable q undefined.  After some tweaking, I find out that anything larger than #createTimeSpan(0,0,11,0)# and it returns variable q undefined.

I am beyond confused why this is not working anymore.  I'm using Coldfusion10 which is using the new ehcaching mechanism if that makes a difference, but I can't see why it would. The server is a Windows2008R2 w/ IIS 7.5.  Anybody have any clues?

This topic is closed to new replies. Start a new post to keep the conversation going.

4 replies

FPN
FPN
Participant
Jul 26, 2016 5:29 PM UTC

I just worked around the problem with CFTRY

<cftry>

  <cfset myResult=GetRecs><!--- Test the query by assigning it to a variable and see if it generates error --->

<cfcatch type="any">

<!--- It does, then redo query with no cache --->

    <cfquery datasource="Guide" name="GetRecs" cachedwithin="#CreateTimeSpan(0,0,0,0)#">  

     select #application.SearchCols# from mytable 

    </cfquery>

    <cfset myResult=GetRecs>

</cfcatch>

</cftry>

Translate
KevlarAuthor
Inspiring
Aug 19, 2013 8:25 PM UTC

To elaborate on this further... I know it is 2 months old (I still have not found a solution).  It looks as if the caching mechanism is so advanced that if the first run of the query fails (before it is cached), it will cache the crashed query.  I know, it sounds odd.  If this piece of code executes...

<cfquery datasource="#dsn#" name="q" cachedwithin="#createTimeSpan(0,0,30,0)#">

Some fancy SQL

</cfquery>

And the above crashes, the page will cache the broken query and that means the page will not work until the cache is changed to 0,0,0,0 (or emptied).  The page will come back with an error that q does not exist.  I have not found a solution yet other than to disable caching on queries that might crash.

Translate
p_sim
p_sim
Participating Frequently
Aug 20, 2013 12:47 AM UTC

Check the Caching Server Settings in the ColdFusion Administrator. You might want to flush it. Pay attention with "Trusted cache" and "Cache Template In Request".

Translate
KevlarAuthor
Inspiring
Aug 20, 2013 7:25 PM UTC

Trusted cache is off... Cache template in request is on, but I don't see how either of those options would affect a query though because we are talking about queries here, not pages (or am I wrong)?

Flushing the query cache makes everything work again until the process restarts when the query crashes mid run and then the crashed query gets cached.

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices