You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "lzb-libra (via GitHub)" <gi...@apache.org> on 2023/12/05 02:32:22 UTC

[I] 使用Druid在springboot启动时出现的问题 (druid)

lzb-libra opened a new issue, #15490:
URL: https://github.com/apache/druid/issues/15490

   I recently set up a service using spring boot 2.1.1.RELEASE + druid-spring-boot-starter 1.2.9 + mysql-connector-java 8.0.13 + MySQL 5.7.26. However, during startup, I keep encountering some error messages. After a few cycles of these error messages, the service is able to query data normally. I have ensured that my network, database, and everything else are working fine. Could it be that I've misconfigured something?
   
   我最近用spring boot 2.1.1.RELEASE + druid-spring-boot-starter 1.2.9 + mysql-connector-java 8.0.13 + MySQL 5.7.26 搭建了一个服务,但是在启动的时候总是出现一些错误信息,但是这个错误信息循环出现几次后又能正常查询出来数据,我已经确保我的网络、数据库等一切正常,请问我是什么东西配置错误了吗?
   
   ```mysql
   spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
   spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.datasource.druid.initial-size=5
   spring.datasource.druid.max-active=100
   spring.datasource.druid.min-idle=5
   spring.datasource.druid.max-wait=60000
   spring.datasource.druid.pool-prepared-statements=false
   spring.datasource.druid.max-pool-prepared-statement-per-connection-size=100
   spring.datasource.druid.validation-query=SELECT 1
   spring.datasource.druid.validation-query-timeout=1
   spring.datasource.druid.test-on-borrow=false
   spring.datasource.druid.test-on-return=false
   spring.datasource.druid.test-while-idle=true
   spring.datasource.druid.time-between-eviction-runs-millis=60000
   spring.datasource.druid.min-evictable-idle-time-millis=300000
   spring.datasource.druid.filters=stat,wall,log4j2,config
   spring.datasource.druid.filter.config.enabled=true
   spring.datasource.druid.filter.slf4j.enabled=true
   spring.datasource.druid.filter.slf4j.statement-create-after-log-enabled=false
   spring.datasource.druid.filter.slf4j.statement-close-after-log-enabled=false
   spring.datasource.druid.filter.slf4j.result-set-open-after-log-enabled=false
   spring.datasource.druid.filter.slf4j.result-set-close-after-log-enabled=false
   spring.datasource.druid.use-global-data-source-stat=true
   spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500;config.decrypt=true;config.decrypt.key=${publicKey}
   spring.datasource.druid.async-init=true
   spring.datasource.druid.web-stat-filter.enabled=true
   spring.datasource.druid.web-stat-filter.url-pattern=/*
   publicKey=xxxxxxx
   spring.datasource.druid.url=jdbc:mysql://localhost:3306/www?useUnicode=true&useOldAliasMetadataBehavior=true
   spring.datasource.druid.username=xxxxxxx
   spring.datasource.druid.password=xxxxxxx
   ```
   
   ```java
   [2023-12-05 10:19:17.051][Druid-ConnectionPool-Create-2078237101][com.alibaba.druid.pool.DruidAbstractDataSource-INFO][] {dataSource-1} failContinuous is false
   [2023-12-05 10:19:17.054][Druid-ConnectionPool-Create-2078237101][com.alibaba.druid.pool.DruidDataSource-ERROR][] create connection SQLException, url: jdbc:mysql://localhost:3306/www?useUnicode=true&useOldAliasMetadataBehavior=true, errorCode 0, state 08S01
   com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
   
   The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
   	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
   	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
   	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
   	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
   	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
   	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
   	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
   	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:251)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
   	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
   	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
   	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1669)
   	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1733)
   	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2840)
   Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
   
   The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
   	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.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
   	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
   	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
   	at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:555)
   	at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:507)
   	at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:397)
   	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1440)
   	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
   	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955)
   	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
   	... 19 common frames omitted
   Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
   	at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)
   	at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
   	at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
   	at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:549)
   	... 25 common frames omitted
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [I] 使用Druid在springboot启动时出现的问题 (druid)

Posted by "asdf2014 (via GitHub)" <gi...@apache.org>.
asdf2014 closed issue #15490: 使用Druid在springboot启动时出现的问题
URL: https://github.com/apache/druid/issues/15490


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [I] 使用Druid在springboot启动时出现的问题 (druid)

Posted by "asdf2014 (via GitHub)" <gi...@apache.org>.
asdf2014 commented on issue #15490:
URL: https://github.com/apache/druid/issues/15490#issuecomment-1839908539

   Hi @lzb-libra, this is Apache Druid not DB connection pool, you've raised up issue in a wrong place 😂


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org