EDS Cache Hint TTL doesn't seem to be working
Issue
- It looks like the ttl set on the cache hint for resultset caching is not working as expected. If you have a look at the logs, I have purposely left it for 3 minutes apart and I was expecting the latter query will go off fetching the data from the database but it did not.
SQL:
/*+ cache ttl:60000 */ select * from WH_SOURCES_D
LOGS:
2014-01-06 17:14:45,362 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2014-01-06 17:14:45.362 requestID=6TTYNuMJLR3A.8 txID=null sessionID=6TTYNuMJLR3A applicationName=JDBC principal=app-DAL@teiid-security vdbName=MV vdbVersion=1 sql=/*+ cache ttl:60000 */ select * from WH_SOURCES_D
2014-01-06 17:14:46,291 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue1019) END USER COMMAND: endTime=2014-01-06 17:14:46.291 requestID=6TTYNuMJLR3A.8 txID=null sessionID=6TTYNuMJLR3A principal=app-DAL@teiid-security vdbName=MV vdbVersion=1 finalRowCount=-1
2014-01-06 17:17:58,615 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START USER COMMAND: startTime=2014-01-06 17:17:58.615 requestID=6TTYNuMJLR3A.9 txID=null sessionID=6TTYNuMJLR3A applicationName=JDBC principal=app-DAL@teiid-security vdbName=MV vdbVersion=1 sql=/*+ cache ttl:60000 */ select * from WH_SOURCES_D
2014-01-06 17:17:59,695 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue1051) END USER COMMAND: endTime=2014-01-06 17:17:59.695 requestID=6TTYNuMJLR3A.9 txID=null sessionID=6TTYNuMJLR3A principal=app-DAL@teiid-security vdbName=MV vdbVersion=1 finalRowCount=-1
Environment
- Red Hat JBoss Data Services (EDS) 5.3.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.