Bug #3536
Updated by Ohad Levy over 11 years ago
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: <pre> 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) </pre>