EDS Cache Hint TTL doesn't seem to be working

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In