🐛 [Bug] 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.

[freehao666]

Contribution guidelines

• I've read the contribution guidelines and wholeheartedly agree

I've found a bug and checked that ...

• ... the problem doesn't occur with the server or web themes
• ... the documentation does not mention anything about my problem
• ... there are no open or closed issues that are related to my problem

Affected Module

Core (Default)

Description

你好，我创建doris数据源时一直超时，请帮忙看一下问题，谢谢。

Hello, I keep getting a timeout error when creating a Doris data source. Could you please help me take a look at the issue? Thank you.

`2025-05-30 09:05:34,168 ERROR [http-nio-0.0.0.0-9096-exec-9] io.edurt.datacap.spi.connection.JdbcConnection [JdbcConnection.java:68] Connection failed
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:828)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at io.edurt.datacap.spi.connection.JdbcConnection.lambda$openConnection$0(JdbcConnection.java:48)
at io.edurt.datacap.plugin.PluginContextManager.runWithClassLoader(PluginContextManager.java:92)
at io.edurt.datacap.spi.connection.JdbcConnection.openConnection(JdbcConnection.java:33)
at io.edurt.datacap.spi.connection.Connection.(Connection.java:23)
at io.edurt.datacap.spi.connection.JdbcConnection.(JdbcConnection.java:26)
at io.edurt.datacap.spi.PluginService.connect(PluginService.java:97)
at io.edurt.datacap.spi.PluginService.execute(PluginService.java:179)
at io.edurt.datacap.service.service.impl.SourceServiceImpl.lambda$testConnection$7(SourceServiceImpl.java:217)
at java.base/java.util.Optional.map(Optional.java:265)
at io.edurt.datacap.service.service.impl.SourceServiceImpl.testConnection(SourceServiceImpl.java:183)
at io.edurt.datacap.server.controller.SourceController.testConnection(SourceController.java:47)
at io.edurt.datacap.server.controller.SourceController$$FastClassBySpringCGLIB$$3058a8e2.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.spr
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
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 java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
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.NativeSocketConnection.connect(NativeSocketConnection.java:89)
at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
... 126 common frames omitted
Caused by: java.net.SocketTimeoutException: connect timed out
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.base/java.net.Socket.connect(Socket.java:609)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
... 129 common frames omitted
2025-05-30 09:06:03,13

`

Expected behaviour

No response

Actual behaviour

No response

Steps to reproduce

No response

Package versions

• Java: java --version
• Node: node --version
• Npm: npm -v
• Server: ./mvnw -Dexec.executable='echo' -Dexec.args='${project.version}' --non-recursive exec:exec -Dorg.slf4j.simpleLogger.defaultLogLevel=WARN -Dorg.slf4j.simpleLogger.log.org.apache.maven.plugins.help=INFO | tail -1

Configuration

System information

• Operating system: ...
• Browser: ...

[qianmoQ]

Message that will be displayed on users' first issue

[freehao666]

doris version：3.0.2 datacap:latest

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

doris version：3.0.2 datacap:latest

[qianmoQ]

这个错误一般是主机地址和端口填写失误导致的，或者部署datacap服务的主机无法访问到 doris 的主机
This error is usually caused by the host address and port filling, or the host where the datacap service is deployed cannot access doris's host.

[freehao666]

这个错误一般是主机地址和端口填写失误导致的，或者部署datacap服务的主机无法访问到 doris 的主机 This error is usually caused by the host address and port filling, or the host where the datacap service is deployed cannot access doris's host.

是部署在同一服务器的，端口是9030，现在好了，是端口写错了。

[freehao666]

这个错误一般是主机地址和端口填写失误导致的，或者部署datacap服务的主机无法访问到 doris 的主机 This error is usually caused by the host address and port filling, or the host where the datacap service is deployed cannot access doris's host.

添加完doris数据源后，不显示，这个是什么问题，麻烦老师看一下。mysql的数据源可以正常显示。

[freehao666]

这个错误一般是主机地址和端口填写失误导致的，或者部署datacap服务的主机无法访问到 doris 的主机 This error is usually caused by the host address and port filling, or the host where the datacap service is deployed cannot access doris's host.

添加完doris数据源后，不显示，这个是什么问题，麻烦老师看一下。mysql的数据源可以正常显示。

可以连接上读取数据，看不到具体的doris表信息。

[qianmoQ]

感谢反馈，我正在测试

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Thanks for the feedback, I'm testing