Skip to content

Error: role "adventure" does not exist #1261

Description

@wardwygaerts

Describe Your Issue

After updating to v0.13.0, I get these error:

After waiting some minutes, the app is live, but the errors remain. Maybe this was already there in previous versions?

adventurelog-db        | 2026-08-23T09:12:55.952657597Z 2026-08-23 09:12:55.951 UTC [4837] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:01.023486305Z 2026-08-23 09:13:01.023 UTC [4847] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:06.121259350Z 2026-08-23 09:13:06.121 UTC [4858] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:11.219524334Z 2026-08-23 09:13:11.219 UTC [4865] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:16.315336958Z 2026-08-23 09:13:16.315 UTC [4875] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:21.413674702Z 2026-08-23 09:13:21.413 UTC [4883] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:26.509635660Z 2026-08-23 09:13:26.509 UTC [4892] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:31.610487518Z 2026-08-23 09:13:31.610 UTC [4903] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:36.711494006Z 2026-08-23 09:13:36.711 UTC [4910] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:41.811942103Z 2026-08-23 09:13:41.811 UTC [4918] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:46.876770258Z 2026-08-23 09:13:46.876 UTC [4927] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:51.979504048Z 2026-08-23 09:13:51.979 UTC [4935] FATAL:  role "adventure" does not exist

Docker Compose (Obfuscated)

services:
  web:
    container_name: adventurelog-frontend
    image: ghcr.io/seanmorley15/adventurelog-frontend
    restart: unless-stopped
    hostname: adventurelog-frontend
    environment:
      - PUBLIC_SERVER_URL=http://server:8000 #http://adventurelog-backend:80 # MOST DOCKER USERS WILL NEVER NEED TO CHANGE THIS, EVEN IF YOU CHANGE THE PORTS
      #- ORIGIN=http://192.168.0.6:8015
      - ORIGIN=https://adventurelog.$DOMAINNAME
      - BODY_SIZE_LIMIT=Infinity # This is measured in bytes
      #- FRONTEND_PORT=8015
    ports:
      - 8015:3000
    networks:
      - proxy
      - local
    labels:
      - traefik.enable=true
      - traefik.http.routers.adventurelog-rtr.entrypoints=https
      - traefik.http.routers.adventurelog-rtr.rule=Host(`adventurelog.$DOMAINNAME`) && !(PathPrefix(`/media`) || PathPrefix(`/admin`) || PathPrefix(`/static`) || PathPrefix(`/accounts`))
      - traefik.http.routers.adventurelog-rtr.tls=true
      - traefik.http.routers.adventurelog-rtr.middlewares=chain-oauth@file
      - traefik.http.routers.adventurelog-rtr.service=adventurelog-svc
      - traefik.http.services.adventurelog-svc.loadbalancer.server.port=3000
    depends_on:
      - server
    healthcheck:
      test:
        [
          "CMD",
          "node",
          "-e",
          "fetch('http://127.0.0.1:3000/health').then(r=>process.exit(r.ok?0:1)).catch(()=>process.exit(1))"
        ]
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 30s
  db:
    container_name: adventurelog-db
    image: postgis/postgis:15-3.3
    restart: unless-stopped
    hostname: adventurelog-db
    #mem_limit: 1g
    #cpu_shares: 1024
    networks:
      - local
    environment:
      POSTGRES_DB: adventurelog
      POSTGRES_USER: adventureloguser
      POSTGRES_PASSWORD: adventurelogpass
    volumes:
      - $CONFIGDIR/adventurelog/db:/var/lib/postgresql/data/
    healthcheck:
      test:
        [
          "CMD-SHELL",
          "pg_isready -U ${POSTGRES_USER:-adventure} -d ${POSTGRES_DB:-database}"
        ]
      interval: 5s
      timeout: 5s
      retries: 5
      start_period: 10s
  server:
    container_name: adventurelog-backend
    image: ghcr.io/seanmorley15/adventurelog-backend
    restart: unless-stopped
    hostname: adventurelog-backend
    environment:
      - PGHOST=db
      - PGDATABASE=adventurelog
      - PGUSER=***********
      - PGPASSWORD=***********
      - SECRET_KEY=**************
      - DJANGO_ADMIN_USERNAME=***********
      - DJANGO_ADMIN_PASSWORD=***********
      - DJANGO_ADMIN_EMAIL=***********
      #- PUBLIC_URL=http://192.168.0.6:8016
      - PUBLIC_URL=https://adventurelog.$DOMAINNAME
      #- CSRF_TRUSTED_ORIGINS=http://192.168.0.6:8015,http://192.168.0.6:8016,http://localhost:8016,http://localhost:8015
      - CSRF_TRUSTED_ORIGINS=https://adventurelog.$DOMAINNAME
      - DEBUG=False
      #- FRONTEND_URL=http://localhost:8015
      - FRONTEND_URL=https://adventurelog.$DOMAINNAME
      #- BACKEND_PORT=8016
      - DISABLE_REGISTRATION=True
      # OPTIONAL: Set the message to display when registration is disabled
      - DISABLE_REGISTRATION_MESSAGE='Registration is disabled for this instance of AdventureLog.'
      - GOOGLE_MAPS_API_KEY=***********
    ports:
      - 8016:80
    networks:
      - local
      - proxy
    depends_on:
      db:
        condition: service_healthy
    volumes:
      - $CONFIGDIR/adventurelog/media:/code/media/
    labels:
      - traefik.enable=true
      - traefik.http.routers.advnginx-rtr.entrypoints=https
      - traefik.http.routers.advnginx-rtr.rule=Host(`adventurelog.$DOMAINNAME`) && (PathPrefix(`/media`) || PathPrefix(`/admin`) || PathPrefix(`/static`) || PathPrefix(`/accounts`))
      - traefik.http.routers.advnginx-rtr.tls=true
      - traefik.http.routers.advnginx-rtr.middlewares=chain-oauth@file
      - traefik.http.routers.advnginx-rtr.service=advnginx-svc
      - traefik.http.services.advnginx-svc.loadbalancer.server.port=80
      #- traefik.http.middlewares.nginx-stripprefix.stripprefix.prefixes=/media
      #- traefik.http.routers.advnginx-rtr.middlewares=nginx-stripprefix
    healthcheck:
      test:
        [
          "CMD-SHELL",
          "python -c \"import urllib.request; urllib.request.urlopen('http://localhost:80/health/')\""
        ]
      interval: 15s
      timeout: 5s
      retries: 5
      start_period: 60s
