<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hi all,<br>
      to remove lock I found this script:<br>
      <br>
      "<br>
      <i>[root@ovirt-new dbutils]#  ./unlock_entity.sh  -t disk
        01f9b5f2-9e48-4c24-80e5-dca7f1d4d128</i><i><br>
      </i><i>Caution, this operation may lead to data corruption and
        should be used with care. Please contact support prior to
        running this command</i><i><br>
      </i><i>Are you sure you want to proceed? [y/n]</i><i><br>
      </i><i>y</i><i><br>
      </i><i>select
        fn_db_unlock_disk('01f9b5f2-9e48-4c24-80e5-dca7f1d4d128');</i><i><br>
      </i><i> </i><i><br>
      </i><i>INSERT 0 1</i><i><br>
      </i><i>unlock disk 01f9b5f2-9e48-4c24-80e5-dca7f1d4d128 completed
        successfully.</i><i><br>
        "<br>
        <br>
      </i><br>
      but virtual disk is still lock.<br>
      <br>
      Enrico<br>
      <br>
      <br>
      Il 16/02/2018 09:50, Enrico Becchetti ha scritto:<br>
    </div>
    <blockquote type="cite"
      cite="mid:0f849bf2-6766-aa64-0395-48ae6d6ade8e@pg.infn.it">
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <div class="moz-cite-prefix">After reboot engine virtual machine
        task disappear but virtual disk is still locked ,<br>
        any ideas to remove that lock ?<br>
        Thanks again.<br>
        Enrico<br>
        <br>
        l 16/02/2018 09:45, Enrico Becchetti ha scritto:<br>
      </div>
      <blockquote type="cite"
        cite="mid:a2f46994-0240-f357-d0e7-24c5354c8dd7@pg.infn.it">
        <meta http-equiv="Content-Type" content="text/html;
          charset=utf-8">
        <div class="moz-cite-prefix">   Dear All,<br>
          Are there tools to remove this task (in attach) ?<br>
          <br>
          taskcleaner.sh it's seems doens't work:<br>
          <br>
          [root@ovirt-new dbutils]# ./taskcleaner.sh -v -r<br>
          select exists (select * from information_schema.tables where
          table_schema = 'public' and table_name = 'command_entities');<br>
           t<br>
          SELECT DeleteAllCommands();<br>
                           6<br>
          [root@ovirt-new dbutils]# ./taskcleaner.sh -v -R<br>
          select exists (select * from information_schema.tables where
          table_schema = 'public' and table_name = 'command_entities');<br>
           t<br>
           This will remove all async_tasks table content!!! <br>
          Caution, this operation should be used with care. Please
          contact support prior to running this command<br>
          Are you sure you want to proceed? [y/n]<br>
          y<br>
          TRUNCATE TABLE async_tasks cascade;<br>
          TRUNCATE TABLE<br>
          <br>
          after that I see the same running tasks . Does It make sense ?<br>
          <br>
          Thanks<br>
          Best Regards<br>
          Enrico<br>
          <br>
          <br>
          Il 14/02/2018 15:53, Enrico Becchetti ha scritto:<br>
        </div>
        <blockquote type="cite"
          cite="mid:53ba550f-53ad-8c09-bbd7-7cce50538f94@pg.infn.it">
          <meta http-equiv="Content-Type" content="text/html;
            charset=utf-8">
          <div class="moz-cite-prefix">Dear All,<br>
            old snapsahots seem to be the problem. In fact domain
            DATA_FC running in 3.5 had some<br>
            lvm snapshot volume. Before deactivate DATA_FC  I didin't
            remove this snapshots so when<br>
            I attach this volume to new ovirt 4.2 and import all vm at
            the same time I also import<br>
            all snapshots but now How I can remove them ? Throught ovirt
            web interface the remove <br>
            tasks running are still hang. Are there any other methods ?<br>
            Thank to following this case.<br>
            Best Regads<br>
            Enrico <br>
            <br>
            Il 14/02/2018 14:34, Maor Lipchuk ha scritto:<br>
          </div>
          <blockquote type="cite"
