https://dagster.io/ logo
Title
f

Frank Dekervel

11/17/2022, 3:26 PM
hello, new dagster version has a migration which does CREATE INDEX CONCURRENTLY , which basically claims exclusive access over the whole DB. https://www.postgresql.org/message-id/MWHPR20MB1421BF01C05147053F6F64CAA19D0%40MWHPR20MB1421.namprd20.prod.outlook.com so for me this never completes
a

Adam Bloom

11/17/2022, 3:35 PM
The migrations are not designed to run while dagster is running. Did you deploy with helm? There’s a guide here on how to stop services first: https://docs.dagster.io/deployment/guides/kubernetes/how-to-migrate-your-instance
f

Frank Dekervel

11/18/2022, 9:06 AM
hello @Adam Bloom thanks for the suggestion. i tried scaling down the statefulset (but no jobs were running already). that didn't unblock the query. also, if the migrations are not supposed to be run in parallel with the code, then why is the "concurrently" in the index creation ?