Executions not showing up

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

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:

Let us know what your findings are! :eyes:

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