<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Could anybody tell me if I can just delete these entries without
    generating further problems?<br>
    <br>
    Thanks for any hint,<br>
    Arsène<br>
    <br>
    <div class="moz-cite-prefix">On 10/08/2015 05:49 PM, Arsène Gschwind
      wrote:<br>
    </div>
    <blockquote cite="mid:5616909F.1050908@unibas.ch" type="cite">
      <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
      Yes they are in this table:engine=# select command_type,
      entity_type from business_entity_snapshot;<br>
                        command_type                  
      |                      entity_type                       <br>
-------------------------------------------------+--------------------------------------------------------<br>
       org.ovirt.engine.core.bll.RemoveSnapshotCommand |
      org.ovirt.engine.core.common.businessentities.Snapshot<br>
       org.ovirt.engine.core.bll.RemoveSnapshotCommand |
      org.ovirt.engine.core.common.businessentities.Snapshot<br>
       org.ovirt.engine.core.bll.RemoveSnapshotCommand |
      org.ovirt.engine.core.common.businessentities.Snapshot<br>
       org.ovirt.engine.core.bll.RemoveSnapshotCommand |
      org.ovirt.engine.core.common.businessentities.Snapshot<br>
      (4 rows)<br>
      <br>
      engine=# <br>
      <br>
      The doc says that taskcleaner.sh should be called by ovirt-setup,
      I can see it in the log, it is called but it doesn't clean that
      compensations. <br>
      Could I just remove these entries?<br>
      <br>
      Thanks for your help,<br>
      Arsène<br>
      <br>
      <br>
      <div class="moz-cite-prefix">On 10/08/2015 04:48 PM, Simone
        Tiraboschi wrote:<br>
      </div>
      <blockquote
cite="mid:CAN8-ONoqZ10LrOFyv4Vm8HV=fy=U-8bVXZFZ2pwzaED9jtUQkg@mail.gmail.com"
        type="cite">
        <meta http-equiv="Content-Type" content="text/html;
          charset=utf-8">
        <div dir="ltr"><br>
          <div class="gmail_extra"><br>
            <div class="gmail_quote">On Thu, Oct 8, 2015 at 12:49 PM,
              Arsène Gschwind <span dir="ltr">&lt;<a
                  moz-do-not-send="true"
                  class="moz-txt-link-abbreviated"
                  href="mailto:arsene.gschwind@unibas.ch"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>&gt;</span>
              wrote:<br>
              <blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                <div text="#000000" bgcolor="#FFFFFF"> Did restart the
                  service and tried to udate again but still the same
                  problem.<br>
                  Are there some entries in the DB somewhere?<br>
                </div>
              </blockquote>
              <div><br>
              </div>
              These are compensations so they should be in that table,
              please try executing this query:<br>
                  select command_type, entity_type from
              business_entity_snapshot<br>
              to check if they are there.<br>
              <br>
              You could use
              /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh
              utility to cleanup there.<br>
               <br>
              <blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                <div text="#000000" bgcolor="#FFFFFF"> Thanks,<br>
                  Arsène
                  <div>
                    <div class="h5"><br>
                      <br>
                      <div>On 10/08/2015 12:33 PM, Raz Tamir wrote:<br>
                      </div>
                      <blockquote type="cite">
                        <div dir="ltr">
                          <div style="font-size:small;color:rgb(0,0,0)"><font
                              face="arial, helvetica, sans-serif">As
                              part of the update process, the
                              ovirt-engine service will restart.</font></div>
                          <div style="font-size:small;color:rgb(0,0,0)"><font
                              face="arial, helvetica, sans-serif">Can
                              you try restart it manually with 'service
                              ovirt-engine restart' and try the update
                              again?</font></div>
                          <div class="gmail_extra"><br clear="all">
                            <div>
                              <div>
                                <div dir="ltr">
                                  <div>
                                    <div dir="ltr">
                                      <div>
                                        <div dir="ltr">
                                          <div>
                                            <div dir="ltr">
                                              <div>
                                                <div dir="ltr"><font
                                                    face="times new
                                                    roman, serif"
                                                    size="4"><br>
                                                  </font></div>
                                                <div dir="ltr"><font
                                                    face="arial,
                                                    helvetica,
                                                    sans-serif" size="2"
                                                    color="#000000"><br>
                                                  </font></div>
                                                <div dir="ltr"><font
                                                    face="arial,
                                                    helvetica,
                                                    sans-serif" size="2"
                                                    color="#000000">Thanks,</font>
                                                  <div><font
                                                      face="arial,
                                                      helvetica,
                                                      sans-serif"
                                                      size="2"
                                                      color="#000000">Raz

                                                      Tamir</font></div>
                                                  <div><font
                                                      face="arial,
                                                      helvetica,
                                                      sans-serif"
                                                      size="2"
                                                      color="#000000">Red

                                                      Hat Israel</font></div>
                                                </div>
                                              </div>
                                            </div>
                                          </div>
                                        </div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                            <br>
                            <div class="gmail_quote">On Thu, Oct 8, 2015
                              at 1:27 PM, Arsène Gschwind <span
                                dir="ltr">&lt;<a moz-do-not-send="true"
                                  class="moz-txt-link-abbreviated"
                                  href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a>&gt;</span>
                              wrote:<br>
                              <blockquote class="gmail_quote"
                                style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                                <div text="#000000" bgcolor="#FFFFFF">
                                  The update still fails with the same
                                  problems.<br>
                                  Running that command on the spm host
                                  returns nothing.<br>
                                  <br>
                                  Thanks,<br>
                                  Arsène
                                  <div>
                                    <div><br>
                                      <br>
                                      <div>On 10/08/2015 12:08 PM, Raz
                                        Tamir wrote:<br>
                                      </div>
                                      <blockquote type="cite">
                                        <div dir="ltr">
                                          <div style="font-family:'times
                                            new
                                            roman',serif;font-size:large">Ok,

                                            so try to update again, and
                                            if you fail, please run
                                            'vdsClient -s 0 getAllTasks'
                                            from your spm host and
                                            provide the output</div>
                                        </div>
                                        <div class="gmail_extra"><br
                                            clear="all">
                                          <div>
                                            <div>
                                              <div dir="ltr">
                                                <div>
                                                  <div dir="ltr">
                                                    <div>
                                                      <div dir="ltr">
                                                        <div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          </font></div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          </font></div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Thanks,</font>
                                                          <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Raz
                                                          Tamir</font></div>
                                                          <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Red
                                                          Hat Israel</font></div>
                                                          </div>
                                                        </div>
                                                      </div>
                                                    </div>
                                                  </div>
                                                </div>
                                              </div>
                                            </div>
                                          </div>
                                          <br>
                                          <div class="gmail_quote">On
                                            Thu, Oct 8, 2015 at 12:55
                                            PM, Arsène Gschwind <span
                                              dir="ltr">&lt;<a
                                                moz-do-not-send="true"
                                                class="moz-txt-link-abbreviated"
