weblogic连接池泄漏问题,求大神指点。
因系统经常因为连接池过载导致某一节点服务宕机,特地请教各位大神,具体描述和错误栈示例如下。
1.目前使用四个节点,仅有一个节点频频出现连接池溢出,服务500的情况,但4个节点都存在泄漏的报错。
2.项目发布在nfs服务器上,四个节点的项目路径均指向该服务期。所以不存在版本差异。
3.排查过代码无明显溢出点,且报错为所有涉及到jdbc连接的方法,无法确定是由于哪一方法引起的。
4.目前的weblogic为开发模式,非活动连接过期时间设置的为120秒。
错误栈示例:
1。####<jdbc/sbk> <WEBLOGIC.JDBC.STMT.USAGE> <1> <java.lang.Exception
at weblogic.jdbc.common.internal.ConnectionPoolProfiler.addStmtUsageData(ConnectionPoolProfiler.java:264)
at weblogic.jdbc.wrapper.Statement.finishStatementProfiling(Statement.java:321)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:148)
at cn.sfkj.util.DBAccess.select(DBAccess.java:283)
at cn.sfkj.util.DBAccess.selectOne(DBAccess.java:239)
at com.PublicSystem.SelResultStr(PublicSystem.java:180)
at procomponent.DBFuncProce.getMapKeyValue(DBFuncProce.java:329)
at procomponent.DBFuncProce.callDBFuncProcetomap(DBFuncProce.java:246)
at services.info.SearchInfoServices.queryDetail(SearchInfoServices.java:46)
at action.info.SearchInfoAction.queryDetail(SearchInfoAction.java:36)
at sun.reflect.GeneratedMethodAccessor601.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:175)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at com.wondersgroup.wssuap.sso.client.SsoLoginFilter.doFilter(SsoLoginFilter.java:170)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)