Skip to content

SQLite Error "no such table: clients" #149

@plazotronik

Description

@plazotronik

When trying to launch after updating to version 1.0.1, I get a startup error:

Fri, 01 May 2026 17:49:31 INFO     Log level: INFO
Fri, 01 May 2026 17:49:31 INFO     Setting timzeone to Europe/Moscow
Fri, 01 May 2026 17:49:31 INFO     Setting UID/GID to 100:100
Fri, 01 May 2026 17:49:31 INFO     Log level: INFO
Fri, 01 May 2026 17:49:31 INFO     Upgrading database schema to version 1...
Traceback (most recent call last):
  File "/home/py-kms/pykms_Server.py", line 543, in <module>
    server_main_terminal()
  File "/home/py-kms/pykms_Server.py", line 468, in server_main_terminal
    server_check()
  File "/home/py-kms/pykms_Server.py", line 384, in server_check
    pykms_Sql.sql_initialize(srv_config['sqlite'])
  File "/home/py-kms/pykms_Sql.py", line 50, in sql_initialize
    cur.execute("ALTER TABLE clients ADD COLUMN lastRequestIP TEXT;")
sqlite3.OperationalError: no such table: clients

I'm launching via Docker Compose

services:
  py-kms:
    image: ghcr.io/py-kms-organization/py-kms:python3
    container_name: py-kms
    hostname: py-kms
    ports:
      - 1688
      - 8080
    environment:
      - SQLITE=true
      - HWID=RANDOM
      - LOGLEVEL=INFO
      - TZ=Europe/Moscow
    restart: always
    volumes:
      - /data/kms/db:/home/py-kms/db
      - /etc/localtime:/etc/localtime:ro

To solve the problem, I renamed the database file, as it wasn't critical, but I saved it just in case.

mv /data/kms/db/pykms_database.db /data/kms/db/pykms_database.db_bak

After that, the log was fine.

py-kms  | Fri, 01 May 2026 17:51:13 INFO     Log level: INFO
py-kms  | Fri, 01 May 2026 17:51:13 INFO     Setting timzeone to Europe/Moscow
py-kms  | Fri, 01 May 2026 17:51:13 INFO     Setting UID/GID to 100:100
py-kms  | Fri, 01 May 2026 17:51:13 INFO     Log level: INFO
py-kms  | Fri, 01 May 2026 17:51:13 INFO     Upgrading database schema to version 1...
py-kms  | Fri, 01 May 2026 17:51:13 INFO     Database schema updated to version 1.
py-kms  | Fri, 01 May 2026 17:51:13 INFO     TCP server listening at :: on port 1688
py-kms  | Fri, 01 May 2026 17:51:13 INFO     HWID: 0F13733D24DD4457
py-kms  | [2026-05-01 17:51:15 +0300] [12] [INFO] Starting gunicorn 23.0.0
py-kms  | [2026-05-01 17:51:15 +0300] [12] [INFO] Listening at: http://0.0.0.0:8080 (12)
py-kms  | [2026-05-01 17:51:15 +0300] [12] [INFO] Using worker: sync
py-kms  | [2026-05-01 17:51:15 +0300] [13] [INFO] Booting worker with pid: 13

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions