Project

General

Profile

Bug #409 ยป foreman.log

Nikolay Aralovets, 10/18/2010 08:30 AM

 
Processing FactValuesController#fact_selected (for 172.30.64.135 at 2010-10-18 11:11:58) [POST]
Parameters: {"via"=>"", "action"=>"fact_selected", "authenticity_token"=>"D82sokhW1wBej8TUf2x23/g66v8XdRmPJgEbGHa4nf4=", "controller"=>"fact_values", "search_fact_name_id"=>"56"}
Completed in 11ms (View: 7, DB: 9) | 200 OK [http://srv2-puppet.net.billing.ru/fact_values/fact_selected]


Processing FactValuesController#index (for 172.30.64.135 at 2010-10-18 11:12:05) [GET]
Parameters: {"commit"=>"Go", "via"=>"", "tab_name"=>"test", "action"=>"index", "controller"=>"fact_values", "search"=>{"fact_name_name_like"=>"", "host_name_like"=>"srv-redhat", "fact_name_id_eq"=>"56", "order"=>"", "value_eq"=>"x86_64"}}
Rendering template within layouts/standard
Rendering fact_values/index
Completed in 64ms (View: 42, DB: 8) | 200 OK [http://srv2-puppet.net.billing.ru/fact_values?search%5Border%5D=&search%5Bhost_name_like%5D=srv-redhat&search%5Bfact_name_name_like%5D=&via=&via=&search%5Bfact_name_id_eq%5D=56&search%5Bvalue_eq%5D=x86_64&commit=Go&tab_name=test]


Processing FactValuesController#fact_selected (for 172.30.64.135 at 2010-10-18 11:12:36) [POST]
Parameters: {"via"=>"", "action"=>"fact_selected", "authenticity_token"=>"D82sokhW1wBej8TUf2x23/g66v8XdRmPJgEbGHa4nf4=", "controller"=>"fact_values", "search_fact_name_id"=>"67"}
Completed in 10ms (View: 6, DB: 13) | 200 OK [http://srv2-puppet.net.billing.ru/fact_values/fact_selected]


Processing FactValuesController#index (for 172.30.64.135 at 2010-10-18 11:12:41) [GET]
Parameters: {"commit"=>"Go", "via"=>"", "tab_name"=>"test1", "action"=>"index", "controller"=>"fact_values", "search"=>{"fact_name_name_like"=>"", "host_name_like"=>"srv-redhat", "fact_name_id_eq"=>"67", "order"=>"", "value_eq"=>"Version 3.3.4"}}

ActiveRecord::StatementInvalid (Mysql::Error: Not unique table/alias: 'hosts': SELECT `fact_values`.`id` AS t0_r0, `fact_values`.`value` AS t0_r1, `fact_values`.`fact_name_id` AS t0_r2, `fact_values`.`host_id` AS t0_r3, `fact_values`.`updated_at` AS t0_r4, `fact_values`.`created_at` AS t0_r5, `fact_names`.`id` AS t1_r0, `fact_names`.`name` AS t1_r1, `fact_names`.`updated_at` AS t1_r2, `fact_names`.`created_at` AS t1_r3, `hosts`.`id` AS t2_r0, `hosts`.`name` AS t2_r1, `hosts`.`ip` AS t2_r2, `hosts`.`environment` AS t2_r3, `hosts`.`last_compile` AS t2_r4, `hosts`.`last_freshcheck` AS t2_r5, `hosts`.`last_report` AS t2_r6, `hosts`.`updated_at` AS t2_r7, `hosts`.`source_file_id` AS t2_r8, `hosts`.`created_at` AS t2_r9, `hosts`.`mac` AS t2_r10, `hosts`.`sp_mac` AS t2_r11, `hosts`.`sp_ip` AS t2_r12, `hosts`.`sp_name` AS t2_r13, `hosts`.`root_pass` AS t2_r14, `hosts`.`serial` AS t2_r15, `hosts`.`puppetmaster` AS t2_r16, `hosts`.`puppet_status` AS t2_r17, `hosts`.`domain_id` AS t2_r18, `hosts`.`architecture_id` AS t2_r19, `hosts`.`operatingsystem_id` AS t2_r20, `hosts`.`environment_id` AS t2_r21, `hosts`.`subnet_id` AS t2_r22, `hosts`.`sp_subnet_id` AS t2_r23, `hosts`.`ptable_id` AS t2_r24, `hosts`.`media_id` AS t2_r25, `hosts`.`build` AS t2_r26, `hosts`.`comment` AS t2_r27, `hosts`.`disk` AS t2_r28, `hosts`.`installed_at` AS t2_r29, `hosts`.`model_id` AS t2_r30, `hosts`.`hostgroup_id` AS t2_r31, `hosts`.`owner_id` AS t2_r32, `hosts`.`owner_type` AS t2_r33, `hosts`.`enabled` AS t2_r34, `domains`.`id` AS t3_r0, `domains`.`name` AS t3_r1, `domains`.`dnsserver` AS t3_r2, `domains`.`gateway` AS t3_r3, `domains`.`fullname` AS t3_r4, `domains`.`created_at` AS t3_r5, `domains`.`updated_at` AS t3_r6 FROM `fact_values` LEFT OUTER JOIN `fact_names` ON `fact_names`.id = `fact_values`.fact_name_id LEFT OUTER JOIN `hosts` ON `hosts`.id = `fact_values`.host_id LEFT OUTER JOIN `domains` ON `domains`.id = `hosts`.domain_id INNER JOIN `hosts` ON `hosts`.id = `fact_values`.host_id WHERE (((hosts.name LIKE '%srv-redhat%') AND (fact_values.value = 'Version 3.3.4')) AND (fact_values.fact_name_id = 67)) LIMIT 0, 20):
app/controllers/fact_values_controller.rb:13:in `index'
app/controllers/fact_values_controller.rb:10:in `index'
passenger (2.2.5) lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
passenger (2.2.5) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/utils.rb:183:in `safe_fork'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:163:in `start'
passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:213:in `start'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
passenger (2.2.5) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
passenger (2.2.5) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Rendering /var/rails/foreman/public/500.html (500 Internal Server Error)


Processing FactValuesController#index (for 172.30.64.135 at 2010-10-18 11:12:58) [GET]
Parameters: {"commit"=>"Go", "via"=>"", "tab_name"=>"test", "action"=>"index", "controller"=>"fact_values", "search"=>{"fact_name_name_like"=>"", "host_name_like"=>"srv-redhat", "fact_name_id_eq"=>"56", "order"=>"", "value_eq"=>"x86_64"}}
Rendering template within layouts/standard
Rendering fact_values/index
Completed in 39ms (View: 28, DB: 5) | 200 OK [http://srv2-puppet.net.billing.ru/fact_values?search%5Border%5D=&search%5Bhost_name_like%5D=srv-redhat&search%5Bfact_name_name_like%5D=&via=&via=&search%5Bfact_name_id_eq%5D=56&search%5Bvalue_eq%5D=x86_64&commit=Go&tab_name=test]
    (1-1/1)