<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body style="font-family: sans-serif; font-size: 16px;" text="#000000"
bgcolor="#FFFFFF">
<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>
</body>
</html>