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@redhat.com> To: "Jakub Bittner" <j.bittner@nbu.cz> Cc: users@ovirt.org, "Alex Lourie" <alourie@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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: users@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@nbu.cz> To: users@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@nbu.cz> To: users@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@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@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