Unable to delete node if it's associated with a database host #224

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

Originally created by @notAreYouScared on GitHub (Dec 25, 2024).

Originally assigned to: @lancepioch, @alexevladgabriel, @pelican-vehikl on GitHub.

Create a node and assign it to a Database Host,
Try to delete the node.

Observe Error

SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed
delete from "nodes" where "id" = 2
Originally created by @notAreYouScared on GitHub (Dec 25, 2024). Originally assigned to: @lancepioch, @alexevladgabriel, @pelican-vehikl on GitHub. Create a node and assign it to a Database Host, Try to delete the node. Observe Error ``` SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed ``` ```sql delete from "nodes" where "id" = 2 ```
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/panel#224