<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" <a.bianchi@skynet.it><br><b>To: </b>users@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>