8 a.m.
Simple guess? An upgrade from 3.1; or early versions of 3.2; we had postgres as the owner
of those objects then. Upgrade didn't change that.
--
Best regards,
Alex Lourie
Software Developer in Integration
Red Hat
----- Original Message -----
From: "Alon Bar-Lev" <alonbl(a)redhat.com>
To: "Jakub Bittner" <j.bittner(a)nbu.cz>
Cc: users(a)ovirt.org, "Alex Lourie" <alourie(a)redhat.com>
Sent: Monday, August 26, 2013 2:06:53 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- Original Message -----
> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> Cc: users(a)ovirt.org
> Sent: Monday, August 26, 2013 2:04:58 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>
> Dne 26.8.2013 12:40, Alon Bar-Lev napsal(a):
> >
> > ----- Original Message -----
> >> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> >> To: users(a)ovirt.org
> >> Sent: Monday, August 26, 2013 1:37:24 PM
> >> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> >>
> >> Dne 26.8.2013 12:18, Bittner Jakub napsal(a):
> >>
> >>
> >>
> >> On 26.8.2013 11:45, Alon Bar-Lev wrote:
> >>
> >>
> >>
> >> ----- Original Message -----
> >>
> >>
> >>
> >> From: "Jakub Bittner" <j.bittner(a)nbu.cz> To:
users(a)ovirt.org Sent:
> >> Monday,
> >> August 26, 2013 12:23:48 PM
> >> Subject: [Users] update from 3.3 beta to RC failed during db upgrade
> >>
> >> I tryed updating 3.3 fom beta to rc, but it failed during db upgrade.
> >>
> >>
> >> [ ERROR ] Failed to execute stage 'Misc configuration': Command
> >> '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute
> >>
> >> and in log:
> >>
> >> 2013-08-26 08:33:01 DEBUG
> >>
oto**FILTERED**i.**FILTERED**lugins.ovirt_engine_setu**FILTERED**.db.schema
> >> **FILTERED**lugin.execute:446 execute-out**FILTERED**ut:
> >>
['/usr/share/ovirt-engine/dbscri**FILTERED**ts/u**FILTERED**grade.sh',
> >> '-s', 'localhost', '-**FILTERED**', '5432',
'-u', $
> >> **FILTERED**sql:common_s**FILTERED**.sql:20: ERROR: must be owner of
> >> function fn_db_add_column
> >> Can you please provide full log?
> >> Of course. https://docs.google.com/file/d/0B7oyL6-mZeEDUW9GU3I0bkRfQ0U
> >>
> >>
> >> _______________________________________________
> >> Users mailing list Users(a)ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >> I changed all function owner from postgre to engine and upgrade works.
> >> The
> >> question is, why owner was postgre. ;-)
> >
> > Well, we create all objects at the ownership of the engine user.
> >
> > Can it be installation of 3.2 and upgrade?
> >
> >> _______________________________________________
> >> Users mailing list
> >> Users(a)ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> Yes, it is 3.2 upgraded to 3.3beta and now 3.3rc.
>
Oh...
Alex,
Can you check in which sequence do we have database owned by postgres user?
Maybe 3.2 upstream had some issue in setting up correct privileges?
Thanks,
Alon