taosdata/TDengine

I/O exception (java.net.SocketTimeoutException) caught when processing request to

Open

#24,700 opened on Feb 1, 2024

View on GitHub
 (1 comment) (0 reactions) (0 assignees)C (5,002 forks)batch import
help wantedquestion

Repository metrics

Stars
 (24,849 stars)
PR merge metrics
 (Avg merge 1d 1h) (4 merged PRs in 30d)

Description

我的数据是在超级表下分开各个普通表，在我select count(ts) from db.普通表时报连接超时的错误 I/O exception (java.net.SocketTimeoutException) caught when processing request to {}->http://xx.xx.xx.xx:36041: Read timed out org.apache.http.impl.execchain.RetryExec | 113 | Retrying request to {}->http://xx.xx.xx.xx:36041

Cause: java.sql.SQLException: ERROR (2318): Read timed out

; uncategorized SQLException; SQL state []; error code [8984]; ERROR (2318): Read timed out; nested exception is java.sql.SQLException: ERROR (2318): Read timed out 。。。 Caused by: java.sql.SQLException: ERROR (2318): Read timed out at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:72) at com.taosdata.jdbc.utils.HttpClientPoolUtil.execute(HttpClientPoolUtil.java:129) at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:65) 。。。 我的普通表大概有18435285条，超级表下大概有二三十个普通表 image

这是在我的TDengineGUI里执行的语句是可以执行的，我查阅资料尝试改jdbc的连接超时时间和mybatis-plus的超时时间，没有效果。我的项目是用application.yml配置，把tdengine用mybatis-plus进行映射使用

如果你有相关思路或者解决办法，请帮助我 谢谢！

Contributor guide

Research direction
Investigate the JDBC connection timeout and socket timeout settings, especially for RESTful connections. Check if the issue is related to the HTTP client's read timeout or the server side query timeout. Consider increasing the timeout values or using a connection pool with appropriate settings.
Tech stack
java
Domain
backenddatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
JavaJDBC
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60