Issue deploy version 1.86.0

  • n8n version: 1.86.0
  • Database: posgres16
  • Running n8n via: Docker Compose
  • Operating system: RHLE 8.6

I have issues deploy this docker-compose using latest version, after deploy with no error when try to access only see grey screen.

docker-compose

version: '3.8'

x-shared: &shared
  restart: always
  image: n8nio/n8n:${VERSION}
  labels:
    - com.centurylinklabs.watchtower.enable=true
    - traefik.enable=true
    - traefik.http.routers.n8n.rule=Host(`${SUBDOMAIN}.${DOMAIN_NAME}`)
    - traefik.http.routers.n8n.tls=true
    - traefik.http.routers.n8n.entrypoints=websecure
    - traefik.http.routers.n8n.tls.certresolver=mytlschallenge
    #- traefik.http.middlewares.n8n-headers.headers.customResponseHeaders.X-Content-Type-Options="nosniff"
    #- traefik.http.middlewares.n8n-headers.headers.customResponseHeaders.X-Frame-Options="DENY"
    #- traefik.http.middlewares.n8n-headers.headers.customResponseHeaders.X-XSS-Protection="1; mode=block"
    #- traefik.http.middlewares.n8n-headers.headers.customResponseHeaders.Referrer-Policy="strict-origin-when-cross-origin"
    #- traefik.http.middlewares.n8n-headers.headers.customResponseHeaders.Permissions-Policy="geolocation=(), microphone=(), camera=()"
    - traefik.http.middlewares.n8n-ratelimit.ratelimit.average=100
    - traefik.http.middlewares.n8n-ratelimit.ratelimit.burst=200
   # - traefik.http.routers.n8n.middlewares=n8n-headers@docker,n8n-ratelimit@docker
    - traefik.http.services.n8n.loadbalancer.server.port=5678
  environment:
    - DB_TYPE=postgresdb
    - DB_POSTGRESDB_HOST=10.89.0.191
    - DB_POSTGRESDB_PORT=5432
    - DB_POSTGRESDB_DATABASE=${POSTGRES_DB}
    - DB_POSTGRESDB_USER=${POSTGRES_NON_ROOT_USER}
    - DB_POSTGRESDB_PASSWORD=${POSTGRES_NON_ROOT_PASSWORD}
    - EXECUTIONS_MODE=queue
    - QUEUE_BULL_REDIS_HOST=10.89.0.192
    - QUEUE_HEALTH_CHECK_ACTIVE=true
    - N8N_ENCRYPTION_KEY=${ENCRYPTION_KEY}
    - N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true
    - OFFLOAD_MANUAL_EXECUTIONS_TO_WORKERS=true
    - N8N_HOST=${SUBDOMAIN}.${DOMAIN_NAME}
    - N8N_PORT=5678
    - N8N_PROTOCOL=https
    - NODE_ENV=production
    - WEBHOOK_URL=https://${SUBDOMAIN}.${DOMAIN_NAME}/
    - GENERIC_TIMEZONE=${GENERIC_TIMEZONE}
    - N8N_RUNNERS_ENABLED=true
  volumes:
    - n8n_storage:/home/node/.n8n
  depends_on:
    - postgres
    - redis
  networks:
      traefik_net:
        ipv4_address: 10.89.0.190

services:
  postgres:
    image: postgres:16
    restart: always
    container_name: n8n-postgres
    environment:
      - POSTGRES_USER=${POSTGRES_NON_ROOT_USER}
      - POSTGRES_PASSWORD=${POSTGRES_NON_ROOT_PASSWORD}
      - POSTGRES_DB=${POSTGRES_DB}
      - POSTGRES_HOST_AUTH_METHOD=${POSTGRES_HOST_AUTH_METHOD}
    volumes:
      - db_storage:/var/lib/postgresql/data
      - /pods/volumes/init-data.sh:/docker-entrypoint-initdb.d/init-data.sh
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U ${POSTGRES_NON_ROOT_USER} -d ${POSTGRES_DB}']
      interval: 5s
      timeout: 5s
      retries: 10
    networks:
      traefik_net:
        ipv4_address: 10.89.0.191

  redis:
    image: redis:6-alpine
    container_name: n8n-redis
    restart: always
    volumes:
      - redis_storage:/data
    healthcheck:
      test: ['CMD', 'redis-cli', 'ping']
      interval: 5s
      timeout: 5s
      retries: 10
    networks:
      traefik_net:
        ipv4_address: 10.89.0.192

  n8n:
    <<: *shared
    container_name: n8n-main
    expose:
      - 5678
    networks:
      traefik_net:
        ipv4_address: 10.89.0.193

  n8n-worker:
    <<: *shared
    container_name: n8n-worker
    command: worker
    depends_on:
      - n8n
    networks:
      traefik_net:
        ipv4_address: 10.89.0.194

