Re: [Openstack-operators] DB archive deleted rows

2015-07-10 Thread Matt Riedemann
On 10/2/2014 9:51 AM, Simon McCartney 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

Re: [Openstack-operators] DB archive deleted rows

2014-10-02 Thread Belmiro Moreira
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 wrote: > We're using the exceptionally crude scripts here: > https://gist.github.com/8b90b0b913df9f679d16 & > https://gist.githu

Re: [Openstack-operators] DB archive deleted rows

2014-10-02 Thread Simon McCartney
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 fe

[Openstack-operators] DB archive deleted rows

2014-10-02 Thread Belmiro Moreira
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.lau