[Users] oVirt API Code 500 with Foreman

[Andrew Lau]

I was able to test, the beta version doesn't have the fix but nightly does.


On Fri, Sep 6, 2013 at 6:22 PM, Andrew Lau <andrew at andrewklau.com> wrote:

> Looks like the same issue is still in 3.3 beta version.. I'm not able to
> upgrade to nightly as it's giving me another error while trying to upgrade ([
> ERROR ] Failed to execute stage 'Misc configuration': Command
> '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute)
>
> But the foreman issue in terms of DB search:
>
> Operation FAILED: statementcallback; bad sql grammar select * from (select
> * from vds groups view where ( vds group id in (select vds groups storage
> domain.vds group id from  vds groups storage domain   left outer join
> storage pool with storage domain on vds groups storage domain.storage pool
> id=storage pool with storage domain.id    where  (  storage pool with
> storage domain.name like '%datacenter\\ m1%' or  storage pool with
> storage domain.description like '%datacenter\\ m1%' or  storage pool with
> storage domain.comment like '%datacenter\\ m1%' ) ))  order by name asc )
> as t1 offset (1 -1) limit 100; nested exception is
> org.postgresql.util.psqlexception: error: column storage pool with storage
> domain.comment does not exist
>
>
> Thanks,
> Andrew
>
>
> On Wed, Aug 14, 2013 at 10:58 PM, Doron Fediuck <dfediuck at redhat.com>wrote:
>
>>
>>
>> ----- Original Message -----
>> | From: "Laszlo Hornyak" <lhornyak at redhat.com>
>> | To: "Andrew Lau" <andrew at andrewklau.com>, "Noam Slomianko" <
>> nslomian at redhat.com>
>> | Cc: users at ovirt.org
>> | Sent: Wednesday, August 14, 2013 10:53:19 AM
>> | Subject: Re: [Users] oVirt API Code 500 with Foreman
>> |
>> | Hi,
>> |
>> | Noam, looks like this is a bug in the free text comment, can you check
>> it?
>> | I think this may be the issue. http://gerrit.ovirt.org/18061
>> |
>> | Thx,
>> | Laszlo
>> |
>> | ----- Original Message -----
>> | > From: "Andrew Lau" <andrew at andrewklau.com>
>> | > To: users at ovirt.org
>> | > Sent: Wednesday, August 14, 2013 8:35:03 AM
>> | > Subject: [Users] oVirt API Code 500 with Foreman
>> | >
>> | > Hi,
>> | >
>> | > Foreman guys say this is probably an oVirt side issue..
>> | >
>> | > I was successfully able to hook up my foreman server to the oVirt
>> | > datacenter
>> | > using the compute resources section. It detected the available
>> datacenters
>> | > and logged in fine. Logs showed code 200, I can view the VMs
>> available,
>> | > power them on and shut them down from the foreman UI.
>> | >
>> | > But when I go to hosts->New Host and select oVirt I get the error:
>> | >
>> | > Error loading virtual machine information: Internal Server Error
>> | >
>> | > Logs are showing:
>> | >
>> | > Operation FAILED: statementcallback; bad sql grammar select * from
>> (select
>> | > *
>> | > from vds groups view where ( vds group id in (select vds groups
>> storage
>> | > domain.vds group id from vds groups storage domain left outer join
>> storage
>> | > pool with storage domain on vds groups storage domain.storage pool
>> | > id=storage pool with storage domain.id where ( storage pool with
>> storage
>> | > domain.name like '%dc_01%' or storage pool with storage
>> domain.description
>> | > like '%dc_01%' or storage pool with storage domain.comment like
>> '%dc_01%' )
>> | > )) order by name asc ) as t1 offset (1 -1) limit 100; nested
>> exception is
>> | > org.postgresql.util.psqlexception: error: column storage pool with
>> storage
>> | > domain.comment does not exist
>> | > position: 421
>> | > Rendered common/500.html.erb (5.2ms)
>> | > Completed 500 Internal Server Error in 150ms (Views: 6.0ms |
>> ActiveRecord:
>> | > 0.3ms)
>> | >
>> | > CentOS 6.4 - Foreman 1.2
>> | > CentOS 6.4 - oVirt 3.3 Nightly
>> | >
>> | > Any suggestions?
>> | >
>> | > Thanks,
>> | > Andrew.
>> | >
>>
>> A fix to it was just merged:
>> http://gerrit.ovirt.org/#/c/18061/
>>
>> So you can re-build if you're working from sources,
>> or wait for the next build.
>>
>> Doron
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130906/d0c8cda1/attachment-0001.html>