<@U04S8PLJWMT> HELP 2026-03-31 17:11:41 destinatio...
# replication-ask-ai
a
@kapa.ai HELP 2026-03-31 171141 destination ERROR main i.a.c.i.u.ConnectorExceptionHandler(handleException):68 caught exception! com.google.cloud.bigquery.BigQueryException: Read timed out at com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.translate(HttpBigQueryRpc.java:116) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] at com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.getTable(HttpBigQueryRpc.java:323) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] at com.google.cloud.bigquery.BigQueryImpl$18.call(BigQueryImpl.java:820) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] at com.google.cloud.bigquery.BigQueryImpl$18.call(BigQueryImpl.java:817) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] at com.google.api.gax.retrying.DirectRetryingExecutor.submit(DirectRetryingExecutor.java:102) ~[gax-2.52.0.jar:2.52.0] at com.google.cloud.RetryHelper.run(RetryHelper.java:76) ~[google-cloud-core-2.42.0.jar:2.42.0] at com.google.cloud.RetryHelper.runWithRetries(RetryHelper.java:50) ~[google-cloud-core-2.42.0.jar:2.42.0] at com.google.cloud.bigquery.BigQueryImpl.getTable(BigQueryImpl.java:816) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] at io.airbyte.integrations.destination.bigquery.typing_deduping.BigQueryDestinationHandler.isFinalTableEmpty(BigQueryDestinationHandler.kt:41) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery.jar:?] at io.airbyte.integrations.destination.bigquery.typing_deduping.BigQueryDestinationHandler.gatherInitialState(BigQueryDestinationHandler.kt:235) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery.jar:?] at io.airbyte.integrations.base.destination.operation.DefaultSyncOperation.createPerStreamOpClients(DefaultSyncOperation.kt:54) ~[airbyte-cdk-typing-deduping-0.48.8.jar:?] at io.airbyte.integrations.base.destination.operation.DefaultSyncOperation.<init>(DefaultSyncOperation.kt:48) ~[airbyte-cdk-typing-deduping-0.48.8.jar:?] at io.airbyte.integrations.base.destination.operation.DefaultSyncOperation.<init>(DefaultSyncOperation.kt:28) ~[airbyte-cdk-typing-deduping-0.48.8.jar:?] at io.airbyte.integrations.destination.bigquery.BigQueryDestination.getSerializedMessageConsumer(BigQueryDestination.kt:464) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery.jar:?] at io.airbyte.cdk.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.kt:214) [airbyte-cdk-core-0.48.8.jar:?] at io.airbyte.cdk.integrations.base.IntegrationRunner.run(IntegrationRunner.kt:119) [airbyte-cdk-core-0.48.8.jar:?] at io.airbyte.cdk.integrations.base.IntegrationRunner.run$default(IntegrationRunner.kt:113) [airbyte-cdk-core-0.48.8.jar:?] at io.airbyte.integrations.destination.bigquery.BigQueryDestinationKt.main(BigQueryDestination.kt:566) [io.airbyte.airbyte-integrations.connectors-destination-bigquery.jar:?] Caused by: java.net.SocketTimeoutException: Read timed out at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:278) ~[?:?] at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:304) ~[?:?] at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:346) ~[?:?] at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:796) ~[?:?] at java.base/java.net.Socket$SocketInputStream.read(Socket.java:1099) ~[?:?] at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:489) ~[?:?] at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:483) ~[?:?] at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70) ~[?:?] at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1461) ~[?:?] at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1066) ~[?:?] at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:291) ~[?:?] at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:347) ~[?:?] at java.base/java.io.BufferedInputStream.implRead(BufferedInputStream.java:420) ~[?:?] at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:399) ~[?:?] at java.base/sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:827) ~[?:?] at java.base/sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:759) ~[?:?] at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1705) ~[?:?] at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1614) ~[?:?] at java.base/java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:531) ~[?:?] at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:307) ~[?:?] at com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:36) ~[google-http-client-1.44.2.jar:1.44.2] at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:152) ~[google-http-client-1.44.2.jar:1.44.2] at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:84) ~[google-http-client-1.44.2.jar:1.44.2] at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1012) ~[google-http-client-1.44.2.jar:1.44.2] at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:565) ~[google-api-client-2.6.0.jar:2.6.0] at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:506) ~[google-api-client-2.6.0.jar:2.6.0] at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:616) ~[google-api-client-2.6.0.jar:2.6.0] at com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.getTable(HttpBigQueryRpc.java:321) ~[google-cloud-bigquery-2.42.2.jar:2.42.2] ... 16 more
k
BigQuery Destination: Read timed out Error You're encountering a
com.google.cloud.bigquery.BigQueryException: Read timed out
(caused by
java.net.SocketTimeoutException
) in the destination-bigquery connector. This happens during the initial sync setup phase, specifically when the connector tries to call
getTable
to check if the final table is empty (
isFinalTableEmpty
), before any data is written. What's happening The stack trace shows: 1.
BigQueryDestinationHandler.isFinalTableEmpty
→
BigQueryImpl.getTable
→ HTTP request to BigQuery API → socket read timeout This is a network/connectivity timeout between the Airbyte destination connector and the Google BigQuery API, not a data or configuration error. Possible causes • Transient network issue between your Airbyte instance and the BigQuery API endpoint • GCP API slowness or outage at the time of the sync • Firewall or proxy blocking or throttling outbound HTTPS connections to
bigquery.googleapis.com
• DNS resolution delays causing the initial connection to be slow What you can try 1. Retry the sync — This is often a transient issue. The error occurs before any data is written, so retrying is safe. 2. Check GCP status — Verify there are no ongoing incidents on the Google Cloud Status Dashboard. 3. Check network connectivity — Ensure your Airbyte instance can reliably reach
bigquery.googleapis.com
on port 443 without timeouts. 4. Upgrade dependencies — There is an open PR [deps bump] that bumps the BigQuery Cloud dependency (
google-cloud-bigquery
) to the latest version, which may include fixes for HTTP client behavior. If you're self-hosting, consider tracking that update. Note on the connector version Your stack trace references
google-cloud-bigquery-2.42.2.jar
, which matches the version referenced in other known issues. [deps bump] The dependency bump PR may address underlying library issues. The knowledge sources do not contain a specific documented fix for this exact timeout scenario, so if retrying and checking network connectivity don't resolve it, I'd recommend opening a GitHub issue on the Airbyte repository with your full logs. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.