tracker issue : CF-4034570

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

Ehcache with CFQuery: not responsive and stops caching after Query Cache Size reached

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Peter Schulz / Peter Schulz (Peter Schulz)

Created: 08/11/2015

Components: Caching

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final / CF11 Update7,CF10 Update18

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win 2008 Server R2

Vote Count: 1

Listed in the version 11.0.07.296330 Issues Fixed doc 
Related Bugs:
CF-4074050 - Similar to


We have troubles with Ehcache and CFQuery caching. We are using https://wikidocs.adobe.com/wiki/display/coldfusionen/Optimizing+ColdFusion+applications as reference.

In Test #1 without using internal query cache, we have timeouts after maximum "Query Cache Size" value 250 is reached.
In Test #2 with using internal query cache, after the maximum "Query Cache Size" is reached our queries will no longer be cached.

Use attachment ehcache.zip to reproduction

---------------------------------------------------------------------------------------
Test in Browser #1: USEINTERNALQUERYCACHE = FALSE
---------------------------------------------------------------------------------------
Open URL:        /internal_false/?cache=1 (CACHED=false)
Refresh URL:   /internal_false/?cache=1 (CACHED=true)

Open URL:        /internal_false/?cache=2 (CACHED=false)
RefreshURL:   /internal_false/?cache=2 (TIMEOUT)

Open URL:        /internal_false/?cache=3 (CACHED=false)
Refresh URL:   /internal_false/?cache=3 (TIMEOUT)

Open URL:        /internal_false/?cache=4 (CACHED=false)
Refresh URL:   /internal_false/?cache=4 (TIMEOUT)

Show DATABASE - Query Cache Status: /internal_false/monitor.png

Click CLEAR & KILL to test again
---------------------------------------------------------------------------------------
Test in Browser #2: USEINTERNALQUERYCACHE = TRUE
---------------------------------------------------------------------------------------
Open URL:        /internal_ true/?cache=1 (CACHED=false)
Refresh URL:   /internal_ true/?cache=1 (CACHED=true)

Open URL:        /internal_ true/?cache=2 (CACHED=false)
Refresh URL:   /internal_ true/?cache=2 (CACHED=true)

Open URL:        /internal_ true/?cache=3 (CACHED=false)
Refresh URL:   /internal_ true/?cache=3 (CACHED=false)

Open URL:        /internal_ true/?cache=4 (CACHED=false)
Refresh URL:   /internal_ true/?cache=4 (CACHED=false)

Click CLEAR & KILL to test again

Show DATABASE - Query Cache Status: /internal_true/monitor.png

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

Watson Bug ID:	4034570

External Customer Info:
External Company:  
External Customer Name: Peter
External Customer Email:  
External Test Config: Patch level: Coldfusion 10 Updater 16 



Coldfusion Server Settings

---------------------------------------

Query Cache Size = 250

Use Internal Cache = false

Attachments:

  1. August 11, 2015 00:00:00: 1_ehcache.zip

Comments:

I used both files without any modifications and started getting timeout errors while refreshing the "internal_false" cached query pages (after loop 50). All queries should have been cached, so I'm not sure why the performance would be worse. I didn't receive any timeout errors when testing "internal_true", but going page to "cache=1" would reveal that the first 100 cached queries were no longer cached after loading/refreshing "cache=2".
Comment by External U.
6293 | August 12, 2015 03:03:53 PM GMT
+1 ......................
Vote by External U.
6298 | September 28, 2015 03:58:35 AM GMT
Fixed? In ColdFusion 12, 11 or 10? (NOTE: Issue was reported in v10.)
Comment by External U.
6294 | October 14, 2015 09:40:57 AM GMT
This fix will be part of upcoming updates for CF10 and CF11. Please note that the internal query cache issue where the query objects are not cached after certain extent is partially fixed. Have raised another bug for same - bug #CF-4074050. This will be fixed eventually. Thanks.
Comment by Akhila K.
6295 | October 15, 2015 01:18:33 AM GMT
Verified this is fixed in CF11 Update 7 (build 11,0,07,296330) w/ the exception of the issues in ticket CF-4074050. Thanks!, -Aaron
Comment by External U.
6296 | December 03, 2015 03:40:34 AM GMT
The issue is not fixed in Updater 18. Adobe support has not fully understood the bug yet. They thought it is fixed, but they misunderstood how their own caching works.
Comment by External U.
6297 | March 03, 2016 07:45:00 AM GMT