druid数据源配置本地数据库正常,配置其他服务器数据库异常

提问 2 2935
allensu
allensu 2019-03-02
版本:renren-security 开发环境:
renren-security项目的renren-admin有个问题请教,数据源配的本地数据库正常,配的别的服务器上的数据库,启动正常但是首次登录报错,再登录又正常。 报错信息如下: 2019-03-02 14:04:25.466 ERROR 16648 --- [io-8081-exec-28] c.a.druid.pool.DruidPooledStatement : CommunicationsException, druid version 1.1.10, jdbcUrl : jdbc:mysql://58.215.179.73:33061/subsidyLock?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true, testWhileIdle true, idle millis 54774, minIdle 0, poolingCount 0, timeBetweenEvictionRunsMillis 60000, lastValidIdleMillis 54774, driver com.mysql.jdbc.Driver, exceptionSorter com.alibaba.druid.pool.vendor.MySqlExceptionSorter 2019-03-02 14:04:25.472 ERROR 16648 --- [io-8081-exec-28] com.alibaba.druid.pool.DruidDataSource : discard connection com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 65,081 milliseconds ago. The last packet sent successfully to the server was 36 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3465) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3365) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3805) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
回帖
  • MySQL8的配置不同
    0 回复
  • allensu
    allensu (楼主)
    2019-03-18
    @Mark 可能是mysql版本问题 最终解决是把数据源改成 HikariPC
    0 回复