<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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"><<a
moz-do-not-send="true"
href="mailto:arsene.gschwind@unibas.ch" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>></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"><<a
moz-do-not-send="true"
href="mailto:arsene.gschwind@unibas.ch"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>></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"><<a
moz-do-not-send="true"
href="mailto:arsene.gschwind@unibas.ch"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>></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"><<a
moz-do-not-send="true" href="mailto:arsene.gschwind@unibas.ch"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</a></a>></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"
href="mailto:Users@ovirt.org" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a></a><br>
<a
moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank"><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"
href="mailto:Users@ovirt.org" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a></a><br>
<a
moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank"><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>
</body>
</html>