[Rdo-list] Clean heat database

[ICHIBA Sara]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rdoproject.org/pipermail/dev/attachments/20150902/22df449e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Capture_heat.PNG
Type: image/png
Size: 70055 bytes
Desc: not available
URL: <http://lists.rdoproject.org/pipermail/dev/attachments/20150902/22df449e/attachment.png>