[jboss-user] [JCA/JBoss] - Re: Message DB + Oracle database connection count problems

sks4jboss do-not-reply at jboss.com
Wed Jul 25 00:52:20 EDT 2007 

Hi Adrian,

This is lot of useful info. 

1) We have been watching thread dump and havent seen threads using connections while application doesn't has any available connection left. 

2) From the pool stats available in jmx-console (actually we even log AvailableConnectionCount and InUseConnectionCount every minute). For the last incident, we see that available connection count slowly reaches 0 and in use connection count was around 25 for last 20 mins. The sum of 0 and 25 is way less then 130 configured as max pool size (We miss a thread dump at that time).

Need to also use CachedConnectionManager.  

Used CachedConnectionManager to view inuse connections under normal operations of the system. I find the below stacktrace. But interestingly I dont find any such thread in thread dump. 
    So does this means that this is an example of not closing the connection ? (This should definitely help in finding out when the connections are not closed.) 

Any further clue about why 0 (Avl conn cnt) + 25  (in use conn cnt) << 130 (Conf max num connections). I am definitely reading the wiki page created for me. 

anonymous wrote : 
  | 
  | {org.jboss.resource.adapter.jdbc.WrappedConnection at 10e0edb=java.lang.Exception: STACKTRACE
  | 	at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:321)
  | 	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:467)
  | 	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:874)
  | 	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
  | 	at com.mobilgw.sam.common.WFComponentFactory.(WFComponentFactory.java:123)
  | .............
  | .............
  | 	at javax.servlet.GenericServlet.init(GenericServlet.java:211)
  | 	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
  | 	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
  | 	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
  | 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
  | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
  | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
  | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
  | 	at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:274)
  | 	at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:91)
  | 	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
  | 	at org.jboss.web.WebModule.startModule(WebModule.java:68)
  | 	at org.jboss.web.WebModule.startService(WebModule.java:46)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
  | 	at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:418)
  | 	at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | 	at $Proxy24.start(Unknown Source)
  | 	at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:394)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
  | 	at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | 	at $Proxy8.deploy(Unknown Source)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:325)
  | 	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:501)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
  | 	at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
  | 	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
  | 	at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
  | 	at $Proxy0.start(Unknown Source)
  | 	at org.jboss.system.ServiceController.start(ServiceController.java:418)
  | 	at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | 	at $Proxy4.start(Unknown Source)
  | 	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:273)
  | 	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
  | 	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:722)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | 	at java.lang.reflect.Method.invoke(Method.java:324)
  | 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | 	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
  | 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
  | 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
  | 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
  | 	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | 	at $Proxy5.deploy(Unknown Source)
  | 	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:434)
  | 	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:315)
  | 	at org.jboss.Main.boot(Main.java:195)
  | 	at org.jboss.Main$1.run(Main.java:463)
  | 	at java.lang.Thread.run(Thread.java:534)
  | 
  | 


Thanks again, Info is really useful.
Sudarshan


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067288#4067288

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067288

More information about the jboss-user mailing list