Issue deploy version 1.86.0

tuanama00 · April 8, 2025, 10:29pm

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

jcuypers · April 9, 2025, 6:15am

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.

tuanama00 · April 9, 2025, 1:10pm

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

system · July 8, 2025, 1:10pm

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