aurelienbrabant
aurelienbrabant12mo ago

Foreign key issue while attempting to delete workspace

Windmill version: self hosted CE v1.206.0-7 The PG database is the one provided with the docker compose setup (which I didn't update since I first installed windmill though) I attempted to delete a windmill workspace but was greeted with foreign key constraint violation errors. As I was in a hurry I fixed it myself by deleting manually the following rows (where WK_ID is the id of the workspace I wanted to delete) DELETE FROM queue WHERE workspace_id = 'WK_ID' DELETE FROM capture WHERE workspace_id = 'WK_ID' DELETE FROM draft WHERE workspace_id = 'WK_ID' After I ran this queries I was able to proceed with proper deletion of the workspace.
2 Replies
rubenf
rubenf12mo ago
We will fix, thanks for the feedback fixed
aurelienbrabant
aurelienbrabant12mo ago
Thanks!