[Openstack-operators] DB archive deleted rows

Simon McCartney simon at mccartney.ie
Thu Oct 2 14:51:58 UTC 2014


We're using the exceptionally crude scripts here: https://gist.github.com/8b90b0b913df9f679d16https://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>


More information about the OpenStack-operators mailing list