Bug 781013 (SOA-3493) - Internal materialized views are not refreshed on both nodes in a Single, Non-Multihomed, Server
Summary: Internal materialized views are not refreshed on both nodes in a Single, Non-...
Keywords:
Status: CLOSED NOTABUG
Alias: SOA-3493
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER5
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-17 15:57 UTC by Paul Nittel
Modified: 2011-11-15 17:48 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Fedora 14
Last Closed: 2011-11-15 17:48:47 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3493 0 Major Closed Internal materialized views are not refreshed on both nodes in a Single, Non-Multihomed, Server 2014-01-21 14:52:22 UTC

Description Paul Nittel 2011-10-17 15:57:08 UTC
Steps to Reproduce: Install EDS in production profile
Copy profile to node1 and node2
Copy datasources and VDB to both deploy directories
Start both servers
Query cluster: SELECT * FROM PartsVirtual.SupplierInfo
Query each node: SELECT * FROM SYSADMIN.MatViews
Note the LoadState column and Updated timestamp
Wait a minute
Query cluster: SELECT * FROM PartsVirtual.SupplierInfo
Query each node: SELECT * FROM SYSADMIN.MatViews
Note the LoadState column and Updated timestamp
On each node CALL SYSADMIN.refreshMatView('PartsVirtual.SupplierInfo',false)
Query each node: SELECT * FROM SYSADMIN.MatViews
Note the LoadState column and Updated timestamp
project_key: SOA

I have a cluster which is configured as a two-node single, non-multihomed, server. On each node (deployed as "Production" and named "node1" and "node2") I have deployed identical datasources and VDB.

Shouldn't Materialized View management take place on all nodes in a cluster?

The servers are started using:
nohup ./run.sh -c node1 -g EDSPartition -b IPaddress -u 239.255.100.100 -Djboss.Domain=EDS -Djboss.jvmRoute="node1" -Djboss.messaging.ServerPeerID=1 -Djboss.service.binding.set=ports-default &>node1.out &

nohup ./run.sh -c node2 -g EDSPartition -b IPaddress -u 239.255.100.100 -Djboss.Domain=EDS -Djboss.jvmRoute="node2" -Djboss.messaging.ServerPeerID=2 -Djboss.service.binding.set=ports-01 &>node2.out &

I connect to the VDB using the following URL:
mm://IPaddress:31000,IPaddress:31100

Querying the IMV table (PartsVirtual.SupplierInfo) loads one of the nodes, but not both. I can refresh both nodes by CALLing SYSADMIN.refreshMatView on each node in the cluster.

Additionally, the transformation being queried contains a TTL of 30 seconds which never appears to expire. (It works as expected in a non-clustered environment.)

Comment 1 Van Halbert 2011-10-17 15:57:08 UTC
Link: Added: This issue Cloned from TEIID-1782


Comment 2 Van Halbert 2011-10-17 15:58:01 UTC
Security: Added: Public


Comment 3 Van Halbert 2011-10-18 18:58:34 UTC
This turned out to be a user error.


Note You need to log in before you can comment on or make changes to this bug.