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