cite="mid:CAJ1JNOeXMJo3Je52Bxa-yukRrMjtDtfHqCzx-d46U1EFCjxLsw@mail.gmail.com">
            <div dir="ltr">Seems like all the engine logs are full with
              the same error.
              <div>From vdsm.log.16.xz I can see an error which might
                explain this failure:<br>
              </div>
              <div><br>
              </div>
              <div>
                <div>2018-02-12 07:51:16,161+0100 INFO  (ioprocess
                  communication (40573)) [IOProcess] Starting ioprocess
                  (__init__:447)</div>
                <div>2018-02-12 07:51:16,201+0100 INFO  (jsonrpc/3)
                  [vdsm.api] FINISH mergeSnapshots return=None
                  from=::ffff:10.0.0.46,57032,
                  flow_id=fd4041b3-2301-44b0-aa65-02bd089f6568,
                  task_id=1be430dc-eeb0-4dc9-92df-3f5b7943c6e0 (api:52)</div>
                <div>2018-02-12 07:51:16,275+0100 INFO  (jsonrpc/3)
                  [jsonrpc.JsonRpcServer] RPC call Image.mergeSnapshots
                  succeeded in 0.13 seconds (__init__:573)</div>
                <div>2018-02-12 07:51:16,276+0100 INFO  (tasks/1)
                  [storage.ThreadPool.WorkerThread] START task
                  1be430dc-eeb0-4dc9-92df-3f5b7943c6e0 (cmd=&lt;bound
                  method Task.commit of &lt;vdsm.storage.task.Task
                  instance at 0x7fa1a0785248&gt;&gt;, args=None)
                  (threadPool:208)</div>
                <div>2018-02-12 07:51:16,543+0100 INFO  (tasks/1)
                  [storage.Image]
                  sdUUID=47b7c9aa-ef53-48bc-bb55-4a1a0ba5c8d5 vmUUID=
                  imgUUID=ee9ab34c-47a8-4306-95d7-dd4318c69ef5
                  ancestor=9cdc96de-65b7-4187-8ec3-8190b78c1825
                  successor=8f595e80-1013-4c14-a2f5-252bce9526fdpostZero=False
                  discard=False (image:1240)</div>
                <div>2018-02-12 07:51:16,669+0100 ERROR (tasks/1)
                  [storage.TaskManager.Task]
                  (Task='1be430dc-eeb0-4dc9-92df-3f5b7943c6e0')
                  Unexpected error (task:875)</div>
                <div>Traceback (most recent call last):</div>
                <div>  File
                  "/usr/lib/python2.7/site-packages/vdsm/storage/task.py",
                  line 882, in _run</div>
                <div>    return fn(*args, **kargs)</div>
                <div>  File
                  "/usr/lib/python2.7/site-packages/vdsm/storage/task.py",
                  line 336, in run</div>
                <div>    return self.cmd(*self.argslist,
                  **self.argsdict)</div>
                <div>  File
                  "/usr/lib/python2.7/site-packages/vdsm/storage/securable.py",
                  line 79, in wrapper</div>
                <div>    return method(self, *args, **kwargs)</div>
                <div>  File
                  "/usr/lib/python2.7/site-packages/vdsm/storage/sp.py",
                  line 1853, in mergeSnapshots</div>
                <div>    discard)</div>
                <div>  File
                  "/usr/lib/python2.7/site-packages/vdsm/storage/image.py",
                  line 1251, in merge</div>
                <div>    srcVol = vols[successor]</div>
                <div>KeyError: u'8f595e80-1013-4c14-a2f5-252bce9526fd'</div>
              </div>
              <div><br>
              </div>
              <div>Ala, maybe you know if there is any known issue with
                mergeSnapshots?</div>
              <div>The usecase here are VMs from oVirt 3.5 which got
                registered to oVirt 4.2.</div>
              <div><br>
              </div>
              <div>Regards,</div>
              <div>Maor</div>
              <div><br>
              </div>
            </div>
            <div class="gmail_extra"><br>
              <div class="gmail_quote">On Wed, Feb 14, 2018 at 10:11 AM,
                Enrico Becchetti <span dir="ltr">&lt;<a
                    href="mailto:enrico.becchetti@pg.infn.it"
                    target="_blank" moz-do-not-send="true">enrico.becchetti@pg.infn.it</a>&gt;</span>
                wrote:<br>
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div text="#000000" bgcolor="#FFFFFF">   Hi,
                    <div class="m_8250037812935481317moz-cite-prefix">also
                      you can download them throught these<br>
                      links:<br>
                      <br>
                      <a
                        class="m_8250037812935481317moz-txt-link-freetext"
