Socket hang up issues

💬 Workflows
1

Hi, I am using a workflow to update inventory in our shopify through API.
The workflows fetches shipment lines from postgres db and loops over them (Batches of 10 with delay of 100ms) . The loop code calls a function like so "const response = await adjust_item_inventory(shopify_store, access_token, location_id,inventory_item_id,available)" which does the post call to shopify. Most of the times the workflow completes successfully but recently we started receiving more and more exceptions on several calls ("Exception: FetchError: request to https://edikted.retool.com/api/workflow/runQueryForSandboxed failed, reason: socket hang up").

Would love some assistance on this issue.

Thanks,

3

@taluk,
Can you please export the json file for your workflow so I can take a look? Are you using a python code block or js?

Thank!

4

Hi @lindakwoo ,

Thanks for reaching out.
PFA the workflow json (took out credentials from it)

The loop itself is using a js block to do the job . There is one python data prep block in the workflow but it can be moved to js relatively easy and doesn't seem to create any issues.
Thanks,
upload_store_shipment - loop (1).json (129.0 KB)

5

@taluk,
This socket hang up error is a known bug that our engineering team is working on. We THINK it has to do with python code and the workaround thus far has been to change your code from python to js, but as you stated, you are already using js for the actual loop. It MAY still be related to your python code, however. Until we get this fixed, can you try converting all your python code to js and see if it fixes your problem?

Thanks very much.

6

Hi @lindakwoo ,

I will do the change and monitor the workflow.

Thanks,

7

Hi @lindakwoo,

I moved the workflow to JS only and the error reproduced again :frowning:

8

okay @taluk, Can you provide me with the the workflow id on the js-code workflow that has this error?

If you click on the Run history tab in the bottom left hand corner of your workflow, you can find it:

workflow_id
workflow_id2604×946 327 KB

I will let our engineering folks know this is not isolated to python code only. Thanks!

9

Thanks @lindakwoo.

The workflow with the failures is : 3b9671f3-42b7-419d-93ed-c1d136735d20

LMK if you need any other details.

Thanks,

10

@taluk,
Can you also send me the exported json for your latest js-coded workflow and a screenshot of the error you are getting? thanks!

11

PFA the exported workflow after the change
upload_store_shipment - loop.json (137.6 KB).

As per the error - I'm handling the exceptions in the code so this is from exception catch:
"Exception: Error: request to https://XXXXX.myshopify.com/admin/api/2024-04/inventory_levels/adjust.json failed, reason: "

In the workflow logs I'm seeing : "
Error evaluating adjust_item_inventory: Unexpected error occurred while running query"

12

@taluk,
Are you still getting the specific "socket hang up" error?

13

@lindakwoo I'm also getting this issue but within the workflow loop using a REST API Resource

I tried uploading the json but it's not letting me since I'm a new user

14

@Salar_Hajimirsadeghi,
You can send me the json file at my email address: lindakwoo@retool.com

Is it the same socket hang up error? Can I get a screenshot please? Do you have any python code blocks in your workflow?
thanks!

16

+1. I am facing the same issue. i have python code block in my multi step loop in my workflow. Would be great if this gets fixed without me needing to convert my code to JS because i converted it to python in the first place due to some other unsolvable bug on my end.

17

@Muhammad_Tayyab,
So sorry to hear this. Engineering is still looking at this issue. It might be helpful if I passed them another workflow run Id, so if you wouldn't mind providing that, I'd appreciate it. thanks!

18

here you go.
Workflow Run Id: d6aac8df-04d5-47dc-a6e4-c5fa63cd95dd

19

Hi - I am also running into this, with a workflow run id of

0196e973-f924-75a1-bb36-462993f0df14

has there been any progress on a fix?

20

I fixed this by moving the automation over to JS rather than python. Would appreciate an update from retool on this!

1 Like
21

Glad to hear it, @Alex_Gao! That's the recommended fix for the time being, but we are tracking this issue and will hopefully have a more robust solution before too long. I'll provide an update here as soon as we have a concrete plan. :+1: