<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" 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: https://gist.github.com/8b90b0b913df9f679d16 & https://gist.github.com/efbb3b55bffd5bd41a42 (this is on a Grizzly environment)</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" 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 id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Simon.</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"> </div> <div id="bloop_sign_1412261391631353856" class="bloop_sign"><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">+447710836915</a></div></div></div> <br><p style="color:#000;">On 2 October 2014 at 15:18:32, Belmiro Moreira (<a href="mailto:moreira.belmiro.email.lists@gmail.com">moreira.belmiro.email.lists@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<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">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>
_______________________________________________
<br>OpenStack-operators mailing list
<br>OpenStack-operators@lists.openstack.org
<br>http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
<br></div></div></span></blockquote></body></html>