RBlhaze Posts - Windmill

RBlhaze

•Created by RBlhaze on 4/12/2024 in #help

Database migration error

Hi all, my self-hosted Windmill stopped working and shows this error before failing.

INFO Binary is in 'server' mode | timestamp=2024-04-12T14:04:18.792315Z target=windmill 
INFO Connecting to database... | timestamp=2024-04-12T14:04:18.792375Z target=windmill 
INFO Database connected | timestamp=2024-04-12T14:04:19.018736Z target=windmill 
INFO PostgreSQL version: PostgreSQL 16.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit (windmill require PG >= 14) | timestamp=2024-04-12T14:04:19.037634Z target=windmill 
INFO Acquiring global PG lock for potential migration with pid: Some(8859) | timestamp=2024-04-12T14:04:19.040425Z target=windmill_api::db 
INFO Acquired global PG lock | timestamp=2024-04-12T14:04:19.043802Z target=windmill_api::db 
INFO Started applying migration 20240209103543: update app new | timestamp=2024-04-12T14:04:19.050553Z target=windmill_api::db 
INFO Finished applying migration 20240209103543 | timestamp=2024-04-12T14:04:19.054929Z target=windmill_api::db 
Error: Migrating database: while executing migrations: error returned from database: more than one row returned by a subquery used as an expression
Caused by:
    0: while executing migrations: error returned from database: more than one row returned by a subquery used as an expression
    1: error returned from database: more than one row returned by a subquery used as an expression
    2: more than one row returned by a subquery used as an expression

INFO Binary is in 'server' mode | timestamp=2024-04-12T14:04:18.792315Z target=windmill 
INFO Connecting to database... | timestamp=2024-04-12T14:04:18.792375Z target=windmill 
INFO Database connected | timestamp=2024-04-12T14:04:19.018736Z target=windmill 
INFO PostgreSQL version: PostgreSQL 16.1 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit (windmill require PG >= 14) | timestamp=2024-04-12T14:04:19.037634Z target=windmill 
INFO Acquiring global PG lock for potential migration with pid: Some(8859) | timestamp=2024-04-12T14:04:19.040425Z target=windmill_api::db 
INFO Acquired global PG lock | timestamp=2024-04-12T14:04:19.043802Z target=windmill_api::db 
INFO Started applying migration 20240209103543: update app new | timestamp=2024-04-12T14:04:19.050553Z target=windmill_api::db 
INFO Finished applying migration 20240209103543 | timestamp=2024-04-12T14:04:19.054929Z target=windmill_api::db 
Error: Migrating database: while executing migrations: error returned from database: more than one row returned by a subquery used as an expression
Caused by:
    0: while executing migrations: error returned from database: more than one row returned by a subquery used as an expression
    1: error returned from database: more than one row returned by a subquery used as an expression
    2: more than one row returned by a subquery used as an expression

Di you have any suggestion on how tò solve this? Many thanks for your support.

19 replies

WWindmill

•Created by RBlhaze on 11/23/2023 in #help

Self-hosted instance workspace bulk migration

Hi all. I'm trying to migrate a workspace from a self-hosted windmill server to another running a newer version (v1.179.1 -> v 1.214). I was trying to find an easy method to do so, and i managed to export the workspace as a .zip file from the "Delete Workspace" menu, but i'm struggling to find an import process. The two instances run two different Postgres versions (12.x -> 16.x) so i'm not quite confident with the idea of just dump the db and restore it on the new instance. Could anyone suggest a recommended method for this type of task? Any advice or insights would be greatly appreciated. Many thanks in advance for your kind support.

9 replies