[Openstack-operators] DB archive deleted rows
moreira.belmiro.email.lists at gmail.com
Thu Oct 2 15:57:33 UTC 2014
thanks for your scripts.
I forgot to mention that I'm trying to "archive deleted rows" on Icehouse.
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
> 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 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:
> 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 "
> which, if I understood correctly, means this functionality is broken for a
> How are other deployments dealing with growing DBs?
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the OpenStack-operators