[Bug]: Airtable connections reset not handled correctly

[matthias-pichler]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

When I use an Airtable datasource it seems that Appsmith doesn't handle connections to their API correctly. Randomly when Queries are run I get

recvAddress(..) failed: Connection reset by peer

as a response. Complete query object after query is:

{
  "isLoading": false,
  "data": "recvaddress(..) failed: connection reset by peer"
  "responseMeta":{
    "isExecutionSuccess": false
    "statusCode": "5000"
  }
}

Steps To Reproduce

1. create an Airtable base
2. add it as a datasource
3. run a lot of list queries to produce the error

Public Sample App

No response

Environment

Production

Issue video log

No response

Version

Cloud

[Vadoempie]

I'm having the exact same problem using the Airtable datasource.

[abgupta-wfc]

any update on this ? Or anyone is able to gracefully handle this error ?

[pb-saraiva]

I found the same issue recorded in video in Appsmith's own YouTube channel (2m19s): https://www.youtube.com/watch?v=9aQe18DPYXI

I'm an Airtable heavy user and the only application that faces these instabilities is Appsmith. Airtable API never fails when executed in Google Colab, for example.

[GreenFlux]

@rohan-arthur do we know the cause for this yet? Is there a workaround with the API, instead of our native integration?

[rohan-arthur]

update:

1. we are not able to replicate this error
2. had a call with one of our users, and we are waiting for them to share the server logs

meanwhile, if anyone reading this is facing the problem, please extract the server logs and share it with support@appsmith.com quoting this issue link.

how to extract server logs: https://docs.appsmith.com/getting-started/setup/instance-management/how-to-get-container-logs#docker

[rohan-arthur]

down-grading this to High, we will continue to watch this issue for updates about reproduction/user logs