tracker issue : CF-3912610

Problem Description: Using Terracotta's offheap/clustered cache regions with a cfquery causes the server to never finish the request.  It is like it is in some infinite loop and the stats of the local disk hit rate for the custom cache region are spiking.

Steps to Reproduce: Modify the ehcache.xml to use a Terracotta server array and add a custom terracotta clustered cache region. Steps are...

Add these jar files to the \cfusion\lib\ dir...
- terracotta-toolkit-runtime-ee-4.1.5.jar
- ehcache-ee-2.8.5.jar

modify the ehcache.xml....
<terracottaConfig url="192.168.1.1:9510,192.168.1.2:9510" rejoin="true" />

<cache name="TEST"
          eternal="false"
          timeToLiveSeconds="720"
          timeToIdleSeconds="720"
          maxBytesLocalHeap="200M"
          maxBytesLocalOffHeap="1G"
          memoryStoreEvictionPolicy="LRU">
          <terracotta/>
        </cache>

Run a simple cfquery using this TEST region and the process just hangs.

<cfquery cacheRegion="TEST" cacheId="CacheID1" cachedwithin="#CreateTimeSpan(0, 0, 5, 0)#" datasource="TEST" name="TEST_QRY">
Select * from TEST
</cfquery>

<cfdump var="#TEST_QRY#" abort="true">

Actual Result: Request hangs

Expected Result: The TEST_QRY should be put in the TEST clustered cache region and returned to the request process.

Any Workarounds: You must use none-clustered cache regions or manually wrap the query results with logic using cacheGet() and cachePut() to use clustered cache regions.

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

Watson Bug ID:	3912610

External Customer Info:
External Company:  
External Customer Name: drapier99
External Customer Email:  
External Test Config: My Hardware and Environment details: CF11 running with Java 1.7.0_71 on a Windows 2008 R2 64bit server.  Tested with Terracotta Server Array 4.1.3 & 4.1.5.

Attachments:

Comments: