search

SparkFund / google-apps-clj

A Clojure library that wraps the Google Java API for different Google Applications.
Apache License 2.0
94 stars 29 forks source link

Unhandled java.net.SocketTimeoutException despite setting :read-timeout and :connect-timeout #29

Open edmundatgmaven opened 3 years ago

edmundatgmaven commented 3 years ago

Read timeout error for a large sheet (3k records, 120 columns). Setting :read-timeout and :connection-timeout in google-ctx not changing anything. Values set to 560000 but it still times-out after about 15s.

  1. Unhandled java.net.SocketTimeoutException Read timed out

    NioSocketImpl.java:  283  sun.nio.ch.NioSocketImpl/timedRead
NioSocketImpl.java:  309  sun.nio.ch.NioSocketImpl/implRead
NioSocketImpl.java:  350  sun.nio.ch.NioSocketImpl/read
NioSocketImpl.java:  803  sun.nio.ch.NioSocketImpl$1/read
       Socket.java:  982  java.net.Socket$SocketInputStream/read

    SSLSocketInputRecord.java: 469 sun.security.ssl.SSLSocketInputRecord/read SSLSocketInputRecord.java: 463 sun.security.ssl.SSLSocketInputRecord/readHeader SSLSocketInputRecord.java: 70 sun.security.ssl.SSLSocketInputRecord/bytesInCompletePacket SSLSocketImpl.java: 1421 sun.security.ssl.SSLSocketImpl/readApplicationRecord SSLSocketImpl.java: 1033 sun.security.ssl.SSLSocketImpl$AppInputStream/read BufferedInputStream.java: 244 java.io.BufferedInputStream/fill BufferedInputStream.java: 284 java.io.BufferedInputStream/read1 BufferedInputStream.java: 343 java.io.BufferedInputStream/read HttpClient.java: 754 sun.net.www.http.HttpClient/parseHTTPHeader HttpClient.java: 689 sun.net.www.http.HttpClient/parseHTTP HttpURLConnection.java: 1623 sun.net.www.protocol.http.HttpURLConnection/getInputStream0 HttpURLConnection.java: 1528 sun.net.www.protocol.http.HttpURLConnection/getInputStream HttpURLConnection.java: 527 java.net.HttpURLConnection/getResponseCode HttpsURLConnectionImpl.java: 308 sun.net.www.protocol.https.HttpsURLConnectionImpl/getResponseCode NetHttpResponse.java: 37 com.google.api.client.http.javanet.NetHttpResponse/ NetHttpRequest.java: 94 com.google.api.client.http.javanet.NetHttpRequest/execute HttpRequest.java: 981 com.google.api.client.http.HttpRequest/execute AbstractGoogleClientRequest.java: 419 com.google.api.client.googleapis.services.AbstractGoogleClientRequest/executeUnparsed AbstractGoogleClientRequest.java: 352 com.google.api.client.googleapis.services.AbstractGoogleClientRequest/executeUnparsed AbstractGoogleClientRequest.java: 469 com.google.api.client.googleapis.services.AbstractGoogleClientRequest/execute google_sheets_v4.clj: 391 google-apps-clj.google-sheets-v4/get-cells google_sheets_v4.clj: 375 google-apps-clj.google-sheets-v4/get-cells google_sheets_v4.clj: 410 google-apps-clj.google-sheets-v4/get-cell-values google_sheets_v4.clj: 404 google-apps-clj.google-sheets-v4/get-cell-values

estikado commented 3 years ago

Having same issue. I believe it is related with this dissoc: https://github.com/SparkFund/google-apps-clj/blob/ffe53b4d07db153df0749f1c263c04a0226a185f/src/google_apps_clj/google_sheets.clj#L43