[teiid-issues] [JBoss JIRA] (TEIID-4780) Clone TEIID-4734 (Backwards compatible solution)

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy updated TEIID-4780:
--------------------------------
      Description: This is clone of TEIID-4734, however the solution provided through it is a breaking change. This JIRA is logged to provide a non-breaking change for released Teiid versions based on comments from TEIID-4734  (was: Under some circumstances, start and stop the server several times at different points, some Materialized Views are not being updated by the server.

It is observable that in status table some views are no longer updated. In server log are being printed lots of INFO lines.

Waited more than 15 minutes and the server was not capable of recovering.

See the _StatusTableAfterStop.csv_ file to observe the status table content after stopping the server.

See the _StatusTableAfterStart.csv_ file to observe the status table content after approximately 15 minutes after restart.

Check _server.log_  for the Teiid Server log.

See that hundreds of lines similar to the following occur


{panel:title=Server.log}
2017-01-31 13:06:34,597 INFO  [org.teiid.COMMAND_LOG] (Teiid Timer0) JfGY9cInAbrb 	START USER COMMAND:	startTime=2017-01-31 13:06:34.597	requestID=JfGY9cInAbrb.0	txID=null	sessionID=JfGY9cInAbrb	applicationName=internal	principal=embedded-async	vdbName=CountryServiceListVDB	vdbVersion=1	sql=execute SYSADMIN.matViewStatus('NumberingPlan', 'numbering_plan')
{panel}

The server cannot continue to load materialized views.
)
    Fix Version/s: 9.2.1
                       (was: 9.3)
          Summary: Clone TEIID-4734 (Backwards compatible solution)  (was: Restart during materialization load, does not update Materialized views anymore)
      Environment:     (was: * Wildfly 10
* MySQL 5.6.32
* Teiid Server 9.1.2)


> Clone TEIID-4734 (Backwards compatible solution)
> ------------------------------------------------
>
>                 Key: TEIID-4780
>                 URL: https://issues.jboss.org/browse/TEIID-4780
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Common
>    Affects Versions: 9.1.2
>            Reporter: Pedro Inácio
>            Assignee: Ramesh Reddy
>             Fix For: 9.2.1
>
>
> This is clone of TEIID-4734, however the solution provided through it is a breaking change. This JIRA is logged to provide a non-breaking change for released Teiid versions based on comments from TEIID-4734



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)