Grafana docker service in swarm fails: error "attempt to write a readonly database"

Grafana Installation
1

This is my docker-compose:

version: '3.3'

services:

  grafana:
    image: grafana/grafana:8.0.5
    ports:
      - 3000
    networks:
      - traefik-public
    environment:
      - GF_SECURITY_ADMIN_USER=${ADMIN_USER:-admin}
      - GF_SECURITY_ADMIN_PASSWORD=${ADMIN_PASSWORD:-admin}
      - GF_USERS_ALLOW_SIGN_UP=false
    deploy:
      mode: replicated
      replicas: 1
      placement:
        constraints:
          - node.role == manager
      resources:
        limits:
          memory: 128M
        reservations:
          memory: 64M
      labels:
          - traefik.enable=true
          - traefik.docker.network=traefik-public
          - traefik.constraint-label=traefik-public
          - traefik.http.routers.grafana.rule=Host(`${GRAFANA_DOMAIN?Variable not set}`)
          - traefik.http.routers.grafana.entrypoints=http
          - traefik.http.middlewares.grafana.redirectscheme.scheme=https
          - traefik.http.middlewares.grafana.redirectscheme.permanent=true
          - traefik.http.routers.grafana-secured.rule=Host(`${GRAFANA_DOMAIN?Variable not set}`)
          - traefik.http.routers.grafana-secured.entrypoints=https
          - traefik.http.routers.grafana-secured.tls.certresolver=le
          - traefik.http.services.grafana-secured.loadbalancer.server.port=3000
    volumes:
      - grafana:/var/lib/grafana

  influxdb:
    image: influxdb:1.8.0
    ports:
      - 8086
    networks:
      - traefik-public
      - sp-net
    deploy:
      resources:
        reservations:
          cpus: '0.3'
          memory: 128M
        limits:
          cpus: '0.6'
          memory: 512M
      placement:
        constraints:
          - node.role==manager
    environment:
      INFLUXDB_DB: shinyproxy_usagestats # this need to match the database specified in application.yml
      # INFLUXDB_ADMIN_USER: admin
      # INFLUXDB_ADMIN_PASSWORD: admin
      # INFLUXDB_HTTP_AUTH_ENABLED: "true" # need to delete volume if change the database environment
    volumes:
        - influxdb:/var/lib/influxdb

networks:
  traefik-public:
    external: true
  sp-net:
    external: true

volumes:
  grafana:
  influxdb:

Which, after deploying, it fails to start the service. Inspecting the logs it shows that it is caused by some permission issue:

image
image1831×341 103 KB

I´ve tried changing grafana:/var/lib/grafana for grafana:/var/lib/grafana:rw but it did not work.

I´m new to all this so I´m a bit lost. I´ve also tried to create /var/lib/grafana on the host and give the diectory the correct permissions but, again, it did not work.

I´ve also read this on the docs, maybe the root part is related?

Any ideas?

2

It looks like you are mapping a local directory into the container, yes? Does that directory have the correct user and group settings?

maybe this will help?

sudo chown -R 472:472 ./grafana

1 Like
3

I’m running Grafana on docker and after a restart my service gave the same error of the @algose.

Your solution worked perfectly for me, thanks!

1 Like