you can try out tomcat-jdbc, and see if that solves your problem, it may help you narrow it down. http://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html
On Fri, Feb 28, 2014 at 11:26 AM, Mark Thomas <ma...@apache.org> wrote: > On 28/02/2014 18:22, Felipe Jaekel wrote: > > Hi, > > > > Today I tried to migrate my production server from 7.0.50 to 8.0.3. > > > > After about 3 hours running I start to get JDBC exceptions(stacktrace > > below) and the server stops responding. Looking at Amazon RDS monitoring > it > > shows the connection limit reached 97%. Restarted the server and after > > about the same time the same problem happened. > > > > With 7.0.50 the highest value reached was 60%, so I think that the > > connection pool may be leaking. > > > > I understand that DBCP2 isn't final yet. I just like to know if that is a > > known issue, so I'll return to Tomcat 7. > > It isn't a known issue. There have been some code changes since the DBCP > version that was used in 8.0.3 but nothing I recall that related to a > connection leak. It is worth taking a look at what is going on with JMX > as that might give you some hints. > > Mark > > > > > Thanks, > > Phillip > > > > > > > -------------------------------------------------------------------------------- > > > > javax.persistence.PersistenceException: > > org.hibernate.exception.GenericJDBCException: could not inspect JDBC > > autocommit mode > > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) > > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) > > at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:316) > > at > br.com.spdata.persistence.mysql.service.ErroService.checkExistente(ErroService.java:134) > > at > br.com.spdata.persistence.mysql.service.ErroService.persist(ErroService.java:58) > > at > br.com.spdata.email.AbstractErrorPageController.(AbstractErrorPageController.java:78) > > at > br.com.spdata.tecnico.ErrorPageController.(ErrorPageController.java:14) > > at sun.reflect.GeneratedConstructorAccessor798.newInstance(Unknown > Source) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > > at java.lang.Class.newInstance(Class.java:374) > > at > com.sun.faces.mgbean.BeanBuilder.newBeanInstance(BeanBuilder.java:186) > > at com.sun.faces.mgbean.BeanBuilder.build(BeanBuilder.java:100) > > at > com.sun.faces.mgbean.BeanManager.createAndPush(BeanManager.java:409) > > at com.sun.faces.mgbean.BeanManager.create(BeanManager.java:269) > > at > com.sun.faces.el.ManagedBeanELResolver.resolveBean(ManagedBeanELResolver.java:257) > > at > com.sun.faces.el.ManagedBeanELResolver.getValue(ManagedBeanELResolver.java:117) > > at > com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176) > > at > com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203) > > at > org.apache.el.parser.AstIdentifier.getValue(AstIdentifier.java:80) > > at org.apache.el.parser.AstValue.getValue(AstValue.java:135) > > at > org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:187) > > at > com.sun.faces.facelets.el.ELText$ELTextVariable.writeText(ELText.java:238) > > at > com.sun.faces.facelets.el.ELText$ELTextComposite.writeText(ELText.java:154) > > at > com.sun.faces.facelets.compiler.TextInstruction.write(TextInstruction.java:85) > > at > com.sun.faces.facelets.compiler.UIInstructions.encodeBegin(UIInstructions.java:82) > > at > com.sun.faces.facelets.compiler.UILeaf.encodeAll(UILeaf.java:183) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1859) > > at > org.primefaces.renderkit.HeadRenderer.encodeEnd(HeadRenderer.java:106) > > at > javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1863) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1859) > > at > com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:461) > > at > com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133) > > at > javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337) > > at > com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120) > > at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) > > at > com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219) > > at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:301) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) > > at > org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) > > at > org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) > > at > org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) > > at > org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) > > at > org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) > > at > org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:721) > > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:468) > > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:391) > > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318) > > at > org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:423) > > at > org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:367) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:166) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:74) > > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1015) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:652) > > at > org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1575) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1533) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at java.lang.Thread.run(Thread.java:744) > > Caused by: org.hibernate.exception.GenericJDBCException: could not > > inspect JDBC autocommit mode > > at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) > > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) > > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) > > at > org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:311) > > at > org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.afterNonTransactionalQuery(TransactionCoordinatorImpl.java:200) > > at > org.hibernate.internal.SessionImpl.afterOperation(SessionImpl.java:477) > > at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1199) > > at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) > > at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:287) > > ... 66 more > > Caused by: java.sql.SQLException: Connection > > com.mysql.jdbc.JDBC4Connection@1c4edb45 is closed. > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:569) > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.getAutoCommit(DelegatingConnection.java:366) > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.getAutoCommit(DelegatingConnection.java:371) > > at > org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:308) > > ... 71 more > > > > > > > -------------------------------------------------------------------------------- > > > > > > javax.persistence.PersistenceException: > > org.hibernate.exception.GenericJDBCException: could not prepare > > statement > > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) > > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) > > at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277) > > at > br.com.spdata.persistence.mysql.dao.AtendimentoDao.findFilaGeral(AtendimentoDao.java:45) > > at > br.com.spdata.persistence.mysql.service.chat.AtendimentoService.calculaPosicaoFila(AtendimentoService.java:482) > > at > br.com.spdata.persistence.model.chat.AbstractAtendimentoBean.getMensagemFila(AbstractAtendimentoBean.java:359) > > at sun.reflect.GeneratedMethodAccessor1166.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at javax.el.BeanELResolver.getValue(BeanELResolver.java:97) > > at > com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176) > > at > com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203) > > at org.apache.el.parser.AstValue.getValue(AstValue.java:167) > > at > org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:187) > > at > com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109) > > at > javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194) > > at > javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:182) > > at javax.faces.component.UIOutput.getValue(UIOutput.java:174) > > at > com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:205) > > at > com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:355) > > at > com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:164) > > at > javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919) > > at > com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:312) > > at > com.sun.faces.renderkit.html_basic.GridRenderer.renderRow(GridRenderer.java:185) > > at > com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:129) > > at > javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1856) > > at javax.faces.render.Renderer.encodeChildren(Renderer.java:176) > > at > javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889) > > at > org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:71) > > at > org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:58) > > at > org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:204) > > at > org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:121) > > at > org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:58) > > at > javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919) > > at > org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:75) > > at > org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:58) > > at > org.primefaces.component.outputpanel.OutputPanelRenderer.encodeMarkup(OutputPanelRenderer.java:64) > > at > org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:40) > > at > javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1863) > > at > com.sun.faces.context.PartialViewContextImpl$PhaseAwareVisitCallback.visit(PartialViewContextImpl.java:570) > > at > com.sun.faces.component.visit.PartialVisitContext.invokeVisitCallback(PartialVisitContext.java:183) > > at > javax.faces.component.UIComponent.visitTree(UIComponent.java:1689) > > at > javax.faces.component.UIComponent.visitTree(UIComponent.java:1700) > > at > javax.faces.component.UIComponent.visitTree(UIComponent.java:1700) > > at > com.sun.faces.context.PartialViewContextImpl.processComponents(PartialViewContextImpl.java:402) > > at > com.sun.faces.context.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:322) > > at > javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:219) > > at > org.primefaces.context.PrimePartialViewContext.processPartial(PrimePartialViewContext.java:59) > > at > javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:1004) > > at > javax.faces.component.UIComponent.encodeAll(UIComponent.java:1856) > > at > com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:435) > > at > com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133) > > at > javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337) > > at > com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120) > > at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) > > at > com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:219) > > at javax.faces.webapp.FacesServlet.service(FacesServlet.java:647) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:301) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.omnifaces.filter.CacheControlFilter.doFilter(CacheControlFilter.java:226) > > at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:77) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:98) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > br.com.spdata.filter.ExceptionFilter.doFilter(ExceptionFilter.java:36) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > br.com.spdata.cliente.filter.LoginFilter.doFilter(LoginFilter.java:40) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:74) > > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1015) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:652) > > at > org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1575) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1533) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at java.lang.Thread.run(Thread.java:744) > > Caused by: org.hibernate.exception.GenericJDBCException: could not > > prepare statement > > at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) > > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) > > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:193) > > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:157) > > at > org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1881) > > at > org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1858) > > at > org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) > > at org.hibernate.loader.Loader.doQuery(Loader.java:906) > > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) > > at org.hibernate.loader.Loader.doList(Loader.java:2548) > > at org.hibernate.loader.Loader.doList(Loader.java:2534) > > at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2364) > > at org.hibernate.loader.Loader.list(Loader.java:2359) > > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) > > at > org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) > > at > org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195) > > at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194) > > at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) > > at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268) > > ... 90 more > > Caused by: java.sql.SQLException: Connection > > com.mysql.jdbc.JDBC4Connection@f1e90be is closed. > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:569) > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:278) > > at > org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:280) > > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:159) > > at > org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183) > > ... 106 more > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
