9:13 a.m.
Sure, I'll investigate.
--
Best regards,
Alex Lourie
Software Developer in Integration
Red Hat
----- Original Message -----
From: "Alon Bar-Lev" <alonbl(a)redhat.com>
To: "Alex Lourie" <alourie(a)redhat.com>
Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Monday, August 26, 2013 3:02:48 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- 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
> >
>