<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <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">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>