Comments (1)
hi, thank you for raising this issue with us. using
cfg := &sf.Config{
Account: account,
User: user,
Password: password,
Host: host,
Port: port,
Protocol: protocol,
Tracing: "trace",
ClientTimeout: 1 * time.Second,
}
and a very unefficient query on purpose, i can actually see in the trace logs that the HTTP request is actually timing out pretty soon (and then retried for a while)
$ go run gh682.go
2023-03-29 13:47:36 - Starting executing query.
INFO[0000]log.go:150 gosnowflake.(*defaultLogger).Info OpenWithConfig
INFO[0000]log.go:106 gosnowflake.(*defaultLogger).Infof Authenticating via SNOWFLAKE
INFO[0000]log.go:150 gosnowflake.(*defaultLogger).Info Username and password
INFO[0000]auth.go:403 gosnowflake.authenticate PARAMS for Auth: &map[], https, myaccount.ap-northeast-2.aws.snowflakecomputing.com, 443, 1m0s, SNOWFLAKE
INFO[0000]log.go:106 gosnowflake.(*defaultLogger).Infof full URL: https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=ac82028c-136a-4792-7b89-02382dea220d
INFO[0000]retry.go:211 gosnowflake.(*retryHTTP).execute retryHTTP.totalTimeout: 1m0s
DEBU[0000]log.go:102 gosnowflake.(*defaultLogger).Debugf retry count: 0
INFO[0000]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=*.ap-northeast-2.snowflakecomputing.com, Issuer: CN=Amazon RSA 2048 M01,O=Amazon,C=US
INFO[0000]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=Amazon RSA 2048 M01,O=Amazon,C=US, Issuer: CN=Amazon Root CA 1,O=Amazon,C=US
WARN[0001]retry.go:239 gosnowflake.(*retryHTTP).execute failed http connection. no response is returned. err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=ac82028c-136a-4792-7b89-02382dea220d": context deadline exceeded (Client.Timeout exceeded while awaiting headers). retrying...
INFO[0001]retry.go:257 gosnowflake.(*retryHTTP).execute to timeout: 1m0s
INFO[0001]retry.go:279 gosnowflake.(*retryHTTP).execute sleeping 2s. to timeout: 58s. retrying
DEBU[0003]log.go:102 gosnowflake.(*defaultLogger).Debugf retry count: 1
INFO[0003]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=*.ap-northeast-2.snowflakecomputing.com, Issuer: CN=Amazon RSA 2048 M01,O=Amazon,C=US
INFO[0003]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=Amazon RSA 2048 M01,O=Amazon,C=US, Issuer: CN=Amazon Root CA 1,O=Amazon,C=US
WARN[0004]retry.go:239 gosnowflake.(*retryHTTP).execute failed http connection. no response is returned. err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=29ff8564-05b1-476a-72ba-9e7bc1ad0abc": context deadline exceeded (Client.Timeout exceeded while awaiting headers). retrying...
INFO[0004]retry.go:257 gosnowflake.(*retryHTTP).execute to timeout: 58s
INFO[0004]retry.go:279 gosnowflake.(*retryHTTP).execute sleeping 5s. to timeout: 53s. retrying
DEBU[0009]log.go:102 gosnowflake.(*defaultLogger).Debugf retry count: 2
INFO[0009]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=*.ap-northeast-2.snowflakecomputing.com, Issuer: CN=Amazon RSA 2048 M01,O=Amazon,C=US
INFO[0009]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=Amazon RSA 2048 M01,O=Amazon,C=US, Issuer: CN=Amazon Root CA 1,O=Amazon,C=US
WARN[0010]retry.go:239 gosnowflake.(*retryHTTP).execute failed http connection. no response is returned. err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=d4db97a9-63ac-4f8c-4a60-02202aa85f66": context deadline exceeded (Client.Timeout exceeded while awaiting headers). retrying...
INFO[0010]retry.go:257 gosnowflake.(*retryHTTP).execute to timeout: 53s
INFO[0010]retry.go:279 gosnowflake.(*retryHTTP).execute sleeping 7s. to timeout: 46s. retrying
DEBU[0017]log.go:102 gosnowflake.(*defaultLogger).Debugf retry count: 3
INFO[0017]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=*.ap-northeast-2.snowflakecomputing.com, Issuer: CN=Amazon RSA 2048 M01,O=Amazon,C=US
INFO[0017]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=Amazon RSA 2048 M01,O=Amazon,C=US, Issuer: CN=Amazon Root CA 1,O=Amazon,C=US
WARN[0018]retry.go:239 gosnowflake.(*retryHTTP).execute failed http connection. no response is returned. err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=c2357e99-6afa-48bb-576e-236a47e74dfe": context deadline exceeded (Client.Timeout exceeded while awaiting headers). retrying...
INFO[0018]retry.go:257 gosnowflake.(*retryHTTP).execute to timeout: 46s
INFO[0018]retry.go:279 gosnowflake.(*retryHTTP).execute sleeping 14s. to timeout: 32s. retrying
DEBU[0032]log.go:102 gosnowflake.(*defaultLogger).Debugf retry count: 4
INFO[0032]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=*.ap-northeast-2.snowflakecomputing.com, Issuer: CN=Amazon RSA 2048 M01,O=Amazon,C=US
INFO[0032]log.go:106 gosnowflake.(*defaultLogger).Infof Subject: CN=Amazon RSA 2048 M01,O=Amazon,C=US, Issuer: CN=Amazon Root CA 1,O=Amazon,C=US
WARN[0033]retry.go:239 gosnowflake.(*retryHTTP).execute failed http connection. no response is returned. err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=2e4ea01e-d37a-4dde-428f-e91b07197988": context deadline exceeded (Client.Timeout exceeded while awaiting headers). retrying...
INFO[0033]retry.go:257 gosnowflake.(*retryHTTP).execute to timeout: 32s
2023/03/29 13:48:09 failed to run a query. SELECT * from snowflake_sample_data.tpch_sf1000.customer, snowflake_sample_data.tpch_sf1000.lineitem, err: Post "https://myaccount.ap-northeast-2.aws.snowflakecomputing.com:443/session/v1/login-request?requestId=7b0ff885-aa00-4043-4c82-17f944511eda&request_guid=2e4ea01e-d37a-4dde-428f-e91b07197988": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
exit status 1
using 1.6.19
of the driver here. can you please try to use this version and see how it goes? if it is still not behaving per the exceptions, please enable the Tracing
as per above example and post the logs + code snippet and I'll reopen this issue for you. Thank you !
from gosnowflake.
Related Issues (20)
- Using bool type parmeter failed with error code = 100132 in multi statements query HOT 3
- Array binding support for filtering parameter HOT 2
- SNOW-938672 Snyk: gosnowflake google.golang.org/grpc v1.49.0 | Snyk ID - SNYK-GOLANG-GOOGLEGOLANGORGGRPC-5953328 HOT 3
- Segfault from s3_storage_client.go:96 HOT 6
- WithMultiStatement - creates an extra process for all queries that doesn't resolve until all queries are resolved. Takes up extra space and blocks other requests. HOT 2
- SNOW-995607 Snyk: gosnowflake golang.org/x/crypto v0.15.0 | Snyk ID - SNYK-GOLANG-GOLANGORGXCRYPTOSSH-6130669 HOT 3
- SNOW-995714 SNOW-998050 Calling stored procedure returning a table in multi-statements query fail with code = 100132 HOT 2
- SNOW-996366 Snyk: gosnowflake github.com/dvsekhvalnov/jose2go 1.5.0 | Snyk ID - SNYK-GOLANG-GITHUBCOMDVSEKHVALNOVJOSE2GO-6137739 HOT 4
- Context not propagated to snowflakeFileTransferAgent on PUT command; cancellation is not supported HOT 3
- JWT token generation is generating an invalid JWT issuer using {account} value HOT 4
- SNOW-1011471 Authentication failed when setting search_path parameter on connection string HOT 3
- GetArrowBatches panics when query returns 0 rows HOT 8
- SNOW-1017575 github.com/form3tech-oss/jwt-go is deprecated HOT 3
- No way to add a row with different typed columns through gosnowflake driver HOT 2
- SNOW-1020361 Unable to insert a UUID/byte array into an existing table HOT 7
- SNOW-1045439 Timestamp_ntz column values are formatted with UTC timezone HOT 3
- SNOW-1061246 "account" parameter is always required by `sf.DSN`? HOT 3
- Race in `easy_logging.go` introduced in v1.8.0 HOT 1
- Does setting CLIENT_SESSION_KEEP_ALIVE to true keep compute resources active and cost money? HOT 2
- SNOW-1230690 File Transfers to buckets in AWS US GOV and AWS China Partitions fail as they do not support Transfer Acceleration HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gosnowflake.