Weblogic监控jndi泄露连接的方法

1、Weblogic监控jndi泄露连接的方法1 说明如果后台出现“No resources currently available in pool iscjndi to allocate to applications”类似这个错误，说明weblogic的数据库连接池满了：可以考虑通过此方法排查一下具体是程序中的什么方法导致。查看数据源监控页面，如果“当前活动连接数”超过系统配置的最大数字（系统默认是15，优化之后为150），就会出现以上错误：最大连接数配置：2 配置一：设置“非活动连接超时”参数设置后 连接在指定时间内（单位：秒）没有活动的话，WebLogic会将之释放并回收到连接池。设置步骤

2、：“数据源-（数据源名称）-连接池-非活动连接超时”1、点击“数据源-（数据源名称）”2、选择“连接池”3、展开高级内容4、找到高级中“非活动连接超时”参数，设置为1004、保存配置3 配置二：开启weblogic数据库连接泄漏日志设置步骤：“数据源-（数据源名称）-诊断 -概要文件连接使用情况”1、点击“数据源-（数据源名称）”2、点击“诊断”3、选中“概要文件连接情况”、“概要文件连接泄露”：4、保存配置4 查看日志在系统中操作，重现一下相关问题，同时监控weblogic日志，日志中会出现类似以下格式的异常信息，提供研发找到具体class进一步排查泄露原因。注意：操作之后等待一段时间，we

3、blogic自动回收连接时才产生日志，不是操作的时候立即产生。日志文件位置：/app/weblogic/user_projects/domains/【domain名称】/servers/【server名称】/logs/【server名称】.log比如总部测试环境的日志文件位置：/app/weblogic/user_projects/domains/mpsm_domain/servers/mpsmServer/logs/mpsmServer.log#<2016-11-28 上午11时20分02秒 CST> <Info> <Common> <mpsm>

4、; <mpsmServer> <ACTIVE ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1480303202391> <BEA-000628> <Created "1" resources for pool "iscjndi", out of which "1"

5、are available and "0" are unavailable.> #<2016-11-28 上午11时20分12秒 CST> <Warning> <JDBC> <mpsm> <mpsmServer> <ACTIVE ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <

6、1480303212879> <BEA-001153> <Forcibly releasing inactive/harvested connection "weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection1048" back into the data source connection pool "iscjndi", currently reserved by: java.lang.Exception at ernal.Co

7、nnectionEnv.setup(ConnectionEnv.java:366) at mon.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:373) at mon.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:339) at ernal.ConnectionPool.reserve(ConnectionPool.java:469) at ernal.ConnectionPool.res

8、erve(ConnectionPool.java:363) at ernal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125) at ernal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:158) at weblogic.jdbc.pool.Driver.connect(Driver.java:132) at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:6

9、58) at weblogic.jdbc.jts.Driver.connect(Driver.java:127) at ernal.RmiDataSource.getConnectionInternal(RmiDataSource.java:548) at ernal.RmiDataSource.getConnection(RmiDataSource.java:513) at ernal.RmiDataSource.getConnection(RmiDataSource.java:506) at org.springframework.orm.hibe

10、rnate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.AbstractBatcher

11、.prepareStatement(AbstractBatcher.java:116) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:202) at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)

12、 at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396) at com.sgcc.isc.authorize.businessduty.dao.impl.UserPostReleDao.updateUserBizRoleNum(UserPostReleDao.java:360) at com.sgcc.isc.authorize.businessduty.service.impl.UserPostReleService.saveUserPost(UserPostReleService.java:77) at

13、 com.sgcc.isc.authorize.businessduty.action.BusinessDutyController.saveUserPost(BusinessDutyController.java:314) at com.sgcc.isc.authorize.businessduty.action.BusinessDutyController$FastClassByCGLIB$f3bff139.invoke(<generated>) at xy.MethodProxy.invoke(MethodProxy.java:204) at

14、org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodIceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice

15、.java:42) at org.springframework.aop.framework.ReflectiveMethodIceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPceed(MethodInvocationProceedingJoinPoint.java:80) at com.sgcc.isc.authorize.sync.aop.ServerAop.aroundMethod

16、(ServerAop.java:138) at sun.reflect.GeneratedMethodAccessor639.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMeth

17、odWithGivenArgs(AbstractAspectJAdvice.java:621) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65) at org.springframework.aop.framework.ReflectiveMethod

18、Iceed(ReflectiveMethodInvocation.java:172) at erceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodIceed(ReflectiveMethodInvocation.java:172) at org.springframework.a

19、op.framework.Cglib2AopProxy$DynamicAdvisedIercept(Cglib2AopProxy.java:622) at com.sgcc.isc.authorize.businessduty.action.BusinessDutyController$EnhancerByCGLIB$94f3347a.saveUserPost(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeM

20、ethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:

21、213) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) at org.springframework.web.servlet.mvc

22、.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) at org.springframework.web.servlet.mvc.method.Abstrac

23、tHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) at org.springframework.web.servlet.FrameworkServle

24、cessRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at ernal.StubSecurityH

25、elper$ServletServiceAction.run(StubSecurityHelper.java:227) at ernal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at ernal.ServletStubImpl.execute(ServletStubImpl.java:301) at ernal.TailFilter.doFilter(TailFilter.java:26) a

26、t ernal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at mon.filter.AuthorFilter.doFilter(AuthorFilter.java:57) at ernal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at mon.filter.CurrentThreadContextInitFilter.doFilter(CurrentThreadContextInitFilter.java:43) at ernal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFil