Database migration error
Hi all,
my self-hosted Windmill stopped working and shows this error before failing.
Di you have any suggestion on how tò solve this?
Many thanks for your support.
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 expressionINFO 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 expressionDi you have any suggestion on how tò solve this?
Many thanks for your support.
