druid连接池获取连接超时异常

项目使用spring+springmvc+hibernate,数据库使用oracle11.2.0.1.0,允许的最大连接数为300,数据库服务器防火墙是关闭的。项目中有个定时任务(每天凌晨执行)使用jdbcTemplate同步数据。druid连接池异常信息如下:

[org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] WARN  com.alibaba.druid.pool.DruidDataSource - get connection timeout retry : 1
[2019-11-02 03:00:02.002] [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] ERROR org.quartz.core.JobRunShell - Job DEFAULT.syncSyldDataDetail threw an unhandled Exception: 
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 350, creating 1
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:371) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:578) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at com.aqkk.task.SyncSyldData.start(SyncSyldData.java:33) ~[classes/:?]
    at com.aqkk.task.SyncSyldDataJob.executeInternal(SyncSyldDataJob.java:17) ~[classes/:?]
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75) ~[spring-context-support-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.0.jar:?]
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.0.jar:?]
Caused by: com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 350, creating 1
    at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1512) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1255) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5007) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:680) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:5003) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1233) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1225) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90) ~[druid-1.1.10.jar:1.1.10]
    at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    ... 7 more
[2019-11-02 03:00:02.002] [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] ERROR org.quartz.core.ErrorLogger - Job (DEFAULT.syncSyldDataDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception.
    at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz-2.3.0.jar:?]
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.0.jar:?]
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 350, creating 1
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:371) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:578) ~[spring-jdbc-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at com.aqkk.task.SyncSyldData.start(SyncSyldData.java:33) ~[classes/:?]
    at com.aqkk.task.SyncSyldDataJob.executeInternal(SyncSyldDataJob.java:17) ~[classes/:?]
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75) ~[spring-context-support-5.0.8.RELEASE.jar:5.0.8.RELEASE]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.0.jar:?]
    ... 1 more
Caused by: com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 350, creating 1
    at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1512) ~[druid-1.1.10.jar:1.1.10]
    at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1255) ~[druid-1.1.10.jar:1.1.10]

druid配置信息如下:

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
    <property name="url" value="${db.jdbcUrl}"/>
    <property name="username" value="${db.user}"/>
    <property name="password" value="${db.password}"/>
    <property name="driverClassName" value="${db.driver}"/>
    <!-- 配置初始化大小、最小、最大 -->
    <property name="initialSize" value="1"/>
    <property name="minIdle" value="20"/>
    <property name="maxActive" value="350"/>
    <!-- 配置获取连接等待超时的时间 -->
    <property name="maxWait" value="1000"/>
    <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
    <property name="timeBetweenEvictionRunsMillis" value="10000"/>
    <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
    <property name="minEvictableIdleTimeMillis" value="30000"/>
    <property name="testWhileIdle" value="true"/>
    <property name="validationQuery" value="SELECT 1 FROM DUAL"/>
    <property name="testOnBorrow" value="false"/>
    <property name="testOnReturn" value="false"/>
    <!-- 打开PSCache,并且指定每个连接上PSCache的大小 -->
    <property name="poolPreparedStatements" value="true"/>
    <property name="maxPoolPreparedStatementPerConnectionSize" value="20"/>
    <!-- 开启Druid的监控统计功能 -->
    <property name="filters" value="stat" />
  </bean>

为啥凌晨执行定时任务获取不到连接,9点上班系统又是正常运行的呢?

1个回答

建议你检查程序,尤其是定时任务的业务逻辑。这是第一步。
第二步,看呦没其他资源占用。并不是说只把问题看到定时任务上。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
Druid数据库连接池使用一段时间进行报错

使用了druid数据库连接池以后有时候运行会报com.alibaba.druid.pool.DruidDataSource.error create connection error, url: jdbc:mysql://localhost:3306/resturant, errorCode 1045, state 28000 java.sql.SQLException: Access denied for user 'root'@'localhost' (using passwo rd: YES)错误是什么原因

SpringBoot使用druid连接池,隔一段时间后,再次访问页面,数据加载时间特别长,有时候会连接超时

https://biwen.csdn.net/question/1229 已经再这里描述问题了。麻烦解答一下,谢谢

springboot2.1.8集成druid连接池 无法实现sql监控

