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@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@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@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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@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://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> --------------070801070108060704090604--