Migration '20260107133344' in postgres fails
Hello,
When upgrading from 1.601.1 to 1.60.3.0 I am getting this error:
This is within a K8S cluster running 1.34.0. Postgres is on 18.1 via CNPG.
When upgrading from 1.601.1 to 1.60.3.0 I am getting this error:
{"timestamp":"2026-01-09T14:13:30.699776Z","level":"INFO","message":"Acquiring global PG lock for potential migration with pid: Some(1874)","target":"windmill_api::db"}
{"timestamp":"2026-01-09T14:13:30.702578Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2026-01-09T14:13:30.708501Z","level":"INFO","message":"Started applying migration 20260107133344: fix custom user instance","target":"windmill_api::db"} {"timestamp":"2026-01-09T14:13:30.710040Z","level":"INFO","message":"Finished applying migration 20260107133344","target":"windmill_api::db"} Error: Error migrating db: Migrating database: while executing migration 20260107133344: error returned from database: role "custom_instance_user" does not exist {"timestamp":"2026-01-09T14:13:30.699776Z","level":"INFO","message":"Acquiring global PG lock for potential migration with pid: Some(1874)","target":"windmill_api::db"}
{"timestamp":"2026-01-09T14:13:30.702578Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2026-01-09T14:13:30.708501Z","level":"INFO","message":"Started applying migration 20260107133344: fix custom user instance","target":"windmill_api::db"} {"timestamp":"2026-01-09T14:13:30.710040Z","level":"INFO","message":"Finished applying migration 20260107133344","target":"windmill_api::db"} Error: Error migrating db: Migrating database: while executing migration 20260107133344: error returned from database: role "custom_instance_user" does not exist This is within a K8S cluster running 1.34.0. Postgres is on 18.1 via CNPG.