href="mailto:arsene.gschwind@unibas.ch"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>&gt;</span>
                                            wrote:<br>
                                            <blockquote
                                              class="gmail_quote"
                                              style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
                                              <div text="#000000"
                                                bgcolor="#FFFFFF"> Hi
                                                Raz,<br>
                                                <br>
                                                The table is empty:<br>
                                                <br>
                                                engine=# select * from
                                                async_tasks;<br>
                                                 task_id | action_type |
                                                status | result |
                                                step_id | command_id |
                                                started_at |
                                                storage_pool_id |
                                                task_type | vdsm_task_id
                                                | root_comm<br>
                                                and_id | user_id <br>
---------+-------------+--------+--------+---------+------------+------------+-----------------+-----------+--------------+----------<br>
                                                -------+---------<br>
                                                (0 rows)<br>
                                                <br>
                                                Thanks for your help,<br>
                                                Arsène
                                                <div>
                                                  <div><br>
                                                    <br>
                                                    <br>
                                                    <div>On 10/07/2015
                                                      08:59 PM, Raz
                                                      Tamir wrote:<br>
                                                    </div>
                                                    <blockquote
                                                      type="cite">
                                                      <div dir="ltr">
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Hi <span
style="color:rgb(51,51,51);line-height:20px">Arsène,</span><br>
                                                          </font></div>
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><span
style="color:rgb(51,51,51);line-height:20px">From the engine run the
                                                          following
                                                          commands:</span></font></div>
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"
                                                          color="#333333"><span
style="line-height:20px">1. # su - postgres</span></font></div>
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"
                                                          color="#333333"><span
style="line-height:20px">2. # psql -d engine</span></font></div>
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"
                                                          color="#333333"><span
style="line-height:20px">3. please, provide the output of this command:</span></font></div>
                                                        <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"
                                                          color="#333333"><span
