[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
----- 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?
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@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.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--
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@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. ;-) --------------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">https://docs.google.com/file/d/0B7oyL6-mZeEDUW9GU3I0bkRfQ0U</a> </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://lists.ovirt.org/mailman/listinfo/users</a> </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--
----- 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
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.
----- 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
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
----- Original Message -----
From: "Alex Lourie" <alourie@redhat.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@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
Sure, I'll investigate. -- Best regards, Alex Lourie Software Developer in Integration Red Hat ----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Alex Lourie" <alourie@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@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
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_Postgresq... ) cd /usr/share/ovirt-engine/dbscripts ./restore.sh -u postgres -f /path/to/engine_sql_DATE.sql -r
----- Original Message -----
From: "Jakub Bittner" <j.bittner@nbu.cz> Cc: users@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_Postgresq... )
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
Dne 27.8.2013 16:13, Alon Bar-Lev napsal(a):
----- Original Message -----
From: "Jakub Bittner" <j.bittner@nbu.cz> Cc: users@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_Postgresq... )
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.
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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> Cc: users@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_Postgresq... )
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.
----- Original Message -----
From: "Alex Lourie" <alourie@redhat.com> To: "Jakub Bittner" <j.bittner@nbu.cz> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> Cc: users@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_Postgresq... )
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.
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alex Lourie" <alourie@redhat.com>, "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Jakub Bittner" <j.bittner@nbu.cz> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> Cc: users@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_Postgresq... )
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.
----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Eli Mesika" <emesika@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Alex Lourie" <alourie@redhat.com>, "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Jakub Bittner" <j.bittner@nbu.cz> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> Cc: users@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_Postgresq... )
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.
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Eli Mesika" <emesika@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Alex Lourie" <alourie@redhat.com>, "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Jakub Bittner" <j.bittner@nbu.cz>, users@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@redhat.com> To: "Jakub Bittner" <j.bittner@nbu.cz> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Alex Lourie" <alourie@redhat.com>, "Eli Mesika" <emesika@redhat.com>, users@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@nbu.cz> > Cc: users@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_Postgresq... > ) > > 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.
participants (5)
-
Alex Lourie -
Alon Bar-Lev -
Bittner Jakub -
Eli Mesika -
Jakub Bittner