<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="GENERATOR" content="GtkHTML/4.4.4">
</head>
<body>
mån 2013-03-11 klockan 08:03 -0400 skrev Eli Mesika:
<blockquote type="CITE">
<pre>
Hi
this was solved in commit e433e54616231c1afe950d3291566133106812d0
</pre>
</blockquote>
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
<a href="http://gerrit.ovirt.org/#/c/12551/2/backend/manager/dbscripts/dbfunctions.sh">
dbfunctions.sh</a> and <a href="http://gerrit.ovirt.org/#/c/12551/2/backend/manager/dbscripts/drop_old_uuid_functions.sql">
drop_old_uuid_functions.sql</a> 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?<br>
<br>
/Karli
<blockquote type="CITE">
<pre>
----- Original Message -----
> From: "Karli Sjöberg" <<a href="mailto:Karli.Sjoberg@slu.se">Karli.Sjoberg@slu.se</a>>
> To: "Juan Hernandez" <<a href="mailto:jhernand@redhat.com">jhernand@redhat.com</a>>
> Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a>
> 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
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a>
> <a href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a>
>
</pre>
</blockquote>
<br>
</body>
</html>