C3P0报错

阅读: 评论:0

C3P0报错

C3P0报错

异常信息:

 

2013-04-28 11:54:48 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] An attempt by a client to checkout a Connection has timed out.
[Cause: sourcepool.TimeoutException: internal -- timeout at awaitAcquire()sourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:925)sourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:207)hange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)hange.v2.Connection(PoolBackedDataSource.java:94)hange.v2.Connection(ComboPooledDataSource.java:521)at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)at org.springframework.jdbc.Connection(TransactionAwareDataSourceProxy.java:109)at Connection(LocalDataSourceConnectionProvider.java:81)at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)at wSessionFactory(LocalSessionFactoryBean.java:805)at hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745)at hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1175)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1145)at org.springframework.beans.factory.ateBean(AbstractAutowireCapableBeanFactory.java:427)at org.springframework.beans.factory.support.Object(AbstractBeanFactory.java:251)at org.springframework.beans.factory.Singleton(DefaultSingletonBeanRegistry.java:144)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:248)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:160)at org.springframework.beans.factory.solveReference(BeanDefinitionValueResolver.java:261)at org.springframework.beans.factory.solveValueIfNecessary(BeanDefinitionValueResolver.java:109)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1073)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:835)at org.springframework.beans.factory.ateBean(AbstractAutowireCapableBeanFactory.java:423)at org.springframework.beans.factory.support.Object(AbstractBeanFactory.java:251)at org.springframework.beans.factory.Singleton(DefaultSingletonBeanRegistry.java:144)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:248)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:160)at org.springframework.beans.factory.solveReference(BeanDefinitionValueResolver.java:261)at org.springframework.beans.factory.solveValueIfNecessary(BeanDefinitionValueResolver.java:109)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1073)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:835)at org.springframework.beans.factory.ateBean(AbstractAutowireCapableBeanFactory.java:423)at org.springframework.beans.factory.support.Object(AbstractBeanFactory.java:251)at org.springframework.beans.factory.Singleton(DefaultSingletonBeanRegistry.java:144)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:248)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:164)at org.springframework.aop.Advice(AbstractBeanFactoryPointcutAdvisor.java:77)at org.springframework.aop.aspectj.AspectJProxyUtils.makeAdvisorChainAspectJCapableIfNecessary(AspectJProxyUtils.java:49)at org.springframework.aop.aspectj.dAdvisors(AspectJAwareAdvisorAutoProxyCreator.java:98)at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findEligibleAdvisors(AbstractAdvisorAutoProxyCreator.java:90)at org.springframework.aop.framework.AdvicesAndAdvisorsForBean(AbstractAdvisorAutoProxyCreator.java:69)at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:296)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:314)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1154)at org.springframework.beans.factory.ateBean(AbstractAutowireCapableBeanFactory.java:427)at org.springframework.beans.factory.support.Object(AbstractBeanFactory.java:251)at org.springframework.beans.factory.Singleton(DefaultSingletonBeanRegistry.java:144)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:248)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:160)at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:279)at t.fresh(AbstractApplicationContext.java:360)at org.ateWebApplicationContext(ContextLoader.java:241)at org.t.ContextLoader.initWebApplicationContext(ContextLoader.java:184)at org.tInitialized(ContextLoaderListener.java:49)at com.officeFrame.web.tInitialized(OfficeListener.java:29)at org.StandardContext.listenerStart(StandardContext.java:4135)at org.StandardContext.start(StandardContext.java:4630)at org.ContainerBase.addChildInternal(ContainerBase.java:791)at org.ContainerBase.addChild(ContainerBase.java:771)at org.StandardHost.addChild(StandardHost.java:546)at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)at org.ContainerBase.start(ContainerBase.java:1053)at org.StandardHost.start(StandardHost.java:785)at org.ContainerBase.start(ContainerBase.java:1045)at org.StandardEngine.start(StandardEngine.java:445)at org.StandardService.start(StandardService.java:519)at org.StandardServer.start(StandardServer.java:710)at org.apache.catalina.startup.Catalina.start(Catalina.java:581)flect.NativeMethodAccessorImpl.invoke0(Native Method)flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at flect.Method.invoke(Method.java:597)at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
]
2013-04-28 11:55:59 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] An attempt by a client to checkout a Connection has timed out.
[Cause: sourcepool.TimeoutException: internal -- timeout at awaitAcquire()sourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:925)sourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:207)hange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)hange.v2.Connection(PoolBackedDataSource.java:94)hange.v2.Connection(ComboPooledDataSource.java:521)at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)at org.springframework.jdbc.Connection(TransactionAwareDataSourceProxy.java:109)at Connection(LocalDataSourceConnectionProvider.java:81)at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)at wSessionFactory(LocalSessionFactoryBean.java:805)at hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745)at hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1175)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1145)at org.springframework.beans.factory.ateBean(AbstractAutowireCapableBeanFactory.java:427)at org.springframework.beans.factory.support.Object(AbstractBeanFactory.java:251)at org.springframework.beans.factory.Singleton(DefaultSingletonBeanRegistry.java:144)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:248)at org.springframework.beans.factory.Bean(AbstractBeanFactory.java:160)at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:276)at t.fresh(AbstractApplicationContext.java:360)at org.ateWebApplicationContext(ContextLoader.java:241)at org.t.ContextLoader.initWebApplicationContext(ContextLoader.java:184)at org.tInitialized(ContextLoaderListener.java:49)at com.officeFrame.web.tInitialized(OfficeListener.java:29)at org.StandardContext.listenerStart(StandardContext.java:4135)at org.StandardContext.start(StandardContext.java:4630)at org.ContainerBase.addChildInternal(ContainerBase.java:791)at org.ContainerBase.addChild(ContainerBase.java:771)at org.StandardHost.addChild(StandardHost.java:546)at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)at org.ContainerBase.start(ContainerBase.java:1053)at org.StandardHost.start(StandardHost.java:785)at org.ContainerBase.start(ContainerBase.java:1045)at org.StandardEngine.start(StandardEngine.java:445)at org.StandardService.start(StandardService.java:519)at org.StandardServer.start(StandardServer.java:710)at org.apache.catalina.startup.Catalina.start(Catalina.java:581)flect.NativeMethodAccessorImpl.invoke0(Native Method)flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at flect.Method.invoke(Method.java:597)at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
]


 