![图片说明](https://img-ask.csdn.net/upload/201910/15/1571113606_898290.jpg) sql监控没有数据 连接池配置: initial-size: 10 # 最大连接数 max-active: 50 #最小连接数 min-idle: 10 #获取连接等待超时时间 max-wait: 5000 pool-prepared-statements: true #是否缓存preparedStatement,也就是PSCache。PSCache对支持游标的数据库性能提升巨大,比如说oracle。在mysql下建议关闭。 max-pool-prepared-statement-per-connection-size: 20 validation-query: SELECT 1 FROM DUAL validation-query-timeout: 20000 test-on-borrow: false #申请连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。 test-on-return: false #归还连接时执行validationQuery检测连接是否有效,做了这个配置会降低性能。 test-while-idle: true #建议配置为true,不影响性能,并且保证安全性。申请连接的时候检测,如果空闲时间大于timeBetweenEvictionRunsMillis,执行validationQuery检测连接是否有效。 time-between-eviction-runs-millis: 60000 #配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 min-evictable-idle-time-millis: 300000 #一个连接在池中最小生存的时间,单位是毫秒 #通过connectionProperties属性来打开mergeSql功能;慢sql记录 connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000 # StatViewServlet配置。(因为暴露的监控信息比较敏感,支持密码加密和访问ip限定) stat-view-servlet: # 是否启用WebStatFilter enabled: true # 访问路径 url-pattern: "/druid/*" # 排除不必要的url exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico" # 监控最大session数,默认是1000 session-stat-max-count: 1000 # 是否启用session的统计功能 session-stat-enable: true # 是否启用监控单个Url调用的sql列表 profile-enable: true # 使druid当前session的用户是谁,session_user_key是你保存到session中的sessionName principalSessionName: session_user_key # 使druid只当当前的user是谁,cookie_user_key是你保存在cookie中的cookieName principalCookieName: cookie_user_key #可以增加访问账号密码【去掉注释就可以】 #login-username: admin #login-password: admin filter: # 监控统计 stat: # 数据库类型 db-type: mysql # 慢SQL log-slow-sql: true # 慢SQL执行时间 slow-sql-millis: 1000 merge-sql: true wall: config: multi-statement-allow: true ###试了各种方法sql监控就是没有出来

自己写数据库连接池 --- 如何回收超时连接

比如 设置超时是10秒 然后 户获取一个连接,然后线程等待10秒 去执行操作数据库操作~~ 十秒后连接池要回收这个连接~~这里应该怎么回收?[color=red]要销毁这个连接然后新建一个放入连接池吗???????[/color] 如果不销毁这个连接,那接下来执行的数据库操作肯定会正常执行~~这样的话就不正确了....

内存溢出问题,不知道是哪里出现的问题,怀疑是druid连接池使用不当,求大佬帮忙。

昨晚上出现了两次内存溢出,找不到复现的方法,每次出现内存溢出都不一样,两次都是先出现"Disk Write of"写入磁盘失败错误,然后就是druid获取连接失败,然后报OOM异常,接着linux服务器cpu使用率上涨,一直涨到百分之600满(服务器是6核CPU),第二次的日志看跟第一次出现类似;下面是第一次 日志 2020-03-16 17:39:47 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_ca92_processor failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:39:47 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_ca92_processor failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351636324","msgId":"598577930","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:40:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351636324","msgId":"598577930","msg":"成功"} 2020-03-16 17:41:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351696340","msgId":"480724569","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:41:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:41:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:41:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351696340","msgId":"480724569","msg":"成功"} 2020-03-16 17:42:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351756356","msgId":"2008015594","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:42:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:42:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:42:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351756356","msgId":"2008015594","msg":"成功"} 2020-03-16 17:43:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351816372","msgId":"1754653907","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:43:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:43:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:43:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351816372","msgId":"1754653907","msg":"成功"} 2020-03-16 17:44:37 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:38 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:38 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:41 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351881843","msgId":"327484943","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:44:41 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:44:43 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:44:48 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:48 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:49 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351881843","msgId":"327484943","msg":"成功"} 2020-03-16 17:45:02 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:45:55 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:45:55 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351955374","msgId":"690664616","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:45:55 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:46:00 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351955374","msgId":"690664616","msg":"成功"} 2020-03-16 17:47:13 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352033984","msgId":"1701533843","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:47:13 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:47:14 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:47:19 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352033984","msgId":"1701533843","msg":"成功"} 2020-03-16 17:48:48 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352128999","msgId":"1984150795","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:48:50 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:48:50 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352128999","msgId":"1984150795","msg":"成功"} 2020-03-16 17:48:51 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:50:00 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352200578","msgId":"1977525065","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:50:01 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:50:03 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:50:04 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352200578","msgId":"1977525065","msg":"成功"} 2020-03-16 17:51:20 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352280657","msgId":"1863876211","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:51:21 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:51:22 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:51:28 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352280657","msgId":"1863876211","msg":"成功"} 2020-03-16 17:52:47 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:52:50 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:52:55 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352373108","msgId":"628094041","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:53:03 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352373108","msgId":"628094041","msg":"成功"} 2020-03-16 17:54:00 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352439640","msgId":"72219615","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:54:00 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:54:03 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:54:09 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352439640","msgId":"72219615","msg":"成功"} 2020-03-16 17:55:23 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:55:23 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:55:25 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:55:26 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:55:26 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352526466","msgId":"1473614692","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:55:36 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:55:41 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:55:42 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352526466","msgId":"1473614692","msg":"成功"} 2020-03-16 17:55:48 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:00 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:00 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:02 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:56:05 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:06 WARN [SqlExceptionHelper.java:143] - SQL Error: 0, SQLState: null 2020-03-16 17:56:06 ERROR [SqlExceptionHelper.java:144] - wait millis 5488, active 8, maxActive 40, creating 0 2020-03-16 17:56:14 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:27 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:56:29 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:56:37 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:56:37 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352597266","msgId":"617319811","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:56:37 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:56:49 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352597266","msgId":"617319811","msg":"成功"} 2020-03-16 17:56:58 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:58:04 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352684961","msgId":"1580436857","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:58:04 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:58:07 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:58:12 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584352684961","msgId":"1580436857","msg":"成功"} 2020-03-16 17:58:17 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:58:38 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:59:06 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 然后这是第二次OOM异常的日志 2020-03-16 17:36:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351396265","msgId":"2054492855","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:36:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351396265","msgId":"2054492855","msg":"成功"} 2020-03-16 17:37:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351456281","msgId":"1912161758","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:37:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351456281","msgId":"1912161758","msg":"成功"} 2020-03-16 17:38:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351516297","msgId":"476243815","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:38:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351516297","msgId":"476243815","msg":"成功"} 2020-03-16 17:39:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351576307","msgId":"2004523303","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:39:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351576307","msgId":"2004523303","msg":"成功"} 2020-03-16 17:39:47 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_ca92_processor failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:39:47 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_ca92_processor failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351636324","msgId":"598577930","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:40:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:40:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351636324","msgId":"598577930","msg":"成功"} 2020-03-16 17:41:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351696340","msgId":"480724569","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:41:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:41:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:41:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351696340","msgId":"480724569","msg":"成功"} 2020-03-16 17:42:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351756356","msgId":"2008015594","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:42:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:42:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:42:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351756356","msgId":"2008015594","msg":"成功"} 2020-03-16 17:43:36 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351816372","msgId":"1754653907","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:43:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:43:36 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:43:36 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351816372","msgId":"1754653907","msg":"成功"} 2020-03-16 17:44:37 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:38 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:38 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:41 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351881843","msgId":"327484943","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":16777400,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:44:41 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:44:43 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:44:48 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:48 WARN [DruidDataSource.java:1258] - get connection timeout retry : 1 2020-03-16 17:44:49 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351881843","msgId":"327484943","msg":"成功"} 2020-03-16 17:45:02 ERROR [DruidDataSource.java:2469] - create connection SQLException, url: jdbc:mysql://localhost:55060/mcs?useUnicode=true&characterEncoding=utf-8, errorCode 0, state S1000 java.sql.SQLException: java.lang.OutOfMemoryError: PermGen space at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:878) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:874) at com.mysql.jdbc.Util.handleNewInstance(Util.java:443) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1513) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) Caused by: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:45:55 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:45:55 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584351955374","msgId":"690664616","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":33554616,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:45:55 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:46:00 INFO [MQTTProtocolHandler.java:89] - 接收到返回协议:{"topic":"reControlProtocol/reApplyBackPicCtrl/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07/00:00:01:A0:43:74","result":"success","timeStamp":"1584351955374","msgId":"690664616","msg":"成功"} 2020-03-16 17:47:13 INFO [BaseHandler.java:42] - 向解码器推送协议{"topic":"controlProtocol/applyBackPicCtrl/00:00:01:A0:43:74/1c79b3b3-6020-4af7-97ec-a1abd5f0cc07","timeStamp":"1584352033984","msgId":"1701533843","videoEnable":0,"picList":[{"level":0,"imageEndY":900,"imageEndX":1600,"blockEndY":900,"blockEndX":1600,"blockStartY":180,"imageStartX":320,"picId":184,"imageStartY":180,"blockStartX":320}]} 2020-03-16 17:47:13 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 2020-03-16 17:47:14 ERROR [DiskStorageFactory.java:495] - Disk Write of mcs_pic_layer failed: java.lang.OutOfMemoryError: PermGen space 这是我项目的druid配置 <!--druid连接池 --> <beans profile="production"> <context:property-placeholder ignore-unresolvable="true" location="classpath:/jdbc.properties" /> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 配置初始化大小、最小、最大 --> <property name="initialSize" value="1" /> <property name="minIdle" value="1" /> <property name="maxActive" value="40" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="5000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="testWhileIdle" value="true" /> <!-- 这里建议配置为TRUE,防止取到的连接不可用 --> <property name="testOnBorrow" value="true" /> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 --> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> <!-- 这里配置提交方式,默认就是TRUE,可以不用配置 --> <property name="defaultAutoCommit" value="true" /> </bean> </beans> 求大佬们帮解答。。。

