Hi everyone,
I run n8n in queue mode inside a Docker container, with PostgreSQL in a separate Docker container.
There are around 80 active workflows running in n8n.
Last night I upgraded from 1.104.1 to 1.106.3. My main workload starts around 9 AM, and I immediately noticed a huge drop in performance — so much that n8n completely stopped connecting to PostgreSQL.
I rolled back to 1.104.1 and then found this thread.
Here’s an example of the errors I was getting:
error Error: timeout exceeded when trying to connect
at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/[email protected][email protected]/node_modules/pg-pool/index.js:45:11
at runNextTicks (node:internal/process/task_queues:65:5)
at listOnTimeout (node:internal/timers:549:9)
at processTimers (node:internal/timers:523:7)
at PostgresDriver.obtainMasterConnection (…)
at PostgresQueryRunner.query (…)
at DataSource.query (…)
at WorkflowStatisticsRepository.upsertWorkflowStatistics (…)
at WorkflowStatisticsService.workflowExecutionCompleted (…)