连接池问题

最新推荐文章于 2024-03-29 17:31:36 发布
最新推荐文章于 2024-03-29 17:31:36 发布
阅读量6.1k 收藏
点赞数
分类专栏： 2设计
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sxhong/article/details/18813241
版权 
[2014-01-27 13:40:53 112 ERROR] [http-nio-8888-exec-133] com.jeedsoft.ecp.application.action.DataServlet - Unexpected Exception
com.jeedsoft.common.basic.exception.SystemException: 获取数据库连接失败。
	at com.jeedsoft.common.advanced.transaction.atomikos.AbstractAtomikosTransactionProvider.getConnection(AbstractAtomikosTransactionProvider.java:27)
	at com.jeedsoft.common.advanced.db.ConnectionHome.getConnectionWithIsolationLevel(ConnectionHome.java:106)
	at com.jeedsoft.common.advanced.db.ConnectionHome.getConnection(ConnectionHome.java:87)
	at com.jeedsoft.common.advanced.db.Executor.getValue(Executor.java:71)
	at com.jeedsoft.common.advanced.db.Executor.getObject(Executor.java:180)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl.optItem(UserDaoImpl.java:29)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b.CGLIB$optItem$4(<generated>)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b$$FastClassByCGLIB$$b3964b84.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b.optItem(<generated>)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl.login(OnlineUserServiceImpl.java:49)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42.CGLIB$login$1(<generated>)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42$$FastClassByCGLIB$$497cf3c7.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.common.advanced.transaction.annotation.TransactionInterceptor.invoke(TransactionInterceptor.java:41)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42.login(<generated>)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl.login(OnlineUserActionImpl.java:30)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371.CGLIB$login$0(<generated>)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371$$FastClassByCGLIB$$c776cb9c.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371.login(<generated>)
	at sun.reflect.GeneratedMethodAccessor1069.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.jeedsoft.common.basic.util.ReflectUtil.invoke(ReflectUtil.java:202)
	at com.jeedsoft.ecp.application.action.DataServlet.doPost(DataServlet.java:42)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.jeedsoft.ecp.application.ValidationFilter.doFilter(ValidationFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.jeedsoft.ecp.application.ThreadFilter.doFilter(ThreadFilter.java:26)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1600)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.atomikos.jdbc.AtomikosSQLException: Connection pool exhausted - try increasing 'maxPoolSize' and/or 'borrowConnectionTimeout' on the DataSourceBean.
	at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:44)
	at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:88)
	at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:83)
	at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:326)
	at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:205)
	at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:373)
	at com.jeedsoft.common.advanced.transaction.atomikos.AbstractAtomikosTransactionProvider.getConnection(AbstractAtomikosTransactionProvider.java:25)
	... 62 more
