<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks you for that info Michael!<div><br><div><div>Le 14 juil. 2013 à 00:20, Michael Still <<a href="mailto:mikal@stillhq.com">mikal@stillhq.com</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">On Sat, Jul 13, 2013 at 12:11 AM, Razique Mahroua <span dir="ltr"><<a href="mailto:razique.mahroua@nuage-and-co.fr" target="_blank">razique.mahroua@nuage-and-co.fr</a>></span> wrote:<br><div class="gmail_extra">
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hey guys, <div>many asked me for that, here is the small sql query :</div>
<div><blockquote type="cite">select concat("/var/lib/nova/instance/instance-00000",conv(id, 10, 16),"/") as instance_path,power_state,vm_state,display_name from instances where deleted=0 and host="vs11" order by id</blockquote>
<br></div><div><br></div><div>It'll give you the according directory :)</div></div></blockquote><div><br></div><div style="">Unfortunately this wont work with grizzly and later, which instance UUIDs are preferred for directory names instead of ids (for instances created after you upgrade). This change happened because the code assumed that the instance name is unique, which isn't always true. UUIDs on the other hand are always unique.</div>
<div style=""><br></div><div style="">Sorry about that.</div><div style=""><br></div><div style="">Michael</div></div></div></div>
_______________________________________________<br>OpenStack-operators mailing list<br><a href="mailto:OpenStack-operators@lists.openstack.org">OpenStack-operators@lists.openstack.org</a><br>http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators<br></blockquote></div><br></div></body></html>