volumes:
  db_storage:
    driver: local
  n8n_storage:
    driver: local
  redis_storage:
    driver: local

networks:
  traefik_net:
    external: true

.env

DOMAIN_NAME=mmmmmm
SUBDOMAIN=mmmmmmmm
GENERIC_TIMEZONE=America/Bogota
VERSION=1.86.0
POSTGRES_DB=n8n
POSTGRES_NON_ROOT_USER=n8n
POSTGRES_NON_ROOT_PASSWORD=mmmmmmmmmmm
ENCRYPTION_KEY=mmmmmmmmmmmmmmmmmmm
POSTGRES_HOST_AUTH_METHOD=trust
POSTGRES_PASSWORD=mmmmmmm

Log Main:

2025-04-08T17:12:49-05:00 User settings loaded from: /home/node/.n8n/config
2025-04-08T17:12:54-05:00 Last session crashed
2025-04-08T17:13:04-05:00 Initializing n8n process
2025-04-08T17:13:06-05:00 n8n ready on 0.0.0.0, port 5678
2025-04-08T17:13:12-05:00 n8n Task Broker ready on 127.0.0.1, port 5679
2025-04-08T17:13:16-05:00 Version: 1.86.0
2025-04-08T17:13:17-05:00 
2025-04-08T17:13:17-05:00 Editor is now accessible via:
2025-04-08T17:13:17-05:00 https://yyyy.nnnn.yyyy
2025-04-08T17:13:20-05:00 Registered runner "JS Task Runner" (FUO3R63r4IylN-AU7_IZQ) 

Log posgress

