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

[Alex Lourie]

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 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
>