Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4779 External materialization Issues
  3. TEIID-4734

Restart during materialization load, does not update Materialized views anymore

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Done
    • Major
    • 9.3
    • 9.1.2
    • Common

    Description

      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

      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')

      The server cannot continue to load materialized views.

      Attachments

        Issue Links

          is cloned by

          Sub-task - The sub-task of the issue TEIID-4780 Clone TEIID-4734 (Backwards compatible solution)

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved
          is related to

          Sub-task - The sub-task of the issue TEIID-4775 External materialization, after transaction timeout, LoadState continues to be LOADING

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-rareddy Ramesh Reddy
              pringi Pedro Inácio (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: