Teiid
  1. Teiid
  2. TEIID-1654

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

    Details

    • Type: Bug Bug
    • Status: Closed Closed (View Workflow)
    • Priority: Major Major
    • Resolution: Done
    • Affects Version/s: 7.1
    • Fix Version/s: 7.4.1, 7.5
    • Component/s: Server
    • 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)
    • Similar Issues:
      Show 10 results 

      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

        Issue Links

          Activity

          Hide
          Steven Hawkins
          added a comment -

          Updated CacheResults to not restore when batches cannot be found.

          Show
          Steven Hawkins
          added a comment - Updated CacheResults to not restore when batches cannot be found.
          Hide
          Paul Nittel
          added a comment -

          Tested and closed.

          Show
          Paul Nittel
          added a comment - Tested and closed.

            People

            • Assignee:
              Steven Hawkins
              Reporter:
              Debbie Steigner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: