search

alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品，为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.9k stars 8.57k forks source link

tomcat 运行一段时间后报错 #2257

Open shuaichaoA opened 6 years ago

shuaichaoA commented 6 years ago

2018-01-06 08:28:34 [ERROR]-[Thread: localhost-startStop-1]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error, url: jdbc:dm://172.17.3.2:12345 java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104) at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:43) at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226) at com.jfinal.core.Config.startPlugins(Config.java:107) at com.jfinal.core.Config.configJFinal(Config.java:51) at com.jfinal.core.JFinal.init(JFinal.java:63) at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260) at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4950) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1015) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:991) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

2018-01-06 08:28:37 [ERROR]-[Thread: localhost-startStop-1]-[com.alibaba.druid.pool.DruidDataSource.init()]: {dataSource-1} init error java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104) at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:43) at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226) at com.jfinal.core.Config.startPlugins(Config.java:107) at com.jfinal.core.Config.configJFinal(Config.java:51) at com.jfinal.core.JFinal.init(JFinal.java:63) at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260) at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4950) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1015) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:991) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

2018-01-06 08:28:37 [ERROR]-[Thread: localhost-startStop-1]-[com.jfinal.core.Config.startPlugins()]: Plugin start error: com.jfinal.plugin.activerecord.ActiveRecordPlugin. java.sql.SQLException: Communication error com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Communication error at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:55) at com.jfinal.plugin.activerecord.ActiveRecordPlugin.start(ActiveRecordPlugin.java:226) at com.jfinal.core.Config.startPlugins(Config.java:107) at com.jfinal.core.Config.configJFinal(Config.java:51) at com.jfinal.core.JFinal.init(JFinal.java:63) at com.jfinal.core.JFinalFilter.init(JFinalFilter.java:49) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260) at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:105) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4950) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5652) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1015) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:991) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:734) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1060) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1056) at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:104) at com.jfinal.plugin.activerecord.TableBuilder.build(TableBuilder.java:43) ... 21 more

2018-01-06 08:28:37 [ERROR]-[Thread: Druid-ConnectionPool-Create-1039732776]-[com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run()]: create connection error, url: jdbc:dm://172.17.3.2:12345, errorCode 6001, state 08S01 java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2100)

2018-01-06 08:28:40 [ERROR]-[Thread: Druid-ConnectionPool-Create-1039732776]-[com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run()]: create connection error, url: jdbc:dm://172.17.3.2:12345, errorCode 6001, state 08S01 java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2100)

2018-01-06 08:28:43 [ERROR]-[Thread: Druid-ConnectionPool-Create-1039732776]-[com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run()]: create connection error, url: jdbc:dm://172.17.3.2:12345, errorCode 6001, state 08S01 java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2100)

2018-01-06 08:28:46 [ERROR]-[Thread: Druid-ConnectionPool-Create-1039732776]-[com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run()]: create connection error, url: jdbc:dm://172.17.3.2:12345, errorCode 6001, state 08S01 java.sql.SQLException: Communication error at dm.jdbc.dbaccess.DBError.throwSQLException(Unknown Source) at dm.jdbc.driver.DmdbConnection.(Unknown Source) at dm.jdbc.driver.DmDriver.connect(Unknown Source) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2100)

shuaichaoA commented 6 years ago

连接达梦数据库的时候报的错误，服务器项目启动的时候连接成功，第二天就报错了，不知道为什么连接失效了，有什么解决方案吗

szleilei commented 6 years ago

报错的时候 有没有试过ping 一下你的数据库IP 172.17.3.2 ？ 测试一下到数据库的网络通不通？

shuaichaoA commented 6 years ago

当时是在远程服务器，我不在现场，没法还原当时的环境，可是我问过数据库说没有重启过，其他项目是正常的，我想问一下，什么情况会出现这种情况

补充： 后来在现场调试的时候，又碰到了这种问题，当时去ping了数据库，结果不通，应该是网络问题，谢谢了！

smile-everyday commented 6 years ago

@shuaichaoA 你怎么连接达梦的?我去掉了sql防火墙但是启动依然报错，Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set说是hibernate获取不到达梦方言，我没用hibernate 啊

shuaichaoA commented 6 years ago

可能是你的方言问题，我用的自己写的达梦方言，继承的oracle方言

smile-everyday commented 6 years ago

@shuaichaoA 厉害，能把你那个发给我么？

shuaichaoA commented 6 years ago

是达梦6吗，你可以直接用oracle的方言代替

smile-everyday commented 6 years ago

@shuaichaoA 是7，应该差距不大吧，实在不行我看看你咋写的，哈哈