net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec: I/O exception while executing DDL

user_12272116 0
Viewed 1537

I am trying to executing a DDL query using snowflake jdbc driver:

Create table table_destination as select * from table_source

I am seeing these errors in logs. Although, table in snowflake is created successfully.

error:

net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec: I/O exception (net.snowflake.client.jdbc.internal.apache.http.NoHttpResponseException) caught when processing request to {s}->https://xyz.snowflakecomputing.com:443: The target server failed to respond

It seems like table creation is taking too long and snowflake is retrying to get response. Can someone please explain what's happening here?

snowflake-cloud-data-platform
1 Answers

I found this post.( https://github.com/DigitalPebble/storm-crawler/issues/405 )

Try ensure automatic retries is enabled. E.g. builder = HttpClients.custom().setUserAgent(userAgent) .setConnectionManager(CONNECTION_MANAGER) .setConnectionManagerShared(true).disableRedirectHandling(); //.disableAutomaticRetries();

user_122866060
Related