Skip to content

InfluxDB 3 Explorer shows Error while getting session data #26609

@Marukome0743

Description

@Marukome0743

TL;DR
SQLITE_READONLY error occurred in InfluxDB 3 Explorer when insert session data.

Steps to reproduce:

  1. Run the InfluxDB 3 Explorer following this guide.
  2. Go to InfluxDB 3 Explorer webpage.
  3. I could see the InfluxDB 3 Explorer dashboard at that time.
  4. Around a week later, I couldn't see the dashboard page and homepage shows Error while getting session data.

Expected behaviour:
I can see the InfluxDB 3 Explorer dashboard every time.

Actual behaviour:
InfluxDB 3 Explorer webpage shows Error while getting session data in a week.

Image

Environment info:

compose.yaml

services:
  influxdb3-core:
    image: influxdb:3-core
    container_name: influxdb3-core
    hostname: influxdb3-core
    restart: always
    ports:
      - "8181:8181"
    command:
      - influxdb3
      - serve
      - --node-id=node0
      - --object-store=file
      - --data-dir=/var/lib/influxdb3/data
      - --plugin-dir=/var/lib/influxdb3/plugins
      - --query-file-limit=4320
    healthcheck:
      test: [ "CMD-SHELL", "curl -f -H 'Authorization: Bearer ${INFLUXDB_TOKEN}' http://localhost:8181/health || exit 1" ]
      interval: 5s
      timeout: 5s
      retries: 3
    volumes:
      - type: volume
        source: influxdb3-data
        target: /var/lib/influxdb3/data
      - type: volume
        source: influxdb3-plugins
        target: /var/lib/influxdb3/plugins

  influxdb3-explorer:
    image: influxdata/influxdb3-ui:latest
    container_name: influxdb3-explorer
    restart: always
    ports:
      - "8888:80"
      - "8889:8888"
    volumes:
      - ./config:/app-root/config:ro
      - ./db:/db:rw

  telegraf:
    image: telegraf:latest
    container_name: telegraf
    restart: always
    environment:
      USERNAME: ${USERNAME}
      PASSWORD: ${PASSWORD}
      INFLUXDB_TOKEN: ${INFLUXDB_TOKEN}
      ORGANIZATION: ${ORGANIZATION}
      BUCKET: ${BUCKET}
    volumes:
      - ./telegraf.conf:/etc/telegraf/telegraf.conf
    depends_on:
      influxdb3-core:
        condition: service_healthy

volumes:
  influxdb3-data:
    name: influxdb3-data
  influxdb3-plugins:
    name: influxdb3-plugins

server

uname -a
Linux web.caravan-kidstec.com 6.8.0-63-generic #66-Ubuntu SMP PREEMPT_DYNAMIC Fri Jun 13 20:25:30 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

Config:
config/config.json

{
  "DEFAULT_INFLUX_SERVER": "http://influxdb3-core:8181",
  "DEFAULT_INFLUX_DATABASE": "smart-scarecrow",
  "DEFAULT_API_TOKEN": "apiv3_secret",
  "DEFAULT_SERVER_NAME": "Smart Scarecrow"
}

Logs:

query failed: INSERT INTO "sessions"("id", "product", "expires_at", "created_at") VALUES (?, ?, ?, CURRENT_TIMESTAMP) -- PARAMETERS: ["90bf467d-1c7a-4b56-b60a-fe6e6d69d39c",null,"2025-11-12T06:25:57.149Z"]
error: Error: SQLITE_READONLY: attempt to write a readonly database
Session middleware error: QueryFailedError: SQLITE_READONLY: attempt to write a readonly database
at Statement.handler (/app-root/_backend_app/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:88:37) {
query: 'INSERT INTO "sessions"("id", "product", "expires_at", "created_at") VALUES (?, ?, ?, CURRENT_TIMESTAMP)',
parameters: [
'90bf467d-1c7a-4b56-b60a-fe6e6d69d39c',
null,
'2025-11-12T06:25:57.149Z'
],
driverError: [Error: SQLITE_READONLY: attempt to write a readonly database] {
errno: 8,
code: 'SQLITE_READONLY'
},
errno: 8,
code: 'SQLITE_READONLY'
}

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions