From j.bittner at nbu.cz Mon Aug 26 06:37:34 2013 Content-Type: multipart/mixed; boundary="===============0502380014077778651==" MIME-Version: 1.0 From: Jakub Bittner To: users at ovirt.org Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade Date: Mon, 26 Aug 2013 12:37:24 +0200 Message-ID: <521B2FE4.1060003@nbu.cz> In-Reply-To: 521B2B88.60000@nbu.cz --===============0502380014077778651== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------000503060307000903030302 Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed Content-Transfer-Encoding: 7bit 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" >>> 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.sc= hema >>> **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. ;-) --------------000503060307000903030302 Content-Type: text/html; charset=3DISO-8859-1 Content-Transfer-Encoding: 7bit
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-mZeEDUW=
9GU3I0bkRfQ0U




_______________________________________________
Users mailing list
Use=
rs(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. ;-)
--------------000503060307000903030302-- --===============0502380014077778651== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wMDA1MDMwNjAzMDcwMDA5MDMwMzAzMDIKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PUlTTy04ODU5LTE7IGZvcm1hdD1mbG93ZWQKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKRG5lIDI2LjguMjAxMyAxMjoxOCwgQml0dG5lciBKYWt1YiBuYXBzYWwoYSk6Cj4gT24g MjYuOC4yMDEzIDExOjQ1LCBBbG9uIEJhci1MZXYgd3JvdGU6Cj4+Cj4+IC0tLS0tIE9yaWdpbmFs IE1lc3NhZ2UgLS0tLS0KPj4+IEZyb206ICJKYWt1YiBCaXR0bmVyIiA8ai5iaXR0bmVyQG5idS5j ej4KPj4+IFRvOiB1c2Vyc0BvdmlydC5vcmcKPj4+IFNlbnQ6IE1vbmRheSwgQXVndXN0IDI2LCAy MDEzIDEyOjIzOjQ4IFBNCj4+PiBTdWJqZWN0OiBbVXNlcnNdIHVwZGF0ZSBmcm9tIDMuMyBiZXRh IHRvIFJDIGZhaWxlZCBkdXJpbmcgZGIgdXBncmFkZQo+Pj4KPj4+IEkgdHJ5ZWQgdXBkYXRpbmcg My4zIGZvbSBiZXRhIHRvIHJjLCBidXQgaXQgZmFpbGVkIGR1cmluZyBkYiB1cGdyYWRlLgo+Pj4K Pj4+Cj4+PiBbIEVSUk9SIF0gRmFpbGVkIHRvIGV4ZWN1dGUgc3RhZ2UgJ01pc2MgY29uZmlndXJh dGlvbic6IENvbW1hbmQKPj4+ICcvdXNyL3NoYXJlL292aXJ0LWVuZ2luZS9kYnNjcmlwdHMvdXBn cmFkZS5zaCcgZmFpbGVkIHRvIGV4ZWN1dGUKPj4+Cj4+PiBhbmQgaW4gbG9nOgo+Pj4KPj4+IDIw MTMtMDgtMjYgMDg6MzM6MDEgREVCVUcKPj4+IG90byoqRklMVEVSRUQqKmkuKipGSUxURVJFRCoq bHVnaW5zLm92aXJ0X2VuZ2luZV9zZXR1KipGSUxURVJFRCoqLmRiLnNjaGVtYQo+Pj4gKipGSUxU RVJFRCoqbHVnaW4uZXhlY3V0ZTo0NDYgZXhlY3V0ZS1vdXQqKkZJTFRFUkVEKip1dDoKPj4+IFsn L3Vzci9zaGFyZS9vdmlydC1lbmdpbmUvZGJzY3JpKipGSUxURVJFRCoqdHMvdSoqRklMVEVSRUQq KmdyYWRlLnNoJywKPj4+ICctcycsICdsb2NhbGhvc3QnLCAnLSoqRklMVEVSRUQqKicsICc1NDMy JywgJy11JywgJAo+Pj4gKipGSUxURVJFRCoqc3FsOmNvbW1vbl9zKipGSUxURVJFRCoqLnNxbDoy MDogRVJST1I6ICBtdXN0IGJlIG93bmVyIG9mCj4+PiBmdW5jdGlvbiBmbl9kYl9hZGRfY29sdW1u Cj4+IENhbiB5b3UgcGxlYXNlIHByb3ZpZGUgZnVsbCBsb2c/Cj4+Cj4KPiBPZiBjb3Vyc2UuCj4K PiBodHRwczovL2RvY3MuZ29vZ2xlLmNvbS9maWxlL2QvMEI3b3lMNi1tWmVFRFVXOUdVM0kwYmtS ZlEwVQo+Cj4KPgo+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fCj4gVXNlcnMgbWFpbGluZyBsaXN0Cj4gVXNlcnNAb3ZpcnQub3JnCj4gaHR0cDovL2xpc3Rz Lm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzCgpJIGNoYW5nZWQgYWxsIGZ1bmN0aW9u IG93bmVyIGZyb20gcG9zdGdyZSB0byBlbmdpbmUgYW5kIHVwZ3JhZGUgd29ya3MuIApUaGUgcXVl c3Rpb24gaXMsIHdoeSBvd25lciB3YXMgcG9zdGdyZS4gOy0pCgotLS0tLS0tLS0tLS0tLTAwMDUw MzA2MDMwNzAwMDkwMzAzMDMwMgpDb250ZW50LVR5cGU6IHRleHQvaHRtbDsgY2hhcnNldD1JU08t ODg1OS0xCkNvbnRlbnQtVHJhbnNmZXItRW5jb2Rpbmc6IDdiaXQKCjxodG1sPgogIDxoZWFkPgog ICAgPG1ldGEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PUlTTy04ODU5LTEiCiAgICAgIGh0 dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSI+CiAgPC9oZWFkPgogIDxib2R5IGJnY29sb3I9IiNGRkZG RkYiIHRleHQ9IiMwMDAwMDAiPgogICAgPGRpdiBjbGFzcz0ibW96LWNpdGUtcHJlZml4Ij5EbmUg MjYuOC4yMDEzIDEyOjE4LCBCaXR0bmVyIEpha3ViCiAgICAgIG5hcHNhbChhKTo8YnI+CiAgICA8 L2Rpdj4KICAgIDxibG9ja3F1b3RlIGNpdGU9Im1pZDo1MjFCMkI4OC42MDAwMEBuYnUuY3oiIHR5 cGU9ImNpdGUiPgogICAgICA8cHJlIHdyYXA9IiI+T24gMjYuOC4yMDEzIDExOjQ1LCBBbG9uIEJh ci1MZXYgd3JvdGU6CjwvcHJlPgogICAgICA8YmxvY2txdW90ZSB0eXBlPSJjaXRlIj4KICAgICAg ICA8cHJlIHdyYXA9IiI+CgotLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tCjwvcHJlPgogICAg ICAgIDxibG9ja3F1b3RlIHR5cGU9ImNpdGUiPgogICAgICAgICAgPHByZSB3cmFwPSIiPkZyb206 ICJKYWt1YiBCaXR0bmVyIiA8YSBjbGFzcz0ibW96LXR4dC1saW5rLXJmYzIzOTZFIiBocmVmPSJt YWlsdG86ai5iaXR0bmVyQG5idS5jeiI+Jmx0O2ouYml0dG5lckBuYnUuY3omZ3Q7PC9hPgpUbzog PGEgY2xhc3M9Im1vei10eHQtbGluay1hYmJyZXZpYXRlZCIgaHJlZj0ibWFpbHRvOnVzZXJzQG92 aXJ0Lm9yZyI+dXNlcnNAb3ZpcnQub3JnPC9hPgpTZW50OiBNb25kYXksIEF1Z3VzdCAyNiwgMjAx MyAxMjoyMzo0OCBQTQpTdWJqZWN0OiBbVXNlcnNdIHVwZGF0ZSBmcm9tIDMuMyBiZXRhIHRvIFJD IGZhaWxlZCBkdXJpbmcgZGIgdXBncmFkZQoKSSB0cnllZCB1cGRhdGluZyAzLjMgZm9tIGJldGEg dG8gcmMsIGJ1dCBpdCBmYWlsZWQgZHVyaW5nIGRiIHVwZ3JhZGUuCgoKWyBFUlJPUiBdIEZhaWxl ZCB0byBleGVjdXRlIHN0YWdlICdNaXNjIGNvbmZpZ3VyYXRpb24nOiBDb21tYW5kCicvdXNyL3No YXJlL292aXJ0LWVuZ2luZS9kYnNjcmlwdHMvdXBncmFkZS5zaCcgZmFpbGVkIHRvIGV4ZWN1dGUK CmFuZCBpbiBsb2c6CgoyMDEzLTA4LTI2IDA4OjMzOjAxIERFQlVHCm90byoqRklMVEVSRUQqKmku KipGSUxURVJFRCoqbHVnaW5zLm92aXJ0X2VuZ2luZV9zZXR1KipGSUxURVJFRCoqLmRiLnNjaGVt YQoqKkZJTFRFUkVEKipsdWdpbi5leGVjdXRlOjQ0NiBleGVjdXRlLW91dCoqRklMVEVSRUQqKnV0 OgpbJy91c3Ivc2hhcmUvb3ZpcnQtZW5naW5lL2Ric2NyaSoqRklMVEVSRUQqKnRzL3UqKkZJTFRF UkVEKipncmFkZS5zaCcsCictcycsICdsb2NhbGhvc3QnLCAnLSoqRklMVEVSRUQqKicsICc1NDMy JywgJy11JywgJAoqKkZJTFRFUkVEKipzcWw6Y29tbW9uX3MqKkZJTFRFUkVEKiouc3FsOjIwOiBF UlJPUjogIG11c3QgYmUgb3duZXIgb2YKZnVuY3Rpb24gZm5fZGJfYWRkX2NvbHVtbgo8L3ByZT4K ICAgICAgICA8L2Jsb2NrcXVvdGU+CiAgICAgICAgPHByZSB3cmFwPSIiPgpDYW4geW91IHBsZWFz ZSBwcm92aWRlIGZ1bGwgbG9nPwoKPC9wcmU+CiAgICAgIDwvYmxvY2txdW90ZT4KICAgICAgPHBy ZSB3cmFwPSIiPgoKT2YgY291cnNlLgoKPGEgY2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4dCIg aHJlZj0iaHR0cHM6Ly9kb2NzLmdvb2dsZS5jb20vZmlsZS9kLzBCN295TDYtbVplRURVVzlHVTNJ MGJrUmZRMFUiPmh0dHBzOi8vZG9jcy5nb29nbGUuY29tL2ZpbGUvZC8wQjdveUw2LW1aZUVEVVc5 R1UzSTBia1JmUTBVPC9hPgoKPC9wcmU+CiAgICAgIDxicj4KICAgICAgPGZpZWxkc2V0IGNsYXNz PSJtaW1lQXR0YWNobWVudEhlYWRlciI+PC9maWVsZHNldD4KICAgICAgPGJyPgogICAgICA8cHJl IHdyYXA9IiI+X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18K VXNlcnMgbWFpbGluZyBsaXN0CjxhIGNsYXNzPSJtb3otdHh0LWxpbmstYWJicmV2aWF0ZWQiIGhy ZWY9Im1haWx0bzpVc2Vyc0BvdmlydC5vcmciPlVzZXJzQG92aXJ0Lm9yZzwvYT4KPGEgY2xhc3M9 Im1vei10eHQtbGluay1mcmVldGV4dCIgaHJlZj0iaHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWls bWFuL2xpc3RpbmZvL3VzZXJzIj5odHRwOi8vbGlzdHMub3ZpcnQub3JnL21haWxtYW4vbGlzdGlu Zm8vdXNlcnM8L2E+CjwvcHJlPgogICAgPC9ibG9ja3F1b3RlPgogICAgPGJyPgogICAgSSBjaGFu Z2VkIGFsbCBmdW5jdGlvbiBvd25lciBmcm9tIHBvc3RncmUgdG8gZW5naW5lIGFuZCB1cGdyYWRl CiAgICB3b3Jrcy4gVGhlIHF1ZXN0aW9uIGlzLCB3aHkgb3duZXIgd2FzIHBvc3RncmUuIDstKTxi cj4KICA8L2JvZHk+CjwvaHRtbD4KCi0tLS0tLS0tLS0tLS0tMDAwNTAzMDYwMzA3MDAwOTAzMDMw MzAyLS0K --===============0502380014077778651==--