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?