C/S系统,服务器端用apache tomcat提供服务,thin连接Oracle,客户端最大连接一般100个左右,并发数一般不会超过10个。服务启动一段时间后,会报“Cannot get a connection, pool exhausted”,重启tomcat后正常。从春节开始至今,共发生了2次这种情况,下面是部分系统日志。
2009-02-18 16:15:48 setProcSql:call kingstar.p70502011(?,?,?,?,?,?,?,?,?,?,?)
setProcInParameter(1,12,2)
setProcInParameter(2,335,2)
setProcInParameter(3,11,2)
setProcInParameter(4,-1,1)
setProcInParameter(5,1,1)
setProcInParameter(6,5,2)
setProcInParameter(7,000400008888
000400011986
000400012039
000400012073
000400012127
000400012158
000400012191
000400012202,1)
setProcInParameter(8,20090218,1)
setProcInParameter(9,342,2)
setProcOutParameter(10,2)
setProcOutParameter(11,1)
2009-02-18 16:15:53 failed to get connection
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.kingstar.data.DbClass.openprvConnect(DbClass.java:109)
at com.kingstar.data.DbClass.resultIntoArray(DbClass.java:696)
at com.kingstar.data.DbClass.execQuery(DbClass.java:301)
at com.kingstar.data.DbClass.execQuery(DbClass.java:289)
at com.kingstar.service.SecuritiesCrmManage.CrmCommFunc.SCRMgetShowList(CrmCommFunc.java:25)
at com.kingstar.service.SecuritiesCrmManage.ServiceSecuritiesCrmManage.SCRMgetShowList(ServiceSecuritiesCrmManage.java:26)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.kingstar.html.EncodingFilter.doFilter(EncodingFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:756)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
... 49 more
tomcat的连接配置如下:
</parameter>
<parameter>
<name>maxActive</name>
<value>30</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>600</value>
</parameter>
</ResourceParams>
</Context>
怀疑有程序一直占着数据库连接不释放,但其它的地方没发现这个问题,不知道是不是服务器太烂的原因。PS:服务器是一2G内存的台式电脑。
分享到:
相关推荐
dbcp 连接池不合理的锁导致连接耗尽解决方案 ... nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.springframework.jdbc.dataso
使用spring + atomikos+druid配置的分布式事务demo,两种数据源配置方式都可以,使用junit测试没问题,案例中使用的mysql数据库是8.0.11版本,版本不同请自行修改pom.xml和jdbc.properties
主要介绍了阿里dubbo出错提示Thread pool is EXHAUSTED的问题及解决方法,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
o POOL-152: GenericObjectPool can block forever in borrowObject when the pool is exhausted and a newly created object fails validation. When borrowing an object if a new object is created but ...
编译时virtual memory exhausted Cannot allocate memory 内存增加.docx
php Allowed memory size of 134217728 bytes exhausted
php解决Allowed memory size of bytes exhausted
connection pool exhausted connection refuse by peer 一个个来分析。 LOADING Redis is loading the dataset in memory 这里至少有2种可能 可用内存太小,修改 redis.conf 中的 maxmemory 即可解决 redis 在...
Until now, a PG connection was used. - In the device dialog of the communication way "MPI/PB CIF", the input fields "Rack:" and "slot no. of CPU" have been added. This extension now allows the ...
今天在百度知道看php相关资料时发现一个网友问一个wordpress安装提示错误的一个问题,说他在安装wordpress安装包时遇到这样一个问题:Fatal error:Allowed memory size of 67108864 bytes exhausted (tried to ...
主要介绍了Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2611816 bytes)错误的解决方法,需要的朋友可以参考下
虚拟内存不足方案虚拟内存不足方案虚拟内存不足方案虚拟内存不足方案虚拟内存不足方案虚拟内存不足方案虚拟内存不足方案
Websphere Application Server WAS 内存溢出分析,帮助分析内存问题
and larger, everyone suffers when disk space is exhausted. With POP, saved messages get offloaded from the mail server. MIME MIME stands for Multipurpose Internet Mail Extensions. It is not a ...
But what do you do once you’ve exhausted your to-build list? Arduino Playground will show you how to keep your hardware hands busy with a variety of intermediate builds, both practical and just-for...
资源枯竭型城市智慧旅游整体框架研究,杨红玉,温廷新,本文以阜新市为例,讨论资源枯竭型城市应以积极发展旅游实施智慧旅游规划为经济转型核心策略。通过分析阜新市进一步提升旅游竞争
usrlocalliblibz.a could not read symbols Bad value问题解决(64 位 Linux).doc