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

EDS - Node returns 0 rows for cached view when other node had it loaded and leaves cluster

    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 ER1
    • Component/s: EDS
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      To recreate:

      1. Start 2 nodes in a cluster with a vdb deployed which has an internal materialized view (IMV).

      2. Query the IMV on node 1 to populate the cache on node 1.

      3. Shutdown node 1

      4. Query the IMV on node 2
      Expectation: node 2 doesn't have a copy of the cache and populates from the sources
      Actual: node 2 returns a successful result with 0 rows. No warning or error is found in the logs.

      Note: this behavior happens when the shutting down in step 3 is done gracefully (and node 2 is notified node 1 is leaving the cluster) as well as when it's done with an kill -9 (simulating a failure)

      Show
      To recreate: 1. Start 2 nodes in a cluster with a vdb deployed which has an internal materialized view (IMV). 2. Query the IMV on node 1 to populate the cache on node 1. 3. Shutdown node 1 4. Query the IMV on node 2 Expectation: node 2 doesn't have a copy of the cache and populates from the sources Actual: node 2 returns a successful result with 0 rows. No warning or error is found in the logs. Note: this behavior happens when the shutting down in step 3 is done gracefully (and node 2 is notified node 1 is leaving the cluster) as well as when it's done with an kill -9 (simulating a failure)
    • Release Notes Text:
      Hide
      https://issues.jboss.org/browse/SOA-3119

      If an internal materialized view was used, a node which had never had a copy of an IMV cache would return zero rows instead of querying the source to see if another node had cached the cluster. An upgrade to the software has now fixed this issue so users will find that the cache is interrogated correctly.
      Show
      https://issues.jboss.org/browse/SOA-3119 If an internal materialized view was used, a node which had never had a copy of an IMV cache would return zero rows instead of querying the source to see if another node had cached the cluster. An upgrade to the software has now fixed this issue so users will find that the cache is interrogated correctly.
    • Release Notes Docs Status:
      Documented as Resolved Issue

      Description

      Using an internal materialized view in EDS 5.1 with CP2, a node which never had a copy of an IMV cache will return 0 rows when it should be querying the source in situations where another node in the cluster had cached the IMV but is no longer in the cluster

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  van.halbert Van Halbert
                  Reporter:
                  dsteigne Debbie Steigner
                  Writer:
                  David Le Sage
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: