This is a multi-part message in MIME format.
--------------020902080600020205010404
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Yes they are in this table:engine=# select command_type, entity_type
from business_entity_snapshot;
command_type | entity_type
-------------------------------------------------+--------------------------------------------------------
org.ovirt.engine.core.bll.RemoveSnapshotCommand |
org.ovirt.engine.core.common.businessentities.Snapshot
org.ovirt.engine.core.bll.RemoveSnapshotCommand |
org.ovirt.engine.core.common.businessentities.Snapshot
org.ovirt.engine.core.bll.RemoveSnapshotCommand |
org.ovirt.engine.core.common.businessentities.Snapshot
org.ovirt.engine.core.bll.RemoveSnapshotCommand |
org.ovirt.engine.core.common.businessentities.Snapshot
(4 rows)
engine=#
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.
Could I just remove these entries?
Thanks for your help,
Arsène
On 10/08/2015 04:48 PM, Simone Tiraboschi wrote:
On Thu, Oct 8, 2015 at 12:49 PM, Arsène Gschwind
<arsene.gschwind(a)unibas.ch <mailto:arsene.gschwind@unibas.ch>> wrote:
Did restart the service and tried to udate again but still the
same problem.
Are there some entries in the DB somewhere?
These are compensations so they should be in that table, please try
executing this query:
select command_type, entity_type from business_entity_snapshot
to check if they are there.
You could use /usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh
utility to cleanup there.
Thanks,
Arsène
On 10/08/2015 12:33 PM, Raz Tamir wrote:
> As part of the update process, the ovirt-engine service will restart.
> Can you try restart it manually with 'service ovirt-engine
> restart' and try the update again?
>
>
>
> Thanks,
> Raz Tamir
> Red Hat Israel
>
> On Thu, Oct 8, 2015 at 1:27 PM, Arsène Gschwind
> <arsene.gschwind(a)unibas.ch <mailto:arsene.gschwind@unibas.ch>>
wrote:
>
> The update still fails with the same problems.
> Running that command on the spm host returns nothing.
>
> Thanks,
> Arsène
>
>
> On 10/08/2015 12:08 PM, Raz Tamir wrote:
>> Ok, so try to update again, and if you fail, please run
>> 'vdsClient -s 0 getAllTasks' from your spm host and provide
>> the output
>>
>>
>>
>> Thanks,
>> Raz Tamir
>> Red Hat Israel
>>
>> On Thu, Oct 8, 2015 at 12:55 PM, Arsène Gschwind
>> <arsene.gschwind(a)unibas.ch
>> <mailto:arsene.gschwind@unibas.ch>> wrote:
>>
>> Hi Raz,
>>
>> The table is empty:
>>
>> engine=# select * from async_tasks;
>> task_id | action_type | status | result | step_id |
>> command_id | started_at | storage_pool_id | task_type |
>> vdsm_task_id | root_comm
>> and_id | user_id
>>
---------+-------------+--------+--------+---------+------------+------------+-----------------+-----------+--------------+----------
>> -------+---------
>> (0 rows)
>>
>> Thanks for your help,
>> Arsène
>>
>>
>>
>> On 10/07/2015 08:59 PM, Raz Tamir wrote:
>>> Hi Arsène,
>>> From the engine run the following commands:
>>> 1. # su - postgres
>>> 2. # psql -d engine
>>> 3. please, provide the output of this command:
>>> # select * from async_tasks ;
>>>
>>>
>>>
>>> Thanks,
>>> Raz Tamir
>>> Red Hat Israel
>>>
>>> On Wed, Oct 7, 2015 at 6:34 PM, Arsène Gschwind
>>> <arsene.gschwind(a)unibas.ch
>>> <mailto:arsene.gschwind@unibas.ch>> wrote:
>>>
>>> Any idea how to get ride of those tasks?
>>>
>>> Thanks a lot
>>> Arsène
>>>
>>>
>>> On 10/06/2015 02:43 PM, Arsène Gschwind wrote:
>>>
>>> Hi,
>>>
>>> I would like to update ovirt to 3.5.4 from
>>> 3.5.3 but engine-setup fails due to remove
>>> snapshot tasks.
>>>
>>> [ INFO ] Cleaning async tasks and compensations
>>> The following system tasks have been
>>> found running in the system:
>>> The following commands have been
>>> found running in the system:
>>> The following compensations have been
>>> found running in the system:
>>> org.ovirt.engine.core.bll.RemoveSnapshotCommand
>>> org.ovirt.engine.core.common.businessentities.Snapshot
>>> org.ovirt.engine.core.bll.RemoveSnapshotCommand
>>> org.ovirt.engine.core.common.businessentities.Snapshot
>>> org.ovirt.engine.core.bll.RemoveSnapshotCommand
>>> org.ovirt.engine.core.common.businessentities.Snapshot
>>> org.ovirt.engine.core.bll.RemoveSnapshotCommand
>>> org.ovirt.engine.core.common.businessentities.Snapshot
>>> Would you like to try to wait for that?
>>>
>>> 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.
>>>
>>> Thanks for any hint/help
>>>
>>> rgds, Arsène
>>> _______________________________________________
>>> Users mailing list
>>> Users(a)ovirt.org <mailto:Users@ovirt.org>
>>>
http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users(a)ovirt.org <mailto:Users@ovirt.org>
>>>
http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>>
>
>
_______________________________________________
Users mailing list
Users(a)ovirt.org <mailto:Users@ovirt.org>
http://lists.ovirt.org/mailman/listinfo/users
--------------020902080600020205010404
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit
<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://...
</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://...
</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/user...
<br>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>
--------------020902080600020205010404--