Hide Forgot
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007CZAx Steps to Reproduce: 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) project_key: SOA 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
Link: Added: This issue depends TEIID-1592
Release Notes Text: Added: This is essentially a duplicate of SOA-3118, which has been fixed by TEIID-1592.
Link: Added: This issue duplicates SOA-3118
This is not the same as SOA-3118
Release Notes Text: Removed: This is essentially a duplicate of SOA-3118, which has been fixed by TEIID-1592.
Link: Added: This issue Cloned to SOA-3123
Link: Removed: This issue duplicates SOA-3118
Link: Removed: This issue depends TEIID-1592
Release Notes Docs Status: Added: Not Yet Documented Writer: Added: dlesage
Release Notes Docs Status: Removed: Not Yet Documented Added: Documented as Resolved Issue Release Notes Text: Added: 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.
Tested and closed.