[Users] engine-upgrade detect erroneous running tasks
------=_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--
This is a multi-part message in MIME format. --------------000609000404010806070008 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Il 27/05/2013 18:47, Yair Zaslavsky ha scritto:
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.
------------------------------------------------------------------------
*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
Thank you for your answer Here are the results: select * from vds_spm_id_map; storage_pool_id | vds_spm_id | vds_id --------------------------------------+------------+-------------------------------------- 5849b030-626e-47cb-ad90-3ce782d831b3 | 1 | 3156bdac-ebfb-44cf-bea6-53d668b74a10 3935800a-abe4-406d-84a1-4c3c0b915cce | 1 | 7cd40aed-b3b7-4e3f-85ab-a1e1d9445ea9 7562ee83-4c7f-4df8-81a5-f638db6be67c | 1 | a7e039b5-71b7-42a9-8a23-09fa2fe818f8 6d565c6e-ce4c-46c6-98ab-a219e2fc3b20 | 1 | e4574226-c5db-4f7c-8b16-93d3b9170f01 5849b030-626e-47cb-ad90-3ce782d831b3 | 2 | df401b12-17b5-46fb-988f-c11937cca4f6 (5 righe) select task_id,action_type from async_tasks; task_id | action_type --------------------------------------+------------- 993bea98-b89b-4054-a212-ee4a429f7173 | 36 <--- this one is from a dead "local cluster" phisycally (I mean hardware) removed I cant' remove from ovirt ( I suppose ) because it says "one host in cluster" and I can't switch it to maintenance and remove since it is *not present* anymore (1 riga) select id,command_id,command_type from business_entity_snapshot; id | command_id | command_type ----+------------+-------------- (0 righe) So i did delete from async_tasks where task_id = '993bea98-b89b-4054-a212-ee4a429f7173'; DELETE 1 and tried again but unfortunately: System Tasks: command_type | entity_type --------------+------------- (0 righe) [ May 27 21:19:16 ] Would you like to proceed and try to stop tasks automatically? (Answering 'no' will stop the upgrade)? (yes|no): yes [ May 27 21:19:28 ] System will try to clear tasks during the next 3 minutes And everything loops again Here is the log 2013-05-27 21:22:30::DEBUG::common_utils::473::root:: stderr = 2013-05-27 21:22:30::DEBUG::common_utils::474::root:: retcode = 0 2013-05-27 21:22:30::DEBUG::common_utils::481::root:: running sql query 'select command_type, entity_type from business_entity_snapshot;' on db server: 'localhost'. 2013-05-27 21:22:30::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 21:22:30::DEBUG::common_utils::472::root:: output = command_type | entity_type --------------+------------- (0 righe) 2013-05-27 21:22:30::DEBUG::common_utils::473::root:: stderr = 2013-05-27 21:22:30::DEBUG::common_utils::474::root:: retcode = 0 2013-05-27 21:22:30::DEBUG::engine-upgrade::863::root:: Still waiting for system tasks to be cleared. 2013-05-27 21:22:30::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) [ May 27 21:22:30 ] Would you like to proceed and try to stop tasks automatically? (Answering 'no' will stop the upgrade)? (yes|no): 2013-05-27 21:24:16::DEBUG::common_utils::998::root:: user answered: no <--- here I aborted at second request 2013-05-27 21:24:16::ERROR::engine-upgrade::887::root:: Traceback (most recent call last): File "/usr/bin/engine-upgrade", line 880, in checkRunningTasks raise Exception(MSG_TASKS_STILL_RUNNING % RUNNING_TASKS_MSG) Exception: There are still running tasks: Thank you Alessandro Bianchi -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it <http://www.skynet.it/> Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare info@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 --------------000609000404010806070008 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 bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Il 27/05/2013 18:47, Yair Zaslavsky ha scritto:<br> </div> <blockquote cite="mid:826235930.8388311.1369673267649.JavaMail.root@redhat.com" type="cite"> <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 class="moz-txt-link-rfc2396E" href="mailto:a.bianchi@skynet.it"><a.bianchi@skynet.it></a><br> <b>To: </b><a class="moz-txt-link-abbreviated" href="mailto:users@ovirt.org">users@ovirt.org</a><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> <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a><br> </blockquote> <br> </div> </blockquote> Thank you for your answer<br> <br> Here are the results:<br> <br> select * from vds_spm_id_map;<br> storage_pool_id | vds_spm_id | vds_id <br> --------------------------------------+------------+--------------------------------------<br> 5849b030-626e-47cb-ad90-3ce782d831b3 | 1 | 3156bdac-ebfb-44cf-bea6-53d668b74a10<br> 3935800a-abe4-406d-84a1-4c3c0b915cce | 1 | 7cd40aed-b3b7-4e3f-85ab-a1e1d9445ea9<br> 7562ee83-4c7f-4df8-81a5-f638db6be67c | 1 | a7e039b5-71b7-42a9-8a23-09fa2fe818f8<br> 6d565c6e-ce4c-46c6-98ab-a219e2fc3b20 | 1 | e4574226-c5db-4f7c-8b16-93d3b9170f01<br> 5849b030-626e-47cb-ad90-3ce782d831b3 | 2 | df401b12-17b5-46fb-988f-c11937cca4f6<br> (5 righe)<br> <br> select task_id,action_type from async_tasks;<br> task_id | action_type <br> --------------------------------------+-------------<br> 993bea98-b89b-4054-a212-ee4a429f7173 | 36 <--- this one is from a dead "local cluster" phisycally (I mean hardware) removed I cant' remove from ovirt ( I suppose ) because it says "one host in cluster" and I can't switch it to maintenance and remove since it is *not present* anymore<br> (1 riga)<br> <br> select id,command_id,command_type from business_entity_snapshot;<br> id | command_id | command_type <br> ----+------------+--------------<br> (0 righe)<br> <br> So i did<br> <br> delete from async_tasks where task_id = '993bea98-b89b-4054-a212-ee4a429f7173';<br> DELETE 1<br> <br> and tried again but unfortunately:<br> <br> System Tasks:<br> <br> command_type | entity_type <br> --------------+-------------<br> (0 righe)<br> <br> <br> <br> <br> [ May 27 21:19:16 ] Would you like to proceed and try to stop tasks automatically?<br> (Answering 'no' will stop the upgrade)? (yes|no): yes<br> <br> [ May 27 21:19:28 ] System will try to clear tasks during the next 3 minutes<br> <br> And everything loops again<br> <br> Here is the log<br> <br> 2013-05-27 21:22:30::DEBUG::common_utils::473::root:: stderr =<br> 2013-05-27 21:22:30::DEBUG::common_utils::474::root:: retcode = 0<br> 2013-05-27 21:22:30::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 21:22:30::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 21:22:30::DEBUG::common_utils::472::root:: output = command_type | entity_type<br> --------------+-------------<br> (0 righe)<br> <br> <br> 2013-05-27 21:22:30::DEBUG::common_utils::473::root:: stderr =<br> 2013-05-27 21:22:30::DEBUG::common_utils::474::root:: retcode = 0<br> 2013-05-27 21:22:30::DEBUG::engine-upgrade::863::root:: Still waiting for system tasks to be cleared.<br> 2013-05-27 21:22:30::DEBUG::common_utils::994::root:: asking user:<br> Info: The following tasks have been found running in the system:<br> <br> System Tasks:<br> <br> command_type | entity_type<br> --------------+-------------<br> (0 righe)<br> <br> <br> <br> <br> [ May 27 21:22:30 ] Would you like to proceed and try to stop tasks automatically?<br> (Answering 'no' will stop the upgrade)? (yes|no):<br> 2013-05-27 21:24:16::DEBUG::common_utils::998::root:: user answered: no <--- here I aborted at second request<br> 2013-05-27 21:24:16::ERROR::engine-upgrade::887::root:: Traceback (most recent call last):<br> File "/usr/bin/engine-upgrade", line 880, in checkRunningTasks<br> raise Exception(MSG_TASKS_STILL_RUNNING % RUNNING_TASKS_MSG)<br> Exception:<br> There are still running tasks:<br> <br> <br> Thank you<br> <br> Alessandro Bianchi<br> <div class="moz-signature">-- <br> <meta http-equiv="CONTENT-TYPE" content="text/html; charset=UTF-8"> <title></title> <meta name="generator" content="Bluefish 2.0.3"> <meta name="author" content="Alessandro"> <meta name="CREATED" content="20100306;9474300"> <meta name="CHANGEDBY" content="Alessandro "> <meta name="CHANGED" content="20100306;10212100"> <style type="text/css"> <!-- P { font-family: "Arial", "Helvetica", sans-serif; font-size: 10pt } P.nome { color: #ff8000; font-family: "Arial", "Helvetica", sans-serif; font-size: 12pt; font-weight: bold; text-align: center } P.indirizzo { color: #0084d1; font-family: "Arial", "Helvetica", sans-serif; font-size: 10pt; font-weight: bold; line-height: 0.48cm; text-align: center } P.info { color: #b3b3b3; font-family: "Arial", "Helvetica", sans-serif; font-size: 9pt } A:link { color: #005dff; text-decoration: none } A:visited { color: #005dff; text-decoration: none } --> </style> <p class="nome">SkyNet SRL</p> <p class="indirizzo">Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608</p> <p align="CENTER"><a href="http://www.skynet.it/">http://www.skynet.it</a></p> <p class="indirizzo">Autorizzazione Ministeriale n.197</p> <p class="info">Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita.<br> Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. <br> Per qualsiasi informazione si prega di contattare <a class="moz-txt-link-abbreviated" href="mailto:info@skynet.it">info@skynet.it</a> (e-mail dell'azienda). Rif. D.L. 196/2003</p> </div> </body> </html> --------------000609000404010806070008--
This is a multi-part message in MIME format. --------------070401020802030501030105 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Alessandro, try LC_ALL=C engine-upgrade, it should work Il 27/05/2013 18:26, Alessandro Bianchi ha scritto:
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
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com --------------070401020802030501030105 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Hi Alessandro,<br> try LC_ALL=C engine-upgrade, it should work<br> <br> <br> Il 27/05/2013 18:26, Alessandro Bianchi ha scritto:<br> </div> <blockquote cite="mid:51A3893F.4070008@skynet.it" type="cite"> <pre wrap="">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 </pre> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ Users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <br> <br> <pre class="moz-signature" cols="72">-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com</pre> </body> </html> --------------070401020802030501030105--
This is a multi-part message in MIME format. --------------010203040705000102030109 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Il 28/05/2013 07:54, Sandro Bonazzola ha scritto:
Hi Alessandro, try LC_ALL=C engine-upgrade, it should work
export LC_ALL=C ; engine-upgrade
Il 27/05/2013 18:26, Alessandro Bianchi ha scritto:
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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com --------------010203040705000102030109 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Il 28/05/2013 07:54, Sandro Bonazzola ha scritto:<br> </div> <blockquote cite="mid:51A44681.3080309@redhat.com" type="cite"> <pre wrap="">Hi Alessandro, try LC_ALL=C engine-upgrade, it should work</pre> </blockquote> <br> export LC_ALL=C ; engine-upgrade<br> <br> <blockquote cite="mid:51A44681.3080309@redhat.com" type="cite"> <pre wrap=""> Il 27/05/2013 18:26, Alessandro Bianchi ha scritto: </pre> <blockquote type="cite"> <pre wrap="">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 <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <pre wrap=""> </pre> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ Users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <br> <br> <pre class="moz-signature" cols="72">-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com</pre> </body> </html> --------------010203040705000102030109--
Il 28/05/2013 08:53, Alessandro Bianchi ha scritto:
I confirm it is a language issue
export LC_ALL=C ; engine-upgrade
fixes the problem and does the upgrade work
I suggest to include the language setting inside the upgrade script before it starts the process
Thank you
Hi, this is already fixed in master, 3.3 will not have this issue.
Il 28/05/2013 07:58, Sandro Bonazzola ha scritto:
Il 28/05/2013 07:54, Sandro Bonazzola ha scritto:
Hi Alessandro, try LC_ALL=C engine-upgrade, it should work
export LC_ALL=C ; engine-upgrade
Il 27/05/2013 18:26, Alessandro Bianchi ha scritto:
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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com
-- Il messaggio è stato analizzato alla ricerca di virus o contenuti pericolosi da *SkyNet Srl> <http://www.skynet.it/>*, ed è risultato non infetto.
This message has been checked for virus or dangerous content by *SkyNet SRL <http://www.skynet.it/>* and seems to be clean.
--
SkyNet SRL
Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608
http://www.skynet.it <http://www.skynet.it/>
Autorizzazione Ministeriale n.197
Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare info@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com
participants (3)
-
Alessandro Bianchi -
Sandro Bonazzola -
Yair Zaslavsky