Jan Stastny created TEIID-3983:
----------------------------------
Summary: External Materialization MATVIEW_ONERROR_ACTION WAIT problem
Key: TEIID-3983
URL:
https://issues.jboss.org/browse/TEIID-3983
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12.5
Reporter: Jan Stastny
Assignee: Steven Hawkins
When using "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT' option in
materialized view definition, there's problem with blocked request.
The blocked request is the one, that triggered the materialized view's loading (first
query on the defined materialized view). After such request, one can observe, that the
query execution doesn't end, but hangs.
Meanwhile while examining the contents of 'status' table in the underlying
database, the LoadNumber column's value increases regularly according to the defined
ttl. Moreover the 'LOADSTATE' column changes from LOADING to LOADED in similar
manner. The materialized table is populated with correct data. From this I assume,
materialization is set up correctly.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)