<!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>
tis 2013-06-25 klockan 16:02 +0003 skrev Alex Lourie:
<blockquote type="CITE">
<pre>
On Tue, Jun 25, 2013 at 5:03 PM, Karli Sjöberg <<a href="mailto:Karli.Sjoberg@slu.se">Karli.Sjoberg@slu.se</a>>
wrote:
> tis 2013-06-25 klockan 15:35 +0200 skrev Gianluca Cecchi: On Tue,
> Jun 25, 2013 at 2:58 PM, Karli Sjöberg wrote:
> 
>>>
>>>
> Yes, I had much better success following that article, and managed
> to upgrade fedora to 18, had to tune my kernel parameters a little
> for the postgres upgrade to work, but then engine-upgrade fails just
> as it did the last time we tried. The log is attached. Hoping to hear
> back from you soon with ideas on what to try next.
> 
>>>
>>>
>>>
> 
>>
>>
> But now the error seems different from the original one in March
> (if I remember correctly the original post).
>>
>
> They are quite the same:
>
> Then
> psql:drop_old_uuid_functions.sql:25: ERROR: cannot drop function
> uuid_nil() because extension uuid-ossp requires it
>
> Now
> 2013-06-25 14:52:16::DEBUG::common_utils::473::root:: stderr =
> psql:drop_old_uuid_functions.sql:25: ERROR: cannot drop function
> uuid_nil() because extension uuid-ossp requires it
>
>> Could it be somehow related with this rhev one bug:
> <a href="https://bugzilla.redhat.com/show_bug.cgi?id=923614">https://bugzilla.redhat.com/show_bug.cgi?id=923614</a>
>>
>>
> and that changing permissions for the impacted objects in db before
> running upgrade could help?
</pre>
</blockquote>
<br>
I have now tried that and it did no change in success there unfortunately, so it´s probably not anything permissions related in the database.<br>
<br>
dbmodify:<br>
#!/bin/sh<br>
export PGPASSFILE=/root/.pgpass
<pre>
for tbl in `psql -U postgres -wqAt -c "select tablename from pg_tables where schemaname = 'public';" engine` ; do psql -U postgres -c "alter table $tbl owner to engine" engine ; done
for tbl in `psql -U postgres -wqAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" engine`; do psql -U postgres -c "alter table $tbl owner to engine" engine ; done
for tbl in `psql -U postgres -wqAt -c "select table_name from information_schema.views where table_schema = 'public';" engine` ; do psql -U postgres -c "alter table $tbl owner to engine" engine ; done
# yum update -y ovirt-engine-setup
# ./dbmodify
# engine-upgrade
fail
Log is attached this time as well, it bombs out at the exact same place, in the same way.
/K
</pre>
<blockquote type="CITE">
<pre>
>>
>
> Very interesting, thanks for the hint! That is definitely worth
> trying out. Will try that first thing tomorrow:)
Hi Karli
If it helps, let me know - I will add a troubleshooting section to the
wiki.
>
>
>>
>>
>>
> BTW: is your environment directly created in 3.1 or did it come
> from a further upgrade?
>>
>
> Started with a minimal Fedora 17 install, added the oVirt-3.1 repo,
> ran yum upgrade -y first, then yum install -y ovirt-engine and lastly
> engine-setup. Nothing more. So it´s just an empty engine that I´m
> trying to upgrade at this point. When that works, I´ll add hosts,
> VMs, Templates, etc.
>
>>
>>
>>
> HIH,
> Gianluca
>
> --
>
> Med Vänliga Hälsningar
> -------------------------------------------------------------------------------
> Karli Sjöberg
> Swedish University of Agricultural Sciences
> Box 7079 (Visiting Address Kronåsvägen 8)
> S-750 07 Uppsala, Sweden
> Phone: +46-(0)18-67 15 66
> <a href="mailto:karli.sjoberg@slu.se">karli.sjoberg@slu.se</a>
</pre>
</blockquote>
<br>
<table cellspacing="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td>-- <br>
<br>
Med Vänliga Hälsningar<br>
-------------------------------------------------------------------------------<br>
Karli Sjöberg<br>
Swedish University of Agricultural Sciences<br>
Box 7079 (Visiting Address Kronåsvägen 8)<br>
S-750 07 Uppsala, Sweden<br>
Phone: +46-(0)18-67 15 66<br>
<a href="mailto:karli.sjoberg@adm.slu.se">karli.sjoberg@slu.se</a> </td>
</tr>
</tbody>
</table>
</body>
</html>