8:02 a.m.
----- Original Message -----
From: "Alex Lourie" <alourie(a)redhat.com>
To: "Alon Bar-Lev" <alonbl(a)redhat.com>
Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)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(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
>