Support Migration Notice: To update migrated JIRA cases click here to open a new case use www.vmware.com/go/sr | vFabric Hyperic 5.7.0 is Now Available

Hyperic HQ

WebSphere Connection Pool discovery fails with cell scope

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 4.5 Sprint 30, 4.5 M7, 4.5
  • Component/s: Agent / PDK
  • Environment:
    hq 4.4, was6.1 fix31 windows
  • Case Links:
    none
  • Regression:
    No
  • Story Points:
    3
  • Tags:

Description

I defined two JDBC Providers

Name: DB2 UDB for iSeries (Toolbox)
Scope: Cell=jvalkealahti-e6500Node01Cell

Name: DB2 UDB for iSeries (Toolbox) 2
Scope: Node=jvalkealahti-e6500Node01,Server=server1

Below query is used to find the providers(testing using wsadmin):


wsadmin>$AdminControl queryNames WebSphere:type=JDBCProvider,process=server1,node=jvalkealahti-e6500Node01,*

"WebSphere:name=DB2 UDB for iSeries (Toolbox) 2,process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/nodes/jvalkealahti-e6500Node01/servers/server1/resources.xml#JDBCProvider_1284720274816,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

"WebSphere:name=DB2 UDB for iSeries (Toolbox),process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/resources.xml#JDBCProvider_1284719944232,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

"WebSphere:name=Derby JDBC Provider (XA),process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/nodes/jvalkealahti-e6500Node01/servers/server1/resources.xml#builtin_jdbcprovider,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

"WebSphere:name=Derby JDBC Provider (XA),process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/resources.xml#builtin_jdbcprovider,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

"WebSphere:name=Derby JDBC Provider,process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/nodes/jvalkealahti-e6500Node01/servers/server1/resources.xml#JDBCProvider_1284588046356,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

"WebSphere:name=Samples Derby JDBC Provider (XA),process=server1,platform=dynamicproxy,node=jvalkealahti-e6500Node01,j2eeType=JDBCResource,J2EEServer=server1,Server=server1,version=6.1.0.31,type=JDBCProvider,mbeanIdentifier=cells/jvalkealahti-e6500Node01Cell/nodes/jvalkealahti-e6500Node01/servers/server1/resources.xml#JDBCProvider_1284588062152,cell=jvalkealahti-e6500Node01Cell,spec=1.0"

JDBCProviderQuery is using this check agains the results:

public boolean apply(ObjectName name) {
String server = name.getKeyProperty("Server");
String id = name.getKeyProperty("mbeanIdentifier");
if ((server == null) || (id == null)) { return super.apply(name); }
else { return id.indexOf(server) != -1; }
}

There's also comment in ConnectionPoolCollector:

//XXX seen in samples, two beans where all attributes are equal
//with the exception of mbeanIdentifier

"server1" is checked from mbeanIdentifier which fails because it's not there(because it's on cell level).

Indeed we can have provider with same name if one is in cell level and other in node/server level. WAS admin console allows you to create providers with same name even with same scope. So we need to find a way to detect this stuff without having duplicates.

Issue Links

Activity

Janne Valkealahti made changes -
Field Original Value New Value
Attachment WAS-jdbc-providers.png [ 30228 ]
Janne Valkealahti made changes -
Environment hq 4.4 hq 4.4, was6.1 fix31 windows
Kashyap Parikh made changes -
Project Hyperic Product Management [ 10130 ] Hyperic HQ [ 10022 ]
Verify By kparikh
Regression No
Ranking 0
Component/s Agent [ 10070 ]
Key HPM-371 HHQ-4311
Component/s Agent [ 10320 ]
Kashyap Parikh made changes -
Fix Version/s 4.5 Sprint 30 [ 10688 ]
Tags 450musthave
Priority Trivial [ 5 ] Critical [ 2 ]
Jennifer Hickey made changes -
Story Points 3
Jennifer Hickey made changes -
Fix Version/s 4.5 [ 10615 ]
Fix Version/s 4.5 RC1 [ 10686 ]
German Laullon made changes -
Assignee Charles Lee [ clee ] German Laullon [ laullon ]
German Laullon made changes -
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Janne Valkealahti made changes -
Link This issue Depends on HHQ-4348 [ HHQ-4348 ]
Kashyap Parikh made changes -
Verify By kparikh fcalinda
Frederic Calindas made changes -
Attachment JDBC Providers added.jpg [ 31023 ]
Attachment JDBC Providers created.jpg [ 31022 ]
Frederic Calindas made changes -
Status Resolved [ 5 ] Closed [ 6 ]

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved:
    Last comment:
    7 years, 5 weeks ago