My wait never continues execution when the time is greater than 65 seconds.
my timezone is -03:00 (recife)
my postgres always saves at +00:00
Could this be it?
below my n8n stack
happens with production flows too
Hi @admdiegolima, I am sorry you’re having touble.
Waiting executions > 65 seconds would indeed be persisted to your database, so it sounds indeed like there could be a time zone mismatch somewhere along the way. I was, however, not able to reproduce this based on the data you have shared.
Can you confirm how exactly you have configured both n8n and Postgres? Ideally share a full docker compose setup using which the problem can be reproduced? I tried using the below setup, but Waiting works as expected for me:
services:
postgres:
image: postgres:15
restart: unless-stopped
environment:
- POSTGRES_USER=n8n
- POSTGRES_PASSWORD=n8n
- POSTGRES_DB=n8n
volumes:
- ./db_data:/var/lib/postgresql/data
ports:
- 5432:5432
healthcheck:
test: ['CMD-SHELL', 'pg_isready -h localhost -U n8n -d n8n']
interval: 5s
timeout: 5s
retries: 10
n8n:
image: n8nio/n8n:1.15.2
restart: unless-stopped
environment:
- DB_TYPE=postgresdb
- DB_POSTGRESDB_HOST=postgres
- DB_POSTGRESDB_PORT=5432
- DB_POSTGRESDB_DATABASE=n8n
- DB_POSTGRESDB_USER=n8n
- DB_POSTGRESDB_PASSWORD=n8n
- QUEUE_HEALTH_CHECK_ACTIVE=true
- N8N_DIAGNOSTICS_ENABLED=false
- TZ=America/Recife
- GENERIC_TIMEZONE=America/Recife
ports:
- 5678:5678
volumes:
- ./n8n_data:/home/node/.n8n
depends_on:
postgres:
condition: service_healthy
PostgreSQL would store the waitTill timestamp in UTC, but that doesn’t stop n8n (using America/Recife time) from picking up the waiting execution as it should.