CF 2016 - Query Caching Issue - cfstoredprocprocedure| View in Tracker
Reporter/Name(from Bugbase): Allwyn Duari Raj / ()
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: Found in Production /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Win 2012 Server x64
Vote Count: 0
Problem Description: We’ve encountered query caching issues in our recently migrated CF 2016 environment. Our legacy system is CF 10, where the same caching procedure is working perfectly fine. See below for more details and advise on your recommendations to resolve this problem. Steps to Reproduce: Existing Caching Procedure: - We are caching cfstroredproc result set. See below code snippet. <cfsetvar cacheVar =createTimeSpan(,,30,)> <cfifarguments.clearSPCacheeq"true"> <cfset cacheVar =createTimeSpan(,,,-1)> </cfif> <cfstoredprocprocedure="PROC_NAME"datasource="#DSN#"cachedwithin="#cacheVar#"> <cfprocparamvariable="v1"value="#val1#"type="in"cfsqltype="cf_sql_integer"> <cfprocresultname="procQuery"> </cfstoredproc> Actual Result: - We are using -1 for clearing/expiring the cache. - This is working perfectly fine in CF 10, but we are having problem in clearing the cache in CF 2016, that it just skipping and returning the cached result despite -1. Expected Result: Any Workarounds: I found some similar bug in adobe bug tracker and the fix is available at CF 2016 update 5. https://tracker.adobe.com/#/view/CF-4198816 https://tracker.adobe.com/#/view/CF-4198980 https://helpx.adobe.com/coldfusion/kb/bugs-fixed-coldfusion-2016-update-5.html#bugsfixed We have tried to update specific CF instance to Update 5 and still we are seeing the same problem. Based on what we see in the update 5 fix explanations(CF-4198816 & CF-4198817), we assume the fixes were applicable only for cfquery but we are using cfstoredproc. Hence no workaround so far. Right now, as a work around we've cached the query in session object and handling it.