tracker issue : CF-3584684

select a category, or use search below
(searches all categories and all time range)

Error when using CFQUERY's cachedWithin with value > 15 days

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): alex jung / alex jung (alex jung)

Created: 06/25/2013

Components: Caching

Versions: 10.0

Failure Type: Crash

Found In Build/Fixed In Build: Final / CF10_Update14

Priority/Frequency: Critical / Some users will encounter

Locale/System: English / Platforms All

Vote Count: 3

Problem Description:
Encountered an issue with a CFQUERY against an Oracle 11g database with a cachedWithin value equal to createTimeSpan(30, 0, 0, 0).  This is a query against reference data not very likely to change (e.g. US State codes & names).  This causes an error of "timeToLive can't be negative"

Steps to Reproduce:
- create query with cachedWithin="#createTimeSpan(30, 0, 0, 0)#"
- run query

Actual Result:
Error: "timeToLive can't be negative"

Expected Result:
Initial query hits the DB
Subsequent query w/in 30 days hits memory

Any Workarounds:
- Using a cacheRegion + cacheId apparently does not cause crash.
- Alternatively, setting cachedWithin < 15 days apparently does not cause crash

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3584684

Deployment Phase:	Release Candidate

External Customer Info:
External Company:  
External Customer Name: alex_jung
External Customer Email:  
External Test Config: My Hardware and Environment details:

Win 7-64bit

Apache 2.2 64bit

CF10-64bit standalone



have selected platform = "all", as I have replicated on Win & Linux
Comment by External U.
15128 | June 25, 2013 11:59:47 AM GMT
ps, this seems to work fine in previous CF versions
Comment by External U.
15129 | June 25, 2013 12:01:33 PM GMT
I get the same error on CF10 Enterprise + MS SQL 2008.
Comment by External U.
15130 | August 19, 2013 11:36:51 AM GMT
I get the same error on CF10 Enterprise + MS SQL 2008.
Vote by External U.
15133 | August 19, 2013 11:37:26 AM GMT
Verified in CF10 Update 11 with mssql 2008: <cfobjectcache action = "clear" /> <cfquery datasource= "sqlserver2008_merant" cachedWithin="#createTimeSpan(30, 0, 0, 0)#" name="test"> select * from testTableFor51595 </cfquery> This gives error: timeToLive can't be negative (Comment added from ex-user id:nawani)
Comment by Adobe D.
15131 | September 16, 2013 08:46:07 AM GMT
Seeing this also in CF 10 with MS SQL 2012 on Window2 2008. Changing to 15 days resolved the issue.
Comment by External U.
15132 | November 01, 2013 03:15:51 PM GMT
Just ran into this same issue. I have a query that I cached for 30 days. In CF 9 it works fine, in CF10, I get the timeToLive error as this bug states. I changed the cache time to 14 days (<15) and it ran fine. Please fix.
Vote by External U.
15134 | November 14, 2013 09:04:25 PM GMT
Same here. I am on CF10 upgrade 12, IIS7, Win2008. Awful, awful bug to say the least. Please fix!
Vote by External U.
15135 | December 07, 2013 12:16:36 AM GMT