Open Stack

Hi Simon,
thanks for your scripts.

I forgot to mention that I'm trying to "archive deleted rows" on Icehouse.

Belmiro

On Thu, Oct 2, 2014 at 4:51 PM, Simon McCartney <simon at mccartney.ie> wrote:

> 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 <//+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/7b3f0c97/attachment.html>