<!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 10:17 -0400 skrev Eli Mesika:
<blockquote type="CITE">
<pre>

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

Please make sure to upgrade to latest 3.1.z before upgrading to 3.2
</pre>
</blockquote>
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:<br>
<a href="http://ovirt.org/releases/3.2/rpm/Fedora/18">http://ovirt.org/releases/3.2/rpm/Fedora/18</a><br>
<br>
<blockquote type="CITE">
<pre>

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