<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 13, 2017 at 5:28 PM, Wesley Stewart <span dir="ltr"><<a href="mailto:wstewart3@gmail.com" target="_blank">wstewart3@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Is the VM showing as locked? You could try to manually unlocking it. I did this in a test environment a while back with some success after a vm was stuck in a "locked" state. Of course the gui and engine should handle most of this for you, manually mucking around the internal DB can cause some pretty serious issues if you are not careful...<div><br></div><div><span id="gmail-m_3013395779251940879gmail-docs-internal-guid-5ebb4940-b624-d7ad-e1f7-464f6602a039"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">sudo su postgres</span></p><span class="gmail-"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">psql -d engine -U postgres </span></p></span><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">SELECT vm_guid, vm_name FROM vm_static WHERE vm_name='<b>VM_Name_Here</b>';</span></p><div><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">This should return a string such as: "</span><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;font-weight:700;white-space:pre-wrap">0ec20854-e1ca-4e49-be87-<wbr>a6cd36d40c18"</span></div><div><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;font-weight:700;white-space:pre-wrap"><br></span></div><div><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;font-weight:700;white-space:pre-wrap">Reset the lock:</span></div><div><span id="gmail-m_3013395779251940879gmail-docs-internal-guid-5ebb4940-b625-b889-54b8-79b3e092d57b"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">update vm_dynamic SET status=0 where vm_guid='<span style="font-size:14.6667px;font-weight:bold">0ec20854-e1ca-4e49-<wbr>be87-a6cd36d40c18</span>';</span></span><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;font-weight:700;white-space:pre-wrap"><br></span></div><div><br></div><div><br></div></span></div></div><div class="gmail_extra"><br></div>
</blockquote></div></div><div class="gmail_extra"><br></div><div class="gmail_extra">I'd prefer to avoid direct manage of the rdbms...</div><div class="gmail_extra"><br></div><div class="gmail_extra">As it happened on Friday, after running again the command</div><div class="gmail_extra"><br></div><div class="gmail_extra"><span class="gmail-im">PGPASSWORD=... /usr/share/ovirt-engine/setup/<wbr>dbutils/unlock_entity.sh -t all -u engine</span></div><div class="gmail_extra"><br></div><div class="gmail_extra">now the gui after some time shows no active task</div><div class="gmail_extra"><br></div><div class="gmail_extra">but the vm still shows as locked and in the event pane I only have the message</div><div class="gmail_extra">Snapshot '13-11-2017-16-30-Danilo' creation for VM 'apex' was initiated by user1@internal-authz.</div><div class="gmail_extra">but no message about its correct completion</div><div class="gmail_extra"><br></div><div class="gmail_extra">This is my disks' subtab situation for the vm, where it seems all ok:</div><div class="gmail_extra"><a href="https://drive.google.com/file/d/1tF3VdA8gzMVvtn2x4HTKOmltRmUR7cTG/view?usp=sharing">https://drive.google.com/file/d/1tF3VdA8gzMVvtn2x4HTKOmltRmUR7cTG/view?usp=sharing</a></div><div class="gmail_extra"><br></div><div class="gmail_extra">And this the snapshots' subtab where it seems all ok: <br></div><div class="gmail_extra"><a href="https://drive.google.com/file/d/1qbEhdS6eOZL-f8y5xCnuc_4_HsYM4mAa/view?usp=sharing">https://drive.google.com/file/d/1qbEhdS6eOZL-f8y5xCnuc_4_HsYM4mAa/view?usp=sharing</a><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">But the VM has the lock symbol in side of itself.</div><div class="gmail_extra">Any guidance appreciated, both to solve the problem and to understand if the snapshot is consistent, as a user should to changes to the VM with a chance to have to come back</div><div class="gmail_extra"><br></div><div class="gmail_extra">Gianluca<br></div></div>