数据库连接池报错问题

数据库连接池信息 <!-- 数据源配置, 使用proxool连接池 --> <bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource"> <property name="alias" value="BAP database" /> <property name="driver" value="${jdbc.driver}" /> <property name="driverUrl" value="${jdbc.url}"/> <property name="user" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 最少保持的空闲连接数 --> <property name="prototypeCount" value="2" /> <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁,默认30秒,我们设置60秒 --> <property name="houseKeepingSleepTime" value="60000" /> <!-- 最大活动时间(超过此时间线程将被kill,默认5分钟) --> <!-- <property name="maximumActiveTime" value=""/> --> <!-- 最小连接数据 --> <property name="minimumConnectionCount" value="${jdbc.minConnection}" /> <!-- 最大连接数 --> <property name="maximumConnectionCount" value="${jdbc.maxConnection}" /> <!-- 测试的sql语句 --> <property name="houseKeepingTestSql" value="${jdbc.testSQL}" /> </bean> 现在项目启动报错,mysql已修改timeout时间,因为是在别人项目基础上改动,不考虑还c3p0连接池,该如何修改求大神指点下![报错信息](https://img-ask.csdn.net/upload/201709/14/1505361116_456865.png)

阿里巴巴连接池断开连接

环境:spring spring mvc mybatis的maven项目。 问题:使用阿里巴巴连接池、登录后如果不去操作等待5分钟的样子就会报错如下: 23:28:14.801 [Druid-ConnectionPool-Destroy-1512369669] ERROR com.alibaba.druid.util.JdbcUtils - close connection error java.sql.SQLRecoverableException: IO 错误: Software caused connection abort: recv failed at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:504) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754) ~[ojdbc6-11.2.jar:11.2.0.1.0] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:169) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.filter.stat.StatFilter.connection_close(StatFilter.java:254) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:165) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.close(ConnectionProxyImpl.java:115) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:83) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource.shrink(DruidDataSource.java:2297) [druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource$DestroyTask.run(DruidDataSource.java:2084) [druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2071) [druid-1.0.20.jar:1.0.20] Caused by: java.net.SocketException: Software caused connection abort: recv failed at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.7.0_67] at java.net.SocketInputStream.read(SocketInputStream.java:152) ~[na:1.7.0_67] at java.net.SocketInputStream.read(SocketInputStream.java:122) ~[na:1.7.0_67] at oracle.net.ns.Packet.receive(Packet.java:282) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.DataPacket.receive(DataPacket.java:103) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:175) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:100) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:85) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491) ~[ojdbc6-11.2.jar:11.2.0.1.0] ... 9 common frames omitted 然后继续使用如果登录还未失效就会等很久才响应、页面才加载出来。​ 数据库使用的:oracle 配置如下: <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!-- 数据库基本信息配置 --> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="driverClassName" value="${jdbc.driverClassName}" /> <property name="filters" value="stat" /> <!-- 初始化连接数量 --> <property name="initialSize" value="1" /> <!-- 最小空闲连接数 --> <property name="minIdle" value="1" /> <!-- 最大并发连接数 --> <property name="maxActive" value="20" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="60000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="removeAbandoned" value="true" /> <property name="removeAbandonedTimeout" value="1800" /> <!-- 申请连接的时候检测 --> <property name="testWhileIdle" value="true" /> <!-- 检测连接是否可用 --> <property name="validationQuery" value="SELECT 1 FROM DUAL" /> <!-- 申请连接时执行validationQuery检测连接是否有效 --> <property name="testOnBorrow" value="false" /> <!-- 归还连接时执行validationQuery检测连接是否有效 --> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 --> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> </bean> ​ 请问有人知道怎么回事吗?

Hibernate3.2+Mysql+Tomcat的中型企业应用用选择哪个连接池最稳定?

目前正开发某企业内部的办公系统,日常同时在线人数500左右。 开源连接池可选的很多: A,Tomcat自带的DBCP B,Hibernate支持的单独DBCP C,C3P0 D,proxool E,其它 希望大家能能给出一个最优的选择,十分感谢! [b]问题补充:[/b] 听取了大家的建议,于前天(2008-06-28)替换掉了以前tomcat自带的DBCP连接池,改为了C3P0,配置如 下: [code] <property name="c3p0.min_size">10</property><!--连接池的最小连接数--> <property name="c3p0.max_size">50</property><!--最大连接数--> <property name="c3p0.timeout">100</property><!--连接超时时间--> <!--每隔100秒检测连接是否可正常使用 --> <property name="c3p0.idle_test_period">100</property> <!--当池中的连接耗尽的时候,一次性增加的连接数量,默认为3--> <property name="hibernate.c3p0.acquire_increment">3</property> <!--statemnets缓存大小--> <property name="c3p0.max_statements">150</property> [/code] 原来的DBCP配置 [code] <Resource maxActive="200" maxIdle="60" maxWait="-1" /> [/code] 今天(2008-06-30)访问量达到了200,并且某一瞬间并发查询达到了150左右。出现用DBCP时未出现过的 问题:瞬间打开页面很慢,并有部分用户超时掉线,我估计是我C3P0设置的问题。并提高悬赏5分,请大家 给予回答!

在线等!!!linux服务器连接mysql5.7数据库报错 Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException

