<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">Sorry I have since destroyed my beta install in favor of the nightly version which seems to not have the issue, anyone else who is on the 3.3 beta should be able to replicate the issue though.</div>
<div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 9, 2013 at 5:24 PM, Shahar Havivi <span dir="ltr"><<a href="mailto:shaharh@redhat.com" target="_blank">shaharh@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Adding Eli...<br>
<br>
Hi Andrew,<br>
Please provide the result of the following sql command:<br>
select * from schema_version order by id desc;<br>
<div class="HOEnZb"><div class="h5"><br>
On 08.09.13 13:45, Shahar Havivi wrote:<br>
> On 08.09.13 10:06, Shahar Havivi wrote:<br>
> > Its looks like a bug that we have in the upgrade in commit:<br>
> > 0c47b30468b855e5c52b120f476d97cc754852ee<br>
> > I will open a bug and fix it.<br>
> the vm_templates in the view is alias for vm_static.<br>
> can you see if there is the file 03_03_0650_add_signle_qxl_pci_column.sql<br>
> it suppose to be in:<br>
> packaging/dbscripts/upgrade/03_03_0650_add_signle_qxl_pci_column.sql<br>
> this is the sql file that add the single_qxl_pci to vm_static.<br>
> ><br>
> > On 06.09.13 06:21, Doron Fediuck wrote:<br>
> > ><br>
> > ><br>
> > > ----- Original Message -----<br>
> > > > From: "Andrew Lau" <<a href="mailto:andrew@andrewklau.com">andrew@andrewklau.com</a>><br>
> > > > To: "Gianluca Cecchi" <<a href="mailto:gianluca.cecchi@gmail.com">gianluca.cecchi@gmail.com</a>><br>
> > > > Cc: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> > > > Sent: Friday, September 6, 2013 12:46:13 PM<br>
> > > > Subject: Re: [Users] oVirt API Code 500 with Foreman<br>
> > > ><br>
> > > > Here's an extract of the error:<br>
> > > ><br>
> > > > 2013-09-06 18:55:49 DEBUG otopi.plugins.ovirt_engine_setup.db.schema<br>
> > > > plugin.execute:446 execute-output:<br>
> > > > ['/usr/share/ovirt-engine/dbscripts/upgrade.sh', '-s', 'localhost', '-p',<br>
> > > > '5432'$<br>
> > > > psql:create_views.sql:400: ERROR: column vm_templates.single_qxl_pci does not<br>
> > > > exist<br>
> > > > LINE 18: vm_templates.single_qxl_pci as single_qxl_pci,<br>
> > > > ^<br>
> > > ><br>
> > ><br>
> > > Thanks Andrew.<br>
> > > This was added here: <a href="http://gerrit.ovirt.org/#/c/16803/14/packaging/dbscripts/create_views.sql" target="_blank">http://gerrit.ovirt.org/#/c/16803/14/packaging/dbscripts/create_views.sql</a><br>
> > > Shahar, can you please take a look?<br>
> > ><br>
> > > > 2013-09-06 18:55:49 DEBUG otopi.context context._executeMethod:137 method<br>
> > > > exception<br>
> > > > Traceback (most recent call last):<br>
> > > > File "/usr/lib/python2.6/site-packages/otopi/context.py", line 127, in<br>
> > > > _executeMethod<br>
> > > > method['method']()<br>
> > > > File<br>
> > > > "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/db/schema.py",<br>
> > > > line 261, in _miscUpgrade<br>
> > > > osetupcons.DBEnv.PGPASS_FILE<br>
> > > > File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 451, in execute<br>
> > > > command=args[0],<br>
> > > > RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed<br>
> > > > to execute<br>
> > > ><br>
> > > ><br>
> > > > On Fri, Sep 6, 2013 at 7:25 PM, Gianluca Cecchi < <a href="mailto:gianluca.cecchi@gmail.com">gianluca.cecchi@gmail.com</a> ><br>
> > > > wrote:<br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > > Il giorno 06/set/2013 11:14, "Doron Fediuck" < <a href="mailto:dfediuck@redhat.com">dfediuck@redhat.com</a> > ha<br>
> > > > scritto:<br>
> > > ><br>
> > > > ><br>
> > > > ><br>
> > > > ><br>
> > > > > ----- Original Message -----<br>
> > > > > > From: "Andrew Lau" < <a href="mailto:andrew@andrewklau.com">andrew@andrewklau.com</a> ><br>
> > > > > > 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 12:07:50 PM<br>
> > > > > > Subject: Re: [Users] oVirt API Code 500 with Foreman<br>
> > > > > ><br>
> > > > > > The patch for the fix only appears to be in the nightlies, my beta<br>
> > > > > > install<br>
> > > > > > the issue was back.<br>
> > > > > ><br>
> > > > > Since the official release is expected in the coming days, I'd suggest not<br>
> > > > > to invest time on the beta release.<br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > ><br>
> > > > If one wants to test right now the upcoming 3.3, nightly is ok?<br>
> > > > No risk to get engine 3.4, correct?<br>
> > > > Or is there any rc repo?<br>
> > > > Gianluca<br>
> > > ><br>
> > > ><br>
> > > > _______________________________________________<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></div>