Re: [Users] oVirt API Code 500 with Foreman

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