#community-help

Airbyte MySQL Connection Timeout with Typesense

TLDR Jamshid reported a connection timeout issue using Airbyte for MySQL and typesense. Jason suggested it could be due to a low client-side timeout in Airbyte.

6mo

Join the chat

Jun 09, 2023 (6 months ago)

Photo of md5-317ed6510eb7587c9e9243fb6ebc4e87

Jamshid

05:11 PM

I am using Airbyte to connect a MySQL database to typesense. It fails with this error:
"internalMessage" : "('Connection aborted.', timeout('The write operation timed out'))", and also says: "externalMessage" : "Something went wrong within the destination connector",

Does typesense cloud has some sort of timeout constraint?

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

05:16 PM

This might be related to the low client-side timeout: https://github.com/airbytehq/airbyte/issues/24097

Jamshid

05:18 PM

Thanks Jason that makes sense. I already reached out to Airbyte team about this. So hopefully they understand the issue and fix it. Glad it is not on the typesense cloud side.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Airbyte Timeout Issue with Typesense Sync

Jamshid experienced timeouts when syncing MySQL records with Airbyte. Jason suggested it's related to an Airbyte issue, leading Jamshid to create a custom Typesense connector to resolve the problem.

5mo

Airbyte Connector for Typesense Integration and Issue Resolution

Cirdes shares the creation of an Airbyte connector for Typesense, later experiencing timeout issues with large-scale data synchronization. Jason provides solutions for adjustment of timeout thresholds and batch sizes, successfully resolving the issue.

14mo

Syncing records issue from BigQuery to Typesense using Airbyte

Jamshid had a problem syncing records from BigQuery to Typesense via Airbyte, with only a partial number of records syncing. Jason suggested checking AirByte logs for Typesense API responses. They found an issue with BigQuery's connector on Airbyte handling repeated fields and concluded to consider building their own sync script to mitigate the situation.

2mo