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

[Alon Bar-Lev]

----- Original Message -----
> From: "Alex Lourie" <alourie at redhat.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: "Jakub Bittner" <j.bittner at nbu.cz>, users at ovirt.org
> Sent: Monday, August 26, 2013 3:00:12 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> 
> 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.
> 

Alex, we must fix that.
Are you sure that 3.1 used postgres as owner?
I thought we always used the engine user to create the database.
Please confirm we have an issue, if we do, we need to add change ownership of objects when upgrade from legacy.

> --
> 
> Best regards,
> 
> Alex Lourie
> Software Developer in Integration
> Red Hat
> 
> 
> ----- Original Message -----
> > From: "Alon Bar-Lev" <alonbl at redhat.com>
> > To: "Jakub Bittner" <j.bittner at nbu.cz>
> > Cc: users at ovirt.org, "Alex Lourie" <alourie at 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 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
> > 
>