Materialized view timeout possible?

[markackert]

Hi,

I'm running into an issue with a materialized view being stuck in a "loading" state. Why the view is stuck is still being researched, but one question I had is if it's possible to specify a timeout on the materialized view's attempt to load. This way, queries being run against the "loading" view won't block indefinitely. Further along that line of questioning - if a materialized view could have a timeout, would it be possible for the view to attempt another load if it failed the previous time?

Thanks!

-Mark

[rareddy]

Mark,

Currently Teiid does not provide any way define the timeout for materialization load. I believe it could be a good enhancement to make. As per reloading after failed attempt should follow.

Ramesh..

[markaddleman]

Created [TEIID-3020] Materialized View timeout on loading - JBoss Issue Tracker

We're still investigating why the materialized view gets stuck in loading state.  It seems that the either the translator or data source times out under some conditions and the translator throws an exception.  Under our application's production configuration, that exception is transformed by a delegating translator into a result set warning and under the app's debug configuration, the exception is passed along to Teiid.  Under both configurations, it the materialized view remains in loading state.  Any suggestions where we might begin looking?  We haven't had a chance yet to put together a test case to examine Teiid's behavior under these conditions.

[rareddy]

Typically when an exception occurs during the load its gets moved to LOAD FAILED state. May be the translator delegation interrupting this process?

[markaddleman]

Thanks.  I wouldn't have thought to include delegation in the test case.  We'll give that a shot.