以下是服务器上的报错代码 ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573526989_375593.png) ``` >org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 1000, active 0, maxActive 500, creating 1 ``` 问题就是出在这里. 1,本地项目正常启动,无任何报错,数据库连接正常(使用的都是linux上面的数据库). ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573527132_402324.png) 2,数据库工具使用无任何问题 ![图片说明](https://img-ask.csdn.net/upload/201911/12/1573527246_699888.png) 3,下面放出jdbc配置文件和spring配置文件 ``` jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://..XXXXXX.:/XXXXXX?useUnicode=true&characterEncoding=UTF-8&useSSL=false jdbc.username=xxxx jdbc.password=xxxxx jdbc.filters=stat jdbc.maxActive=500 jdbc.initialSize=1 jdbc.maxWait=1000 jdbc.minIdle=10 jdbc.maxIdle=15 jdbc.timeBetweenEvictionRunsMillis=60000 jdbc.minEvictableIdleTimeMillis=300000 jdbc.validationQuery=SELECT 'x' jdbc.testWhileIdle=true jdbc.testOnBorrow=false jdbc.testOnReturn=false jdbc.maxOpenPreparedStatements=20 jdbc.removeAbandoned=true jdbc.removeAbandonedTimeout=180 jdbc.logAbandoned=true ``` spring 配置 ``` <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 扫描service包下所有使用注解的类型 --> <context:component-scan base-package="com.yoFish.service"/> <!-- 配置数据库相关参数properties的属性:${url} --> <context:property-placeholder location="classpath:jdbc.properties"/> <!-- 阿里 druid 数据库连接池 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"> <!-- 数据库基本信息配置 --> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="filters" value="${jdbc.filters}"/> <!-- 最大并发连接数 --> <property name="maxActive" value="${jdbc.maxActive}"/> <!-- 初始化连接数量 --> <property name="initialSize" value="${jdbc.initialSize}"/> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="${jdbc.maxWait}"/> <!-- 最小空闲连接数 --> <property name="minIdle" value="${jdbc.minIdle}"/> <!-- 最大空闲连接数 --> <property name="maxIdle" value="${jdbc.maxIdle}"/> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"/> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}"/> <property name="validationQuery" value="${jdbc.validationQuery}"/> <property name="testWhileIdle" value="${jdbc.testWhileIdle}"/> <property name="testOnBorrow" value="${jdbc.testOnBorrow}"/> <property name="testOnReturn" value="${jdbc.testOnReturn}"/> <property name="maxOpenPreparedStatements" value="${jdbc.maxOpenPreparedStatements}"/> <!-- 超过时间限制是否回收 --> <property name="removeAbandoned" value="${jdbc.removeAbandoned}"/> <!-- 1800 秒,也就是 30 分钟 --> <property name="removeAbandonedTimeout" value="${jdbc.removeAbandonedTimeout}"/> <!-- 关闭 abanded 连接时输出错误日志 --> <property name="logAbandoned" value="${jdbc.logAbandoned}"/> </bean> <!-- 配置SqlSessionFactory对象 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> <!-- 扫描model包 使用别名 --> <property name="typeAliasesPackage" value="com.yoFish.model"/> <!-- 扫描sql配置文件:mapper需要的xml文件 --> <property name="mapperLocations" value="classpath:mapper/*.xml"/> </bean> <!-- 配置扫描Dao接口包,动态实现Dao接口,注入到spring容器中 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!-- 注入sqlSessionFactory --> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> <!-- 给出需要扫描Dao接口包 --> <property name="basePackage" value="com.yoFish.dao"/> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!-- 注入数据库连接池 --> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置基于注解的声明式事务 --> <tx:annotation-driven transaction-manager="transactionManager"/> </beans> ``` 这个问题搞了很久了,主要就是不知道问题在哪,本地真的是没有任何问题,很多方式我也试过了.很头疼,求大佬帮忙解决

spring-mvc和mybatis整合DruidDataSource配置连接池报错

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dynamicDatasourceAspect' defined in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\dm_job\WEB-INF\classes\com\creditease\job\aop\DynamicDatasourceAspect.class]: Initialization of bean failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.alibaba.druid.pool.DruidDataSource' to required type 'org.aspectj.lang.JoinPoint' for property 'dbmsDataSource'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:547) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) at org.springframework.aop.aspectj.annotation.BeanFactoryAspectInstanceFactory.getAspectInstance(BeanFactoryAspectInstanceFactory.java:77) at org.springframework.aop.aspectj.annotation.LazySingletonAspectInstanceFactoryDecorator.getAspectInstance(LazySingletonAspectInstanceFactoryDecorator.java:50) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:603) at org.springframework.aop.aspectj.AspectJMethodBeforeAdvice.before(AspectJMethodBeforeAdvice.java:40) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) at com.creditease.job.service.impl.CityServiceImpl$$EnhancerBySpringCGLIB$$23f19862.getAllCityCodeAndName(<generated>) at com.creditease.job.base.InitDataListener.contextInitialized(InitDataListener.java:48) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.alibaba.druid.pool.DruidDataSource' to required type 'org.aspectj.lang.JoinPoint' for property 'dbmsDataSource'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:476) at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:512) at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:506) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1523) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1482) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) ... 26 more Caused by: java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:287) at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:461) * ... 32 more 配置文件如下: <!-- 基础数据源配置 --> <bean id="baseDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"> <!-- 配置初始化大小、最小、最大 --> <property name="initialSize" value="10" /> <property name="minIdle" value="10" /> <property name="maxActive" value="50" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="60000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="validationQuery" value="SELECT * FROM CREDIT_CHANNEL LIMT 1" /> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 --> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> <!-- 配置监控统计拦截的filters --> <property name="filters" value="wall,stat" /> </bean> <!-- kls数据源 --> <bean id="klsDataSource" parent="baseDataSource"> <!-- 基本属性 url、user、password --> <property name="url" value="${kls.jdbc.url}" /> <property name="username" value="${kls.jdbc.username}" /> <property name="password" value="${kls.jdbc.password}" /> </bean> <!-- dbms数据源 --> <bean id="dbmsDataSource" parent="baseDataSource"> <!-- 基本属性 url、user、password --> <property name="url" value="${dbms.jdbc.url}" /> <property name="username" value="${dbms.jdbc.username}" /> <property name="password" value="${dbms.jdbc.password}" /> </bean> <!-- 设置spring 配置文件的配置多数源映射关系 --> <bean id="dataSource" class="com.creditease.job.datasource.DynamicDataSource"> <property name="targetDataSources"> <map> <entry value-ref="klsDataSource" key="kls"></entry> <entry value-ref="dbmsDataSource" key="dbms"></entry> </map> </property> <property name="defaultTargetDataSource" ref="klsDataSource" /> </bean> <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy"> <property name="targetDataSource" ref="dataSource" /> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <constructor-arg ref="dataSourceProxy" /> </bean> <!--事务管理器配置 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSourceProxy" /> </bean> <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="*" propagation="REQUIRED" /> </tx:attributes> </tx:advice> <bean class="com.creditease.job.util.SpringUtils" /> <!-- 数据库工厂 --> <!-- mySqlSessionFactory配置 --> <bean id="mySqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:mybatis-config.xml" /> </bean> ![图片说明](https://img-ask.csdn.net/upload/201605/16/1463363631_18856.png)

阿里云服务器上安装oracle,SpringBoot项目时间长总是IO 错误: Socket read timed out

**请问有哪些错误原因呢?** 我的疑问有以下几点: 1. 是SpringBoot项目的配置错误,我用的druid连接池,配置都是网上常用的配置。 * oracle安装错误,但是用Navicat和PL/SQL软件连接都没问题。 有谁知道什么原因吗?能解决的话,可加wx红包报酬的:w1150111308

spring boot多数据源 mysql8+超时问题

使用spring boot2.0.3,加druid配置多数据源,配置了testWhileIdle和timeBetweenEvictionRunsMillis, 超过mysql的time_out 时间时,代码还会报错 com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 401,266 milliseconds ago. The last packet sent successfully to the server was 401,270 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

springjdbc 连接数据库,超过8小时没有连接,断开了与数据库的连接怎么办

如题,autoReconnect=true这个参数貌似在mysql5以后就不好使了,所以有时候访问接口的时候会出错,PreparedStatementCallback The last packet successfully received from the server was 934,535,670 milliseconds ago. The last packet sent successfully to the server was 934,535,672 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem 这个问题怎么解决

spring datasource 连接会自动关闭吗

如题,我获取了spring的dataSource对象调用了 [code="java"]Connection conn = dataSource.getConnection();[/code] 我用conn对象执行完操作以后需要手动关闭这个连接吗 [code="java"]conn.close();[/code]

