Hey there,

Please, I need some help with heat database. Actually as I failed to delete some heat stuck via the cli and the dashboard I deleted them manually. I mean I deleted the resources of those stacks. Now I need to clean my heat database as i always see the names of those stacks in my dashboard (see the capture enclosed).

I already tried to do it myself but i failed:

MariaDB [heat]> delete from stack where id='fd80f026-6c8f-46f2-adfb-61d380eef5cd';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`heat`.`event`, CONSTRAINT `event_ibfk_1` FOREIGN KEY (`stack_id`) REFERENCES `stack` (`id`))

can anyone help please?