href="https://owncloud.pg.infn.it/index.php/s/QpsTyGxtRTPYRTD"
                        target="_blank" moz-do-not-send="true">https://owncloud.pg.infn.it/<wbr>index.php/s/QpsTyGxtRTPYRTD</a><br>
                    </div>
                    <a
                      class="m_8250037812935481317moz-txt-link-freetext"
href="https://owncloud.pg.infn.it/index.php/s/ph8pLcABe0nadeb"
                      target="_blank" moz-do-not-send="true">https://owncloud.pg.infn.it/<wbr>index.php/s/ph8pLcABe0nadeb</a><br>
                    <br>
                    Thanks again !!!!
                    <div>
                      <div class="h5"><br>
                        Best Regards<br>
                        Enrico<br>
                        <br>
                        <blockquote type="cite">
                          <div
                            class="m_8250037812935481317moz-cite-prefix">
                            Il 13/02/2018 14:52, Maor Lipchuk ha
                            scritto:<br>
                          </div>
                          <blockquote type="cite">
                            <div dir="ltr"><br>
                              <div class="gmail_extra"><br>
                                <div class="gmail_quote">On Tue, Feb 13,
                                  2018 at 3:51 PM, Maor Lipchuk <span
                                    dir="ltr">&lt;<a
                                      href="mailto:mlipchuk@redhat.com"
                                      target="_blank"
                                      moz-do-not-send="true">mlipchuk@redhat.com</a>&gt;</span>
                                  wrote:<br>
                                  <blockquote class="gmail_quote"
                                    style="margin:0 0 0
                                    .8ex;border-left:1px #ccc
                                    solid;padding-left:1ex">
                                    <div dir="ltr">
                                      <div class="gmail_extra"><br>
                                        <div class="gmail_quote"><span>On
                                            Tue, Feb 13, 2018 at 3:42
                                            PM, Enrico Becchetti <span
                                              dir="ltr">&lt;<a
                                                href="mailto:enrico.becchetti@pg.infn.it"
                                                target="_blank"
                                                moz-do-not-send="true">enrico.becchetti@pg.infn.it</a>&gt;</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 bgcolor="#FFFFFF">
                                                <div
class="m_8250037812935481317m_1867120190031562186gmail-m_-8783667902876592593moz-cite-prefix">see
                                                  the attach files
                                                  please ... thanks for
                                                  your attention !!!<br>
                                                </div>
                                              </div>
                                            </blockquote>
                                            <div class="gmail_quote"><br>
                                            </div>
                                            <div class="gmail_quote"><br>
                                            </div>
                                          </span>Seems like the engine
                                          logs does not contain the
                                          entire process, can you please
                                          share older logs since the
                                          import operation?</div>
                                      </div>
                                    </div>
                                  </blockquote>
                                  <div><br>
                                  </div>
                                  <div>And VDSM logs as well from your
                                    host</div>
                                  <div> </div>
                                  <blockquote class="gmail_quote"
                                    style="margin:0 0 0
                                    .8ex;border-left:1px #ccc
                                    solid;padding-left:1ex">
                                    <div dir="ltr">
                                      <div class="gmail_extra">
                                        <div class="gmail_quote">
                                          <div>
                                            <div
                                              class="m_8250037812935481317h5">
                                              <div> </div>
                                              <blockquote
                                                class="gmail_quote"
                                                style="margin:0px 0px
                                                0px
                                                0.8ex;border-left:1px
                                                solid
rgb(204,204,204);padding-left:1ex">
                                                <div bgcolor="#FFFFFF">
                                                  <div
class="m_8250037812935481317m_1867120190031562186gmail-m_-8783667902876592593moz-cite-prefix">
                                                    Best Regards<br>
                                                    Enrico
                                                    <div>
                                                      <div
                                                        class="m_8250037812935481317m_1867120190031562186gmail-h5"><br>
                                                        <br>
                                                        Il 13/02/2018
                                                        14:09, Maor
                                                        Lipchuk ha
                                                        scritto:<br>
                                                      </div>
                                                    </div>
                                                  </div>
                                                  <div>
                                                    <div
                                                      class="m_8250037812935481317m_1867120190031562186gmail-h5">
                                                      <blockquote
                                                        type="cite">
                                                        <div dir="ltr"><br>
                                                          <div
                                                          class="gmail_extra"><br>
                                                          <div
                                                          class="gmail_quote">On
                                                          Tue, Feb 13,
                                                          2018 at 1:48
                                                          PM, Enrico
                                                          Becchetti <span
                                                          dir="ltr">&lt;<a
