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--