Project

General

Profile

Actions

Bug #3536

closed

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

Added by Yama Kasi over 11 years ago. Updated about 8 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

Also available in: Atom PDF