在postgres返回结果c3p0之前，套接字在服务器上被关闭

Question

这只在系统处于负载状态时发生。至少在那时是值得注意的。

Postgres 8.3.14JDK 1.6Tomcat 6机器有7GB内存

我注意到我的postgres数据目录也在吞噬我的整个hd。我有一个100GB的postgres驱动器，它会在几个小时内填满它。

我有1000万行，很多连接，大部分是读。

我现在注意到这一点，因为我的使用率一夜之间增加了10倍。

share_buffers = 2GBeffecve_cache_size = 3GB其他的都保持不变

21:56:59,736 DEBUG BasicResourcePool:1620 - trace com.mchange.v2.resourcepool。BasicResourcePool@176b9ea[管理:24，未使用:1，排除:0](例如com.mchange.v2.c3p0.impl.NewPooledConnection@1c3dc66)21:56:59,736 DEBUG BasicResourcePool:1620 - trace com.mchange.v2.resourcepool。BasicResourcePool@176b9ea[管理:24，未使用:1，排除:0](例如com.mchange.v2.c3p0.impl.NewPooledConnection@1c3dc66)21:56:59,736 DEBUG BasicResourcePool:1450 - FINISHED检查过期资源。(com.mchange.v2.resourcepool.BasicResourcePool@176b9ea)21:56:59,736 DEBUG BasicResourcePool:956 -准备销毁资源:com.mchange.v2.c3p0.impl.NewPooledConnection@1e0a56221:56:59,736 DEBUG C3P0PooledConnectionPool:468 -准备销毁PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@1e0a562[21:56:59 . 736] DEBUG NewPooledConnection:564 . com.mchange.v2.c3p0.impl。NewPooledConnection@1e0a562被客户关闭。异常:DEBUG——关闭客户端堆栈跟踪com.mchange.v2.c3p0.impl.NewPooledConnection.close (NewPooledConnection.java: 564)com.mchange.v2.c3p0.impl.NewPooledConnection.close (NewPooledConnection.java: 234)pooledconnectionresourcepoolmanager.destroyresource com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool 1美元(C3P0PooledConnectionPool.java: 470)destroyresourcetask.run com.mchange.v2.resourcepool.BasicResourcePool 1美元(BasicResourcePool.java: 958)com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread.run美元(ThreadPoolAsynchronousRunner.java: 547)21:56:59,736 DEBUG C3P0PooledConnectionPool:476 -成功销毁PooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@1e0a56221:56:59,736 DEBUG BasicResourcePool:961 -成功销毁资源:com.mchange.v2.c3p0.impl.NewPooledConnection@1e0a562[21:56:59 . 737]调试NewPooledConnection:430 - com.mchange.v2.c3p0.impl。NewPooledConnection@1e0a562处理一个可投掷物。postgresql.util. psqlexception:发送到后台时发生I/O错误。org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 283)在org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java: 479)org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java: 367)org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery (AbstractJdbc2Statement.java: 271)com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery (NewProxyPreparedStatement.java: 76)org.hibernate.jdbc.AbstractBatcher.getResultSet (AbstractBatcher.java: 208)org.hibernate.loader.Loader.getResultSet (Loader.java: 1953)org.hibernate.loader.Loader.doQuery (Loader.java: 802)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java: 274)org.hibernate.loader.Loader.loadEntity (Loader.java: 2037)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 86)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 76)org.hibernate.persister.entity.AbstractEntityPersister.load (AbstractEntityPersister.java: 3268)org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource (DefaultLoadEventListener.java: 496)org.hibernate.event.def.DefaultLoadEventListener.doLoad (DefaultLoadEventListener.java: 477)org.hibernate.event.def.DefaultLoadEventListener.load (DefaultLoadEventListener.java: 227)org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad (DefaultLoadEventListener.java: 403)org.hibernate.event.def.DefaultLoadEventListener.onLoad (DefaultLoadEventListener.java: 155)org.hibernate.impl.SessionImpl.fireLoad (SessionImpl.java: 1090)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1061)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1050)com.icon.sa.common.dm.dao.BaseDao.findByIdLockedOrException (BaseDao.java: 52)在com.icon.sa.service.action.auser.ItemUpdateAction.pre (ItemUpdateAction.java: 28)com.icon.sa.service.action.BaseAction.perform (BaseAction.java: 59)com.icon.sa.ws.auser.ItemResource.update (ItemResource.java: 43)在sun.reflect.GeneratedMethodAccessor299。调用(未知源)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 616)com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider TypeOutInvoker._dispatch美元(AbstractResourceMethodDispatchProvider.java: 168)com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch (ResourceJavaMethodDispatcher.java: 70)com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept (HttpMethodRule.java: 279)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept (ResourceClassRule.java: 86)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept (RootResourceClassesRule.java: 74)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1357)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1289)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1239)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1229)com.sun.jersey.spi.container.servlet.WebComponent.service (WebComponent.java: 420)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 497)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 684)javax.servlet.http.HttpServlet.service (HttpServlet.java: 717)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 290)org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 206)org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java: 233)org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java: 191)org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java: 127)org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java: 102)org.apache.catalina.valves.RemoteIpValve.invoke (RemoteIpValve.java: 647)org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java: 109)org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java: 298)org.apache.coyote.http11.Http11AprProcessor.process (Http11AprProcessor.java: 864)org.apache.coyote.http11.Http11AprProtocol Http11ConnectionHandler.process美元(Http11AprProtocol.java: 579)org.apache.tomcat.util.net.AprEndpoint Worker.run美元(AprEndpoint.java: 1665)java.lang.Thread.run (Thread.java: 636)原因:java.net.SocketException: Socket closed在java.net.SocketInputStream.socketRead0java.net.SocketInputStream.read (SocketInputStream.java: 146)org.postgresql.core.VisibleBufferedInputStream.readMore (VisibleBufferedInputStream.java: 135)org.postgresql.core.VisibleBufferedInputStream.ensureBytes (VisibleBufferedInputStream.java: 104)org.postgresql.core.VisibleBufferedInputStream.read (VisibleBufferedInputStream.java: 73)org.postgresql.core.PGStream.ReceiveChar (PGStream.java: 259)org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java: 1620)org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 257)…58更多21:56:59 737 DEBUG SqlUtils:85 -试图将SQLException转换为SQLException。别管它。[SQLState: 08006;错误代码:0)postgresql.util. psqlexception:发送到后台时发生I/O错误。org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 283)在org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java: 479)org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java: 367)org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery (AbstractJdbc2Statement.java: 271)com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery (NewProxyPreparedStatement.java: 76)org.hibernate.jdbc.AbstractBatcher.getResultSet (AbstractBatcher.java: 208)org.hibernate.loader.Loader.getResultSet (Loader.java: 1953)org.hibernate.loader.Loader.doQuery (Loader.java: 802)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java: 274)org.hibernate.loader.Loader.loadEntity (Loader.java: 2037)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 86)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 76)org.hibernate.persister.entity.AbstractEntityPersister.load (AbstractEntityPersister.java: 3268)org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource (DefaultLoadEventListener.java: 496)org.hibernate.event.def.DefaultLoadEventListener.doLoad (DefaultLoadEventListener.java: 477)org.hibernate.event.def.DefaultLoadEventListener.load (DefaultLoadEventListener.java: 227)org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad (DefaultLoadEventListener.java: 403)org.hibernate.event.def.DefaultLoadEventListener.onLoad (DefaultLoadEventListener.java: 155)org.hibernate.impl.SessionImpl.fireLoad (SessionImpl.java: 1090)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1061)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1050)com.icon.sa.common.dm.dao.BaseDao.findByIdLockedOrException (BaseDao.java: 52)在com.icon.sa.service.action.auser.ItemUpdateAction.pre (ItemUpdateAction.java: 28)com.icon.sa.service.action.BaseAction.perform (BaseAction.java: 59)com.icon.sa.ws.auser.ItemResource.update (ItemResource.java: 43)在sun.reflect.GeneratedMethodAccessor299。调用(未知源)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 616)com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider TypeOutInvoker._dispatch美元(AbstractResourceMethodDispatchProvider.java: 168)com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch (ResourceJavaMethodDispatcher.java: 70)com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept (HttpMethodRule.java: 279)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept (ResourceClassRule.java: 86)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept (RootResourceClassesRule.java: 74)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1357)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1289)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1239)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1229)com.sun.jersey.spi.container.servlet.WebComponent.service (WebComponent.java: 420)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 497)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 684)javax.servlet.http.HttpServlet.service (HttpServlet.java: 717)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 290)org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 206)org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java: 233)org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java: 191)org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java: 127)org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java: 102)org.apache.catalina.valves.RemoteIpValve.invoke (RemoteIpValve.java: 647)org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java: 109)org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java: 298)org.apache.coyote.http11.Http11AprProcessor.process (Http11AprProcessor.java: 864)org.apache.coyote.http11.Http11AprProtocol Http11ConnectionHandler.process美元(Http11AprProtocol.java: 579)org.apache.tomcat.util.net.AprEndpoint Worker.run美元(AprEndpoint.java: 1665)java.lang.Thread.run (Thread.java: 636)原因:java.net.SocketException: Socket closed在java.net.SocketInputStream.socketRead0java.net.SocketInputStream.read (SocketInputStream.java: 146)org.postgresql.core.VisibleBufferedInputStream.readMore (VisibleBufferedInputStream.java: 135)org.postgresql.core.VisibleBufferedInputStream.ensureBytes (VisibleBufferedInputStream.java: 104)org.postgresql.core.VisibleBufferedInputStream.read (VisibleBufferedInputStream.java: 73)org.postgresql.core.PGStream.ReceiveChar (PGStream.java: 259)org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java: 1620)org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 257)…58更多21:56:59,738 DEBUG DefaultConnectionTester:126 -测试连接响应异常:postgresql.util. psqlexception:发送到后台时发生I/O错误。org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 283)在org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java: 479)org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java: 367)org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery (AbstractJdbc2Statement.java: 271)com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery (NewProxyPreparedStatement.java: 76)org.hibernate.jdbc.AbstractBatcher.getResultSet (AbstractBatcher.java: 208)org.hibernate.loader.Loader.getResultSet (Loader.java: 1953)org.hibernate.loader.Loader.doQuery (Loader.java: 802)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java: 274)org.hibernate.loader.Loader.loadEntity (Loader.java: 2037)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 86)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 76)org.hibernate.persister.entity.AbstractEntityPersister.load (AbstractEntityPersister.java: 3268)org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource (DefaultLoadEventListener.java: 496)org.hibernate.event.def.DefaultLoadEventListener.doLoad (DefaultLoadEventListener.java: 477)org.hibernate.event.def.DefaultLoadEventListener.load (DefaultLoadEventListener.java: 227)org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad (DefaultLoadEventListener.java: 403)org.hibernate.event.def.DefaultLoadEventListener.onLoad (DefaultLoadEventListener.java: 155)org.hibernate.impl.SessionImpl.fireLoad (SessionImpl.java: 1090)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1061)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1050)com.icon.sa.common.dm.dao.BaseDao.findByIdLockedOrException (BaseDao.java: 52)在com.icon.sa.service.action.auser.ItemUpdateAction.pre (ItemUpdateAction.java: 28)com.icon.sa.service.action.BaseAction.perform (BaseAction.java: 59)com.icon.sa.ws.auser.ItemResource.update (ItemResource.java: 43)在sun.reflect.GeneratedMethodAccessor299。调用(未知源)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 616)com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider TypeOutInvoker._dispatch美元(AbstractResourceMethodDispatchProvider.java: 168)com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch (ResourceJavaMethodDispatcher.java: 70)com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept (HttpMethodRule.java: 279)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept (ResourceClassRule.java: 86)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept (RootResourceClassesRule.java: 74)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1357)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1289)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1239)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1229)com.sun.jersey.spi.container.servlet.WebComponent.service (WebComponent.java: 420)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 497)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 684)javax.servlet.http.HttpServlet.service (HttpServlet.java: 717)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 290)org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 206)org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java: 233)org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java: 191)org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java: 127)org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java: 102)org.apache.catalina.valves.RemoteIpValve.invoke (RemoteIpValve.java: 647)org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java: 109)org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java: 298)org.apache.coyote.http11.Http11AprProcessor.process (Http11AprProcessor.java: 864)org.apache.coyote.http11.Http11AprProtocol Http11ConnectionHandler.process美元(Http11AprProtocol.java: 579)org.apache.tomcat.util.net.AprEndpoint Worker.run美元(AprEndpoint.java: 1665)java.lang.Thread.run (Thread.java: 636)原因:java.net.SocketException: Socket closed在java.net.SocketInputStream.socketRead0java.net.SocketInputStream.read (SocketInputStream.java: 146)org.postgresql.core.VisibleBufferedInputStream.readMore (VisibleBufferedInputStream.java: 135)org.postgresql.core.VisibleBufferedInputStream.ensureBytes (VisibleBufferedInputStream.java: 104)org.postgresql.core.VisibleBufferedInputStream.read (VisibleBufferedInputStream.java: 73)org.postgresql.core.PGStream.ReceiveChar (PGStream.java: 259)org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java: 1620)org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 257)…58更多org.postgresql.jdbc4 21:56:59,738调试DefaultConnectionTester: 194 -连接。Jdbc4Connection@3aca默认系统表连接测试失败，出现异常!postgresql.util. psqlexception:发送到后台时发生I/O错误。org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 283)在org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java: 479)org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java: 353)org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery (AbstractJdbc2Statement.java: 252)org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getTables (AbstractJdbc2DatabaseMetaData.java: 2062)com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnectionNoQuery (DefaultConnectionTester.java: 185)com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection (DefaultConnectionTester.java: 62)com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException (DefaultConnectionTester.java: 143)com.mchange.v2.c3p0.AbstractConnectionTester.statusOnException (AbstractConnectionTester.java: 82)com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable (NewPooledConnection.java: 437)com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery (NewProxyPreparedStatement.java: 93)org.hibernate.jdbc.AbstractBatcher.getResultSet (AbstractBatcher.java: 208)org.hibernate.loader.Loader.getResultSet (Loader.java: 1953)org.hibernate.loader.Loader.doQuery (Loader.java: 802)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java: 274)org.hibernate.loader.Loader.loadEntity (Loader.java: 2037)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 86)org.hibernate.loader.entity.AbstractEntityLoader.load (AbstractEntityLoader.java: 76)org.hibernate.persister.entity.AbstractEntityPersister.load (AbstractEntityPersister.java: 3268)org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource (DefaultLoadEventListener.java: 496)org.hibernate.event.def.DefaultLoadEventListener.doLoad (DefaultLoadEventListener.java: 477)org.hibernate.event.def.DefaultLoadEventListener.load (DefaultLoadEventListener.java: 227)org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad (DefaultLoadEventListener.java: 403)org.hibernate.event.def.DefaultLoadEventListener.onLoad (DefaultLoadEventListener.java: 155)org.hibernate.impl.SessionImpl.fireLoad (SessionImpl.java: 1090)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1061)org.hibernate.impl.SessionImpl.load (SessionImpl.java: 1050)com.icon.sa.common.dm.dao.BaseDao.findByIdLockedOrException (BaseDao.java: 52)在com.icon.sa.service.action.auser.ItemUpdateAction.pre (ItemUpdateAction.java: 28)com.icon.sa.service.action.BaseAction.perform (BaseAction.java: 59)com.icon.sa.ws.auser.ItemResource.update (ItemResource.java: 43)在sun.reflect.GeneratedMethodAccessor299。调用(未知源)sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 43)java.lang.reflect.Method.invoke (Method.java: 616)com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider TypeOutInvoker._dispatch美元(AbstractResourceMethodDispatchProvider.java: 168)com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch (ResourceJavaMethodDispatcher.java: 70)com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept (HttpMethodRule.java: 279)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept (SubLocatorRule.java: 121)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept (ResourceClassRule.java: 86)com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept (RightHandPathRule.java: 136)com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept (RootResourceClassesRule.java: 74)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1357)com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest (WebApplicationImpl.java: 1289)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1239)com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest (WebApplicationImpl.java: 1229)com.sun.jersey.spi.container.servlet.WebComponent.service (WebComponent.java: 420)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 497)com.sun.jersey.spi.container.servlet.ServletContainer.service (ServletContainer.java: 684)javax.servlet.http.HttpServlet.service (HttpServlet.java: 717)org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 290)org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 206)org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java: 233)org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java: 191)org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java: 127)org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java: 102)org.apache.catalina.valves.RemoteIpValve.invoke (RemoteIpValve.java: 647)org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java: 109)org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java: 298)org.apache.coyote.http11.Http11AprProcessor.process (Http11AprProcessor.java: 864)org.apache.coyote.http11.Http11AprProtocol Http11ConnectionHandler.process美元(Http11AprProtocol.java: 579)org.apache.tomcat.util.net.AprEndpoint Worker.run美元(AprEndpoint.java: 1665)java.lang.Thread.run (Thread.java: 636)造成原因:java.io.IOException: Stream closedsun.nio.cs.StreamEncoder.ensureOpen (StreamEncoder.java: 44)sun.nio.cs.StreamEncoder.flush (StreamEncoder.java: 139)java.io.OutputStreamWriter.flush (OutputStreamWriter.java: 229)org.postgresql.core.PGStream.flush (PGStream.java: 507)org.postgresql.core.v3.QueryExecutorImpl.sendSync (QueryExecutorImpl.java: 1107)org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java: 256)…64