href="mailto:enrico.becchetti@pg.infn.it" target="_blank"
                                                          moz-do-not-send="true">enrico.becchetti@pg.infn.it</a>&gt;</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"> Dear
                                                          All,<br>
                                                          I have been
                                                          using ovirt
                                                          for a long
                                                          time with
                                                          three
                                                          hypervisors
                                                          and an
                                                          external
                                                          engine running
                                                          in a centos vm
                                                          .<br>
                                                          <br>
                                                          This three
                                                          hypervisors
                                                          have HBAs and
                                                          access to
                                                          fiber channel
                                                          storage. Until
                                                          recently I
                                                          used version
                                                          3.5, then I
                                                          reinstalled
                                                          everything
                                                          from scratch
                                                          and now I have
                                                          4.2.<br>
                                                          <br>
                                                          Before
                                                          formatting
                                                          everything, I
                                                          detach the
                                                          storage data
                                                          domani (FC)
                                                          with the
                                                          virtual
                                                          machines and
                                                          reimported it
                                                          to the new 4.2
                                                          and all went
                                                          well. In<br>
                                                          this domain
                                                          there were
                                                          virtual
                                                          machines with
                                                          and without
                                                          snapshots.<br>
                                                          <br>
                                                          Now I have two
                                                          problems. The
                                                          first is that
                                                          if I try to
                                                          delete a
                                                          snapshot the
                                                          process is not
                                                          end successful
                                                          and remains
                                                          hanging and
                                                          the second
                                                          problem is
                                                          that<br>
                                                          in one case I
                                                          lost the
                                                          virtual
                                                          machine !!!<br>
                                                          </blockquote>
                                                          <div><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>Not sure
                                                          that I fully
                                                          understand the
                                                          scneario.'</div>
                                                          <div>How was
                                                          the virtual
                                                          machine got
                                                          lost if you
                                                          only tried to
                                                          delete a
                                                          snapshot?</div>
                                                          <div> </div>
                                                          <blockquote
                                                          class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid
                                                          rgb(204,204,204);padding-left:1ex">
                                                          <br>
                                                          So I need your
                                                          help to kill
                                                          the three
                                                          running zombie
                                                          tasks because
                                                          with
                                                          taskcleaner.sh
                                                          I can't do
                                                          anything and
                                                          then I need to
                                                          know how I can
                                                          delete the old
                                                          snapshots<br>
                                                          made with the
                                                          3.5 without
                                                          losing other
                                                          data or
                                                          without having
                                                          new processes
                                                          that terminate
                                                          correctly.<br>
                                                          <br>
                                                          If you want
                                                          some log files
                                                          please let me
                                                          know.<br>
                                                          </blockquote>
                                                          <div><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>Hi
                                                          Enrico,</div>
                                                          <div><br>
                                                          </div>
                                                          <div>Can you
                                                          please attach
                                                          the engine and
                                                          VDSM logs</div>
                                                          <div>  </div>
                                                          <blockquote
                                                          class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid
                                                          rgb(204,204,204);padding-left:1ex">
                                                          <br>
                                                          Thank you so
                                                          much.<br>
                                                          Best Regards<span
class="m_8250037812935481317m_1867120190031562186gmail-m_-8783667902876592593gmail-HOEnZb"><font
color="#888888"><br>
                                                          Enrico<br>
                                                          <br>
                                                          <br>
                                                          </font></span><br>
______________________________<wbr>_________________<br>
                                                          Users mailing
                                                          list<br>
                                                          <a
                                                          href="mailto:Users@ovirt.org"
