Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-3126

EDS - refreshMatView does not work correctly for an internal materialized view when clustering is enabled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 5.1.0 GA
    • Fix Version/s: 5.2.0.ER2
    • Component/s: EDS
    • Labels:
      None
    • Release Notes Text:
      Hide
      https://issues.jboss.org/browse/SOA-3126

      The refreshMatView no longer refreshed the data with "teiid-cache-manager-jboss-beans.xml" enabled in a single-node environment. A software upgrade has resolved this issue so the refreshMatView now works as expected when clustering is enabled.
      Show
      https://issues.jboss.org/browse/SOA-3126 The refreshMatView no longer refreshed the data with "teiid-cache-manager-jboss-beans.xml" enabled in a single-node environment. A software upgrade has resolved this issue so the refreshMatView now works as expected when clustering is enabled.
    • Release Notes Docs Status:
      Documented as Resolved Issue

      Description

      The refreshMatView works as expected in a single node environment with 'teiid-cache-manager-jboss-beans-rename-me.xml'. Still in a single node environment, that function no longer refreshes the data with "teiid-cache-manager-jboss-beans.xml" enabled.

      To recreate:

      1. Start up an EDS instance with a vdb deployed which has an internal materialized view (IMV).

      2. Query SYSADMIN.MATVIEWS and verify LoadState = "NEEDS_LOADING"

      3. Query the IMV to populate the cache.

      4. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column

      5. run "CALL SYSADMIN.refreshMatView('view name',false)"

      6. Query SYSADMIN.MATVIEWS and verify LoadState = "LOADED". Note the value of the 'Updated' column

      7. Query the IMV to see if it pulls from the source or cache

      Expected results: Steps 3 and 5 should trigger queries to the source. Step 7 should pull from the cache without going back to the source.

        Gliffy Diagrams

          Attachments

            Issue Links

            cloned to

            Bug - A problem which impairs or prevents the functions of the product. TEIID-1657 CLONE - EDS - refreshMatView does not work correctly for an internal materialized view when clustering is enabled

            • Major - A request that should be considered seriously but is not a show stopper.
            • Closed

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  shawkins Steven Hawkins
                  Writer:
                  David Le Sage
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: