From kripper at imatronix.cl Tue May 5 02:02:10 2015 Content-Type: multipart/mixed; boundary="===============8266589715279475441==" MIME-Version: 1.0 From: Christopher Pereira To: devel at ovirt.org Subject: Re: [ovirt-devel] ovirt-engine replies with 503 Service Temporarily Unavailable on fresh install Date: Tue, 05 May 2015 03:01:29 -0300 Message-ID: <55485CB9.4090007@imatronix.cl> In-Reply-To: 55485A2E.4090808@redhat.com --===============8266589715279475441== 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. --------------070200050607030108030303 Content-Type: text/plain; charset=3Dwindows-1252; format=3Dflowed Content-Transfer-Encoding: 7bit On 05-05-2015 2:50, knarra wrote: > > Hi, > > >From last Tuesday (Apr-28), I'm experiencing > "ovirt-engine replies with 503 Service Temporarily Unavailable on fresh i= nstall" > https://bugzilla.redhat.com/show_bug.cgi?id=3D1217023 > > I tried to completely reinstall before filing BZ and the issue was reprod= ucible. I also updated today my install with latest, still the same. > > Am I alone who is hit by this BZ? Anything I could try? Should I reinstal= l again tomorrow? > > can some one please help with this issue. > Hi, I just got an SQL error in engine.log after upgrading to latest nightbuild: 2015-05-05 02:31:49,855 WARN [org.ovirt.engine.core.bll.IconLoader] (MSC service thread 1-3) [] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from getvmiconbyvmicondataurl()]; nested exception is org.postgresql.util.PSQLException: _*ERROR: function getvmiconbyvmicondataurl() does not exist*_ Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 Since this is the second time I have problems with the DB update script, = I did an "engine-cleanup" and reinstalled from scratch. Problem solved. In case you are experiencing the same issue, please provide more details = so the update script can be properly fixed. --------------070200050607030108030303 Content-Type: text/html; charset=3Dwindows-1252 Content-Transfer-Encoding: 8bit
On 05-05-2015 2:50, knarra wrote:

Hi,

>From last Tuesday (Apr-28), I'm experiencing
"ovirt-engine replies with 503 Service Temporarily Unavailable on fresh ins=
tall"
https://bugzilla.redhat.com=
/show_bug.cgi?id=3D1217023

I tried to completely reinstall before filing BZ and the issue was reproduc=
ible. I also updated today my install with latest, still the same.

Am I alone who is hit by this BZ? Anything I could try? Should I reinstall =
again tomorrow?

can some one please help with this issue.

Hi,

I just got an SQL error in engine.log after upgrading to latest nightbuild:
2015-05-05 02:31:49,855 WARN=C2=A0 [org.ovirt.engine.core.bll.IconLoader] (MSC service thread 1-3) [] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from=C2=A0 getvmiconbyvmicondataurl()]; nested exception is org.postgresql.util.PSQLException: ERROR: function getvmiconbyvmicondataurl() does not exist
=C2=A0 Hint: No function matches the given name and argument types. Y= ou might need to add explicit type casts.
=C2=A0 Position: 16

