[ovirt-devel] ovirt-engine replies with 503 Service Temporarily Unavailable on fresh install

[Christopher Pereira]

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 install"
> https://bugzilla.redhat.com/show_bug.cgi?id=1217023
>
> I tried to completely reinstall before filing BZ and the issue was reproducible. 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 [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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20150505/e0f10c1c/attachment-0001.html>