Wait node does not continue after 65 seconds

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

Information on your n8n setup

  • **n8n version:1.6.1 query
  • **Database (default: SQLite):postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):docker
  • **Operating system:linux

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.

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