Workflow error - Database query timeout

Need help Database
1

Hello,

I’m trying to create around 500 things with an API workflow.

Everytime a thing is created I schedule the same api worflow for 2 seconds in the future for it to create a new thing, with the condition to only do this while de number of things created is smaller than the number of things to create.

image
image877×625 26.3 KB

The action stopped with the error Workflow error - Database query timeout

image

Does anyone know what this means and can be done to prevent it from happening in the future?

Any help is much appreciatted.

2

What does your Create a New Thing action look like?

3

Q. What is the step after the API is scheduled?
Q. Is the condition on Step 1 involve a Search?

5

Thanks for the interest @jgellis.

  1. After the api is scheduled, there’s an action to make changes to a thing, basically saving in the database that the flow has finished. It has a condition to only happen when all the things have been created.

Screenshot below:

image
image1244×282 16.3 KB

  1. it does not.

Screenshot below:
image

6

Hello @adamhholmes, thanks for replying.

it looks something like take the item#current_item and save it to the database, given it is not empty.

Screenshot below:
image

7

Do you have lots of other workflows running elsewhere? Specifically, ones which are making a lot of database queries?

9

At the time of the crashing, only that one was running.

10

At what point did the workflow stop running? (i.e. how many things had it created before stopping)…

And where and how are you scheduling it in the first place?

11

It stopped at number 185 of 550.

image
image847×686 24.1 KB

I trigger it in a worflow where the user uploads a XLSX table, I call an external API to parse it to JSON and send one of the lists the the api workflow.

image
image1741×420 32.9 KB

@adamhholmes I’m clicking reply, but it doesn’t seem to be linking my replies to you original message, i’ll tag you just in case

12

Sorry I did not get back too you @arturbraga , we ran into a nasty issue and have been working 29 hours straight on it (so far). Glad to see others have jumped in.
John

13

Oh boy.

1 Like
14

No worries @jgellis.

Just added an extra second between schedules and it has been working ever since.

Appreciate the time and best of luck over there!

15

Any tips?

16

Yeah, everything I’ve ever written about Bubble. Every video I’ve ever recorded about Bubble. I got lots of tips.

1 Like
17

Seems great. Congrats.