target="_blank" moz-do-not-send="true">Users@ovirt.org</a><br>
                                                          <a
                                                          href="http://lists.ovirt.org/mailman/listinfo/users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
                                                          <br>
                                                          </blockquote>
                                                          </div>
                                                          <br>
                                                          </div>
                                                        </div>
                                                      </blockquote>
                                                      <p><br>
                                                      </p>
                                                    </div>
                                                  </div>
                                                  <span
                                                    class="m_8250037812935481317m_1867120190031562186gmail-HOEnZb"><font
                                                      color="#888888">
                                                      <pre class="m_8250037812935481317m_1867120190031562186gmail-m_-8783667902876592593moz-signature" cols="72">-- 
______________________________<wbr>______________________________<wbr>___________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:<a href="tel:+39%20075%20585%202777" value="+390755852777" target="_blank" moz-do-not-send="true">+39 075 5852777</a>             Mail: Enrico.Becchetti&lt;at&gt;<a href="http://pg.infn.it" target="_blank" moz-do-not-send="true">pg.infn.it</a>
______________________________<wbr>______________________________<wbr>__________ </pre>
                                                    </font></span></div>
                                              </blockquote>
                                            </div>
                                          </div>
                                        </div>
                                        <br>
                                      </div>
                                    </div>
                                  </blockquote>
                                </div>
                                <br>
                              </div>
                            </div>
                          </blockquote>
                          <p><br>
                          </p>
                          <pre class="m_8250037812935481317moz-signature" cols="72">-- 
______________________________<wbr>______________________________<wbr>___________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:<a href="tel:+39%20075%20585%202777" value="+390755852777" target="_blank" moz-do-not-send="true">+39 075 5852777</a>             Mail: Enrico.Becchetti&lt;at&gt;<a href="http://pg.infn.it" target="_blank" moz-do-not-send="true">pg.infn.it</a>
______________________________<wbr>______________________________<wbr>__________ </pre>
                        </blockquote>
                        <p><br>
                        </p>
                        <pre class="m_8250037812935481317moz-signature" cols="72">-- 
______________________________<wbr>______________________________<wbr>___________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:<a href="tel:+39%20075%20585%202777" value="+390755852777" target="_blank" moz-do-not-send="true">+39 075 5852777</a>             Mail: Enrico.Becchetti&lt;at&gt;<a href="http://pg.infn.it" target="_blank" moz-do-not-send="true">pg.infn.it</a>
______________________________<wbr>______________________________<wbr>__________ </pre>
                      </div>
                    </div>
                  </div>
                </blockquote>
              </div>
              <br>
            </div>
          </blockquote>
          <p><br>
          </p>
          <pre class="moz-signature" cols="72">-- 
_______________________________________________________________________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:+39 075 5852777             Mail: Enrico.Becchetti&lt;at&gt;pg.infn.it
______________________________________________________________________ </pre>
          <br>
          <fieldset class="mimeAttachmentHeader"></fieldset>
          <br>
          <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org" moz-do-not-send="true">Users@ovirt.org</a>
<a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users" moz-do-not-send="true">http://lists.ovirt.org/mailman/listinfo/users</a></pre>
        </blockquote>
        <p><br>
        </p>
        <pre class="moz-signature" cols="72">-- 
_______________________________________________________________________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:+39 075 5852777             Mail: Enrico.Becchetti&lt;at&gt;pg.infn.it
______________________________________________________________________ </pre>
        <br>
        <fieldset class="mimeAttachmentHeader"></fieldset>
        <br>
        <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org" moz-do-not-send="true">Users@ovirt.org</a>
<a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users" moz-do-not-send="true">http://lists.ovirt.org/mailman/listinfo/users</a>
</pre>
      </blockquote>
      <p><br>
      </p>
      <pre class="moz-signature" cols="72">-- 
_______________________________________________________________________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:+39 075 5852777             Mail: Enrico.Becchetti&lt;at&gt;pg.infn.it
______________________________________________________________________ </pre>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <p><br>
    </p>
    <pre class="moz-signature" cols="72">-- 
_______________________________________________________________________

Enrico Becchetti                    Servizio di Calcolo e Reti

Istituto Nazionale di Fisica Nucleare - Sezione di Perugia
Via Pascoli,c/o Dipartimento di Fisica  06123 Perugia (ITALY)
Phone:+39 075 5852777             Mail: Enrico.Becchetti&lt;at&gt;pg.infn.it
______________________________________________________________________ </pre>
  </body>
</html>