https://linen.dev logo
Failed to delete Project with Database Error
# help
b
Copy code
shell$ cargo shuttle delete
Error: 500 Internal Server Error
message: Persistence failure: Database error: error returned from database: (code: 787) FOREIGN KEY constraint failed
a
try going to pgadmin (or whatever you're using for db management) and using Drop Cascade on the tables
from what I know of using pgadmin, if you try to simply "drop" a table and it has foreign keys it won't allow you unless you use drop cascade to drop dependencies
b
what's pgadmin 😅 postgres? i am using mysql. so i basically have to drop everything so shuttle can delete it? (i still consider it a bug 🐛)
a
Sorry i forgot to say whatever db management system you're using
But yeah if it's failing because of foreign keys that is the most likely solution
k
Ah yes, this is a known issue, it's because we're not cleaning up all the associated tables when we delete a service. I'll look into creating an issue for this
b
ok