networks:
  proxy:
    external: true
  local:
    external: true

Logs / Error Output

adventurelog-db        | 2026-08-23T09:12:55.952657597Z 2026-08-23 09:12:55.951 UTC [4837] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:01.023486305Z 2026-08-23 09:13:01.023 UTC [4847] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:06.121259350Z 2026-08-23 09:13:06.121 UTC [4858] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:11.219524334Z 2026-08-23 09:13:11.219 UTC [4865] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:16.315336958Z 2026-08-23 09:13:16.315 UTC [4875] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:21.413674702Z 2026-08-23 09:13:21.413 UTC [4883] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:26.509635660Z 2026-08-23 09:13:26.509 UTC [4892] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:31.610487518Z 2026-08-23 09:13:31.610 UTC [4903] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:36.711494006Z 2026-08-23 09:13:36.711 UTC [4910] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:41.811942103Z 2026-08-23 09:13:41.811 UTC [4918] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:46.876770258Z 2026-08-23 09:13:46.876 UTC [4927] FATAL:  role "adventure" does not exist
adventurelog-db        | 2026-08-23T09:13:51.979504048Z 2026-08-23 09:13:51.979 UTC [4935] FATAL:  role "adventure" does not exist

AdventureLog Version

v0.13.0

Reverse Proxy

Traefik

Confirmation

  • I removed or obfuscated all sensitive data from this issue.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    deploymentIssues related to deploying AdventureLog

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions