<div dir="ltr"><div class="gmail_default"><span style="font-family:tahoma,sans-serif">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 (</span><font face="tahoma, sans-serif">[ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute)</font><span style="font-family:tahoma,sans-serif"></span></div>
<div><br></div><div><div class="gmail_default" style="font-family:tahoma,sans-serif">But the foreman issue in terms of DB search:</div></div><div class="gmail_default" style="font-family:tahoma,sans-serif"><br></div><div class="gmail_default">
<div class="gmail_default"><font face="tahoma, sans-serif">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 <a href="http://domain.id">domain.id</a> � �where �( �storage pool with storage <a href="http://domain.name">domain.name</a> 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</font></div>
<div style="font-family:tahoma,sans-serif"><br></div></div></div><div class="gmail_extra"><br clear="all"><div><font face="tahoma, sans-serif">Thanks,<br>Andrew</font><br></div>
<br><br><div class="gmail_quote">On Wed, Aug 14, 2013 at 10:58 PM, Doron Fediuck <span dir="ltr"><<a href="mailto:dfediuck@redhat.com" target="_blank">dfediuck@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br>
<br>
----- Original Message -----<br>
| From: "Laszlo Hornyak" <<a href="mailto:lhornyak@redhat.com">lhornyak@redhat.com</a>><br>
| To: "Andrew Lau" <<a href="mailto:andrew@andrewklau.com">andrew@andrewklau.com</a>>, "Noam Slomianko" <<a href="mailto:nslomian@redhat.com">nslomian@redhat.com</a>><br>
| Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
| Sent: Wednesday, August 14, 2013 10:53:19 AM<br>
| Subject: Re: [Users] oVirt API Code 500 with Foreman<br>
|<br>
| Hi,<br>
|<br>
| Noam, looks like this is a bug in the free text comment, can you check it?<br>
| I think this may be the issue. <a href="http://gerrit.ovirt.org/18061" target="_blank">http://gerrit.ovirt.org/18061</a><br>
|<br>
| Thx,<br>
| Laszlo<br>
|<br>
| ----- Original Message -----<br>
| > From: "Andrew Lau" <<a href="mailto:andrew@andrewklau.com">andrew@andrewklau.com</a>><br>
| > To: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
| > Sent: Wednesday, August 14, 2013 8:35:03 AM<br>
| > Subject: [Users] oVirt API Code 500 with Foreman<br>
| ><br>
| > Hi,<br>
| ><br>
| > Foreman guys say this is probably an oVirt side issue..<br>
| ><br>
| > I was successfully able to hook up my foreman server to the oVirt<br>
| > datacenter<br>
| > using the compute resources section. It detected the available datacenters<br>
| > and logged in fine. Logs showed code 200, I can view the VMs available,<br>
| > power them on and shut them down from the foreman UI.<br>
| ><br>
| > But when I go to hosts->New Host and select oVirt I get the error:<br>
| ><br>
| > Error loading virtual machine information: Internal Server Error<br>
| ><br>
| > Logs are showing:<br>
| ><br>
| > Operation FAILED: statementcallback; bad sql grammar select * from (select<br>
| > *<br>
| > from vds groups view where ( vds group id in (select vds groups storage<br>
| > domain.vds group id from vds groups storage domain left outer join storage<br>
| > pool with storage domain on vds groups storage domain.storage pool<br>
| > id=storage pool with storage <a href="http://domain.id" target="_blank">domain.id</a> where ( storage pool with storage<br>
| > <a href="http://domain.name" target="_blank">domain.name</a> like '%dc_01%' or storage pool with storage domain.description<br>
| > like '%dc_01%' or storage pool with storage domain.comment like '%dc_01%' )<br>
| > )) order by name asc ) as t1 offset (1 -1) limit 100; nested exception is<br>
| > org.postgresql.util.psqlexception: error: column storage pool with storage<br>
| > domain.comment does not exist<br>
| > position: 421<br>
| > Rendered common/500.html.erb (5.2ms)<br>
| > Completed 500 Internal Server Error in 150ms (Views: 6.0ms | ActiveRecord:<br>
| > 0.3ms)<br>
| ><br>
| > CentOS 6.4 - Foreman 1.2<br>
| > CentOS 6.4 - oVirt 3.3 Nightly<br>
| ><br>
| > Any suggestions?<br>
| ><br>
| > Thanks,<br>
| > Andrew.<br>
| ><br>
<br>
</div></div>A fix to it was just merged:<br>
<a href="http://gerrit.ovirt.org/#/c/18061/" target="_blank">http://gerrit.ovirt.org/#/c/18061/</a><br>
<br>
So you can re-build if you're working from sources,<br>
or wait for the next build.<br>
<span class="HOEnZb"><font color="#888888"><br>
Doron<br>
</font></span></blockquote></div><br></div>