Since this is the second time I have problems with the DB update script, I did an "engine-cleanup" and reinstalled from scratch. Problem solved.
In case you are experiencing the same issue, please provide more details so the update script can be properly fixed.
--------------070200050607030108030303-- --===============8266589715279475441== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wNzAyMDAwNTA2MDcwMzAxMDgwMzAzMDMKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PXdpbmRvd3MtMTI1MjsgZm9ybWF0PWZsb3dlZApDb250ZW50LVRyYW5zZmVyLUVuY29kaW5n OiA3Yml0CgoKT24gMDUtMDUtMjAxNSAyOjUwLCBrbmFycmEgd3JvdGU6Cj4KPiBIaSwKPgo+ID5G cm9tIGxhc3QgVHVlc2RheSAoQXByLTI4KSwgSSdtIGV4cGVyaWVuY2luZwo+ICJvdmlydC1lbmdp bmUgcmVwbGllcyB3aXRoIDUwMyBTZXJ2aWNlIFRlbXBvcmFyaWx5IFVuYXZhaWxhYmxlIG9uIGZy ZXNoIGluc3RhbGwiCj4gaHR0cHM6Ly9idWd6aWxsYS5yZWRoYXQuY29tL3Nob3dfYnVnLmNnaT9p ZD0xMjE3MDIzCj4KPiBJIHRyaWVkIHRvIGNvbXBsZXRlbHkgcmVpbnN0YWxsIGJlZm9yZSBmaWxp bmcgQlogYW5kIHRoZSBpc3N1ZSB3YXMgcmVwcm9kdWNpYmxlLiBJIGFsc28gdXBkYXRlZCB0b2Rh eSBteSBpbnN0YWxsIHdpdGggbGF0ZXN0LCBzdGlsbCB0aGUgc2FtZS4KPgo+IEFtIEkgYWxvbmUg d2hvIGlzIGhpdCBieSB0aGlzIEJaPyBBbnl0aGluZyBJIGNvdWxkIHRyeT8gU2hvdWxkIEkgcmVp bnN0YWxsIGFnYWluIHRvbW9ycm93Pwo+Cj4gY2FuIHNvbWUgb25lIHBsZWFzZSBoZWxwIHdpdGgg dGhpcyBpc3N1ZS4KPgoKSGksCgpJIGp1c3QgZ290IGFuIFNRTCBlcnJvciBpbiBlbmdpbmUubG9n IGFmdGVyIHVwZ3JhZGluZyB0byBsYXRlc3QgbmlnaHRidWlsZDoKCiAgICAyMDE1LTA1LTA1IDAy OjMxOjQ5LDg1NSBXQVJOIFtvcmcub3ZpcnQuZW5naW5lLmNvcmUuYmxsLkljb25Mb2FkZXJdCiAg ICAoTVNDIHNlcnZpY2UgdGhyZWFkIDEtMykgW10KICAgIG9yZy5zcHJpbmdmcmFtZXdvcmsuamRi Yy5CYWRTcWxHcmFtbWFyRXhjZXB0aW9uOgogICAgUHJlcGFyZWRTdGF0ZW1lbnRDYWxsYmFjazsg YmFkIFNRTCBncmFtbWFyIFtzZWxlY3QgKiBmcm9tCiAgICBnZXR2bWljb25ieXZtaWNvbmRhdGF1 cmwoKV07IG5lc3RlZCBleGNlcHRpb24gaXMKICAgIG9yZy5wb3N0Z3Jlc3FsLnV0aWwuUFNRTEV4 Y2VwdGlvbjogXypFUlJPUjogZnVuY3Rpb24KICAgIGdldHZtaWNvbmJ5dm1pY29uZGF0YXVybCgp IGRvZXMgbm90IGV4aXN0Kl8KICAgICAgIEhpbnQ6IE5vIGZ1bmN0aW9uIG1hdGNoZXMgdGhlIGdp dmVuIG5hbWUgYW5kIGFyZ3VtZW50IHR5cGVzLiBZb3UKICAgIG1pZ2h0IG5lZWQgdG8gYWRkIGV4 cGxpY2l0IHR5cGUgY2FzdHMuCiAgICAgICBQb3NpdGlvbjogMTYKCgpTaW5jZSB0aGlzIGlzIHRo ZSBzZWNvbmQgdGltZSBJIGhhdmUgcHJvYmxlbXMgd2l0aCB0aGUgREIgdXBkYXRlIHNjcmlwdCwg CkkgZGlkIGFuICJlbmdpbmUtY2xlYW51cCIgYW5kIHJlaW5zdGFsbGVkIGZyb20gc2NyYXRjaC4g UHJvYmxlbSBzb2x2ZWQuCkluIGNhc2UgeW91IGFyZSBleHBlcmllbmNpbmcgdGhlIHNhbWUgaXNz dWUsIHBsZWFzZSBwcm92aWRlIG1vcmUgZGV0YWlscyAKc28gdGhlIHVwZGF0ZSBzY3JpcHQgY2Fu IGJlIHByb3Blcmx5IGZpeGVkLgoKLS0tLS0tLS0tLS0tLS0wNzAyMDAwNTA2MDcwMzAxMDgwMzAz MDMKQ29udGVudC1UeXBlOiB0ZXh0L2h0bWw7IGNoYXJzZXQ9d2luZG93cy0xMjUyCkNvbnRlbnQt VHJhbnNmZXItRW5jb2Rpbmc6IDhiaXQKCjxodG1sPgogIDxoZWFkPgogICAgPG1ldGEgY29udGVu dD0idGV4dC9odG1sOyBjaGFyc2V0PXdpbmRvd3MtMTI1MiIKICAgICAgaHR0cC1lcXVpdj0iQ29u dGVudC1UeXBlIj4KICA8L2hlYWQ+CiAgPGJvZHkgYmdjb2xvcj0iI0ZGRkZGRiIgdGV4dD0iIzAw MDAwMCI+CiAgICA8YnI+CiAgICA8ZGl2IGNsYXNzPSJtb3otY2l0ZS1wcmVmaXgiPk9uIDA1LTA1 LTIwMTUgMjo1MCwga25hcnJhIHdyb3RlOjxicj4KICAgIDwvZGl2PgogICAgPGJsb2NrcXVvdGUg Y2l0ZT0ibWlkOjU1NDg1QTJFLjQwOTA4MDhAcmVkaGF0LmNvbSIgdHlwZT0iY2l0ZSI+CiAgICAg IDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOwogICAg ICAgIGNoYXJzZXQ9d2luZG93cy0xMjUyIj4KICAgICAgPGJyPgogICAgICA8ZGl2IGNsYXNzPSJt b3otZm9yd2FyZC1jb250YWluZXIiPgogICAgICAgIDxwcmUgd3JhcD0iIj5IaSwKCiZndDtGcm9t IGxhc3QgVHVlc2RheSAoQXByLTI4KSwgSSdtIGV4cGVyaWVuY2luZwoib3ZpcnQtZW5naW5lIHJl cGxpZXMgd2l0aCA1MDMgU2VydmljZSBUZW1wb3JhcmlseSBVbmF2YWlsYWJsZSBvbiBmcmVzaCBp bnN0YWxsIgo8YSBtb3otZG8tbm90LXNlbmQ9InRydWUiIGNsYXNzPSJtb3otdHh0LWxpbmstZnJl ZXRleHQiIGhyZWY9Imh0dHBzOi8vYnVnemlsbGEucmVkaGF0LmNvbS9zaG93X2J1Zy5jZ2k/aWQ9 MTIxNzAyMyI+aHR0cHM6Ly9idWd6aWxsYS5yZWRoYXQuY29tL3Nob3dfYnVnLmNnaT9pZD0xMjE3 MDIzPC9hPgoKSSB0cmllZCB0byBjb21wbGV0ZWx5IHJlaW5zdGFsbCBiZWZvcmUgZmlsaW5nIEJa IGFuZCB0aGUgaXNzdWUgd2FzIHJlcHJvZHVjaWJsZS4gSSBhbHNvIHVwZGF0ZWQgdG9kYXkgbXkg aW5zdGFsbCB3aXRoIGxhdGVzdCwgc3RpbGwgdGhlIHNhbWUuCgpBbSBJIGFsb25lIHdobyBpcyBo aXQgYnkgdGhpcyBCWj8gQW55dGhpbmcgSSBjb3VsZCB0cnk/IFNob3VsZCBJIHJlaW5zdGFsbCBh Z2FpbiB0b21vcnJvdz8KCmNhbiBzb21lIG9uZSBwbGVhc2UgaGVscCB3aXRoIHRoaXMgaXNzdWUu Cgo8L3ByZT4KICAgICAgPC9kaXY+CiAgICA8L2Jsb2NrcXVvdGU+CiAgICA8YnI+CiAgICBIaSw8 YnI+CiAgICA8YnI+CiAgICBJIGp1c3QgZ290IGFuIFNRTCBlcnJvciBpbiBlbmdpbmUubG9nIGFm dGVyIHVwZ3JhZGluZyB0byBsYXRlc3QKICAgIG5pZ2h0YnVpbGQ6PGJyPgogICAgPGJsb2NrcXVv dGU+MjAxNS0wNS0wNSAwMjozMTo0OSw4NTUgV0FSTqAKICAgICAgW29yZy5vdmlydC5lbmdpbmUu Y29yZS5ibGwuSWNvbkxvYWRlcl0gKE1TQyBzZXJ2aWNlIHRocmVhZCAxLTMpIFtdCiAgICAgIG9y Zy5zcHJpbmdmcmFtZXdvcmsuamRiYy5CYWRTcWxHcmFtbWFyRXhjZXB0aW9uOgogICAgICBQcmVw YXJlZFN0YXRlbWVudENhbGxiYWNrOyBiYWQgU1FMIGdyYW1tYXIgW3NlbGVjdCAqIGZyb22gCiAg ICAgIGdldHZtaWNvbmJ5dm1pY29uZGF0YXVybCgpXTsgbmVzdGVkIGV4Y2VwdGlvbiBpcwogICAg ICBvcmcucG9zdGdyZXNxbC51dGlsLlBTUUxFeGNlcHRpb246IDx1PjxiPkVSUk9SOiBmdW5jdGlv bgogICAgICAgICAgZ2V0dm1pY29uYnl2bWljb25kYXRhdXJsKCkgZG9lcyBub3QgZXhpc3Q8L2I+ PC91Pjxicj4KICAgICAgoCBIaW50OiBObyBmdW5jdGlvbiBtYXRjaGVzIHRoZSBnaXZlbiBuYW1l IGFuZCBhcmd1bWVudCB0eXBlcy4gWW91CiAgICAgIG1pZ2h0IG5lZWQgdG8gYWRkIGV4cGxpY2l0 IHR5cGUgY2FzdHMuPGJyPgogICAgICCgIFBvc2l0aW9uOiAxNjxicj4KICAgIDwvYmxvY2txdW90 ZT4KICAgIDxicj4KICAgIFNpbmNlIHRoaXMgaXMgdGhlIHNlY29uZCB0aW1lIEkgaGF2ZSBwcm9i bGVtcyB3aXRoIHRoZSBEQiB1cGRhdGUKICAgIHNjcmlwdCwgSSBkaWQgYW4gImVuZ2luZS1jbGVh bnVwIiBhbmQgcmVpbnN0YWxsZWQgZnJvbSBzY3JhdGNoLgogICAgUHJvYmxlbSBzb2x2ZWQuPGJy PgogICAgSW4gY2FzZSB5b3UgYXJlIGV4cGVyaWVuY2luZyB0aGUgc2FtZSBpc3N1ZSwgcGxlYXNl IHByb3ZpZGUgbW9yZQogICAgZGV0YWlscyBzbyB0aGUgdXBkYXRlIHNjcmlwdCBjYW4gYmUgcHJv cGVybHkgZml4ZWQuPGJyPgogIDwvYm9keT4KPC9odG1sPgoKLS0tLS0tLS0tLS0tLS0wNzAyMDAw NTA2MDcwMzAxMDgwMzAzMDMtLQo= --===============8266589715279475441==--