[Users] update from 3.3 beta to RC failed during db upgrade

[Alon Bar-Lev]

----- Original Message -----
> From: "Jakub Bittner" <j.bittner at nbu.cz>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: users at 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 at nbu.cz>
> >> To: users at 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 at nbu.cz> To: users at 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 at 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 at 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