This is a multi-part message in MIME format. --------------070401020802030501030105 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Alessandro, try LC_ALL=C engine-upgrade, it should work 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@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 --------------070401020802030501030105 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> <div class="moz-cite-prefix">Hi Alessandro,<br> try LC_ALL=C engine-upgrade, it should work<br> <br> <br> Il 27/05/2013 18:26, Alessandro Bianchi ha scritto:<br> </div> <blockquote cite="mid:51A3893F.4070008@skynet.it" type="cite"> <pre wrap="">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 </pre> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ Users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <br> <br> <pre class="moz-signature" cols="72">-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com</pre> </body> </html> --------------070401020802030501030105--