[teiid-issues] [JBoss JIRA] (TEIID-4661) Subsequent queries hang after materialized view TTL expires.

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13384719#comment-13384719 ] 

Steven Hawkins commented on TEIID-4661:
---------------------------------------

> Can you give me some hints how to reproduce the issue?

The unit test scenario should fail without the fix.  Table loads via an access.  Wait for the ttl to expire.  Access again to trigger a lazy refresh.  Wait for the ttl to expire.  Access again - without a fix that last query was effectively hanging as it was detecting that it should wait on a load operation, which was not happening.

> Subsequent queries hang after materialized view TTL expires.
> ------------------------------------------------------------
>
>                 Key: TEIID-4661
>                 URL: https://issues.jboss.org/browse/TEIID-4661
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12.x
>            Reporter: Colin Mondesir
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 9.0.6, 9.1.2, 9.2, 8.12.10.6_3
>
>
> With a VDB using lazy-invalidate in a clustered configuration initially the materialized view is cached correctly but when the TTL expires (10 minutes) and the query is run again the state of the view changes to LOADING and never reverts to "LOADED", so the next query hangs.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)