[2014-01-27 13:41:23 127 ERROR] [http-nio-8888-exec-132] com.jeedsoft.ecp.application.action.DataServlet - Unexpected Exception
com.jeedsoft.common.basic.exception.SystemException: 获取数据库连接失败。
	at com.jeedsoft.common.advanced.transaction.atomikos.AbstractAtomikosTransactionProvider.getConnection(AbstractAtomikosTransactionProvider.java:27)
	at com.jeedsoft.common.advanced.db.ConnectionHome.getConnectionWithIsolationLevel(ConnectionHome.java:106)
	at com.jeedsoft.common.advanced.db.ConnectionHome.getConnection(ConnectionHome.java:87)
	at com.jeedsoft.common.advanced.db.Executor.getValue(Executor.java:71)
	at com.jeedsoft.common.advanced.db.Executor.getObject(Executor.java:180)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl.optItem(UserDaoImpl.java:29)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b.CGLIB$optItem$4(<generated>)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b$$FastClassByCGLIB$$b3964b84.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.dao.impl.UserDaoImpl$$EnhancerByCGLIB$$a95994b.optItem(<generated>)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl.login(OnlineUserServiceImpl.java:49)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42.CGLIB$login$1(<generated>)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42$$FastClassByCGLIB$$497cf3c7.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.common.advanced.transaction.annotation.TransactionInterceptor.invoke(TransactionInterceptor.java:41)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.service.impl.OnlineUserServiceImpl$$EnhancerByCGLIB$$9fe61b42.login(<generated>)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl.login(OnlineUserActionImpl.java:30)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371.CGLIB$login$0(<generated>)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371$$FastClassByCGLIB$$c776cb9c.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:44)
	at com.jeedsoft.ecp.registry.Registry$TimeInterceptor.invoke(Registry.java:351)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInvocation.proceed(UpwardInvocation.java:47)
	at com.jeedsoft.common.advanced.aop.cglib.UpwardInterceptor.intercept(UpwardInterceptor.java:20)
	at com.jeedsoft.ecp.user.action.impl.OnlineUserActionImpl$$EnhancerByCGLIB$$908bd371.login(<generated>)
	at sun.reflect.GeneratedMethodAccessor1069.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.jeedsoft.common.basic.util.ReflectUtil.invoke(ReflectUtil.java:202)
	at com.jeedsoft.ecp.application.action.DataServlet.doPost(DataServlet.java:42)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.jeedsoft.ecp.application.ValidationFilter.doFilter(ValidationFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.jeedsoft.ecp.application.ThreadFilter.doFilter(ThreadFilter.java:26)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1600)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.atomikos.jdbc.AtomikosSQLException: Connection pool exhausted - try increasing 'maxPoolSize' and/or 'borrowConnectionTimeout' on the DataSourceBean.
	at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:44)
	at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:88)
	at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:83)
	at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:326)
	at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:205)
	at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:373)
	at com.jeedsoft.common.advanced.transaction.atomikos.AbstractAtomikosTransactionProvider.getConnection(AbstractAtomikosTransactionProvider.java:25)
	... 62 more

