Bug 780677 (SOA-3119)

Summary:	EDS - Node returns 0 rows for cached view when other node had it loaded and leaves cluster
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	dsteigne
Component:	EDS	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.1.0 GA
Target Milestone:	---
Target Release:	5.2.0 ER1
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-3119
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-10-25 15:33:31 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description dsteigne 2011-06-22 19:14:18 UTC

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

Comment 1 Van Halbert 2011-06-23 16:40:26 UTC

Link: Added: This issue depends TEIID-1592

Comment 2 Van Halbert 2011-06-23 16:41:50 UTC

Release Notes Text: Added: This is essentially a duplicate of SOA-3118, which has been fixed by TEIID-1592.

Comment 3 Van Halbert 2011-06-23 16:42:41 UTC

Link: Added: This issue duplicates SOA-3118

Comment 4 Steven Hawkins 2011-06-23 16:52:48 UTC

This is not the same as SOA-3118

Comment 5 Steven Hawkins 2011-06-23 16:55:38 UTC

Release Notes Text: Removed: This is essentially a duplicate of SOA-3118, which has been fixed by TEIID-1592.

Comment 6 Steven Hawkins 2011-06-23 16:56:46 UTC

Link: Added: This issue Cloned to SOA-3123

Comment 7 Steven Hawkins 2011-06-23 18:36:41 UTC

Link: Removed: This issue duplicates SOA-3118

Comment 8 Steven Hawkins 2011-06-23 18:37:03 UTC

Link: Removed: This issue depends TEIID-1592

Comment 10 David Le Sage 2011-07-15 05:47:19 UTC

Release Notes Docs Status: Added: Not Yet Documented
Writer: Added: dlesage

Comment 11 David Le Sage 2011-09-28 01:18:18 UTC

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.

Comment 12 Paul Nittel 2011-10-25 15:33:31 UTC

Tested and closed.