数据库驱动版本低导致linux下启动异常

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">最近项目要部署到linux服务器进行测试,，部署上去启动出现下列异常，同服务器上的其他项目也无法连上数据库，关闭该web服务，重启数据库其它项目正常运行。当运维跟我们说这情况，大家很惊讶，因为本地运行完全没问题。连接池采用的c3p0。</span><pre name="code" class="java">014-10-16 19:39:23,738) WARN   [ThreadPoolAsynchronousRunner$DeadlockDetector.run():608] - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@126d0169 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!(2014-10-16 19:39:23,746) WARN   [ThreadPoolAsynchronousRunner$DeadlockDetector.run():624] - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@126d0169 -- APPARENT DEADLOCK!!! Complete Status: Managed Threads: 3Active Threads: 3Active Tasks: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@32a4b306 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5ae568e3 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@b493db4 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)Pending Tasks: com.mchange.v2.resourcepool.BasicResourcePool$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$[e-mail]$AcquireTask@904bbeePool thread stack traces:Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]java.lang.Thread.sleep(Native Method)com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]java.lang.Thread.sleep(Native Method)com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]java.lang.Thread.sleep(Native Method)com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">最后决定换连接池，用BoneCP替换c3p0。结果还是异常如下</span><pre name="code" class="html">(2014-10-17 10:29:50,703) ERROR  [DemoController.selectPagedDemos():282] - nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://10.159.153.251:7006/kj?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false, username = kj. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at java.lang.reflect.Constructor.newInstance(Unknown Source)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2291)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2212)at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797)at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at java.lang.reflect.Constructor.newInstance(Unknown Source)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)<span style="color:#ff0000;">at java.sql.DriverManager.getConnection(Unknown Source)</span>at java.sql.DriverManager.getConnection(Unknown Source)at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363)at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:66)at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)at com.sun.proxy.$Proxy5.selectOne(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)at com.sun.proxy.$Proxy11.selectDemosCount(Unknown Source)at com.right.toafrica.uc.service.impl.DemoServiceImpl.selectDemosCount(DemoServiceImpl.java:84)at com.right.toafrica.uc.web.controller.DemoController.selectPagedDemos(DemoController.java:265)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Unknown Source)Caused by: java.sql.SQLException: null,  message from server: "Host 'im.chbjt.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1136)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2389)at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2230)... 81 more------

经过分析我把数据库驱动提高了一个版本，测试运行问题解决。连接池换回c3p0运行正常。