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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
