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.
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.
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.
- 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