pixeleet•8mo ago

Stuck in migration hell during upgrade.

{"timestamp":"2024-05-10T12:38:45.990624Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:45.996531Z","level":"INFO","message":"Started applying migration 20240415144144: tighten delete permissions","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:46.003459Z","level":"INFO","message":"Finished applying migration 20240415144144","target":"windmill_api::db"}
Error: Migrating database: while executing migrations: error returned from database: must be owner of relation resource

{"timestamp":"2024-05-10T12:38:45.990624Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:45.996531Z","level":"INFO","message":"Started applying migration 20240415144144: tighten delete permissions","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:46.003459Z","level":"INFO","message":"Finished applying migration 20240415144144","target":"windmill_api::db"}
Error: Migrating database: while executing migrations: error returned from database: must be owner of relation resource

5 Replies

pixeleetOP•8mo ago

https://github.com/windmill-labs/windmill/blob/bb8af8fa988767e85a370a01ac41f75304cdcb20/backend/migrations/20240415144144_tighten_delete_permissions.up.sql#L4 This is the migration in question.

GitHub

windmill/backend/migrations/20240415144144_tighten_delete_permissio...

Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). Open-source alternative to Airplane and Retool. - windmill-labs/windmill

pixeleetOP•8mo ago

How can I get around this one?

rubenf•8mo ago

https://stackoverflow.com/questions/28584640/postgresql-error-must-be-owner-of-relation-when-changing-a-owner-object

Stack Overflow

Postgresql: error "must be owner of relation" when changing a owner...

What is the grant option/trick I need to give to the current user ("userA") to allow him to change a object's owner which belongs by another user ("userC")? More precisely, the

rubenf•8mo ago

you have to check who is the current owner of those tables and make sure the user you use for the servers is the owner

pixeleetOP•8mo ago

thank you. that worked.