We're using the exceptionally crude scripts here: https://gist.github.com/8b90b0b913df9f679d16 & https://gist.github.com/efbb3b55bffd5bd41a42 (this is on a Grizzly environment) if you try the archive script & it fails, it should tell you what record in what table failed (we had to clean up a few fixed_ip table entries by hand to clear some dangling FKs) Simon. -- Simon McCartney "If not me, who? If not now, when?" +447710836915 On 2 October 2014 at 15:18:32, Belmiro Moreira (moreira.belmiro.email.lists at gmail.com) wrote: Hi, our nova DBs are growing rapidly and it's time to start pruning them... I'm trying the "archive deleted rows" however is not working and I'm getting the following warning in the logs: "IntegrityError detected when archiving table" Searching about this problem I found the bug "https://bugs.launchpad.net/nova/+bug/1183523" which, if I understood correctly, means this functionality is broken for a while... How are other deployments dealing with growing DBs? thanks, Belmiro _______________________________________________ OpenStack-operators mailing list OpenStack-operators at lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20141002/2a0d9d9b/attachment.html>