这是我的配置

<property name="c3p0.acquire_increment">1</property> 
<property name="c3p0.idle_test_period">100</property> <!-- seconds --> 
<property name="c3p0.max_size">250</property> 
<property name="c3p0.max_statements">0</property> 
<property name="c3p0.min_size">10</property> 
<property name="c3p0.timeout">100</property> <!-- seconds --> 
<!-- Configuring Connection Testing -->
<!-- Create a test table to query for on checkout and checkin. A test table
is faster than to use the getTables default cmd. -->
<property name="automaticTestTable">c3p0_test</property>
<property name="checkoutTimeout">0</property>
<!-- This tests to make sure the connection is still valid (needed for high load system). -->
<property name="testConnectionOnCheckout">true</property>
<property name="testConnectionOnCheckin">true</property>
<!-- Configuring Recovery From Database Outages -->
<property name="acquireRetryAttempts">0</property>
<property name="acquireRetryDelay">1000</property>
<property name="breakAfterAcquireFailure">false</property>
<!-- This is a safeguard to cleanup any open, abandoned connections.
These are connections that are opened but never closed. Debug on server if this ever needs
to cleanup.
We can test without this feature (its discouraged to use)     -->
<property name="unreturnedConnectionTimeout">300</property>
<property name="debugUnreturnedConnectionStackTraces">true</property>

Answer 1

这类事情通常是由后端崩溃引起的。很可能有一个糟糕的扩展或库把事情弄得一团糟。您需要做的是检查PostgreSQL日志中的错误，或者捕获查询并尝试查看发生错误的地方。如果无法追踪问题，则可能是硬件故障。

在数据库服务器上，这种事情相对紧急，因为它可能会干扰保存的数据，甚至导致数据库损坏。我的建议是，如果你看到这样的问题，尽快寻求专业帮助。