------=_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@skynet.it> To: users@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@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" <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> ------=_Part_8388310_982752601.1369673267648--