500 when deleting a database host that has a linked node. #226

Closed
opened 2026-02-04 17:09:36 +03:00 by OVERLORD · 3 comments
Owner

Originally created by @notAreYouScared on GitHub (Jan 4, 2025).

If you try to delete a database host with a linked node, you will get a 500 due to a foreign key issue

SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed

You must remove the linked node, save the database host, and then delete it.

Originally created by @notAreYouScared on GitHub (Jan 4, 2025). If you try to delete a database host with a linked node, you will get a 500 due to a foreign key issue ``` SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed ``` You must remove the linked node, save the database host, and then delete it.
Author
Owner

@rmartinoscar commented on GitHub (Jan 4, 2025):

Couldn't reproduce on main, tried on sqlite & mariadb
I believe #844 fixed it

@rmartinoscar commented on GitHub (Jan 4, 2025): Couldn't reproduce on main, tried on sqlite & mariadb I believe #844 fixed it
Author
Owner

@notAreYouScared commented on GitHub (Jan 4, 2025):

My migrations are up to date on sqlite, sooo I'm not sure.

@notAreYouScared commented on GitHub (Jan 4, 2025): My migrations are up to date on sqlite, sooo I'm not sure.
Author
Owner

@notAreYouScared commented on GitHub (Jan 4, 2025):

I guess this isn't an issue?

@notAreYouScared commented on GitHub (Jan 4, 2025): I guess this isn't an issue?
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/panel#226