tracker issue : CF-3835765

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

Unable to use ehcache disk persistence for Query Cache

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (S V Pavankumar)

Created: 10/07/2014

Components: Caching

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: CF10 /

Priority/Frequency: Normal / Few users will encounter

Locale/System: ALL / Mac 10 All,Win XP All

Vote Count: 0

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_fixed on July 27, 2017 using build 2016.0.01.298513
Problem:

Method:
set ehcache disk store to some location in ehcache.xml
    <diskStore path="C:\work\cf_main\cfusion\cache"/>

configure a cache with disk persistence in ehcache.xml
name="mycache"
        maxElementsInMemory="10000"
        eternal="false"
        timeToIdleSeconds="86400"
        timeToLiveSeconds="86400"
        overflowToDisk="true"
        diskSpoolBufferSizeMB="30"
        maxElementsOnDisk="10000000"
        diskPersistent="true"
        diskExpiryThreadIntervalSeconds="3600"
        memoryStoreEvictionPolicy="LRU"
		clearOnFlush="true"
		statistics="true"
            />
 
use this cache to store the cached queries 
<cfquery name="getArtists" datasource="cfartgallery"  CACHEREGION="mycache" cachedWithin="#createTimeSpan(0,1,0,0)#">
	SELECT *
	from artists
</cfquery>

Run this query the result gets stored in the cache as well as in the cache disk store. stop the server. Go to the directory where your ehcache disk store is configured you will be able to see that cache got persisted. 

Start the server and try running this query
1) If request time out is not set query runs indefinitely.
2) If request time out is set will get request timed out exception.


Result:

Expected:

Workaround:

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

Watson Bug ID:	3835765

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

Verified the issue on CF10 Update 15 (build 10.0.15.292620). Verified the issue does not exist in CF11 Update 7 (build 11.0.07.296330). Verified the issue is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
10767 | July 27, 2017 06:14:45 AM GMT