[Users] Fedora upgrading from 3.1 to 3.2

Mon Mar 11 14:26:02 UTC 2013

mån 2013-03-11 klockan 10:17 -0400 skrev Eli Mesika:

----- Original Message -----
> From: "Karli Sjöberg" <Karli.Sjoberg at slu.se<mailto:Karli.Sjoberg at slu.se>>
> To: "Eli Mesika" <emesika at redhat.com<mailto:emesika at redhat.com>>
> Cc: users at ovirt.org<mailto:users at ovirt.org>, "Juan Hernandez" <jhernand at redhat.com<mailto:jhernand at redhat.com>>
> Sent: Monday, March 11, 2013 2:54:10 PM
> Subject: Re: [Users] Fedora upgrading from 3.1 to 3.2
>
> mån 2013-03-11 klockan 08:03 -0400 skrev Eli Mesika:
>
> Hi
> this was solved in commit e433e54616231c1afe950d3291566133106812d0
> Following procedured still fails; revert failed upgrade to 3.1.0-4,
> re-enable 3.2 repo, update ovirt-engine-setup (3.2.0-4), download
> new dbfunctions.sh and drop_old_uuid_functions.sql from gerrit, and
> then try to engine-upgrade. Same problem as before. Is there any
> patch-set I could try and verify if changes work, or how long until
> there is any update to the repository packages?

Please make sure to upgrade to latest 3.1.z before upgrading to 3.2

Of course, they are all the latest versions. Before attempting upgrade are oVirt-3.1.0-4, going to oVirt-3.2.0-4 taken from:
http://ovirt.org/releases/3.2/rpm/Fedora/18

>
> /Karli
>
> ----- Original Message -----
> > From: "Karli Sjöberg" < Karli.Sjoberg at slu.se<mailto:Karli.Sjoberg at slu.se> >
> > To: "Juan Hernandez" < jhernand at redhat.com<mailto:jhernand at redhat.com> >
> > Cc: users at ovirt.org<mailto:users at ovirt.org> > Sent: Monday, March 11, 2013 1:35:29 PM
> > Subject: Re: [Users] Fedora upgrading from 3.1 to 3.2
> >
> >
> > mån 2013-03-11 klockan 12:20 +0100 skrev Juan Hernandez:
> >
> > On 03/11/2013 12:16 PM, Karli Sjöberg wrote:
> > > in the absence of any official path, we have started working out
> > > our own
> > > procedure for going from oVirt-3.1/Fedora 17 to oVirt-3.2/Fedora
> > > 18.
> > > We´ve come about halfway into upgrading to the engine node, where
> > > we
> > > have managed to get it up to 18, with postgres, httpd and
> > > ovirt-engine-3.1.0-4 running and functional. Then we edit our
> > > ovirt-engine.repo to add 3.2 packages, yum update
> > > ovirt-engine-setup,
> > > then run engine-upgrade, that fails on upgrading the database.
> > > The
> > > log
> > > file is attached. What could be the issue here?
> >
> > The service is failing to start after the upgrade. Can you check
> > /var/log/messages? What about
> > /var/log/ovirt-engine/{engine.log,server.log}? Well that comes
> > after
> > failing to upgrade the database, engine- and server.log attached,
> > doesn´t say anything useful really. It´s rather here it starts
> > going
> > south:
> >
> > 2013-03-11 11:56:49::DEBUG::engine-upgrade::412::root:: DB Update
> > started
> > 2013-03-11 11:56:49::DEBUG::common_utils::434::root:: Executing
> > command --> '/usr/share/ovirt-engine/dbscripts/upgrade.sh -s
> > localhost -p 5432 -u engine -d engine_2013_03_11_11_54_00'
> > 2013-03-11 11:56:54::DEBUG::common_utils::472::root:: output =
> > /usr/share/ovirt-engine/dbscripts /usr/share/ovirt-engine/dbscripts
> > upgrade script detected a change in Config, View or Stored
> > Procedure...
> >
> > 2013-03-11 11:56:54::DEBUG::common_utils::473::root:: stderr =
> > psql:common_sp.sql:524: NOTICE: drop cascades to function
> > fn_db_get_async_tasks()
> > psql:common_sp.sql:567: NOTICE: type "fk_info_rs" does not exist,
> > skipping
> > psql:drop_all_views.sql:1: NOTICE: drop cascades to 9 other objects
> > ...
> > psql:common_sp.sql:524: NOTICE: drop cascades to function
> > fn_db_get_async_tasks()
> > psql:drop_old_uuid_functions.sql:25: NOTICE: extension "uuid" does
> > not exist, skipping
> > CONTEXT: SQL statement "DROP EXTENSION IF EXISTS uuid--ossp
> > CASCADE;"
> > PL/pgSQL function __temp_drop_old_uuid_functions() line 6 at
> > EXECUTE
> > statement
> > psql:drop_old_uuid_functions.sql:25: ERROR: cannot drop function
> > uuid_nil() because extension uuid-ossp requires it
> > HINT: You can drop extension uuid-ossp instead.
> > CONTEXT: SQL statement "drop function if exists uuid_nil()"
> > PL/pgSQL function __temp_drop_old_uuid_functions() line 10 at SQL
> > statement
> > psql:create_functions.sql:379: WARNING: GLOBAL is deprecated in
> > temporary table creation
> > LINE 25: CREATE GLOBAL TEMPORARY TABLE tt_TEMP22
> > ^
> > psql:create_functions.sql:535: NOTICE: type
> > "all_vds_group_usage_rs"
> > does not exist, skipping
> > psql:create_functions.sql:570: NOTICE: type "all_storage_usage_rs"
> > does not exist, skipping
> > psql:create_functions.sql:671: ERROR: must be owner of function
> > uuid_generate_v1
> >
> > 2013-03-11 11:56:54::DEBUG::common_utils::474::root:: retcode = 3
> > 2013-03-11 11:56:54::ERROR::engine-upgrade::1078::root:: Traceback
> > (most recent call last):
> > File "/usr/bin/engine-upgrade", line 1065, in main
> > runFunc([db.update], MSG_INFO_DB_UPDATE)
> > File "/usr/bin/engine-upgrade", line 594, in runFunc
> > func()
> > File "/usr/bin/engine-upgrade", line 429, in update
> > output, rc = utils.execCmd(cmdList=cmd, failOnError=True,
> > msg=MSG_ERROR_UPDATE_DB)
> > File "/usr/share/ovirt-engine/scripts/common_utils.py", line 477,
> > in
> > execCmd
> > raise Exception(msg)
> > Exception: Error: Database update failed
> > ...
> >
> > /Karli
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org<mailto: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/20130311/a8cee119/attachment-0001.html>