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

[Jan Stastny (JIRA)]

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

Jan Stastny edited comment on TEIID-4661 at 3/29/17 1:34 AM:
-------------------------------------------------------------

I am afraid I can't reproduce the issue. When I do, what you suggest, everything works fine.

So let me summarize:
* I have 2 standalone-ha servers
* resultset-repl is a replicated cache as posted above
* I have the vdb above
* I query the mat-view first time, check that status is back to LOADED
* I query the mat-view second time, check that status is back to LOADED
* I query the mat-view third time, check that status is back to LOADED

And all the above passes, is it safe to say the issue has been resolved (Even though I haven't been able to reproduce it on 8.12.x version at all)?


was (Author: jstastny):
I am afraid I can't reproduce the issue. When I do, what you suggest, everything works fine.

So let me summarize:
* I have 2 standalone-ha servers
* resultset-repl is a replicated cache as posted above
* I have the vdb above
* I query the mat-view first time, check that status is back to LOADED
* I query the mat-view second time, check that status is back to LOADED
* I query the mat-view third time, check that status is back to LOADED
And all the above passes, is it safe to say the issue has been resolved (Even though I haven't been able to reproduce it on 8.12.x version at all)?

> 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)