7:32 a.m.
This is a multi-part message in MIME format.
--------------070801070108060704090604
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Could anybody tell me if I can just delete these entries without
generating further problems?
Thanks for any hint,
Arsène
On 10/08/2015 05:49 PM, Arsène Gschwind wrote:
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> 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> 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> 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> 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
>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users(a)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
>
>
--------------070801070108060704090604
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">
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"><<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>></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"
class="moz-txt-link-abbreviated"
href="mailto:arsene.gschwind@unibas.ch">arsene.gschwind@unibas.ch</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"
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>></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" 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>></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://...
</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://...
</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>
</blockquote>
<br>
</body>
</html>
--------------070801070108060704090604--