----- Original Message ----- > From: "Alex Lourie" <[email protected]> > To: "Alon Bar-Lev" <[email protected]> > Cc: "Jakub Bittner" <[email protected]>, [email protected] > 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" <[email protected]> > > To: "Jakub Bittner" <[email protected]> > > Cc: [email protected], "Alex Lourie" <[email protected]> > > 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" <[email protected]> > > > To: "Alon Bar-Lev" <[email protected]> > > > Cc: [email protected] > > > 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" <[email protected]> > > > >> To: [email protected] > > > >> 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" <[email protected]> To: [email protected] 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 [email protected] > > > >> 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 > > > >> [email protected] > > > >> 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 > > > _______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