springboot2.0加入druid后使用的还是Hikari

配置 ``` spring: datasource: type: com.alibaba.druid.pool.DruidDataSource master: jdbcUrl: jdbc:mysql://127.0.0.1:3306/spring_boot_learning?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8 username: root password: root3306 driver-class-name: com.mysql.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource # 初始化大小,最小,最大 initialSize: 5 minIdle: 5 maxActive: 20 # 配置获取连接等待超时的时间 maxWait: 60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 timeBetweenEvictionRunsMillis: 60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false # 打开PSCache,并且指定每个连接上PSCache的大小 poolPreparedStatements: true maxPoolPreparedStatementPerConnectionSize: 20 # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 filters: stat,wall,log4j # 合并多个DruidDataSource的监控数据 #useGlobalDataSourceStat: true slave: jdbcUrl: jdbc:mysql://127.0.0.1:3306/spring_boot_learning_one?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8 username: root password: root3306 driver-class-name: com.mysql.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource # 初始化大小,最小,最大 initialSize: 5 minIdle: 5 maxActive: 20 # 配置获取连接等待超时的时间 maxWait: 60000 # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 timeBetweenEvictionRunsMillis: 60000 # 配置一个连接在池中最小生存的时间,单位是毫秒 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT 1 FROM DUAL testWhileIdle: true testOnBorrow: false testOnReturn: false # 打开PSCache,并且指定每个连接上PSCache的大小 poolPreparedStatements: true maxPoolPreparedStatementPerConnectionSize: 20 # 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 filters: stat,wall,log4j # 合并多个DruidDataSource的监控数据 #useGlobalDataSourceStat: true ``` 主数据源配置 ``` @Configuration @MapperScan(basePackages = "indi.xulala.dao.master", sqlSessionTemplateRef = "masterSqlSessionTemplate") public class MasterDataSourceConfig { @Bean(name = "masterDataSource") @ConfigurationProperties(prefix = "spring.datasource.master") @Primary public DataSource setDataSource() { return DataSourceBuilder.create().build(); } @Bean(name = "masterTransactionManager") @Primary public DataSourceTransactionManager setTransactionManager(@Qualifier("masterDataSource") DataSource dataSource) { return new DataSourceTransactionManager(dataSource); } @Bean(name = "masterSqlSessionFactory") @Primary public SqlSessionFactory setSqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml")); return bean.getObject(); } @Bean(name = "masterSqlSessionTemplate") @Primary public SqlSessionTemplate setSqlSessionTemplate(@Qualifier("masterSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception { return new SqlSessionTemplate(sqlSessionFactory); } } ``` 从数据源配置 ``` @Configuration @MapperScan(basePackages = "indi.xulala.dao.slave", sqlSessionTemplateRef = "slaveSqlSessionTemplate") public class SlaveDataSourceConfig { @Bean(name = "slaveDataSource") @ConfigurationProperties(prefix = "spring.datasource.slave") @Primary public DataSource setDataSource() { return DataSourceBuilder.create().build(); } @Bean(name = "slaveTransactionManager") @Primary public DataSourceTransactionManager setTransactionManager(@Qualifier("slaveDataSource") DataSource dataSource) { return new DataSourceTransactionManager(dataSource); } @Bean(name = "slaveSqlSessionFactory") @Primary public SqlSessionFactory setSqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml")); return bean.getObject(); } @Bean(name = "slaveSqlSessionTemplate") @Primary public SqlSessionTemplate setSqlSessionTemplate(@Qualifier("slaveSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception { return new SqlSessionTemplate(sqlSessionFactory); } } ``` application ``` @SpringBootApplication(exclude = {DataSourceAutoConfiguration.class, DataSourceTransactionManagerAutoConfiguration.class, HibernateJpaAutoConfiguration.class}) @MapperScan(basePackages = {"indi.xulala.dao.master","indi.xulala.dao.slave"}) public class SpringBootLearningApplication { public static void main(String[] args) { SpringApplication.run(SpringBootLearningApplication.class, args); } } ``` 启动日志 ``` 07:48:27.764 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [afterSingletonsInstantiated,434] - Registering beans for JMX exposure on startup 07:48:27.765 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [autodetect,896] - Bean with name 'masterDataSource' has been autodetected for JMX exposure 07:48:27.765 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [autodetect,896] - Bean with name 'slaveDataSource' has been autodetected for JMX exposure 07:48:27.765 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [autodetect,896] - Bean with name 'statFilter' has been autodetected for JMX exposure 07:48:27.772 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [registerBeanInstance,669] - Located MBean 'masterDataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=masterDataSource,type=HikariDataSource] 07:48:27.773 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [registerBeanInstance,669] - Located MBean 'slaveDataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=slaveDataSource,type=HikariDataSource] 07:48:27.774 [restartedMain] INFO o.s.j.e.a.AnnotationMBeanExporter - [registerBeanInstance,669] - Located MBean 'statFilter': registering with JMX server as MBean [com.alibaba.druid.filter.stat:name=statFilter,type=StatFilter] ``` 测试日志 ``` 07:49:20.159 [main] INFO com.zaxxer.hikari.HikariDataSource - [getConnection,110] - HikariPool-1 - Starting... 07:49:20.694 [main] INFO com.zaxxer.hikari.HikariDataSource - [getConnection,123] - HikariPool-1 - Start completed. 07:49:20.742 [main] INFO com.zaxxer.hikari.HikariDataSource - [getConnection,110] - HikariPool-2 - Starting... 07:49:20.771 [main] INFO com.zaxxer.hikari.HikariDataSource - [getConnection,123] - HikariPool-2 - Start completed. 07:49:20.813 [Thread-3] INFO o.s.w.c.s.GenericWebApplicationContext - [doClose,989] - Closing org.springframework.web.context.support.GenericWebApplicationContext@38831718: startup date [Sat Mar 24 07:49:11 CST 2018]; root of context hierarchy 07:49:20.817 [Thread-3] INFO com.zaxxer.hikari.HikariDataSource - [close,381] - HikariPool-2 - Shutdown initiated... 07:49:20.833 [Thread-3] INFO com.zaxxer.hikari.HikariDataSource - [close,383] - HikariPool-2 - Shutdown completed. 07:49:20.834 [Thread-3] INFO com.zaxxer.hikari.HikariDataSource - [close,381] - HikariPool-1 - Shutdown initiated... 07:49:20.845 [Thread-3] INFO com.zaxxer.hikari.HikariDataSource - [close,383] - HikariPool-1 - Shutdown completed. ``` druid-spring-boot-starter版本1.1.9

Linux服务器Tomcat启动时,连接数据库正常,URL访问时,创建不了数据库连接

