]
Steven Hawkins commented on TEIID-4661:
---------------------------------------
What vdb are you using? Also are you testing that the subsequent query is hanging as
it's not clear from what's here that we could be in the loading state
ephemerally.
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.