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 <[email protected]> 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 ( > [email protected]) 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 > [email protected] > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators > >
_______________________________________________ OpenStack-operators mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
