You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/09/08 02:42:31 UTC
[GitHub] [dolphinscheduler] Flutemr opened a new issue, #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Flutemr opened a new issue, #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
Here is a question. Is it because of hive or DS。
The following is the error message:
[INFO] 2022-09-08 04:25:44.024 org.apache.hive.jdbc.Utils:[318] - Supplied authorities: 100.16100.201:10001
[INFO] 2022-09-08 04:25:44.024 org.apache.hive.jdbc.Utils:[437] - Resolved authority: 100.16100.201:10001
[WARN] 2022-09-08 04:25:45.688 com.zaxxer.hikari.pool.PoolBase:[184] - HikariPool-2 - Failed to validate connection org.apache.hive.jdbc.HiveConnection@46f96733 (org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out). Possibly consider using a shorter maxLifetime value.
[ERROR] 2022-09-08 04:25:45.690 org.apache.dolphinscheduler.plugin.datasource.hive.HiveDataSourceClient:[152] - get oneSessionDataSource Connection fail SQLException: HikariPool-2 - Connection is not available, request timed out after 30002ms.
java.sql.SQLTransientConnectionException: HikariPool-2 - Connection is not available, request timed out after 30002ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.apache.dolphinscheduler.plugin.datasource.hive.HiveDataSourceClient.getConnection(HiveDataSourceClient.java:150)
at org.apache.dolphinscheduler.plugin.datasource.api.plugin.DataSourceClientProvider.getConnection(DataSourceClientProvider.java:66)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:183)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:154)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:191)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:57)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:317)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:250)
at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
... 14 common frames omitted
Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
at org.apache.thrift.transport.TSaslTransport.readLength(TSaslTransport.java:376)
at org.apache.thrift.transport.TSaslTransport.readFrame(TSaslTransport.java:453)
at org.apache.thrift.transport.TSaslTransport.read(TSaslTransport.java:435)
at org.apache.thrift.transport.TSaslClientTransport.read(TSaslClientTransport.java:37)
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
### What you expected to happen
no
### How to reproduce
no
### Anything else
no
### Version
2.0.6
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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@dolphinscheduler.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1272666534
This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1240175555
Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] SbloodyS commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
SbloodyS commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1240312975
What did you expected to happen?
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] Azonerr commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by "Azonerr (via GitHub)" <gi...@apache.org>.
Azonerr commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1515781711
> I want to ask whether it is due to insufficient cluster resources or the hikaripool parameter setting of DS scheduler
we encountered the same question,how to solve this problem?
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1280110909
This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] Flutemr commented on issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
Flutemr commented on issue #11842:
URL: https://github.com/apache/dolphinscheduler/issues/11842#issuecomment-1241409589
> 你预计会发生什么？
I want to ask whether it is due to insufficient cluster resources or the hikaripool parameter setting of DS scheduler
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] closed issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #11842: [Bug]HikariPool-2 - Connection is not available, request timed out after 30002ms
URL: https://github.com/apache/dolphinscheduler/issues/11842
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org