配置文件:

	<!-- 测试库1 --><bean id="c3pomainDataSource"   class=&#hange.v2.c3p0.ComboPooledDataSource">   <property name="driverClass" value="oracle.jdbc.OracleDriver"/><property name="jdbcUrl" value="jdbc:oracle:thin:@10.1.20.30:1521:cuctest"/><property name="user" value="officetest"/>   <property name="password" value="officetest"/>   <property name="maxPoolSize" value="30"/>   <property name="minPoolSize" value="10"/>   <property name="initialPoolSize" value="10"/>   <property name="maxIdleTime" value="30"/><property name="idleConnectionTestPeriod" value="30"/><property name="checkoutTimeout" value="7000"/></bean>


 

有一个线上环境使用的是c3p0数据库,为外部提供接口服务。最近访问压力增大后台tomcat的日志里面频繁出现

的异常信息

在网上搜索了半天找到两种最多的方法:

1.修改checkoutTimeout的值,这个值我现在已经设定是5000了也就是5秒超时,如果再大就没意义了,一个接口5秒还没响应是非常不正常的。

2.增加acquireIncrement的值,这个值感觉也不靠谱,只是增大了每次获取的数量,如果根本就获取不到连接就无意义。

无奈只好优化程序,加大连接池的maxPoolSize和minPoolSize的值。

但是就算把 maxPoolSize 的值设置的比tomcat的最大线程的值大,过不了一会还是出现那个问题。我就奇怪了就算每个请求永久占用一个连接也够用了,怎么还会出现获取连接超时的问题。

然后继续在晚上搜数据库连接池发现了bonecp。

换上这个后果然问题解决,日志里面再没出现获取连接超时的问题。

看来c3p0在大并发的情况下还真的是不容乐观啊。

顺便说下项目的并发情况,单台tomcat 最大maxThreads的值设为400,每次启动后tomcat的日志中都会出现线程超过最大线程的信息。 也就是峰值并发数 > 400 。

 

通过VPN远程连接老是要报错。

 

 


官方网

 

本文发布于:2024-01-29 15:50:31,感谢您对本站的认可!

本文链接:https://www.4u4v.net/it/170651463416374.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

下一篇:【ESP
标签:报错
留言与评论(共有 0 条评论)
   
验证码:

Copyright ©2019-2022 Comsenz Inc.Powered by ©

网站地图1 网站地图2 网站地图3 网站地图4 网站地图5 网站地图6 网站地图7 网站地图8 网站地图9 网站地图10 网站地图11 网站地图12 网站地图13 网站地图14 网站地图15 网站地图16 网站地图17 网站地图18 网站地图19 网站地图20 网站地图21 网站地图22/a> 网站地图23