sxhong
关注
专栏目录
psycopg2.pool.PoolError: connection pool exhausted
qq_41929657的博客
11-08 916
数据库连接池用完
impala java 连接池_springboot 集成impala连接池问题
weixin_29363945的博客
02-27 3096
HikariDataSource连接池配置datasource:type: com.zaxxer.hikari.HikariDataSourcedriver-class-name: com.cloudera.impala.jdbc41.Driverurl: jdbc:impala://118.31.173.39:25001/bill_gypoc_0802hikari:minimumIdle: 5m...
connection pool exhausted
qq_30505673的博客
08-24 1580
1.发现问题 生产环境发现有一些redis报错日志 connection pool exhausted。如果redis中没有数据 就直接回源 查DB。暂时不会有什么大问题。中文意思是连接池耗尽。 2.追踪问题 查看源码 我们用的redis客户端类似于redigo 按照错误提示搜索到了一段代码（基于最新的redigo 源码版本分析） // Handle limit for p.Wait == false. if !p.Wait && p.MaxActive > 0 &&
redigo连接池——redigo: connection pool exhausted
ckx178的博客
06-08 3870
网上大家好多连接池没有wait这个参数，在连接池链接数达到上限时会报错，影响程序的正常执行，这是不应该的，正常的应该添加这个参数并设置值为true，这样即使链接被用完，会阻塞等待其他协程用完归还之后继续执行： //初始化一个pool func NewRedisPool(server, password string) *redis.Pool { return &redis.Pool{...
Connection pool exhausted - try increasing 'maxPoolSize'
止境博客
04-16 5706
错误： [ERROR][-- ::,][org.hibernate.engine.jdbc.spi.SqlExceptionHelper]Connection pool exhausted - try increasing 'maxPoolSize' and/or 'borrowConnectionTimeout' on the DataSourceBean. [ERROR][-- ...
详谈Jedis连接池的使用
08-30
Jedis连接池的使用 Jedis连接池是Redis客户端Jedis的连接池实现，用于管理Redis连接的创建、释放和复用。通过使用Jedis连接池，可以提高Redis的访问性能和可靠性。在本文中，我们将详细讨论Jedis连接池的使用，包括...
C3p0连接池问题
03-21
博客文章《C3p0连接池问题》可能深入探讨了这些细节，并给出了具体的案例和解决方案。通过阅读该文章，开发者可以更好地理解和解决C3p0连接池在实际应用中可能出现的各种问题，提升系统的稳定性和效率。同时，了解C3...
weblogic连接池不释放问题解决_weblogic连接池问题总结（转载）
weixin_39805851的博客
12-24 1973
目录1. 概述 31.1 概述： 31.2 系统信息： 32. 连接池问题 52. 1 问题描述 52.2 错误日志分析 52.3连接池问题总结 143. 其他问题 143. 1 部署 143. 1 部署类型 151. 概述1.1 概述：应客户的要求，某局BATCH系统存在的问题进行诊断。经过日志分析及故障现象定位造成问题的原因，形成此份报告。为了提供系统的稳定和性能，建议针对性的修改一些参数(会...
关于数据库连接池的问题和思考
12-14
近数据中心出了一些问题，在Mysql连接上... 　数据库有自己的连接池，例如Mysql，当一种编程语言要使用Mysql数据库时，Mysql公司会编写这种语言的数据库驱动，例如vb.net的Mysql驱动，所以，当vb.net连接mysql时，mys
Connection pool exhausted - try increasing ‘maxPoolSize‘ and/or ‘borrowConnectionTimeout‘ on the Dat
最新发布
weixin_55229531的博客
03-29 1万+
使用Atomikos这个插件配置参数AtomikosDataSourceBean时忘记配置MinPoolSize,MaxPoolSize,BorrowConnectionTimeout这三个参数，导致连接池资源耗尽。调接口时反应及慢，迟迟不响应，之后提示下面的报错。
Springboot使用druid配置达梦数据库启动异常：com.atomikos.jdbc.AtomikosSQLException: Failedtogrow theconnection pool
weixin_45626288的博客
05-30 1587
在使用Springboot、druid配置多数据源使用了默认的MySQL的数据库连接池的配置，然后在访问达梦数据库时会出现无法创建连接池的异常。使用默认的配置构建；后续可以自己单独给一个数据库连接池的配置方法。
Cannot get a connection, pool exhausted解决办法
weixin_30535565的博客
09-22 686
http://blog.163.com/it_message/blog/static/8892051200908102032653/ 连接池（Tomcat+oracle）,运行一段时间后就会出现 Cannot get a connection, pool exhausted这样的异常。其实这个问题很简单就是数据库connection对象用尽了。 解决的办法有3个 1重启服务器 2在c...
关于Cannot get a connection, pool exhausted解决办法
04-19 919
关于Cannot get a connection, pool exhausted解决办法
tomcat连接池提示错误
伤心忘忧草的专栏
04-24 1327
我用tomcat连接池连接数据库，过一天就提示Cannot get a connection, pool exhausted,查找资料得到的是连接池已经用完import java.sql.*;import java.io.*;import javax.naming.*;import javax.sql.*;public class pubconn {          private Stri
java 连接池问题oracle
简简单单，平平淡淡
01-15 8161
[2014-01-15 10:06:09 326 ERROR] [http-nio-8888-exec-9] com.jeedsoft.ecp.application.action.DataServlet - Unexpected Exception com.jeedsoft.common.basic.exception.SystemException: 获取数据库连接失败。 at com.je
JAVA分布式事务atomikos
叼哥的博客
07-20 4640
出于对作者的尊重和感谢，原文地址为 http://www.cnblogs.com/cerxp/p/3468097.html 1.现有方案 a.atomikos b.jotm 说明:spring3.0已将jotm的支持踢掉 2.使用atomikos时的pom.xml内容 分布式事务支持-atomikos-begin --> dependency>
atomikos 异常报错（java.lang.NoSuchMethodException:com.mysql.cj.conf.PropertySet.getBooleanReadablePrope）
idongit的博客
09-14 1207
转载自：https://blog.csdn.net/weixin_43931625/article/details/103541019 atomikos异常报错（java.lang.NoSuchMethodException） 报错信息 java.lang.NoSuchMethodException: com.mysql.cj.conf.PropertySet.getBooleanReadableProperty(java.lang.String) at java.base/java.la..
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值