Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ask a question for help, Connection is not available, request timed out after 30000 #2280

Open
qq31715879 opened this issue Jan 3, 2025 · 3 comments

Comments

@qq31715879
Copy link

connections status of services

image

The active number of client connection pools is very low, but obtaining links still times out
javax.sql.DataSource.getConnection poolName:HikariPool-business timeout: 9015 > 1000, current connections: 8

com.zaxxer.hikari.pool.HikariPool#createTimeoutException

I don't know where there might be a problem

@xiaoye-2018
Copy link

xiaoye-2018 commented Jan 4, 2025

you should check network is work ok ? or increase the connectionTimeout @qq31715879

@qq31715879
Copy link
Author

you should check network is work ok ? or increase the connectionTimeout @qq31715879

It is indeed possible that it is a network issue. Our company's operations and maintenance have given us normal indicators. Let me first think about how to prove that it is a network problem

@wangwenzhao1
Copy link

wangwenzhao1 commented Jan 23, 2025

Image

Image

I had the same problem, my service was on the same server as the database
2025-01-23 09:20:45.004[ WARN] 122093 [] [HikariPool-1 housekeeper:229294143] [com.zaxxer.hikari.pool.HikariPool.?:?] HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=32m10s221ms838µs213ns).

2025-01-23 09:26:56.732[ WARN] 122093 [e8df73a25e59414cbce13469d4f583eb] [XNIO-2 task-93:229665871] [c.g.z.boot.handler.DefaultGlobalExceptionHandler.?:?] Exception:
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 970095ms.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants