Trying to bulk update a table in my MySQL resource using the id column in a Workflow. (It's around 1000 objects being updated).
Expected behaviour would be that the block finishes after the updates have finished.
What actually happens is that the block throws a timeout error. The updates persist in the DB (I've verified that the updates are made) but I get an error on the front-end.
Steps:
I've increased timeout upto 2 minutes.
I've also added an index on the column being updated. None worked.
Sorry for this weird bug, and thank you for reporting this.
Let me look into things and see if this is a known issue our team is working on.
I would expect that increasing the time to timeout would fix this, but if the updates are applied to all the objects then it seems like the query is finishing correctly
Which would mean the error is a false negative, but there are a couple potential root causes for this bug. Are you self hosting Retool? If so, what version are you on?
Query blocks have a maximum timeout of ten minutes on Cloud. I would think that increasing it to two minutes would be enough but you might just need to add more time
You might just need to increase the amount of time the block has before the front end "thinks" it should throw an error due to a lack on a response from the backend/DB to confirm that the bulk update has succeeded.
Is the error showing up on the two minute mark or is it occurring sooner? If it happening sooner then we might need to dig around to find out why it isn't waiting until the time limit to error.
