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@andrewklau.com>
> > > > To: "Gianluca Cecchi" <gianluca.cecchi@gmail.com>
> > > > Cc: "users" <users@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@gmail.com >
> > > > wrote:
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Il giorno 06/set/2013 11:14, "Doron Fediuck" < dfediuck@redhat.com > ha
> > > > scritto:
> > > >
> > > > >
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > > From: "Andrew Lau" < andrew@andrewklau.com >
> > > > > > To: "Doron Fediuck" < dfediuck@redhat.com >
> > > > > > Cc: "users" < users@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@ovirt.org
> > > > http://lists.ovirt.org/mailman/listinfo/users
> > > >