[Users] oVirt API Code 500 with Foreman

[Andrew Lau]

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.

On Mon, Sep 9, 2013 at 5:24 PM, Shahar Havivi <shaharh at redhat.com> wrote:

> Adding Eli...
>
> Hi Andrew,
> Please provide the result of the following sql command:
> select * from schema_version order by id desc;
>
> On 08.09.13 13:45, Shahar Havivi wrote:
> > On 08.09.13 10:06, Shahar Havivi wrote:
> > > Its looks like a bug that we have in the upgrade in commit:
> > > 0c47b30468b855e5c52b120f476d97cc754852ee
> > > I will open a bug and fix it.
> > the vm_templates in the view is alias for vm_static.
> > can you see if there is the file 03_03_0650_add_signle_qxl_pci_column.sql
> > it suppose to be in:
> > packaging/dbscripts/upgrade/03_03_0650_add_signle_qxl_pci_column.sql
> > this is the sql file that add the single_qxl_pci to vm_static.
> > >
> > > On 06.09.13 06:21, Doron Fediuck wrote:
> > > >
> > > >
> > > > ----- Original Message -----
> > > > > From: "Andrew Lau" <andrew at andrewklau.com>
> > > > > To: "Gianluca Cecchi" <gianluca.cecchi at gmail.com>
> > > > > Cc: "users" <users at ovirt.org>
> > > > > Sent: Friday, September 6, 2013 12:46:13 PM
> > > > > Subject: Re: [Users] oVirt API Code 500 with Foreman
> > > > >
> > > > > Here's an extract of the error:
> > > > >
> > > > > 2013-09-06 18:55:49 DEBUG
> otopi.plugins.ovirt_engine_setup.db.schema
> > > > > plugin.execute:446 execute-output:
> > > > > ['/usr/share/ovirt-engine/dbscripts/upgrade.sh', '-s',
> 'localhost', '-p',
> > > > > '5432'$
> > > > > psql:create_views.sql:400: ERROR: column
> vm_templates.single_qxl_pci does not
> > > > > exist
> > > > > LINE 18: vm_templates.single_qxl_pci as single_qxl_pci,
> > > > > ^
> > > > >
> > > >
> > > > Thanks Andrew.
> > > > This was added here:
> http://gerrit.ovirt.org/#/c/16803/14/packaging/dbscripts/create_views.sql
> > > > Shahar, can you please take a look?
> > > >
> > > > > 2013-09-06 18:55:49 DEBUG otopi.context context._executeMethod:137
> method
> > > > > exception
> > > > > Traceback (most recent call last):
> > > > > File "/usr/lib/python2.6/site-packages/otopi/context.py", line
> 127, in
> > > > > _executeMethod
> > > > > method['method']()
> > > > > File
> > > > >
> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/db/schema.py",
> > > > > line 261, in _miscUpgrade
> > > > > osetupcons.DBEnv.PGPASS_FILE
> > > > > File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 451,
> in execute
> > > > > command=args[0],
> > > > > RuntimeError: Command
> '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed
> > > > > to execute
> > > > >
> > > > >
> > > > > On Fri, Sep 6, 2013 at 7:25 PM, Gianluca Cecchi <
> gianluca.cecchi at gmail.com >
> > > > > wrote:
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Il giorno 06/set/2013 11:14, "Doron Fediuck" < dfediuck at redhat.com> ha
> > > > > scritto:
> > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > > From: "Andrew Lau" < andrew at andrewklau.com >
> > > > > > > To: "Doron Fediuck" < dfediuck at redhat.com >
> > > > > > > Cc: "users" < users at ovirt.org >
> > > > > > > Sent: Friday, September 6, 2013 12:07:50 PM
> > > > > > > Subject: Re: [Users] oVirt API Code 500 with Foreman
> > > > > > >
> > > > > > > The patch for the fix only appears to be in the nightlies, my
> beta
> > > > > > > install
> > > > > > > the issue was back.
> > > > > > >
> > > > > > Since the official release is expected in the coming days, I'd
> suggest not
> > > > > > to invest time on the beta release.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > If one wants to test right now the upcoming 3.3, nightly is ok?
> > > > > No risk to get engine 3.4, correct?
> > > > > Or is there any rc repo?
> > > > > Gianluca
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Users mailing list
> > > > > Users at ovirt.org
> > > > > http://lists.ovirt.org/mailman/listinfo/users
> > > > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130909/5aa8322f/attachment-0001.html>