Linux服务器Tomcat启动时,连接数据库正常,URL访问时,创建不了数据库连接 报如图所示错误,项目是用 maven + ssm框架的,请问有哪位大神知道是什么原 因导致的吗,这个项目放到Windows服务器的Tomcat下是正常的,没有错误,不是网络原因。急急急![图片说明](https://img-ask.csdn.net/upload/201803/29/1522317709_437033.png)

DruidDataSource 配置mysql,启动报错,求大神指点

地址信息: jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/order?characterEncoding=UTF-8 jdbc.username=root jdbc.password=123456 jdbc.initSize=5 jdbc.maxActive=10 jdbc.maxIdle=5 jdbc.minIdle=2 jdbc.maxWait=1000 <!-- 配置数据源 --> <bean id="dataSourceone" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close"> <!-- 数据库基本信息配置 --> <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 初始化连接数量 --> <property name="initialSize" value="${jdbc.initSize}" /> <!-- 最大并发连接数 --> <property name="maxActive" value="${jdbc.maxActive}" /> <!-- 最大空闲连接数 --> <property name="maxIdle" value="${jdbc.maxIdle}" /> <!-- 最小空闲连接数 --> <property name="minIdle" value="${jdbc.minIdle}" /> <!-- 配置获取连接等待超时的时间 ms --> <property name="maxWait" value="${jdbc.maxWait}" /> <!-- 牺牲效率,避免活锁 --> <property name="useUnfairLock" value="false" /> <!-- 超过时间限制是否回收 未归还(调用close)的连接 --> <property name="removeAbandoned" value="false" /> <!-- 超时回收限制多长;没有批量处理需求,设短一点,单位 秒 --> <property name="removeAbandonedTimeout" value="180" /> <!-- 用来检测连接是否有效的sql,要求是一个查询语句--> <property name="validationQuery" value="SELECT 1 FROM dual" /> <!-- 空闲的时候检测(空闲时间超过下面的值) --> <property name="testWhileIdle" value="true" /> <!-- 申请连接时执行validationQuery检测连接是否有效,配置为true会降低性能 --> <property name="testOnBorrow" value="false" /> <!-- 归还连接时执行validationQuery检测连接是否有效,配置为true会降低性能 --> <property name="testOnReturn" value="false" /> <!-- Destroy线程检测是否关闭连接的间隔,同时也是空闲检测的判断依据,单位 毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="600000" /> <!--属性类型是字符串,通过别名的方式配置扩展插件,常用的插件有: 监控统计用的filter:stat 日志用的filter:log4j 防御SQL注入的filter:wall--> <property name="filters" value="filter:wall" /> </bean> 启动报错:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'root'@'122.225.88.154' (using password: YES) 122.225.88.154都不知道是哪里的地址,我已经蒙了,求大神指点

分布式tx-lcn5.0.2版本,测试遇到的问题

首先是debug 断点调试 5.0.2 tm和tc,tm正在创建事务组的时候,tc会进入到这个函数里面,并且会进入到 log.warn("Non lcn connection when clear transaction."); @Override public void clear(String groupId, int state, String unitId, String unitType) throws TransactionClearException { try { LcnConnectionProxy connectionProxy = globalContext.getLcnConnection(groupId); connectionProxy.notify(state); // todo notify exception } catch (TCGlobalContextException e) { log.warn("Non lcn connection when clear transaction."); } } 不知道这个过程是如何调用的,是否是超时。 tm里面可以设置dtxTime,tc不能设置?tc会读取tc的这个文件,但是这得修改tc的源码,然后打jar包修改。按着官网上说的,tm里面设置的时间会传到tc这边来,但是没看到。修改tm的配置文件并没有影响到tc。求解答。 public class TxClientConfig { public TxClientConfig() { this.dtxAspectOrder = 0; this.dtxTime = 30 * 1000; this.managerAddress = Collections.singletonList("127.0.0.1:8070"); } 。。。。。 }

启动tomcat后,只要有数据操作mysql服务就自动关闭?

今天把项目部署到服务器上时,报了一个error。 后来检查发现,mysql服务停止了,但是之前服务已经启动了。经过几次测试发现,没启动tomcat时,使用Navicat对数据库操作不会有问题,只要启动项目,一有数据操作就会自动停止mysql服务,这是什么情况? 错误信息如下: 2017-11-01 08:49:35,007 ERROR [com.alibaba.druid.pool.DruidDataSource] - create connection error, url: jdbc:mysql://192.168.251.229:3306/creditteaching?useUnico de=true&characterEncoding=utf-8, errorCode 0, state 08S01 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai lure The last packet sent successfully to the server was 0 milliseconds ago. The driv er has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct orAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC onstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1 127) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 539) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct orAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC onstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :344) at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterCha inImpl.java:148) at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilte r.java:211) at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterCha inImpl.java:142) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnecti on(DruidAbstractDataSource.java:1410) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnecti on(DruidAbstractDataSource.java:1464) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(Dru idDataSource.java:1969) Caused by: java.net.ConnectException: Connection refused: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketI mpl.java:79) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.ja va:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocket Impl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java :182) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at java.net.Socket.connect(Socket.java:528) at java.net.Socket.<init>(Socket.java:425) at java.net.Socket.<init>(Socket.java:241) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja va:258) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:306) ... 18 more 数据源使用的时druid,配置信息如下: <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!-- 数据源驱动类可不写,Druid默认会自动根据URL识别DriverClass --> <property name="driverClassName" value="${jdbc.driver}" /> <!-- 基本属性 url、user、password --> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 配置初始化大小、最小、最大 --> <property name="initialSize" value="1" /> <property name="minIdle" value="3" /> <property name="maxActive" value="20" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="60000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="validationQuery" value="${jdbc.testSql}" /> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小(Oracle使用) <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> --> <!-- 配置监控统计拦截的filters --> <property name="filters" value="stat" /> </bean>

定量遥感中文版 梁顺林著 范闻捷译

这是梁顺林的定量遥感的中文版,由范闻捷等翻译的,是电子版PDF,解决了大家看英文费时费事的问题,希望大家下载看看,一定会有帮助的

Java 最常见的 200+ 面试题:面试必备

这份面试清单是从我 2015 年做了 TeamLeader 之后开始收集的,一方面是给公司招聘用,另一方面是想用它来挖掘在 Java 技术栈中,还有那些知识点是我不知道的,我想找到这些技术盲点,然后修复它,以此来提高自己的技术水平。虽然我是从 2009 年就开始参加编程工作了,但我依旧觉得自己现在要学的东西很多,并且学习这些知识,让我很有成就感和满足感,那所以何乐而不为呢? 说回面试的事,这份面试...

机器学习初学者必会的案例精讲

通过六个实际的编码项目,带领同学入门人工智能。这些项目涉及机器学习(回归,分类,聚类),深度学习(神经网络),底层数学算法,Weka数据挖掘,利用Git开源项目实战等。

远程工具,免费

远程工具,免费

java jdk 8 帮助文档 中文 文档 chm 谷歌翻译

JDK1.8 API 中文谷歌翻译版 java帮助文档 JDK API java 帮助文档 谷歌翻译 JDK1.8 API 中文 谷歌翻译版 java帮助文档 Java最新帮助文档 本帮助文档是使用谷

csma/ca和csma/cd的matlab仿真源代码带有详细的注释

csma/ca和csma/cd的matlab仿真源代码带有详细的注释,载波侦听,随意设置节点数,带有炫酷的图形展示效果。

Java基础知识面试题(2020最新版)

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性?原理是什么Java语言有哪些特点什么是字节码?采用字节码的最大好处是什么什么是Java程序的主类?应用程序和小程序的主类有何不同?Java应用程序与小程序之间有那些差别?Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

软件测试入门、SQL、性能测试、测试管理工具

软件测试2小时入门,让您快速了解软件测试基本知识,有系统的了解; SQL一小时,让您快速理解和掌握SQL基本语法 jmeter性能测试 ,让您快速了解主流来源性能测试工具jmeter 测试管理工具-禅道,让您快速学会禅道的使用,学会测试项目、用例、缺陷的管理、

pokemmo的资源

pokemmo必须的4个rom 分别为绿宝石 火红 心金 黑白 还有汉化补丁 资源不错哦 记得下载

三个项目玩转深度学习(附1G源码)

从事大数据与人工智能开发与实践约十年,钱老师亲自见证了大数据行业的发展与人工智能的从冷到热。事实证明,计算机技术的发展,算力突破,海量数据,机器人技术等,开启了第四次工业革命的序章。深度学习图像分类一直是人工智能的经典任务,是智慧零售、安防、无人驾驶等机器视觉应用领域的核心技术之一,掌握图像分类技术是机器视觉学习的重中之重。针对现有线上学习的特点与实际需求,我们开发了人工智能案例实战系列课程。打造:以项目案例实践为驱动的课程学习方式,覆盖了智能零售,智慧交通等常见领域,通过基础学习、项目案例实践、社群答疑,三维立体的方式,打造最好的学习效果。

无线通信中的智能天线:IS-95和第3代CDMA应用_.pdf

无线通信中的智能天线:IS-95和第3代CDMA应用_.pdf

设计模式(JAVA语言实现)--20种设计模式附带源码

课程亮点: 课程培训详细的笔记以及实例代码,让学员开始掌握设计模式知识点 课程内容: 工厂模式、桥接模式、组合模式、装饰器模式、外观模式、享元模式、原型模型、代理模式、单例模式、适配器模式 策略模式、模板方法模式、观察者模式、迭代器模式、责任链模式、命令模式、备忘录模式、状态模式、访问者模式 课程特色: 笔记设计模式,用笔记串连所有知识点,让学员从一点一滴积累,学习过程无压力 笔记标题采用关键字标识法,帮助学员更加容易记住知识点 笔记以超链接形式让知识点关联起来,形式知识体系 采用先概念后实例再应用方式,知识点深入浅出 提供授课内容笔记作为课后复习以及工作备查工具 部分图表(电脑PC端查看):

Java8零基础入门视频教程

这门课程基于主流的java8平台,由浅入深的详细讲解了java SE的开发技术,可以使java方向的入门学员,快速扎实的掌握java开发技术!

玩转Linux:常用命令实例指南

人工智能、物联网、大数据时代,Linux正有着一统天下的趋势,几乎每个程序员岗位,都要求掌握Linux。本课程零基础也能轻松入门。 本课程以简洁易懂的语言手把手教你系统掌握日常所需的Linux知识,每个知识点都会配合案例实战让你融汇贯通。课程通俗易懂,简洁流畅,适合0基础以及对Linux掌握不熟练的人学习; 【限时福利】 1)购课后按提示添加小助手,进答疑群,还可获得价值300元的编程大礼包! 2)本月购买此套餐加入老师答疑交流群,可参加老师的免费分享活动,学习最新技术项目经验。 --------------------------------------------------------------- 29元=掌握Linux必修知识+社群答疑+讲师社群分享会+700元编程礼包。 &nbsp;

极简JAVA学习营第四期(报名以后加助教微信:eduxy-1)

想学好JAVA必须要报两万的培训班吗? Java大神勿入 如果你: 零基础想学JAVA却不知道从何入手 看了一堆书和视频却还是连JAVA的环境都搭建不起来 囊中羞涩面对两万起的JAVA培训班不忍直视 在职没有每天大块的时间专门学习JAVA 那么恭喜你找到组织了,在这里有: 1. 一群志同道合立志学好JAVA的同学一起学习讨论JAVA 2. 灵活机动的学习时间完成特定学习任务+每日编程实战练习 3. 热心助人的助教和讲师及时帮你解决问题,不按时完成作业小心助教老师的家访哦 上一张图看看前辈的感悟: &nbsp; &nbsp; 大家一定迫不及待想知道什么是极简JAVA学习营了吧,下面就来给大家说道说道: 什么是极简JAVA学习营? 1. 针对Java小白或者初级Java学习者; 2. 利用9天时间,每天1个小时时间; 3.通过 每日作业 / 组队PK / 助教答疑 / 实战编程 / 项目答辩 / 社群讨论 / 趣味知识抢答等方式让学员爱上学习编程 , 最终实现能独立开发一个基于控制台的‘库存管理系统’ 的学习模式 极简JAVA学习营是怎么学习的? &nbsp; 如何报名? 只要购买了极简JAVA一:JAVA入门就算报名成功! &nbsp;本期为第四期极简JAVA学习营,我们来看看往期学员的学习状态: 作业看这里~ &nbsp; 助教的作业报告是不是很专业 不交作业打屁屁 助教答疑是不是很用心 &nbsp; 有奖抢答大家玩的很嗨啊 &nbsp; &nbsp; 项目答辩终于开始啦 &nbsp; 优秀者的获奖感言 &nbsp; 这是答辩项目的效果 &nbsp; &nbsp; 这么细致的服务,这么好的氛围,这样的学习效果,需要多少钱呢? 不要1999,不要199,不要99,只要9.9 是的你没听错,只要9.9以上所有就都属于你了 如果你: 1、&nbsp;想学JAVA没有基础 2、&nbsp;想学JAVA没有整块的时间 3、&nbsp;想学JAVA没有足够的预算 还等什么?赶紧报名吧,抓紧抢位,本期只招300人,错过只有等时间待定的下一期了 &nbsp; 报名请加小助手微信:eduxy-1 &nbsp; &nbsp;

Python数据清洗实战入门

本次课程主要以真实的电商数据为基础,通过Python详细的介绍了数据分析中的数据清洗阶段各种技巧和方法。

董付国老师Python全栈学习优惠套餐

购买套餐的朋友可以关注微信公众号“Python小屋”,上传付款截图,然后领取董老师任意图书1本。

linux下利用/proc进行进程树的打印

在linux下利用c语言实现的进程树的打印,主要通过/proc下的目录中的进程文件,获取status中的进程信息内容,然后利用递归实现进程树的打印

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

HoloLens2开发入门教程

本课程为HoloLens2开发入门教程,讲解部署开发环境,安装VS2019,Unity版本,Windows SDK,创建Unity项目,讲解如何使用MRTK,编辑器模拟手势交互,打包VS工程并编译部署应用到HoloLens上等。

150讲轻松搞定Python网络爬虫

【为什么学爬虫?】 &nbsp; &nbsp; &nbsp; &nbsp;1、爬虫入手容易,但是深入较难,如何写出高效率的爬虫,如何写出灵活性高可扩展的爬虫都是一项技术活。另外在爬虫过程中,经常容易遇到被反爬虫,比如字体反爬、IP识别、验证码等,如何层层攻克难点拿到想要的数据,这门课程,你都能学到! &nbsp; &nbsp; &nbsp; &nbsp;2、如果是作为一个其他行业的开发者,比如app开发,web开发,学习爬虫能让你加强对技术的认知,能够开发出更加安全的软件和网站 【课程设计】 一个完整的爬虫程序,无论大小,总体来说可以分成三个步骤,分别是: 网络请求:模拟浏览器的行为从网上抓取数据。 数据解析:将请求下来的数据进行过滤,提取我们想要的数据。 数据存储:将提取到的数据存储到硬盘或者内存中。比如用mysql数据库或者redis等。 那么本课程也是按照这几个步骤循序渐进的进行讲解,带领学生完整的掌握每个步骤的技术。另外,因为爬虫的多样性,在爬取的过程中可能会发生被反爬、效率低下等。因此我们又增加了两个章节用来提高爬虫程序的灵活性,分别是: 爬虫进阶:包括IP代理,多线程爬虫,图形验证码识别、JS加密解密、动态网页爬虫、字体反爬识别等。 Scrapy和分布式爬虫:Scrapy框架、Scrapy-redis组件、分布式爬虫等。 通过爬虫进阶的知识点我们能应付大量的反爬网站,而Scrapy框架作为一个专业的爬虫框架,使用他可以快速提高我们编写爬虫程序的效率和速度。另外如果一台机器不能满足你的需求,我们可以用分布式爬虫让多台机器帮助你快速爬取数据。 &nbsp; 从基础爬虫到商业化应用爬虫,本套课程满足您的所有需求! 【课程服务】 专属付费社群+每周三讨论会+1v1答疑

MySQL 8.0.19安装教程(windows 64位)

话不多说直接开干 目录 1-先去官网下载点击的MySQL的下载​ 2-配置初始化的my.ini文件的文件 3-初始化MySQL 4-安装MySQL服务 + 启动MySQL 服务 5-连接MySQL + 修改密码 先去官网下载点击的MySQL的下载 下载完成后解压 解压完是这个样子 配置初始化的my.ini文件的文件 ...

Python数据挖掘简易入门

&nbsp; &nbsp; &nbsp; &nbsp; 本课程为Python数据挖掘方向的入门课程,课程主要以真实数据为基础,详细介绍数据挖掘入门的流程和使用Python实现pandas与numpy在数据挖掘方向的运用,并深入学习如何运用scikit-learn调用常用的数据挖掘算法解决数据挖掘问题,为进一步深入学习数据挖掘打下扎实的基础。

深度学习原理+项目实战+算法详解+主流框架(套餐)

深度学习系列课程从深度学习基础知识点开始讲解一步步进入神经网络的世界再到卷积和递归神经网络,详解各大经典网络架构。实战部分选择当下最火爆深度学习框架PyTorch与Tensorflow/Keras,全程实战演示框架核心使用与建模方法。项目实战部分选择计算机视觉与自然语言处理领域经典项目,从零开始详解算法原理,debug模式逐行代码解读。适合准备就业和转行的同学们加入学习! 建议按照下列课程顺序来进行学习 (1)掌握深度学习必备经典网络架构 (2)深度框架实战方法 (3)计算机视觉与自然语言处理项目实战。(按照课程排列顺序即可)

网络工程师小白入门--【思科CCNA、华为HCNA等网络工程师认证】

本课程适合CCNA或HCNA网络小白同志,高手请绕道,可以直接学习进价课程。通过本预科课程的学习,为学习网络工程师、思科CCNA、华为HCNA这些认证打下坚实的基础! 重要!思科认证2020年2月24日起,已启用新版认证和考试,包括题库都会更新,由于疫情原因,请关注官网和本地考点信息。题库网络上很容易下载到。

Ubuntu18.04安装教程

Ubuntu18.04.1安装一、准备工作1.下载Ubuntu18.04.1 LTS2.制作U盘启动盘3.准备 Ubuntu18.04.1 的硬盘空间二、安装Ubuntu18.04.1三、安装后的一些工作1.安装输入法2.更换软件源四、双系统如何卸载Ubuntu18.04.1新的改变功能快捷键合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列...

sql语句 异常 Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your

在我们开发的工程中,有时候会报 [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ------ 这种异常 不用多想,肯定是我们的sql语句出现问题,下面...

西南交通大学新秀杯数学建模试题

题目比较难,如果符合大家的口味欢迎大家下载哈,提高你的思维想象能力

Windows版YOLOv4目标检测实战:训练自己的数据集

课程演示环境:Windows10; cuda 10.2; cudnn7.6.5; Python3.7; VisualStudio2019; OpenCV3.4 需要学习ubuntu系统上YOLOv4的同学请前往:《YOLOv4目标检测实战:训练自己的数据集》 课程链接:https://edu.csdn.net/course/detail/28745 YOLOv4来了!速度和精度双提升! 与 YOLOv3 相比,新版本的 AP (精度)和 FPS (每秒帧率)分别提高了 10% 和 12%。 YOLO系列是基于深度学习的端到端实时目标检测方法。本课程将手把手地教大家使用labelImg标注和使用YOLOv4训练自己的数据集。课程实战分为两个项目:单目标检测(足球目标检测)和多目标检测(足球和梅西同时检测)。 本课程的YOLOv4使用AlexyAB/darknet,在Windows系统上做项目演示。包括:安装软件环境、安装YOLOv4、标注自己的数据集、整理自己的数据集、修改配置文件、训练自己的数据集、测试训练出的网络模型、性能统计(mAP计算)和先验框聚类分析。还将介绍改善YOLOv4目标检测性能的技巧。 除本课程《Windows版YOLOv4目标检测实战:训练自己的数据集》外,本人将推出有关YOLOv4目标检测的系列课程。请持续关注该系列的其它视频课程,包括: 《Windows版YOLOv4目标检测实战:人脸口罩佩戴检测》 《Windows版YOLOv4目标检测实战:中国交通标志识别》 《Windows版YOLOv4目标检测:原理与源码解析》

Spring Boot -01- 快速入门篇(图文教程)

Spring Boot -01- 快速入门篇 今天开始不断整理 Spring Boot 2.0 版本学习笔记,大家可以在博客看到我的笔记,然后大家想看视频课程也可以到【慕课网】手机 app,去找【Spring Boot 2.0 深度实践】的课程,令人开心的是,课程完全免费! 什么是 Spring Boot? Spring Boot 是由 Pivotal 团队提供的全新框架。Spring Boot...

相关热词 c#对文件改写权限 c#中tostring c#支付宝回掉 c#转换成数字 c#判断除法是否有模 c# 横向chart c#控件选择多个 c#报表如何锁定表头 c#分级显示数据 c# 不区分大小写替换
立即提问
相关内容推荐