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 -
Verify By kparikh
Component/s Agent [ 10320 ]
Component/s Agent [ 10070 ]
Regression No
Key HPM-371 HHQ-4311
Ranking 0
Project Hyperic Product Management [ 10130 ] Hyperic HQ [ 10022 ]
Kashyap Parikh made changes -
Priority Trivial [ 5 ] Critical [ 2 ]
Tags 450musthave
Fix Version/s 4.5 Sprint 30 [ 10688 ]
Jennifer Hickey made changes -
Story Points 3
Jennifer Hickey made changes -
Fix Version/s 4.5 RC1 [ 10686 ]
Fix Version/s 4.5 [ 10615 ]
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:
    3 years, 26 weeks, 1 day ago