<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">The patch for the fix only appears to be in the nightlies, my beta install the issue was back.</div><div class="gmail_default" style="font-family:tahoma,sans-serif">
<br></div><div class="gmail_default" style="font-family:tahoma,sans-serif">In regards to the upgrade issue, I ran engine-setup after enabling the nightly repo. It updated all the packages but ran into the error and rolled back all the packages.</div>
<div class="gmail_default"><div class="gmail_default"><font face="tahoma, sans-serif"><br></font></div><div class="gmail_default"><font face="tahoma, sans-serif">[ INFO ] Updating database schema</font></div><div class="gmail_default">
<font face="tahoma, sans-serif">[ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute</font></div><div class="gmail_default"><font face="tahoma, sans-serif">[ INFO ] Yum Performing yum transaction rollback</font></div>
<div style="font-family:tahoma,sans-serif"><br></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 Fri, Sep 6, 2013 at 7:04 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="im"><br>
<br>
----- Original Message -----<br>
> From: "Andrew Lau" <<a href="mailto:andrew@andrewklau.com">andrew@andrewklau.com</a>><br>
</div><div class="im">> To: "Doron Fediuck" <<a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a>><br>
> Cc: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> Sent: Friday, September 6, 2013 11:22:16 AM<br>
> Subject: Re: [Users] oVirt API Code 500 with Foreman<br>
><br>
</div><div class="im">> Looks like the same issue is still in 3.3 beta version.. I'm not able to<br>
> upgrade to nightly as it's giving me another error while trying to upgrade (<br>
> [ ERROR ] Failed to execute stage 'Misc configuration': Command<br>
> '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute)<br>
><br>
<br>
</div>Obviously this needs to be resolved regardless of the Foreman search issue,<br>
which was already resolved.<br>
Can you provide some more details on the upgrade issue?<br>
<div class="HOEnZb"><div class="h5"><br>
> But the foreman issue in terms of DB search:<br>
><br>
> Operation FAILED: statementcallback; bad sql grammar select * from (select *<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 '%datacenter\\ m1%' or storage pool with storage<br>
> domain.description like '%datacenter\\ m1%' or storage pool with storage<br>
> domain.comment like '%datacenter\\ m1%' ) )) order by name asc ) as t1<br>
> 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>
><br>
><br>
> Thanks,<br>
> Andrew<br>
><br>
><br>
> On Wed, Aug 14, 2013 at 10:58 PM, Doron Fediuck < <a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a> ><br>
> wrote:<br>
><br>
><br>
><br>
><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" <<br>
> | <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<br>
> | > 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<br>
> | > (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<br>
> | > 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<br>
> | > domain.description<br>
> | > like '%dc_01%' or storage pool with storage domain.comment like '%dc_01%'<br>
> | > )<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<br>
> | > 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 |<br>
> | > 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>
> 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>
><br>
> Doron<br>
><br>
><br>
</div></div><div class="HOEnZb"><div class="h5">> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</div></div></blockquote></div><br></div>