Re: [Users] engine-upgrade detect erroneous running tasks

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

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(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> Users(a)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(a)skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003