[Users] engine-upgrade detect erroneous running tasks

Tue May 28 07:24:13 UTC 2013

Il 28/05/2013 08:53, Alessandro Bianchi ha scritto:
> 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

Hi, this is already fixed in master, 3.3 will not have this issue.

> 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 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
> >
> > -- 
> > 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 at skynet.it (e-mail 
> dell'azienda). Rif. D.L. 196/2003
>
>

-- 
Sandro Bonazzola
Better technology. Faster innovation. Powered by community collaboration.
See how it works at redhat.com