[teiid-issues] [JBoss JIRA] (TEIID-3983) External Materialization MATVIEW_ONERROR_ACTION WAIT problem

[Jan Stastny (JIRA)]

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

Jan Stastny edited comment on TEIID-3983 at 2/25/16 4:59 AM:
-------------------------------------------------------------

[~shawkins]
Commit 88fa78d doesn't respect property "teiid_rel:MATVIEW_STATUS_TABLE". There is table name 'status' hardcoded.

See https://github.com/teiid/teiid/blob/master/engine/src/main/java/org/teiid/query/function/FunctionMethods.java#L1552 .

If I create a status table with name 'status', it works as expected. Thus replacing of 'status' table name with "teiid_rel:MATVIEW_STATUS_TABLE" property value should fix the issue.


was (Author: jstastny):
[~shawkins]
Commit 88fa78d doesn't respect property "teiid_rel:MATVIEW_STATUS_TABLE". There is table name 'status' hardcoded.

See https://github.com/teiid/teiid/blob/master/engine/src/main/java/org/teiid/query/function/FunctionMethods.java#L1552 .

> 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
>             Fix For: 9.0, 8.12.5, 8.13.2
>
>
> 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.
> During the wait, when logging set to DEBUG, there appears regularly, apart from the logs about refreshing the mat view, this entry:
> {code:plain}
> [32m09:14:52,151 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2695) Request Thread 87XzBpSzkyk4.0 with state PROCESSING
> [32m09:14:52,151 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2695) Request Thread 87XzBpSzkyk4.0 - processor blocked
> {code}
> The log appears in 'ttl' determined intervals, each time after materialized table loading related entries.
> The thread mentioned is the one created after the original query execution was initiated.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)