[Users] engine-upgrade detect erroneous running tasks

[Sandro Bonazzola]

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 at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130528/05c831b1/attachment-0001.html>