Losing a part of data after docker down and up

[Hoang_Nguyen]

Describe the problem/error/question

I lost data, showing past data, even though I just restarted docker compose. The config file is preserved.

Information on your n8n setup

• n8n version: 1.88.0
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): own
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Ubuntu

Here is my docker-compose.yml file:

version: "3.7"

services:
  traefik:
    image: "traefik:v2.9"
    restart: always
    command:
      - "--api=true"
      - "--api.insecure=true"
      - "--providers.docker=true"
      - "--providers.docker.exposedbydefault=false"
      - "--entrypoints.web.address=:80"
      - "--entrypoints.web.http.redirections.entryPoint.to=websecure"
      - "--entrypoints.web.http.redirections.entrypoint.scheme=https"
      - "--entrypoints.websecure.address=:443"
      - "--certificatesresolvers.mytlschallenge.acme.tlschallenge=true"
      - "--certificatesresolvers.mytlschallenge.acme.email=${SSL_EMAIL}"
      - "--certificatesresolvers.mytlschallenge.acme.storage=/letsencrypt/acme.json"
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - traefik_data:/letsencrypt
      - /var/run/docker.sock:/var/run/docker.sock:ro
    networks:
      - web

  n8n:
    image: docker.n8n.io/n8nio/n8n
    restart: always
    ports:
      - "127.0.0.1:5678:5678"
    labels:
      - traefik.enable=true
      - traefik.http.routers.n8n.rule=Host(`${SUBDOMAIN}.${DOMAIN_NAME}`)
      - traefik.http.routers.n8n.tls=true
      - traefik.http.routers.n8n.entrypoints=web,websecure
      - traefik.http.routers.n8n.tls.certresolver=mytlschallenge
      - traefik.http.middlewares.n8n.headers.SSLRedirect=true
      - traefik.http.middlewares.n8n.headers.STSSeconds=315360000
      - traefik.http.middlewares.n8n.headers.browserXSSFilter=true
      - traefik.http.middlewares.n8n.headers.contentTypeNosniff=true
      - traefik.http.middlewares.n8n.headers.forceSTSHeader=true
      - traefik.http.middlewares.n8n.headers.SSLHost=${DOMAIN_NAME}
      - traefik.http.middlewares.n8n.headers.STSIncludeSubdomains=true
      - traefik.http.middlewares.n8n.headers.STSPreload=true
      - traefik.http.routers.n8n.middlewares=n8n@docker
      - traefik.http.routers.n8n.priority=10
    environment:
      - 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
      - N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true
    volumes:
      - n8n_data:/home/node/.n8n
      - ./data:/data
    networks:
      - web

volumes:
  traefik_data:
    external: true
  n8n_data:
    external: true

networks:
  web:
    driver: bridge

[jcuypers]

Hi,

Can you please state which data your are missing and/or what is not working?

reg,
J.

[Hoang_Nguyen]

Hi master,
somehow i am missing all the data i did today after i restarted docker (docker compose down && docker compose up -d).
Thanks.

[jcuypers]

Hi,

And to confirm, these volumes (n8n_data) were created/managed independently of the docker-compose right? they exist?

I personally would advice on using a manual encryption through ENV so it’s clear whats being used.

reg,
J.

[Hoang_Nguyen]

Hi,
Yes, [n8n_data] was created and managed by docker compose and they exist. But n8n use old data after i restarted docker.
Thanks

[Hoang_Nguyen]

[jcuypers]

Hi, sorry not sure what to comment:
Can you verify with docker-compose examples on the N8N-hosting whether or not this works correctly?

Your SQLite database has a recent timestamp

Any special info in the eventlogs?

Reg,
J.