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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
