[Users] engine-upgrade detect erroneous running tasks
Alessandro Bianchi
a.bianchi at skynet.it
Mon May 27 19:28:26 UTC 2013
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 at skynet.it>
> *To: *users at 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 at 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 at skynet.it (e-mail
dell'azienda). Rif. D.L. 196/2003
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130527/2b6ad34b/attachment-0001.html>
More information about the Users
mailing list