<div dir="ltr">Hi Simon,<div>thanks for your scripts.</div><div><br></div><div>I forgot to mention that I'm trying to "archive deleted rows" on Icehouse.</div><div><br></div><div>Belmiro</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 2, 2014 at 4:51 PM, Simon McCartney <span dir="ltr"><<a href="mailto:simon@mccartney.ie" target="_blank">simon@mccartney.ie</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">We're using the exceptionally crude scripts here: <a href="https://gist.github.com/8b90b0b913df9f679d16" target="_blank">https://gist.github.com/8b90b0b913df9f679d16</a> & <a href="https://gist.github.com/efbb3b55bffd5bd41a42" target="_blank">https://gist.github.com/efbb3b55bffd5bd41a42</a> (this is on a Grizzly environment)</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">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)</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Simon.</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"> </div> <div><div style="font-family:helvetica,arial;font-size:13px">-- <br><div style="line-height:normal">Simon McCartney</div><div style="line-height:normal">"If not me, who? If not now, when?"<br><a href="tel://+447710836915" target="_blank">+447710836915</a></div></div></div><div><div class="h5"> <br><p style="color:#000">On 2 October 2014 at 15:18:32, Belmiro Moreira (<a href="mailto:moreira.belmiro.email.lists@gmail.com" target="_blank">moreira.belmiro.email.lists@gmail.com</a>) wrote:</p> </div></div><blockquote type="cite"><span><div><div></div><div><div><div class="h5">






<div dir="ltr">Hi,
<div>our nova DBs are growing rapidly and it's time to start
pruning them...</div>
<div><br></div>
<div>I'm trying the "archive deleted rows" however is not working
and I'm getting the following </div>
<div>warning in the logs: "<span style="font-family:Menlo;font-size:13px">IntegrityError detected when
archiving table</span>"</div>
<div>Searching about this problem I found the bug "<a href="https://bugs.launchpad.net/nova/+bug/1183523" target="_blank">https://bugs.launchpad.net/nova/+bug/1183523</a>"</div>
<div>which, if I understood correctly, means this functionality is
broken for a while...</div>
<div><br></div>
<div>How are other deployments dealing with growing DBs?</div>
<div><br></div>
<div>thanks,</div>
<div>Belmiro</div>
</div></div></div>


_______________________________________________
<br>OpenStack-operators mailing list
<br><a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.openstack.org</a>
<br><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a>
<br></div></div></span></blockquote></div></blockquote></div><br></div>