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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content