style="line-height:20px">    # select * from async_tasks ;</span></font></div>
                                                        <div
                                                          class="gmail_extra"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br
                                                          clear="all">
                                                          </font>
                                                          <div>
                                                          <div>
                                                          <div dir="ltr">
                                                          <div>
                                                          <div dir="ltr">
                                                          <div>
                                                          <div dir="ltr">
                                                          <div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          </font></div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          </font></div>
                                                          <div dir="ltr"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Thanks,</font>
                                                          <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Raz
                                                          Tamir</font></div>
                                                          <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Red
                                                          Hat Israel</font></div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          <font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          </font>
                                                          <div
                                                          class="gmail_quote"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">On
                                                          Wed, Oct 7,
                                                          2015 at 6:34
                                                          PM, Arsène
                                                          Gschwind <span
                                                          dir="ltr">&lt;<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
                                                          href="mailto:arsene.gschwind@unibas.ch"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>&gt;</span>
                                                          wrote:<br>
                                                          </font>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px

                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4">Any
                                                          idea how to
                                                          get ride of
                                                          those tasks?<br>
                                                          <br>
                                                          Thanks a lot<span><font
color="#888888"><br>
                                                          Arsène</font></span></font>
                                                          <div>
                                                          <div><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
                                                          <br>
                                                          On 10/06/2015
                                                          02:43 PM,
                                                          Arsène
                                                          Gschwind
                                                          wrote:<br>
                                                          </font>
                                                          <blockquote
                                                          class="gmail_quote"
                                                          style="margin:0px

                                                          0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"> Hi,<br>
                                                          <br>
                                                          I would like
                                                          to update
                                                          ovirt to 3.5.4
                                                          from 3.5.3 but
                                                          engine-setup
                                                          fails due to
                                                          remove
                                                          snapshot
                                                          tasks.<br>
                                                          <br>
                                                          [ INFO  ]
                                                          Cleaning async
                                                          tasks and
                                                          compensations<br>
                                                                    The
                                                          following
                                                          system tasks
                                                          have been
                                                          found running
                                                          in the system:<br>
                                                                    The
                                                          following
                                                          commands have
                                                          been found
                                                          running in the
                                                          system:<br>
                                                                    The
                                                          following
                                                          compensations
                                                          have been
                                                          found running
                                                          in the system:<br>
                                                                   
                                                          org.ovirt.engine.core.bll.RemoveSnapshotCommand
org.ovirt.engine.core.common.businessentities.Snapshot<br>
                                                                   
                                                          org.ovirt.engine.core.bll.RemoveSnapshotCommand
org.ovirt.engine.core.common.businessentities.Snapshot<br>
                                                                   
                                                          org.ovirt.engine.core.bll.RemoveSnapshotCommand
org.ovirt.engine.core.common.businessentities.Snapshot<br>
                                                                   
                                                          org.ovirt.engine.core.bll.RemoveSnapshotCommand
org.ovirt.engine.core.common.businessentities.Snapshot<br>
                                                                   
                                                          Would you like
                                                          to try to wait
                                                          for that?<br>
                                                          <br>
                                                          This tasks are
                                                          not showing up
                                                          in the task
                                                          monitor and I
                                                          have no idea
                                                          how to get
                                                          them away to
                                                          be abl to
                                                          update.<br>
                                                          <br>
                                                          Thanks for any
                                                          hint/help<br>
                                                          <br>
                                                          rgds, Arsène<br>
_______________________________________________<br>
                                                          Users mailing
                                                          list<br>
                                                          <a
                                                          moz-do-not-send="true"
class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org"><a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a></a><br>
                                                          <a
                                                          moz-do-not-send="true"
class="moz-txt-link-freetext"
                                                          href="http://lists.ovirt.org/mailman/listinfo/users"><a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a></a><br>
                                                          </font></blockquote>
                                                          <font
                                                          face="times
                                                          new roman,
                                                          serif"
                                                          size="4"><br>
_______________________________________________<br>
                                                          Users mailing
                                                          list<br>
                                                          <a
                                                          moz-do-not-send="true"
class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org"><a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a></a><br>
                                                          <a
                                                          moz-do-not-send="true"
class="moz-txt-link-freetext"
                                                          href="http://lists.ovirt.org/mailman/listinfo/users"><a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a></a><br>
                                                          </font></div>
                                                          </div>
                                                          </blockquote>
                                                          </div>
                                                          <br>
                                                        </div>
                                                      </div>
                                                    </blockquote>
                                                    <br>
                                                  </div>
                                                </div>
                                              </div>
                                            </blockquote>
                                          </div>
                                          <br>
                                        </div>
                                      </blockquote>
                                      <br>
                                    </div>
                                  </div>
                                </div>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                        </div>
                      </blockquote>
                      <br>
                    </div>
                  </div>
                </div>
                <br>
                _______________________________________________<br>
                Users mailing list<br>
                <a moz-do-not-send="true" href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
                <a moz-do-not-send="true"
                  href="http://lists.ovirt.org/mailman/listinfo/users"
                  rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
                <br>
              </blockquote>
            </div>
            <br>
          </div>
        </div>
      </blockquote>
      <br>
    </blockquote>
    <br>
  </body>
</html>