Presto java.net.SocketTimeoutException: timeout java.io.UncheckedIOException: java.net.SocketTimeoutException: timeout #10735
Labels
Comments
|
do you have the server.log about the problem? Your error stack is from the presto-cli, but we may find the root cause easier from server side. |
|
I got the same issue for Presto 0.217 + Hive 2.3.3. I'm able to query user tables but I'm not able to extract from information_table (e.g show tables). Here is the stack trace that I got from Presto Web UI: Error Information: Error Type | EXTERNAL |
|
I found an error log from the Hive-Metastore when Presto connected: |
|
Hi,
|
|
The root cause is I am not that familiar with okhttp connection management, but one thing I would check is, when the issue happens is a timeout triggered on the client side (connect/read/write timeouts are all 30s, see this)? That may happen if the coordinator is unavailable long enough (say due to a garbage collection pause). This is for checking whether a timeout condition and closing of a socket is correlated. |
|
That issue is resolved it was happening because of presto cli version. |
|
@nico-arianto @nimmicv were you able to workaround this? |
|
I solved this by replaced the Derby with PostgreSQL Reference: nico-arianto/big-data-local#1 |
|
This issue has been automatically marked as stale because it has not had any activity in the last 2 years. If you feel that this issue is important, just comment and the stale tag will be removed; otherwise it will be closed in 7 days. This is an attempt to ensure that our open issues remain valuable and relevant so that we can keep track of what needs to be done and prioritize the right things. |
6 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I am trying to execute presto queries from a presto-cli and I am getting the following error
[hadoop@ip-172-16-125-74 ~]$ presto-cli --debug
presto> show schemas from hive.default;
Error running command: java.net.SocketTimeoutException: timeout
java.io.UncheckedIOException: java.net.SocketTimeoutException: timeout
at com.facebook.presto.client.JsonResponse.execute(JsonResponse.java:148)
at com.facebook.presto.client.StatementClient.(StatementClient.java:118)
at com.facebook.presto.cli.QueryRunner.startInternalQuery(QueryRunner.java:102)
at com.facebook.presto.cli.QueryRunner.startQuery(QueryRunner.java:97)
at com.facebook.presto.cli.Console.process(Console.java:336)
at com.facebook.presto.cli.Console.runConsole(Console.java:262)
at com.facebook.presto.cli.Console.run(Console.java:148)
at com.facebook.presto.cli.Presto.main(Presto.java:32)
Caused by: java.net.SocketTimeoutException: timeout
at okio.Okio$4.newTimeoutException(Okio.java:230)
at okio.AsyncTimeout.exit(AsyncTimeout.java:285)
at okio.AsyncTimeout$2.read(AsyncTimeout.java:241)
at okio.RealBufferedSource.indexOf(RealBufferedSource.java:345)
at okio.RealBufferedSource.readUtf8LineStrict(RealBufferedSource.java:217)
at okio.RealBufferedSource.readUtf8LineStrict(RealBufferedSource.java:211)
at okhttp3.internal.http1.Http1Codec.readResponseHeaders(Http1Codec.java:189)
at okhttp3.internal.http.CallServerInterceptor.intercept(CallServerInterceptor.java:75)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:92)
at okhttp3.internal.connection.ConnectInterceptor.intercept(ConnectInterceptor.java:45)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:92)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:67)
at okhttp3.internal.cache.CacheInterceptor.intercept(CacheInterceptor.java:93)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:92)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:67)
at okhttp3.internal.http.BridgeInterceptor.intercept(BridgeInterceptor.java:93)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:92)
at okhttp3.internal.http.RetryAndFollowUpInterceptor.intercept(RetryAndFollowUpInterceptor.java:120)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:92)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:67)
at okhttp3.RealCall.getResponseWithInterceptorChain(RealCall.java:185)
at okhttp3.RealCall.execute(RealCall.java:69)
at com.facebook.presto.client.JsonResponse.execute(JsonResponse.java:130)
... 7 more
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.read(SocketInputStream.java:204)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at okio.Okio$2.read(Okio.java:139)
at okio.AsyncTimeout$2.read(AsyncTimeout.java:237)
... 27 more
The text was updated successfully, but these errors were encountered: