Project

General

Profile

Actions

Bug #3536

closed

Error loading virtual machine information: Internal Server Error -- When Adding Host

Added by Yama Kasi over 10 years ago. Updated almost 7 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Compute resources - oVirt
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

When I want to Add a new host to a Ovirt Node I get an 500 Error on the Virtual Machine Tab, but I can access all VM's through the Compute Resource.

This is the error which I see in Production.log:

Read fragment views/tabs_and_title_records-1 (0.4ms)
  Rendered home/_topbar.html.erb (3.7ms)
Completed 200 OK in 1561ms (Views: 1530.6ms | ActiveRecord: 23.6ms)
Started POST "/hosts/compute_resource_selected" for 172.16.5.25 at Tue Oct 29 13:08:41 +0100 2013
Processing by HostsController#compute_resource_selected as */*
  Parameters: {"authenticity_token"=>”XXXXXXXXXXXXXXXXXXXXX=", "host"=>{"hostgroup_id"=>"", "provision_method"=>"build", "comment"=>"", "build"=>"1", "environment_id"=>"", "puppet_proxy_id"=>"", "interfaces_attributes"=>{"new_interfaces"=>{"provider"=>"IPMI", "_destroy"=>"false", "type"=>"Nic::Managed", "domain_id"=>"", "name"=>"", "mac"=>"", "ip"=>""}}, "disk"=>"", "enabled"=>"1", "type"=>"Host::Managed", "managed"=>"true", "domain_id"=>"", "is_owned_by"=>"", "name"=>"", "compute_resource_id"=>"1", "progress_report_id"=>"[FILTERED]", "root_pass"=>"[FILTERED]", "model_id"=>"", "puppet_ca_proxy_id"=>"", "mac"=>"", "ip"=>"", "architecture_id"=>"", "overwrite"=>"false"}, "utf8"=>"✓"}
  Rendered compute_resources_vms/form/_ovirt.html.erb (416.2ms)
  Rendered hosts/_compute.html.erb (520.9ms)
Operation FAILED: statementcallback; bad sql grammar select * from (select * from vds groups view where ( vds group id in (select vds groups storage domain.vds group id from  vds groups storage domain   left outer join storage pool with storage domain on vds groups storage domain.storage pool id=storage pool with storage domain.id    where  (  storage pool with storage domain.name like '%MyDomain%' or  storage pool with storage domain.description like '%MyDomain%' or  storage pool with storage domain.comment like '%MyDomain%' ) ))  order by name asc ) as t1 offset (1 -1) limit 100; nested exception is org.postgresql.util.psqlexception: error: column storage pool with storage domain.comment does not exist
  position: 425
  Rendered common/500.html.erb (5.4ms)

Actions #1

Updated by Dominic Cleal over 10 years ago

  • Category changed from Host creation to Compute resources
  • Status changed from New to Rejected
  • Priority changed from High to Normal
  • Difficulty deleted (medium)

The SQL statement on the "Operation FAILED" line cannot have been generated by Foreman, but instead by oVirt. It references a missing column, presumably in oVirt's own database. Please contact the oVirt project for support, or to raise a bug there.

Actions #2

Updated by Yama Kasi over 10 years ago

Hi Dominic,

The question is who is following who it's specifications.

I thought that FM was on top of oVirt so if oVirt changes something, FM needs to follow.

Actions #3

Updated by Dominic Cleal over 10 years ago

Foreman doesn't interact with oVirt's database, but the error states that a table column is missing. It seems unlikely that Foreman or the libraries we use could cause this class of error - it's likely to be internal to the application.

Actions #4

Updated by Yama Kasi over 10 years ago

But it seems that FM wants to get something from that table using ?? the api ??

As it has worked before and oVirt can change things internal I think FM has to change their things too...

I know it sounds nitpicking but that is how integration goes it seems.

Actions #5

Updated by Dominic Cleal over 10 years ago

Foreman doesn't access the table directly, so it should not be able to cause this class of error. I think you'll have better luck raising it with the oVirt project first, as it appears to be an error from there.

Actions #6

Updated by Dominic Cleal over 10 years ago

  • Status changed from Rejected to New

As discussed on IRC, reopening, but I still have my reservations about the cause.

Actions #7

Updated by Ohad Levy over 10 years ago

see workaround to the problem at https://github.com/abenari/rbovirt/pull/27

Actions #8

Updated by Yama Kasi over 10 years ago

Hi Ohad,

I have changed both files on my Ubuntu installation but it didn't fix the issue yet, these are the files:

/usr/share/foreman/vendor/ruby/1.8/gems/rbovirt-0.0.20/lib/ovirt/volume.rb
/usr/share/foreman/vendor/ruby/1.8/gems/rbovirt-0.0.21/lib/ovirt/volume.rb

Thanks so far!

Cheers,
Matt

Actions #9

Updated by Ohad Levy over 10 years ago

Yama Kasi wrote:

Hi Ohad,

I have changed both files on my Ubuntu installation but it didn't fix the issue yet, these are the files:

/usr/share/foreman/vendor/ruby/1.8/gems/rbovirt-0.0.20/lib/ovirt/volume.rb
/usr/share/foreman/vendor/ruby/1.8/gems/rbovirt-0.0.21/lib/ovirt/volume.rb

Thanks so far!

It turns out its a workaround for another ovirt issue, not related to this one.

do we have an ovirt bug for this trace too?

Actions #10

Updated by Ohad Levy over 10 years ago

as this looks like an ovirt trace and not a foreman trace...

Actions #11

Updated by Ohad Levy over 10 years ago

  • Description updated (diff)
Actions #12

Updated by Yama Kasi over 10 years ago

The logs indeed exists in de engine log of oVirt, but no issues on oVirt so far.

I cannot find any issues @ the API too.

Actions #13

Updated by Walden Raines over 10 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Applied in changeset katello:katello|commit:28abc66d6b2a6be4e03ae2e0d1a4142e623004b5.

Actions #14

Updated by Dominic Cleal over 10 years ago

  • Status changed from Closed to New
  • % Done changed from 100 to 0

Please ignore the linked commit, an incorrect issue number was referenced.

Actions #15

Updated by Dominic Cleal over 9 years ago

  • Category changed from Compute resources to Compute resources - oVirt
Actions #16

Updated by Anonymous almost 7 years ago

  • Status changed from New to Rejected
Actions

Also available in: Atom PDF