2025-04-08T17:12:41-05:00 
2025-04-08T17:12:41-05:00 PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-04-08T17:12:41-05:00 
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.463 UTC [1] LOG:  starting PostgreSQL 16.8 (Debian 16.8-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.464 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.464 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.469 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.482 UTC [28] LOG:  database system was interrupted; last known up at 2025-04-08 22:07:59 UTC
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.576 UTC [28] LOG:  database system was not properly shut down; automatic recovery in progress
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.583 UTC [28] LOG:  redo starts at 0/1BC3458
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.583 UTC [28] LOG:  invalid record length at 0/1BC3490: expected at least 24, got 0
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.583 UTC [28] LOG:  redo done at 0/1BC3458 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.594 UTC [26] LOG:  checkpoint starting: end-of-recovery immediate wait
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.605 UTC [26] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.013 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/1BC3490, redo lsn=0/1BC3490
2025-04-08T17:12:41-05:00 2025-04-08 22:12:41.617 UTC [1] LOG:  database system is ready to accept connections

log redis

2025-04-08T17:12:40-05:00 1:C 08 Apr 2025 22:12:40.778 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
2025-04-08T17:12:40-05:00 1:C 08 Apr 2025 22:12:40.778 # Redis version=6.2.17, bits=64, commit=00000000, modified=0, pid=1, just started
2025-04-08T17:12:40-05:00 1:C 08 Apr 2025 22:12:40.778 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
2025-04-08T17:12:40-05:00 1:M 08 Apr 2025 22:12:40.780 * monotonic clock: POSIX clock_gettime
2025-04-08T17:12:40-05:00 1:M 08 Apr 2025 22:12:40.782 * Running mode=standalone, port=6379.
2025-04-08T17:12:40-05:00 1:M 08 Apr 2025 22:12:40.783 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
2025-04-08T17:12:40-05:00 1:M 08 Apr 2025 22:12:40.783 # Server initialized
2025-04-08T17:12:40-05:00 1:M 08 Apr 2025 22:12:40.784 * Ready to accept connections

log worker

2025-04-08T17:12:50-05:00 User settings loaded from: /home/node/.n8n/config
2025-04-08T17:12:55-05:00 Last session crashed
2025-04-08T17:13:09-05:00 n8n Task Broker ready on 127.0.0.1, port 5679
2025-04-08T17:13:09-05:00 
2025-04-08T17:13:09-05:00 n8n worker is now ready
2025-04-08T17:13:09-05:00  * Version: 1.86.0
2025-04-08T17:13:09-05:00  * Concurrency: 10
2025-04-08T17:13:09-05:00 
2025-04-08T17:13:09-05:00 
2025-04-08T17:13:09-05:00 n8n worker server listening on port 5678
2025-04-08T17:13:16-05:00 Registered runner "JS Task Runner" (3dqUhk3Ahl12R4N87Jx7i) 

Please let me know what is wrong with this docker-compose file.

Thanks

Hi,

it seems that your DB has an issue. can you confirm its up and running ?
If you restart everything, does it consistently show the recovery error on the DB?
Have you tried to connect to it manually to see if everything is ok?

Regards
J.

Hi jcuypers,

I delete and create again, all appear ok, but didn’t work
Log posgres

2025-04-09T08:05:46-05:00 Success. You can now start the database server using:
2025-04-09T08:05:46-05:00 
2025-04-09T08:05:46-05:00     pg_ctl -D /var/lib/postgresql/data -l logfile start
2025-04-09T08:05:46-05:00 
2025-04-09T08:05:46-05:00 initdb: warning: enabling "trust" authentication for local connections
2025-04-09T08:05:46-05:00 initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.waiting for server to start....
2025-04-09T08:05:46-05:00 2025-04-09 13:05:46.368 UTC [56] LOG:  starting PostgreSQL 16.8 (Debian 16.8-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-04-09T08:05:46-05:00 2025-04-09 13:05:46.374 UTC [56] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-04-09T08:05:46-05:00 2025-04-09 13:05:46.395 UTC [59] LOG:  database system was shut down at 2025-04-09 13:05:45 UTC
2025-04-09T08:05:46-05:00 2025-04-09 13:05:46.415 UTC [56] LOG:  database system is ready to accept connections
2025-04-09T08:05:46-05:00  done
2025-04-09T08:05:46-05:00 server started
2025-04-09T08:05:47-05:00 CREATE DATABASE
2025-04-09T08:05:47-05:00 
2025-04-09T08:05:47-05:00 
2025-04-09T08:05:47-05:00 /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/init-data.sh
2025-04-09T08:05:47-05:00 SETUP INFO: No Environment variables given!
2025-04-09T08:05:47-05:00 waiting for server to shut down....
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.292 UTC [56] LOG:  received fast shutdown request
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.297 UTC [56] LOG:  aborting any active transactions
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.310 UTC [56] LOG:  background worker "logical replication launcher" (PID 62) exited with exit code 1
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.315 UTC [57] LOG:  shutting down
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.319 UTC [57] LOG:  checkpoint starting: shutdown immediate
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.488 UTC [57] LOG:  checkpoint complete: wrote 922 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.126 s, sync=0.032 s, total=0.174 s; sync files=301, longest=0.026 s, average=0.001 s; distance=4255 kB, estimate=4255 kB; lsn=0/19120F8, redo lsn=0/19120F8
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.527 UTC [56] LOG:  database system is shut down
2025-04-09T08:05:47-05:00  done
2025-04-09T08:05:47-05:00 server stopped
2025-04-09T08:05:47-05:00 
2025-04-09T08:05:47-05:00 PostgreSQL init process complete; ready for start up.
2025-04-09T08:05:47-05:00 
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.793 UTC [1] LOG:  starting PostgreSQL 16.8 (Debian 16.8-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.795 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.795 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.844 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.863 UTC [78] LOG:  database system was shut down at 2025-04-09 13:05:47 UTC
2025-04-09T08:05:47-05:00 2025-04-09 13:05:47.892 UTC [1] LOG:  database system is ready to accept connections

log main

2025-04-09T08:05:57-05:00 Initializing n8n process
2025-04-09T08:05:59-05:00 n8n ready on 0.0.0.0, port 5678
2025-04-09T08:05:59-05:00 Migrations in progress, please do NOT stop the process.
2025-04-09T08:05:59-05:00 Starting migration InitialMigration1587669153312
2025-04-09T08:05:59-05:00 Finished migration InitialMigration1587669153312
2025-04-09T08:05:59-05:00 Starting migration WebhookModel1589476000887
2025-04-09T08:05:59-05:00 Finished migration WebhookModel1589476000887
2025-04-09T08:05:59-05:00 Starting migration CreateIndexStoppedAt1594828256133
2025-04-09T08:05:59-05:00 Finished migration CreateIndexStoppedAt1594828256133
2025-04-09T08:05:59-05:00 Starting migration MakeStoppedAtNullable1607431743768
2025-04-09T08:05:59-05:00 Finished migration MakeStoppedAtNullable1607431743768
2025-04-09T08:05:59-05:00 Starting migration AddWebhookId1611144599516
2025-04-09T08:05:59-05:00 Finished migration AddWebhookId1611144599516
2025-04-09T08:05:59-05:00 Starting migration CreateTagEntity1617270242566
2025-04-09T08:06:00-05:00 Finished migration CreateTagEntity1617270242566
2025-04-09T08:06:00-05:00 Starting migration UniqueWorkflowNames1620824779533
2025-04-09T08:06:00-05:00 Finished migration UniqueWorkflowNames1620824779533
2025-04-09T08:06:00-05:00 Starting migration AddwaitTill1626176912946
2025-04-09T08:06:00-05:00 Finished migration AddwaitTill1626176912946
2025-04-09T08:06:00-05:00 Starting migration UpdateWorkflowCredentials1630419189837
2025-04-09T08:06:00-05:00 Finished migration UpdateWorkflowCredentials1630419189837
2025-04-09T08:06:00-05:00 Starting migration AddExecutionEntityIndexes1644422880309
2025-04-09T08:06:00-05:00 Finished migration AddExecutionEntityIndexes1644422880309
2025-04-09T08:06:00-05:00 Starting migration IncreaseTypeVarcharLimit1646834195327
2025-04-09T08:06:00-05:00 Finished migration IncreaseTypeVarcharLimit1646834195327
2025-04-09T08:06:00-05:00 Starting migration CreateUserManagement1646992772331
2025-04-09T08:06:00-05:00 Finished migration CreateUserManagement1646992772331
2025-04-09T08:06:00-05:00 Starting migration LowerCaseUserEmail1648740597343
2025-04-09T08:06:00-05:00 Finished migration LowerCaseUserEmail1648740597343
2025-04-09T08:06:00-05:00 Starting migration CommunityNodes1652254514002
2025-04-09T08:06:00-05:00 Finished migration CommunityNodes1652254514002
2025-04-09T08:06:00-05:00 Starting migration AddUserSettings1652367743993
2025-04-09T08:06:00-05:00 Finished migration AddUserSettings1652367743993
2025-04-09T08:06:00-05:00 Starting migration AddAPIKeyColumn1652905585850
2025-04-09T08:06:00-05:00 Finished migration AddAPIKeyColumn1652905585850
2025-04-09T08:06:00-05:00 Starting migration IntroducePinData1654090467022

...
2025-04-09T08:06:04-05:00 Starting migration UpdateParentFolderIdColumn1740445074052
2025-04-09T08:06:04-05:00 Finished migration UpdateParentFolderIdColumn1740445074052
2025-04-09T08:06:04-05:00 Starting migration RenameAnalyticsToInsights1741167584277
2025-04-09T08:06:04-05:00 Finished migration RenameAnalyticsToInsights1741167584277
2025-04-09T08:06:08-05:00 n8n Task Broker ready on 127.0.0.1, port 5679
2025-04-09T08:06:14-05:00 Version: 1.86.0
2025-04-09T08:06:14-05:00 
2025-04-09T08:06:14-05:00 Editor is now accessible via:
2025-04-09T08:06:14-05:00 https://yyyy.mmm.www
2025-04-09T08:06:16-05:00 Registered runner "JS Task Runner" (q7At80JaXhN6RJ_5IRw2-) 
n8n=# \du
                             List of roles
 Role name |                         Attributes                         
-----------+------------------------------------------------------------
 n8n       | Superuser, Create role, Create DB, Replication, Bypass RLS

n8n=# 
                List of relations
 Schema |            Name            | Type  | Owner 
--------+----------------------------+-------+-------
 public | annotation_tag_entity      | table | n8n
 public | auth_identity              | table | n8n
 public | auth_provider_sync_history | table | n8n
 public | credentials_entity         | table | n8n
 public | event_destinations         | table | n8n
 public | execution_annotation_tags  | table | n8n
 public | execution_annotations      | table | n8n
 public | execution_data             | table | n8n
 public | execution_entity           | table | n8n
 public | execution_metadata         | table | n8n
 public | folder                     | table | n8n
 public | folder_tag                 | table | n8n
 public | insights_by_period         | table | n8n
 public | insights_metadata          | table | n8n
 public | insights_raw               | table | n8n
 public | installed_nodes            | table | n8n
 public | installed_packages         | table | n8n
 public | invalid_auth_token         | table | n8n
 public | migrations                 | table | n8n
 public | processed_data             | table | n8n
 public | project                    | table | n8n
 public | project_relation           | table | n8n
 public | role                       | table | n8n
 public | settings                   | table | n8n
 public | shared_credentials         | table | n8n
 public | shared_workflow            | table | n8n

1 Like

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