<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>