[teiid-issues] [JBoss JIRA] (TEIID-4758) Permanent materialization load failure is when target source goes down
[
https://issues.jboss.org/browse/TEIID-4758?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-4758:
-------------------------------------
[~shawkins] Can you tell how the exception propagation is handled in Teiid procedure
language? If a inner block throws an exception but does not catch it, but outer block has
catch is it propagated to that? for ex:
{code}
CREATE VIRTUAL PROCEDURE ...
BEGIN
IF (FOO is 'BAR')
BEGIN
IF (X <> Y)
BEGIN
RAISE EXCEPTION ...;
END
EXCEPTION
logMsg("exception caught");
END
END
{code}
Permanent materialization load failure is when target source goes
down
----------------------------------------------------------------------
Key: TEIID-4758
URL: https://issues.jboss.org/browse/TEIID-4758
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 8.12
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
During the external materialization load, if the target cache database goes offline, the
materialization job stops, but the {{Status}} table is left in {{LOADING}} state, which
will never recover when the target cache database comes back up again.
This situation is observed when JDG is used in OpenShift along with JDV However, behavior
can occur in standalone situations too. The system should resilient and must recover in
this situation.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)