N8n fails to process tasks in queue mode with postgress db

Questions
, ,
1

Describe the problem/error/question

I’m using n8n 234.1,

recently after updating to latest docker image I started getting number of failed tasks in execution list.

I have two workflows that are triggered by webhook

processing works fine in single node mode but in queue it returns following errors to about 40% of executions:

Unable to find data of execution “866” in database. Aborting execution.

What is the error message (if any)?

Unable to find data of execution “866” in database. Aborting execution.

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

Hey @Kirill,

Welcome to the community :raised_hands:

Out of interest did you update all of the workers as well? If you check the logs for the workers are they showing any errors?

1 Like
3

yeah, I updated both main and worker nodes.

And surprisingly no errors in worker’s logs

worker only outputs messages “workflow execution x started”

then when I check in UI that execution shows above error.

Although there are few executions that manage to get through… very confusing state

4

That is a bit odd, How many web workers do you have and have you remembered to exclude the main instance from the load balancer config for webhook routes?