4:23 a.m.
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
4:45 a.m.
----- 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?
5:18 a.m.
This is a cryptographically signed message in MIME format.
--------------ms030805020904000500050100
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
On 26.8.2013 11:45, Alon Bar-Lev wrote:
=20
=20
----- 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.s=
chema
> **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
=20
Can you please provide full log?
=20
Of course.
https://docs.google.com/file/d/0B7oyL6-mZeEDUW9GU3I0bkRfQ0U
--------------ms030805020904000500050100
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIMjDCC
BcAwggSooAMCAQICBGCejPcwDQYJKoZIhvcNAQELBQAwggEBMQswCQYDVQQGEwJDWjEXMBUG
A1UECgwOZUlkZW50aXR5IGEucy4xPDA6BgNVBAsMM0FrcmVkaXRvdmFuw70gcG9za3l0b3Zh
dGVsIGNlcnRpZmlrYcSNbsOtY2ggc2x1xb5lYjEvMC0GA1UEBwwmVmlub2hyYWRza8OhIDE4
NC8yMzk2LCAxMzAgMDAsIFByYWhhIDMxajBoBgNVBAMMYUNDQWVJRDIgLSBDb21tZXJjaWFs
IENlcnRpZmljYXRlIEF1dGhvcml0eSAoa3ZhbGlmaWtvdmFuw70gc3lzdMOpbW92w70gY2Vy
dGlmaWvDoXQga29tZXLEjW7DrSBDQSkwHhcNMTIxMTI4MDk1NTE1WhcNMTMxMTI4MDk1NTE1
WjCB0jELMAkGA1UEBhMCQ1oxKDAmBgNVBAoMH07DoXJvZG7DrSBiZXpwZcSNbm9zdG7DrSDD
usWZYWQxDTALBgNVBAsMBE9LSVMxFjAUBgNVBAMMDUpha3ViIEJpdHRuZXIxKzApBgNVBAcM
Ik5hIFBvcGVsY2UgMi8xNiwgMTUwMDYgUHJhaGEgNSwgQ1oxHzAdBgkqhkiG9w0BCQEWEGou
Yml0dG5lckBuYnUuY3oxETAPBgNVBAwMCHJlZmVyZW50MREwDwYDVQQFEwhRQ0EtODUxMDCC
ASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAOX/wiktVD5UDDR9mD+XSMGFKvuth9Jb
QczYUPVqAAeLtGlbRUVOuH21W8eOfreM5svKgVCrhbVVaFoto1/PpZksmYnHBun9rqlcwCma
MYyE4f2+UrpN2xkbJKNri7ONvHvWxnMnfcDXPPKDKtEoCQW+QqjiaYPGDl5+zII2IgRoNO3d
I6OLWNd2UVLgdHXD0wyNvUeWaHZaCjWJTcskAURvNzod1x3oSsTq1Fem/cQxH60BijNnxxaO
hsiHoN1wMsVC1k6ce7jtm3BdEokZiSSfWKlIWK5SLoho4gkyIf/U3aHATV9lkxk1Q8VsH3hR
Z7a3c2DaD6NZA4AOrCerILkCAwEAAaOCAWowggFmMB0GA1UdDgQWBBQt2QAD3WaAG3q1tfWz
Z0N076BZRjBMBgNVHSAERTBDMEEGDCqBS4z26CkBZAECAjAxMC8GCCsGAQUFBwIBFiNodHRw
Oi8vd3d3LmNjYWVpZC5jei9jY2EyL2NwLWNjLnBkZjAJBgNVHRMEAjAAMB8GA1UdIwQYMBaA
FOVAK2JjJeWQ4wADKCpQF3H5Yd4ZMIGdBgNVHR8EgZUwgZIwLqAsoCqGKGh0dHA6Ly93d3cu
Y2NhZWlkLmN6L2NjYTIvY3JsL2FjdHVhbC5jcmwwL6AtoCuGKWh0dHA6Ly9wdWIxLmNjYWVp
ZC5jei9jY2EyL2NybC9hY3R1YWwuY3JsMC+gLaArhilodHRwOi8vcHViMi5jY2FlaWQuY3ov
Y2NhMi9jcmwvYWN0dWFsLmNybDAbBgNVHREEFDASgRBqLmJpdHRuZXJAbmJ1LmN6MA4GA1Ud
DwEB/wQEAwIE8DANBgkqhkiG9w0BAQsFAAOCAQEAoiGXvOFIwzmVug8nP8tn/06LDki/0W2m
0bmMdEzBKyUUTRGIZg50XzVnk6twveYoFjcUFfNjUOlh24S4KF4BDFF3nihUCzANTmSENF9/
4gdBRCj6Jj7fwLDC8D6oK07hGAARZ/TF0mWj5BrYkKnRKTFq/24KYTsLHZwkFdjkn17DgZ7f
mRAhrltXxdFz4KhIQVUMcT9Wt/MDoZQ1LYIPUAP1pqo8kXg2RD2q2dOEEqiW/pK/85tZoMvH
3hb2vRCGC34qc3xGdORDyLnp9d2FXp3RurOQmOhQVQWVzONCqtu8obfo8QEkrMowdYsBVGA/
sCFdqi/XevMJVKlDO/h+GjCCBsQwggWsoAMCAQICBEMJ4gQwDQYJKoZIhvcNAQELBQAwgfsx
CzAJBgNVBAYTAkNaMRcwFQYDVQQKDA5lSWRlbnRpdHkgYS5zLjE8MDoGA1UECwwzQWtyZWRp
dG92YW7DvSBwb3NreXRvdmF0ZWwgY2VydGlmaWthxI1uw61jaCBzbHXFvmViMS8wLQYDVQQH
DCZWaW5vaHJhZHNrw6EgMTg0LzIzOTYsIDEzMCAwMCwgUHJhaGEgMzFkMGIGA1UEAwxbQUNB
ZUlEMiAtIFF1YWxpZmllZCBSb290IENlcnRpZmljYXRlIChrdmFsaWZpa292YW7DvSBzeXN0
w6ltb3bDvSBjZXJ0aWZpa8OhdCBrb8WZZW5vdsOpIENBKTAeFw0xMDAyMjIxNzMwMzNaFw0x
NjAyMjIxNzMwMzNaMIIBATELMAkGA1UEBhMCQ1oxFzAVBgNVBAoMDmVJZGVudGl0eSBhLnMu
MTwwOgYDVQQLDDNBa3JlZGl0b3ZhbsO9IHBvc2t5dG92YXRlbCBjZXJ0aWZpa2HEjW7DrWNo
IHNsdcW+ZWIxLzAtBgNVBAcMJlZpbm9ocmFkc2vDoSAxODQvMjM5NiwgMTMwIDAwLCBQcmFo
YSAzMWowaAYDVQQDDGFDQ0FlSUQyIC0gQ29tbWVyY2lhbCBDZXJ0aWZpY2F0ZSBBdXRob3Jp
dHkgKGt2YWxpZmlrb3ZhbsO9IHN5c3TDqW1vdsO9IGNlcnRpZmlrw6F0IGtvbWVyxI1uw60g
Q0EpMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAu/5cjG7jXecxcThVPO+IruxC
AYuuTzGH+UON+hS43WXVy80FWePfCqzQkz8DsbiKOaOYFrLlcWcSgmz5m/0XI2DDA4e1fzOl
8q8G3phavfRb8bqFQSBPUd9poUOWCSGhZHn2tUATOAGU+5ggh6ogj4fVIfnyZy+UqsUn9FfO
Pu4JAYDIoIff3cgv/5pQJg938cFn71gzGgIOh5LVm4tnvslQGbyeDv14KaL9dsfzneig2chg
6iqUrclYzAXHrb45gFbR6mUGCknvO4P4YIsHknfdPBqP/4ZViNv6RGgbGN8zdBs98bXxSDXX
yHOdOvm8H1y1p/dtikRKCoMK9m7zuQIDAQABo4ICRTCCAkEwHQYDVR0OBBYEFOVAK2JjJeWQ
4wADKCpQF3H5Yd4ZMIIBHAYDVR0gBIIBEzCCAQ8wggELBgwqgUuM9ugpAQoDAgIwgfowMgYI
KwYBBQUHAgEWJmh0dHA6Ly93d3cuYWNhZWlkLmN6L3Jvb3QyL2NwLXJxc2MucGRmMIHDBggr
BgEFBQcCAjCBtgyBs1RlbnRvIGNlcnRpZmlrw6F0IGplIHZ5ZMOhbiBqYWtvIEt2YWxpZmlr
b3ZhbsO9IHN5c3TDqW1vdsO9IGNlcnRpZmlrw6F0IHBvZGxlIHrDoWtvbmEgMjI3LzIwMDAg
U2IuIC8gVGhpcyBpcyBRdWFsaWZpZWQgU3lzdGVtIENlcnRpZmljYXRlIGFjY29yZGluZyB0
byBDemVjaCBBY3QgTm8uIDIyNy8yMDAwIENvbGwuMBIGA1UdEwEB/wQIMAYBAf8CAQAwHwYD
VR0jBBgwFoAUlf4jUC/KY3DTwMElEiFyxbrmnl0wgaAGA1UdHwSBmDCBlTAvoC2gK4YpaHR0
cDovL3d3dy5hY2FlaWQuY3ovcm9vdDIvY3JsL2FjdHVhbC5jcmwwMKAuoCyGKmh0dHA6Ly9w
dWIxLmFjYWVpZC5jei9yb290Mi9jcmwvYWN0dWFsLmNybDAwoC6gLIYqaHR0cDovL3B1YjIu
YWNhZWlkLmN6L3Jvb3QyL2NybC9hY3R1YWwuY3JsMBgGCCsGAQUFBwEDBAwwCjAIBgYEAI5G
AQEwDgYDVR0PAQH/BAQDAgEGMA0GCSqGSIb3DQEBCwUAA4IBAQASXFdwCMC0mLXv39169e8m
bPFl2QNj+WnO7XWzqdga9RkI3Lr2+joZdlkqbFuB+zMfow4iiIEwTVPahhPSYWPyxymlCZQC
RXM5LIz0ujTdXyukap0u0mE8t174nKODWetm5aK6dOVzuVgWNuYVa0sT8nnkUgXM+46NSyXP
FTc6gLO0KjzXOQYm4HWY45WI7XhRIYGgQyP5z+HBsL9gs+i/HmayPdsJayhs/nr4ke02lzF8
9sjuzasaQO1lfbO1k7YjNSr2wTdJHaow1Pt0nRa4C2B9YjTyEmVcIwWSQzTPyXgnbZPWMNHb
75e5R4apQrS/KJpVqwbiPGQQcoItYCF5MYIFSTCCBUUCAQEwggELMIIBATELMAkGA1UEBhMC
Q1oxFzAVBgNVBAoMDmVJZGVudGl0eSBhLnMuMTwwOgYDVQQLDDNBa3JlZGl0b3ZhbsO9IHBv
c2t5dG92YXRlbCBjZXJ0aWZpa2HEjW7DrWNoIHNsdcW+ZWIxLzAtBgNVBAcMJlZpbm9ocmFk
c2vDoSAxODQvMjM5NiwgMTMwIDAwLCBQcmFoYSAzMWowaAYDVQQDDGFDQ0FlSUQyIC0gQ29t
bWVyY2lhbCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgKGt2YWxpZmlrb3ZhbsO9IHN5c3TDqW1v
dsO9IGNlcnRpZmlrw6F0IGtvbWVyxI1uw60gQ0EpAgRgnoz3MAkGBSsOAwIaBQCgggMRMBgG
CSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTEzMDgyNjEwMTg1Mlow
IwYJKoZIhvcNAQkEMRYEFNYd4twkhTC6iiwOfRHCXYj+6M/IMGwGCSqGSIb3DQEJDzFfMF0w
CwYJYIZIAWUDBAEqMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAw
DQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwggEeBgkrBgEEAYI3EAQx
ggEPMIIBCzCCAQExCzAJBgNVBAYTAkNaMRcwFQYDVQQKDA5lSWRlbnRpdHkgYS5zLjE8MDoG
A1UECwwzQWtyZWRpdG92YW7DvSBwb3NreXRvdmF0ZWwgY2VydGlmaWthxI1uw61jaCBzbHXF
vmViMS8wLQYDVQQHDCZWaW5vaHJhZHNrw6EgMTg0LzIzOTYsIDEzMCAwMCwgUHJhaGEgMzFq
MGgGA1UEAwxhQ0NBZUlEMiAtIENvbW1lcmNpYWwgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IChr
dmFsaWZpa292YW7DvSBzeXN0w6ltb3bDvSBjZXJ0aWZpa8OhdCBrb21lcsSNbsOtIENBKQIE
YJ6M9zCCASAGCyqGSIb3DQEJEAILMYIBD6CCAQswggEBMQswCQYDVQQGEwJDWjEXMBUGA1UE
CgwOZUlkZW50aXR5IGEucy4xPDA6BgNVBAsMM0FrcmVkaXRvdmFuw70gcG9za3l0b3ZhdGVs
IGNlcnRpZmlrYcSNbsOtY2ggc2x1xb5lYjEvMC0GA1UEBwwmVmlub2hyYWRza8OhIDE4NC8y
Mzk2LCAxMzAgMDAsIFByYWhhIDMxajBoBgNVBAMMYUNDQWVJRDIgLSBDb21tZXJjaWFsIENl
cnRpZmljYXRlIEF1dGhvcml0eSAoa3ZhbGlmaWtvdmFuw70gc3lzdMOpbW92w70gY2VydGlm
aWvDoXQga29tZXLEjW7DrSBDQSkCBGCejPcwDQYJKoZIhvcNAQEBBQAEggEAnz53QWQkKPjw
Dx1bDK0YjX+Xd8UgPQu7PnxTYmJDuvynRlYew6KNepLfSpcobVOjIhUk5xOCrqFodFty5Ee6
bPwAesDv9nN5nIRRN/wRuiKx2gRAgKhJJN1YrVbn+xQkcykdqNA1OqmNlP2j+tkEbEXBHGSr
LvnyCIFodFhQe80Mvj3EvfCRSeUrgReDzk8EgLxIHYKq1O4l0JwZXGpQJpIVEQTLfiawL+q3
A7NlyOhwfESpOk2IeflP5ZS/V1v8ap2RqZ46dND/Ow15mnEi9aQwJZ0z2i6LqBqnGFiSROz7
jDXFfDcorzf5tKMso4cn6sKfuouruJSb5ZxPbZS8xAAAAAAAAA==
--------------ms030805020904000500050100--
5:37 a.m.
This is a multi-part message in MIME format.
--------------000503060307000903030302
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
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-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=ISO-8859-1
Content-Transfer-Encoding: 7bit
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Dne 26.8.2013 12:18, Bittner Jakub
napsal(a):<br>
</div>
<blockquote cite="mid:521B2B88.60000@nbu.cz" type="cite">
<pre wrap="">On 26.8.2013 11:45, Alon Bar-Lev wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
----- Original Message -----
</pre>
<blockquote type="cite">
<pre wrap="">From: "Jakub Bittner" <a
class="moz-txt-link-rfc2396E"
href="mailto:j.bittner@nbu.cz"><j.bittner@nbu.cz></a>
To: <a class="moz-txt-link-abbreviated"
href="mailto:users@ovirt.org">users@ovirt.org</a>
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
</pre>
</blockquote>
<pre wrap="">
Can you please provide full log?
</pre>
</blockquote>
<pre wrap="">
Of course.
<a class="moz-txt-link-freetext"
href="https://docs.google.com/file/d/0B7oyL6-mZeEDUW9GU3I0bkRfQ0U&qu...
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated"
href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext"
href="http://lists.ovirt.org/mailman/listinfo/users">http://...
</pre>
</blockquote>
<br>
I changed all function owner from postgre to engine and upgrade
works. The question is, why owner was postgre. ;-)<br>
</body>
</html>
--------------000503060307000903030302--
5:40 a.m.
----- 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
6:04 a.m.
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.
6:06 a.m.
----- 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
7 a.m.
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(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
7: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
>
8: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
> >
>
8:33 a.m.
Dne 26.8.2013 15:13, Alex Lourie napsal(a):
Sure, I'll investigate.
Maybe I found a problem which causes function owner to be postgre. I use
restore command as postgre (as on wiki:
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
)
cd /usr/share/ovirt-engine/dbscripts
./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
9:13 a.m.
----- Original Message -----
From: "Jakub Bittner" <j.bittner(a)nbu.cz>
Cc: users(a)ovirt.org
Sent: Tuesday, August 27, 2013 4:33:34 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> Sure, I'll investigate.
>
Maybe I found a problem which causes function owner to be postgre. I use
restore command as postgre (as on wiki:
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
)
cd /usr/share/ovirt-engine/dbscripts
./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
Nice!
Thank you!
Eli, can you please confirm, or suggest alternate way.
We should probably provide a script to change ownership for users who made restore.
Regards,
Alon
10:31 a.m.
Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
----- Original Message -----
> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> Cc: users(a)ovirt.org
> Sent: Tuesday, August 27, 2013 4:33:34 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>
> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
>> Sure, I'll investigate.
>>
> Maybe I found a problem which causes function owner to be postgre. I use
> restore command as postgre (as on wiki:
>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
> )
>
> cd /usr/share/ovirt-engine/dbscripts
> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
Nice!
Thank you!
Eli, can you please confirm, or suggest alternate way.
We should probably provide a script to change ownership for users who made restore.
Regards,
Alon
That script would be perfect, because I dont know how to easily switch
owner of function.
Last time I did it by exporting db, manually change owner postgre to
owner engine in sql backup file and restore db from it.
10:45 a.m.
I think we already have such a tool. Will check with Eli and update.
--
Best regards,
Alex Lourie
Software Developer in Integration
Red Hat
----- Original Message -----
From: "Jakub Bittner" <j.bittner(a)nbu.cz>
To: "Alon Bar-Lev" <alonbl(a)redhat.com>
Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli Mesika"
<emesika(a)redhat.com>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 6:31:11 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
>
> ----- Original Message -----
>> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
>> Cc: users(a)ovirt.org
>> Sent: Tuesday, August 27, 2013 4:33:34 PM
>> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>>
>> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
>>> Sure, I'll investigate.
>>>
>> Maybe I found a problem which causes function owner to be postgre. I use
>> restore command as postgre (as on wiki:
>>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
>> )
>>
>> cd /usr/share/ovirt-engine/dbscripts
>> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> Nice!
> Thank you!
>
> Eli, can you please confirm, or suggest alternate way.
>
> We should probably provide a script to change ownership for users who made
> restore.
>
> Regards,
> Alon
That script would be perfect, because I dont know how to easily switch
owner of function.
Last time I did it by exporting db, manually change owner postgre to
owner engine in sql backup file and restore db from it.
10:59 a.m.
----- Original Message -----
From: "Alex Lourie" <alourie(a)redhat.com>
To: "Jakub Bittner" <j.bittner(a)nbu.cz>
Cc: "Alon Bar-Lev" <alonbl(a)redhat.com>, "Eli Mesika"
<emesika(a)redhat.com>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 6:45:13 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
I think we already have such a tool. Will check with Eli and update.
I have such a script , do you want me to post it upstream ???
--
Best regards,
Alex Lourie
Software Developer in Integration
Red Hat
----- Original Message -----
> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli Mesika"
<emesika(a)redhat.com>,
> users(a)ovirt.org
> Sent: Tuesday, August 27, 2013 6:31:11 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>
> Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
> >
> > ----- Original Message -----
> >> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> >> Cc: users(a)ovirt.org
> >> Sent: Tuesday, August 27, 2013 4:33:34 PM
> >> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> >>
> >> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> >>> Sure, I'll investigate.
> >>>
> >> Maybe I found a problem which causes function owner to be postgre. I use
> >> restore command as postgre (as on wiki:
> >>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
> >> )
> >>
> >> cd /usr/share/ovirt-engine/dbscripts
> >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> > Nice!
> > Thank you!
> >
> > Eli, can you please confirm, or suggest alternate way.
> >
> > We should probably provide a script to change ownership for users who
> > made
> > restore.
> >
> > Regards,
> > Alon
> That script would be perfect, because I dont know how to easily switch
> owner of function.
>
> Last time I did it by exporting db, manually change owner postgre to
> owner engine in sql backup file and restore db from it.
>
11:54 a.m.
----- Original Message -----
From: "Eli Mesika" <emesika(a)redhat.com>
To: "Alex Lourie" <alourie(a)redhat.com>, "Alon Bar-Lev"
<alonbl(a)redhat.com>
Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 6:59:10 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: "Jakub Bittner" <j.bittner(a)nbu.cz>
> Cc: "Alon Bar-Lev" <alonbl(a)redhat.com>, "Eli Mesika"
<emesika(a)redhat.com>,
> users(a)ovirt.org
> Sent: Tuesday, August 27, 2013 6:45:13 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>
> I think we already have such a tool. Will check with Eli and update.
I have such a script , do you want me to post it upstream ???
Yes, it will be great.
It should be run on 3.2 and prepare it to upgrade in case of post-restore.
>
> --
>
> Best regards,
>
> Alex Lourie
> Software Developer in Integration
> Red Hat
>
>
> ----- Original Message -----
> > From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> > Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli Mesika"
> > <emesika(a)redhat.com>,
> > users(a)ovirt.org
> > Sent: Tuesday, August 27, 2013 6:31:11 PM
> > Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> >
> > Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
> > >
> > > ----- Original Message -----
> > >> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > >> Cc: users(a)ovirt.org
> > >> Sent: Tuesday, August 27, 2013 4:33:34 PM
> > >> Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > >> upgrade
> > >>
> > >> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> > >>> Sure, I'll investigate.
> > >>>
> > >> Maybe I found a problem which causes function owner to be postgre. I
> > >> use
> > >> restore command as postgre (as on wiki:
> > >>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
> > >> )
> > >>
> > >> cd /usr/share/ovirt-engine/dbscripts
> > >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> > > Nice!
> > > Thank you!
> > >
> > > Eli, can you please confirm, or suggest alternate way.
> > >
> > > We should probably provide a script to change ownership for users who
> > > made
> > > restore.
> > >
> > > Regards,
> > > Alon
> > That script would be perfect, because I dont know how to easily switch
> > owner of function.
> >
> > Last time I did it by exporting db, manually change owner postgre to
> > owner engine in sql backup file and restore db from it.
> >
>
8:22 a.m.
----- Original Message -----
From: "Alon Bar-Lev" <alonbl(a)redhat.com>
To: "Eli Mesika" <emesika(a)redhat.com>
Cc: "Alex Lourie" <alourie(a)redhat.com>, "Jakub Bittner"
<j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Tuesday, August 27, 2013 7:54:15 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- Original Message -----
> From: "Eli Mesika" <emesika(a)redhat.com>
> To: "Alex Lourie" <alourie(a)redhat.com>, "Alon Bar-Lev"
<alonbl(a)redhat.com>
> Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)ovirt.org
> Sent: Tuesday, August 27, 2013 6:59:10 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: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > Cc: "Alon Bar-Lev" <alonbl(a)redhat.com>, "Eli Mesika"
> > <emesika(a)redhat.com>,
> > users(a)ovirt.org
> > Sent: Tuesday, August 27, 2013 6:45:13 PM
> > Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
> >
> > I think we already have such a tool. Will check with Eli and update.
>
> I have such a script , do you want me to post it upstream ???
Yes, it will be great.
Should that be located in dbscripts or dbutils (or you don't mind ....)
It should be run on 3.2 and prepare it to upgrade in case of post-restore.
>
> >
> > --
> >
> > Best regards,
> >
> > Alex Lourie
> > Software Developer in Integration
> > Red Hat
> >
> >
> > ----- Original Message -----
> > > From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > > To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> > > Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli
Mesika"
> > > <emesika(a)redhat.com>,
> > > users(a)ovirt.org
> > > Sent: Tuesday, August 27, 2013 6:31:11 PM
> > > Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > upgrade
> > >
> > > Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
> > > >
> > > > ----- Original Message -----
> > > >> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > > >> Cc: users(a)ovirt.org
> > > >> Sent: Tuesday, August 27, 2013 4:33:34 PM
> > > >> Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > >> upgrade
> > > >>
> > > >> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> > > >>> Sure, I'll investigate.
> > > >>>
> > > >> Maybe I found a problem which causes function owner to be
postgre. I
> > > >> use
> > > >> restore command as postgre (as on wiki:
> > > >>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
> > > >> )
> > > >>
> > > >> cd /usr/share/ovirt-engine/dbscripts
> > > >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> > > > Nice!
> > > > Thank you!
> > > >
> > > > Eli, can you please confirm, or suggest alternate way.
> > > >
> > > > We should probably provide a script to change ownership for users
who
> > > > made
> > > > restore.
> > > >
> > > > Regards,
> > > > Alon
> > > That script would be perfect, because I dont know how to easily switch
> > > owner of function.
> > >
> > > Last time I did it by exporting db, manually change owner postgre to
> > > owner engine in sql backup file and restore db from it.
> > >
> >
>
9:07 a.m.
----- Original Message -----
From: "Eli Mesika" <emesika(a)redhat.com>
To: "Alon Bar-Lev" <alonbl(a)redhat.com>
Cc: "Alex Lourie" <alourie(a)redhat.com>, "Jakub Bittner"
<j.bittner(a)nbu.cz>, users(a)ovirt.org
Sent: Wednesday, August 28, 2013 4:22:06 PM
Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
----- Original Message -----
> From: "Alon Bar-Lev" <alonbl(a)redhat.com>
> To: "Eli Mesika" <emesika(a)redhat.com>
> Cc: "Alex Lourie" <alourie(a)redhat.com>, "Jakub Bittner"
<j.bittner(a)nbu.cz>,
> users(a)ovirt.org
> Sent: Tuesday, August 27, 2013 7:54:15 PM
> Subject: Re: [Users] update from 3.3 beta to RC failed during db upgrade
>
>
>
> ----- Original Message -----
> > From: "Eli Mesika" <emesika(a)redhat.com>
> > To: "Alex Lourie" <alourie(a)redhat.com>, "Alon
Bar-Lev"
> > <alonbl(a)redhat.com>
> > Cc: "Jakub Bittner" <j.bittner(a)nbu.cz>, users(a)ovirt.org
> > Sent: Tuesday, August 27, 2013 6:59:10 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: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > > Cc: "Alon Bar-Lev" <alonbl(a)redhat.com>, "Eli
Mesika"
> > > <emesika(a)redhat.com>,
> > > users(a)ovirt.org
> > > Sent: Tuesday, August 27, 2013 6:45:13 PM
> > > Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > upgrade
> > >
> > > I think we already have such a tool. Will check with Eli and update.
> >
> > I have such a script , do you want me to post it upstream ???
>
> Yes, it will be great.
Should that be located in dbscripts or dbutils (or you don't mind ....)
Better dbutils no? so it comes with setup, as dbscripts is versionlocked.
>
> It should be run on 3.2 and prepare it to upgrade in case of post-restore.
>
> >
> > >
> > > --
> > >
> > > Best regards,
> > >
> > > Alex Lourie
> > > Software Developer in Integration
> > > Red Hat
> > >
> > >
> > > ----- Original Message -----
> > > > From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > > > To: "Alon Bar-Lev" <alonbl(a)redhat.com>
> > > > Cc: "Alex Lourie" <alourie(a)redhat.com>, "Eli
Mesika"
> > > > <emesika(a)redhat.com>,
> > > > users(a)ovirt.org
> > > > Sent: Tuesday, August 27, 2013 6:31:11 PM
> > > > Subject: Re: [Users] update from 3.3 beta to RC failed during db
> > > > upgrade
> > > >
> > > > Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
> > > > >
> > > > > ----- Original Message -----
> > > > >> From: "Jakub Bittner" <j.bittner(a)nbu.cz>
> > > > >> Cc: users(a)ovirt.org
> > > > >> Sent: Tuesday, August 27, 2013 4:33:34 PM
> > > > >> Subject: Re: [Users] update from 3.3 beta to RC failed
during db
> > > > >> upgrade
> > > > >>
> > > > >> Dne 26.8.2013 15:13, Alex Lourie napsal(a):
> > > > >>> Sure, I'll investigate.
> > > > >>>
> > > > >> Maybe I found a problem which causes function owner to be
postgre.
> > > > >> I
> > > > >> use
> > > > >> restore command as postgre (as on wiki:
> > > > >>
http://wiki.ovirt.org/User:Adrian15/oVirt_engine_migration#Restore_Postgr...
> > > > >> )
> > > > >>
> > > > >> cd /usr/share/ovirt-engine/dbscripts
> > > > >> ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
> > > > > Nice!
> > > > > Thank you!
> > > > >
> > > > > Eli, can you please confirm, or suggest alternate way.
> > > > >
> > > > > We should probably provide a script to change ownership for
users
> > > > > who
> > > > > made
> > > > > restore.
> > > > >
> > > > > Regards,
> > > > > Alon
> > > > That script would be perfect, because I dont know how to easily
> > > > switch
> > > > owner of function.
> > > >
> > > > Last time I did it by exporting db, manually change owner postgre to
> > > > owner engine in sql backup file and restore db from it.
> > > >
> > >
> >
>
3897
days inactive
3899
days old
17 comments
5 participants
participants (5)
-
Alex Lourie -
Alon Bar-Lev -
Bittner Jakub -
Eli Mesika -
Jakub Bittner