Skip to content

Migrations Database Error #165

@Mr-Question

Description

@Mr-Question

Hi,

Here I am, just a noobby who wanted to run a local instance of this nice app without knowing anything about lapis of anything else.

I have "Debian GNU/Linux 12 (bookworm)" and am trying to create and run a Docker image in the usual way like docker build -t sightreading.training ..

The thing is that an image is built normally, but when I try to run it, all that magic about configuration happens and ends up shortly with the following error:

  • su postgres -c '/usr/bin/pg_ctl -s -D /var/lib/postgres/data start -w -t 120'

2025-05-10 17:46:23.425 UTC [2284] LOG: starting PostgreSQL 16.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.1 20230801, 64-bit
2025-05-10 17:46:23.426 UTC [2284] LOG: listening on IPv6 address "::1", port 5432
2025-05-10 17:46:23.426 UTC [2284] LOG: listening on IPv4 address "127.0.0.1", port 5432
2025-05-10 17:46:23.427 UTC [2284] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"
2025-05-10 17:46:23.431 UTC [2287] LOG: database system was shut down at 2024-02-24 00:06:10 UTC
2025-05-10 17:46:23.437 UTC [2284] LOG: database system is ready to accept connections

  • make init_schema
    createdb -U postgres sightreading
    cat schema.sql | psql -U postgres sightreading
    SET
    SET
    SET
    SET
    SET
    set_config

(1 row)

SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
SET
SET
SET
SET
SET
set_config

(1 row)

SET
SET
SET
SET
COPY 12

  • make migrate
    lapis migrate
    Running migrations for environment: development
    Error: Database type could not be determined from configuration (postgres, mysql, sqlite)

I would appreciate very well if you give some piece of advice on how to fix the issue or provide some fix or little hint in the docs via the repository.

TIA.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions