Wait Node Is Not Releasing Executions

Questions
,
1

Describe the problem/error/question

I noticed today that I have hundreds of executions stuck on the “wait” node with the status in the execution entity db of “waiting”. When I sort them and filter by just executions that have a “waitTill” that is less than now, there are ~860.

Essentially, I’m not seeing the execution get released even though the wait time has elapsed completely.

What is the error message (if any)?

No specific errors, other than it stays stuck in waiting forever. We have some that have been waiting since June 16th, even though their wait nodes were < 24hours, most being <1 hour of wait time.

Please share your workflow

Full workflow is quite large so I can’t share all of it, here’s a screenshot: Image 2023-06-21 at 12.25.1...

Here’s an example of the db record: Image 2023-06-21 at 12.26.3...
You’ll see it was supposed to wait 3min, but my current date time is > 2 hours since it happened.

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.230.3
  • Database (default: SQLite): postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: aws ec2 linux
2

I think we’ve solved this now. It appears our primary box (not the workers) is responsible for adding the delayed jobs to the queue, for some reason, it wasn’t. We restarted the primary and it seems to have kicked them all off now that should have run.

3 Likes
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.