Restart of Docker container fails with DB error (postgresql-v2.19.0)

[vpeil]

Describe the Bug

I am using this image ghcr.io/umami-software/umami:postgresql-v2.19.0. The Postgresql-Db itself lives on another host (version 15 of postgres).

Out of nowhere, after restarting the container I am getting an DB error.

I my humble opinion nothing has changed, so no migration needed.
I have a DB of 110 DB and really would like to keep the data.

Thanks in advance for any help!

Database

PostgreSQL

Relevant log output

> umami@2.19.0 start-docker /app
> npm-run-all check-db update-tracker set-routes-manifest start-server


> umami@2.19.0 check-db /app
> node scripts/check-db.js

[dotenv@17.2.1] injecting env (0) from .env -- tip: 🔐 encrypt with Dotenvx: https://dotenvx.com
✓ DATABASE_URL is defined.
✓ Database connection successful.
✓ Database version check successful.
Error: P3009

migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
The `01_init` migration started at 2025-10-27 17:06:00.831525 UTC failed


✗ Command failed: prisma migrate deploy
Error: P3009

migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
The `01_init` migration started at 2025-10-27 17:06:00.831525 UTC failed



 ELIFECYCLE  Command failed with exit code 1.
ERROR: "check-db" exited with 1.
 ELIFECYCLE  Command failed with exit code 1.

Which Umami version are you using? (if relevant)

2.19.0

Which browser are you using? (if relevant)

No response

How are you deploying your application? (if relevant)

Docker

[vpeil]

Maybe related to #3551 ? I have the same in the db logs.

[franciscao633]

It looks like its not recognizing your old database. It shouldn't be running 01_init on an existing Umami db. Are you missing a schema or something? If you able to query your db can you post what your _prisma_migrations table looks like?

[vpeil]

Here's my output from select * from _prisma_migrations:

                  id                  |                             checksum                             | finished_at | migration_name |                                                                                                                                                                          logs                                                                                                                                                                          | rolled_back_at |          started_at           | applied_steps_count 
--------------------------------------+------------------------------------------------------------------+-------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+-------------------------------+---------------------
 6aeffd12-0a21-4682-97d9-20c5bbd5de25 | 65f0f9ee4a3b432e7fa917795033254887497a849d95acf7d9cb4ff24b45f98f |             | 01_init        | A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve                                                                                                                                         +|                | 2025-10-27 17:06:00.831525+00 |                   0
                                      |                                                                  |             |                |                                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                | Migration name: 01_init                                                                                                                                                                                                                                                                                                                               +|                |                               | 
                                      |                                                                  |             |                |                                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                | Database error code: 42P07                                                                                                                                                                                                                                                                                                                            +|                |                               | 
                                      |                                                                  |             |                |                                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                | Database error:                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                | ERROR: relation "user" already exists                                                                                                                                                                                                                                                                                                                 +|                |                               | 
                                      |                                                                  |             |                |                                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                | DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E42P07), message: "relation \"user\" already exists", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("heap.c"), line: Some(1150), routine: Some("heap_create_with_catalog") }+|                |                               | 
                                      |                                                                  |             |                |                                                                                                                                                                                                                                                                                                                                                       +|                |                               | 
                                      |                                                                  |             |                |    0: sql_schema_connector::apply_migration::apply_script                                                                                                                                                                                                                                                                                             +|                |                               |