<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 02 Sep 2016, at 17:08, Matt Fischer <<a href="mailto:matt@mattfischer.com" class="">matt@mattfischer.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Fri, Sep 2, 2016 at 8:57 AM, Abel Lopez <span dir="ltr" class="">
<<a href="mailto:alopgeek@gmail.com" target="_blank" class="">alopgeek@gmail.com</a>></span> wrote:<br class="">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
For cinder, since kilo, we've had 'cinder-manage db purge-deleted'
<div class="gmail-HOEnZb">
<div class="gmail-h5">
<div class=""><span class=""></span><br class="">
</div>
</div>
</div>
</blockquote>
<div class=""><br class="">
</div>
<div class="">This is the issue we see with this tool in Liberty, I think this might be fixed in M.</div>
<div class=""><br class="">
</div>
<div class=""># cinder-manage db purge 365<br class="">
</div>
<div class="">.... (some stuff works here)</div>
<div class="">...</div>
<div class=""><br class="">
</div>
<div class="">2016-09-02 15:07:02.196 203924 ERROR cinder DBReferenceError: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2`
FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))') [SQL: u'DELETE FROM snapshots WHERE snapshots.deleted_at < %s'] [parameters: (datetime.datetime(2015, 9, 3, 15, 7, 2, 189701),)] </div>
</div>
<br class="">
</div>
</div>
</div>
</blockquote>
<br class="">
</div>
<div>I think this is fixed here: <a href="https://review.openstack.org/#/c/338228/" class="">https://review.openstack.org/#/c/338228/</a></div>
<div>(which comes with Newton only).</div>
<div><br class="">
</div>
<div>Cheers,</div>
<div> Arne</div>
<div><br class="">
</div>
<br class="">
<div class="">--<br class="">
Arne Wiebalck<br class="">
CERN IT </div>
<br class="">
</body>
</html>