7:47 p.m.
------=_Part_8388310_982752601.1369673267648
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Please provide select * from vds_spm_id_map
select task_id,action_type from async_tasks;
select id,command_id,command_type from business_entity_snapshot;
Thanks.
----- Original Message -----
From: "Alessandro Bianchi" <a.bianchi(a)skynet.it>
To: users(a)ovirt.org
Sent: Monday, May 27, 2013 7:26:39 PM
Subject: [Users] engine-upgrade detect erroneous running tasks
Hi all
I tried to run engine-upgrade on Fedora 18 but upgrade hangs stating
for
fictious tasks as follows:
2013-05-27 18:12:45::DEBUG::common_utils::434::root:: Executing
command -->
'/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c select
command_type, entity_type from business_entity_snapshot;'
2013-05-27 18:12:45::DEBUG::common_utils::472::root:: output = command_type |
entity_type
--------------+-------------
(0 righe)
2013-05-27 18:12:45::DEBUG::common_utils::473::root:: stderr =
2013-05-27 18:12:45::DEBUG::common_utils::474::root:: retcode = 0
2013-05-27 18:12:45::DEBUG::engine-upgrade::863::root:: Still waiting for
system tasks to be cleared.
2013-05-27 18:12:45::DEBUG::common_utils::994::root:: asking user:
Info: The following tasks have been found running in the system:
System Tasks:
command_type | entity_type
--------------+-------------
(0 righe) <----- this means 0 rows (system uses italian language)
[ May 27 18:12:45 ] Would you like to proceed and try to stop tasks
automatically?
(Answering 'no' will stop the upgrade)? (yes|no):
2013-05-27 18:13:05::DEBUG::common_utils::998::root:: user answered: yes
2013-05-27 18:13:05::DEBUG::engine-upgrade::882::root:: Retrying to clear
system tasks. System will try to clear tasks during the next 3 minutes.
2013-05-27 18:16:05::DEBUG::common_utils::481::root:: running sql
query
'select * from fn_db_get_async_tasks();' on db server: 'localhost'.
2013-05-27 18:16:05::DEBUG::common_utils::434::root:: Executing command -->
'/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c select * from
fn_db_get_async_tasks();'
2013-05-27 18:16:05::DEBUG::common_utils::472::root:: output = dc_id |
dc_name | spm_host_id | spm_host_name | task_count
--------------------------------------+---------+-------------+---------------+------------
0b6c934f-de25-4de6-b389-cf62b7a9f674 | | | | 1
(1 riga)
2013-05-27 18:16:05::DEBUG::common_utils::473::root:: stderr =
2013-05-27 18:16:05::DEBUG::common_utils::474::root:: retcode = 0
2013-05-27 18:16:05::DEBUG::common_utils::481::root:: running sql query
'select command_type, entity_type from business_entity_snapshot;' on db
server: 'localhost'.
2013-05-27 18:16:05::DEBUG::common_utils::434::root:: Executing command -->
'/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c select
command_type, entity_type from business_entity_snapshot;'
2013-05-27 18:16:05::DEBUG::common_utils::472::root:: output = command_type |
entity_type
--------------+-------------
(0 righe)
Here is the relevamt rpm list:
ovirt-engine-tools-3.2.1-1.fc18.noarch
ovirt-engine-3.2.1-1.fc18.noarch
ovirt-log-collector-3.2.2-1.fc18.noarch
ovirt-engine-dbscripts-3.2.1-1.fc18.noarch
ovirt-engine-sdk-3.2.0.11-1.fc18.noarch
ovirt-engine-setup-plugin-allinone-3.2.2-1.1.fc18.noarch
ovirt-release-fedora-5-3.noarch
ovirt-engine-userportal-3.2.1-1.fc18.noarch
ovirt-engine-restapi-3.2.1-1.fc18.noarch
ovirt-iso-uploader-3.2.2-1.fc18.noarch
ovirt-engine-webadmin-portal-3.2.1-1.fc18.noarch
ovirt-host-deploy-1.0.2-1.fc18.noarch
ovirt-engine-backend-3.2.1-1.fc18.noarch
ovirt-engine-cli-3.2.0.12-1.fc18.noarch
ovirt-host-deploy-offline-1.0.2-1.fc18.noarch
ovirt-image-uploader-3.2.2-1.fc18.noarch
ovirt-engine-genericapi-3.2.1-1.fc18.noarch
ovirt-engine-setup-3.2.2-1.1.fc18.noarch
ovirt-host-deploy-java-1.0.2-1.fc18.noarch
How may I skip/fix this control to let upgrade proceed?
Is there someone else experimenting this "0 rows"
detection?
Any advice is higly welcome!
Thank you
Best regards
Alessandro Bianchi
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
------=_Part_8388310_982752601.1369673267648
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<html><body><div style="font-family: times new roman, new york, times,
serif; font-size: 12pt; color: #000000"><div>Please provide select * from
vds_spm_id_map</div><div><br></div><div>select
task_id,action_type from
async_tasks;</div><div><br></div><div>select
id,command_id,command_type from
business_entity_snapshot;</div><div><br></div><div>Thanks.</div><div><br></div><div><br></div><hr
id="zwchr"><blockquote style="border-left:2px solid
#1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From:
</b>"Alessandro Bianchi"
&lt;a.bianchi(a)skynet.it&gt;<br><b>To:
</b>users(a)ovirt.org<br><b>Sent: </b>Monday, May 27, 2013 7:26:39
PM<br><b>Subject: </b>[Users] engine-upgrade detect erroneous running
tasks<br><div><br></div>
<div id="QCMcontainer"
style="font-family:sans-serif;font-size:16px;">Hi all<br>
<br>
I tried to run engine-upgrade on Fedora 18 but upgrade hangs
stating for fictious tasks as follows:<br>
<br>
2013-05-27 18:12:45::DEBUG::common_utils::434::root:: Executing
command --> '/usr/bin/psql -h localhost -p 5432 -U engine -d
engine -c select command_type, entity_type from
business_entity_snapshot;'<br>
2013-05-27 18:12:45::DEBUG::common_utils::472::root:: output =
command_type | entity_type <br>
--------------+-------------<br>
(0 righe)<br>
<br>
<br>
2013-05-27 18:12:45::DEBUG::common_utils::473::root:: stderr = <br>
2013-05-27 18:12:45::DEBUG::common_utils::474::root:: retcode = 0<br>
2013-05-27 18:12:45::DEBUG::engine-upgrade::863::root:: Still
waiting for system tasks to be cleared.<br>
2013-05-27 18:12:45::DEBUG::common_utils::994::root:: asking user:
<br>
Info: The following tasks have been found running in the system: <br>
<br>
<b>System Tasks:</b><b><br>
</b><b><br>
</b><b> command_type | entity_type
</b><b><br>
</b><b>--------------+-------------</b><b><br>
</b><b>(0 righe)</b> <----- this means 0 rows (system uses
italian language)<br>
<br>
<br>
<br>
<br>
[ May 27 18:12:45 ] Would you like to proceed and try to stop
tasks automatically?<br>
(Answering 'no' will stop the upgrade)? (yes|no): <br>
2013-05-27 18:13:05::DEBUG::common_utils::998::root:: user
answered: yes<br>
2013-05-27 18:13:05::DEBUG::engine-upgrade::882::root:: Retrying
to clear system tasks. System will try to clear tasks during the
next 3 minutes.<br>
<br>
2013-05-27 18:16:05::DEBUG::common_utils::481::root:: running sql
query 'select * from fn_db_get_async_tasks();' on db server:
'localhost'.<br>
2013-05-27 18:16:05::DEBUG::common_utils::434::root:: Executing
command --> '/usr/bin/psql -h localhost -p 5432 -U engine -d
engine -c select * from fn_db_get_async_tasks();'<br>
2013-05-27 18:16:05::DEBUG::common_utils::472::root:: output
=
dc_id
| dc_name | spm_host_id |
spm_host_name | task_count <br>
--------------------------------------+---------+-------------+---------------+------------<br>
0b6c934f-de25-4de6-b389-cf62b7a9f674
|
|
|
|
1<br>
(1 riga)<br>
<br>
<br>
2013-05-27 18:16:05::DEBUG::common_utils::473::root:: stderr = <br>
2013-05-27 18:16:05::DEBUG::common_utils::474::root:: retcode = 0<br>
2013-05-27 18:16:05::DEBUG::common_utils::481::root:: running sql
query 'select command_type, entity_type from
business_entity_snapshot;' on db server: 'localhost'.<br>
2013-05-27 18:16:05::DEBUG::common_utils::434::root:: Executing
command --> '/usr/bin/psql -h localhost -p 5432 -U engine -d
engine -c select command_type, entity_type from
business_entity_snapshot;'<br>
2013-05-27 18:16:05::DEBUG::common_utils::472::root:: output =
command_type | entity_type <br>
--------------+-------------<br>
<b>(0 righe)</b><br>
<br>
Here is the relevamt rpm list:<br>
<br>
ovirt-engine-tools-3.2.1-1.fc18.noarch<br>
ovirt-engine-3.2.1-1.fc18.noarch<br>
ovirt-log-collector-3.2.2-1.fc18.noarch<br>
ovirt-engine-dbscripts-3.2.1-1.fc18.noarch<br>
ovirt-engine-sdk-3.2.0.11-1.fc18.noarch<br>
ovirt-engine-setup-plugin-allinone-3.2.2-1.1.fc18.noarch<br>
ovirt-release-fedora-5-3.noarch<br>
ovirt-engine-userportal-3.2.1-1.fc18.noarch<br>
ovirt-engine-restapi-3.2.1-1.fc18.noarch<br>
ovirt-iso-uploader-3.2.2-1.fc18.noarch<br>
ovirt-engine-webadmin-portal-3.2.1-1.fc18.noarch<br>
ovirt-host-deploy-1.0.2-1.fc18.noarch<br>
ovirt-engine-backend-3.2.1-1.fc18.noarch<br>
ovirt-engine-cli-3.2.0.12-1.fc18.noarch<br>
ovirt-host-deploy-offline-1.0.2-1.fc18.noarch<br>
ovirt-image-uploader-3.2.2-1.fc18.noarch<br>
ovirt-engine-genericapi-3.2.1-1.fc18.noarch<br>
ovirt-engine-setup-3.2.2-1.1.fc18.noarch<br>
ovirt-host-deploy-java-1.0.2-1.fc18.noarch<br>
<br>
<br>
How may I skip/fix this control to let upgrade proceed?<br>
<br>
Is there someone else experimenting this "0 rows"
detection?<br>
<br>
Any advice is higly welcome!<br>
<br>
Thank you<br>
<br>
Best regards<br>
<br>
Alessandro Bianchi<br>
<br>
</div>
<br>_______________________________________________<br>Users mailing
list<br>Users@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br></blockquote><div><br></div></div></body></html>
------=_Part_8388310_982752601.1369673267648--