Hello, is this a bug? I'm trying to delete an offl...
# fleete
Esteban
08/19/2021, 2:06 PMHello, is this a bug? I'm trying to delete an offline host and this happens. This is the response from the server.
Copy code
{
"message": "Validation Failed",
"errors": [
{
"name": "base",
"reason": "Error 1451: Cannot delete or update a parent row: a foreign key constraint fails (`fleet`.`host_software`, CONSTRAINT `host_software_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`))"
}
]
}t
Tomas Touceda
08/19/2021, 2:10 PMhi Esteban, how are you trying to delete the host?
e
Esteban
08/19/2021, 2:11 PMOn host details, clicking on Delete
Esteban
08/19/2021, 2:11 PMI think there's a constraint since that host has software related to him
t
Tomas Touceda
08/19/2021, 2:15 PMwill look into it
Tomas Touceda
08/19/2021, 2:16 PMah yes, it doesn't have the delete cascade
Tomas Touceda
08/19/2021, 2:22 PMyou were running mariadb, correct? could you remind me the version?
e
Esteban
08/19/2021, 2:31 PM10.5.4
t
Tomas Touceda
08/19/2021, 4:39 PMall right, just pushed a pull request to address this issue. Should be available in the next release. In the meantime, as a work around would be to clear the host_software for that host by hand
e
Esteban
08/19/2021, 4:51 PMUnderstood, thank you!