[teiid-issues] [JBoss JIRA] (TEIID-4758) Permanent materialization load failure is when target source goes down

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-4758:
-------------------------------------

This turns out to be close enough to TEIID-4775, for the fix for the server side. However this error was logged against JDG, here the issue is JDG throws a RuntimeException instead of throwing a TranslatorException as it should when a connection is not found. 

So, I am going, to convert this JIRA to fix the JDG issue, assigning to [~rhn-engineering-vhalbert]

> 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: Sub-task
>          Components: Server
>    Affects Versions: 8.12
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 9.3
>
>
> 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)