[Users] engine-upgrade detect erroneous running tasks

[Yair Zaslavsky]

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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130527/b9a263be/attachment-0001.html>