Executions not showing up

Dominic_Jay · July 26, 2024, 6:17pm

Describe the problem/error/question

noticed executions are not showing up for most of the workflows. Seems like others are not working as well (for webhook initiated). Some still do.
There was this one automation that has been working for a few months now, nothing changed but around 3 weeks ago it stopped working.
Tried creating multiple workflows and send test executions from multiple softwares to webhook nothing works.

Looking at all executions only today’s executions for one workflow shows, even monitored it in real time and they keep getting added, but then there is a gap of 3000 executions until April 27th 2 executions show up, then gap for 200 executions, then gap for 300 executions

Information on your n8n setup

n8n version: Updated today to latest to see if it solves problem - 1.51.2
Database (default: SQLite): postgres: 16-alpine
n8n EXECUTIONS_PROCESS setting (default: own, main): queue
**Running n8n via (Docker, npm, n8n cloud, desktop app):**docker
Operating system: Ubuntu 20.04.6 LTS

After analyzing logs it seems it’s having issues connecting to postgres:
postgres_db | 2024-07-26 18:21:18.884 UTC [291] FATAL: password authentication failed for user “postgres”
postgres_db | 2024-07-26 18:21:18.884 UTC [291] DETAIL: Role “postgres” does not exist.

postgres_db | 2024-07-26 18:25:01.614 UTC [340] FATAL: password authentication failed for user “root”
postgres_db | 2024-07-26 18:25:01.614 UTC [340] DETAIL: Role “root” does not exist.

I know there were breaking changes on 1.40.0, but my DB_POSTGRESDB_USER is set to ‘n8n_user’ in .env

Nothing was changed in docker compose in terms of postgres version, just updating n8n. How do I solve this???

ria · July 29, 2024, 10:45am

Hi @Dominic_Jay

How did you configure your postgres environment in your docker compose?

Feel free to compare your docker compose with our self-host example here:

github.com

n8n-io/n8n-hosting/blob/main/docker-compose/withPostgres/docker-compose.yml

version: '3.8'

volumes:
  db_storage:
  n8n_storage:

services:
  postgres:
    image: postgres:16
    restart: always
    environment:
      - POSTGRES_USER
      - POSTGRES_PASSWORD
      - POSTGRES_DB
      - POSTGRES_NON_ROOT_USER
      - POSTGRES_NON_ROOT_PASSWORD
    volumes:
      - db_storage:/var/lib/postgresql/data
      - ./init-data.sh:/docker-entrypoint-initdb.d/init-data.sh
    healthcheck:

This file has been truncated. show original

Let us know what your findings are!

system · October 27, 2024, 10:46am

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