<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Agreed. You may also wish to update deleted_at=now() to keep a record of when you did it.<br><br>Sent from my iPhone</div><div><br>On 30 Jul 2014, at 10:28 PM, Abel Lopez <<a href="mailto:alopgeek@gmail.com">alopgeek@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><meta http-equiv="Content-Type" content="text/html charset=windows-1252">If your UUID is correct, I’d just update the DB to say deleted=1.<div>It’s possible that you’re looking at images that have the same “display name” but different UUID’s.</div><div>If you confirm the UUID is the same, just do</div><div>update images set deleted=1 where id=“${UUID}”;</div><div><br><div><div>On Jul 30, 2014, at 12:54 PM, Fischer, Matt <<a href="mailto:matthew.fischer@twcable.com">matthew.fischer@twcable.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;">
<div>environment: Icehouse release on Ubuntu</div>
<div><br>
</div>
<div>We have a glance image that is in a "deleted" state but still shows up in Horizon. The image is in a state where I cannot move it one way or the other and I'd like it gone. The state in the database is "deleted", the image itself is gone from disk (ceph
backing), but still shows up in image lists and in Horizon. The only differences I see in the database when I compare this deleted image to others is that the "deleted_at" field is NULL and "deleted" is 0, not 1. I assume that the deletion returned a failure
status and the database was not updated. Before I go and mess with a production database, I'd like to get an opinion on a fix. My current best guess is to enter a date for 'deleted_at' and set 'deleted' to 1 in the DB. Alternatively I can set the status back
to active and make an empty file with the id in ceph and use the CLI/API to fulfill the delete.</div>
<div><br>
</div>
<div>Opinions?</div>
<div><br>
</div>
<div><br>
</div>
<div>Anything below here is not from me-----</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely
for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to
this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout.<br>
</font>
</div>
_______________________________________________<br>OpenStack-operators mailing list<br><a href="mailto:OpenStack-operators@lists.openstack.org">OpenStack-operators@lists.openstack.org</a><br><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><br></blockquote></div><br></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>OpenStack-operators mailing list</span><br><span><a href="mailto:OpenStack-operators@lists.openstack.org">OpenStack-operators@lists.openstack.org</a></span><br><span><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a></span><br></div></blockquote></body></html>