Project

General

Profile

Actions

Bug #14780

open

foreman-chef 0.3.1 fails to import facts

Added by Elias Abacioglu almost 8 years ago. Updated almost 8 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
foreman_chef
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

usinng foreman with chef plugin, mysql2 db store engine, a mariadb 10 as backend.

This happens everytime a node reports in.
I did a ugly fix by adding a default value in the foreman_chef_environments, column chef_proxy_id.
Then the error disappeared.

2016-04-22T14:50:16 [foreman_chef] [I] Import facts for 'dnschp-hq01.se-hq.delta.prod' completed. Added: 11, Updated: 1, Deleted 5 facts
2016-04-22T14:50:17 [foreman-tasks/action] [E] Mysql2::Error: Field 'chef_proxy_id' doesn't have a default value: INSERT INTO `foreman_chef_environments` (`created_at`, `name`, `updated_at`) VALUES ('2016-04-22 12:50:17', '_default', '2016-04-22 12:50:17') (ActiveRecord::StatementInvalid)
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `query'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `block in execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:303:in `execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/mysql2_adapter.rb:250:in `exec_insert'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:95:in `insert'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/relation.rb:64:in `insert'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/persistence.rb:504:in `_create_record'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/attribute_methods/dirty.rb:87:in `_create_record'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/callbacks.rb:306:in `block in _create_record'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:113:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:113:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:552:in `block (2 levels) in compile'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:502:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:502:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:86:in `run_callbacks'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/callbacks.rb:306:in `_create_record'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/timestamp.rb:57:in `_create_record'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/persistence.rb:484:in `create_or_update'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/callbacks.rb:302:in `block in create_or_update'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:113:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:113:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:552:in `block (2 levels) in compile'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:502:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:502:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-4.1.14.2/lib/active_support/callbacks.rb:86:in `run_callbacks'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/callbacks.rb:302:in `create_or_update'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/persistence.rb:103:in `save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/validations.rb:51:in `save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/attribute_methods/dirty.rb:21:in `save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:268:in `block (2 levels) in save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:329:in `block in with_transaction_returning_status'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:208:in `transaction'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:326:in `with_transaction_returning_status'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:268:in `block in save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:283:in `rollback_active_record_state!'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/transactions.rb:267:in `save'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/protected_attributes-1.1.3/lib/active_record/mass_assignment_security/persistence.rb:46:in `create'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/relation.rb:139:in `block in create'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/relation.rb:292:in `scoping'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/relation.rb:139:in `create'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/protected_attributes-1.1.3/lib/active_record/mass_assignment_security/relation.rb:35:in `first_or_create'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/foreman_chef-0.3.1/app/models/foreman_chef/fact_parser.rb:37:in `environment'
 | /usr/share/foreman/app/models/host/managed.rb:475:in `populate_fields_from_facts'
 | /usr/share/foreman/app/models/host/base.rb:151:in `import_facts'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/foreman-tasks-0.7.16/app/lib/actions/foreman/host/import_facts.rb:25:in `block in run'
 | /usr/share/foreman/app/models/concerns/foreman/thread_session.rb:72:in `as'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/foreman-tasks-0.7.16/app/lib/actions/foreman/host/import_facts.rb:23:in `run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:506:in `block (3 levels) in execute_run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/stack.rb:26:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/stack.rb:26:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware.rb:17:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action/progress.rb:30:in `with_progress_calculation'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action/progress.rb:16:in `run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/stack.rb:22:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/stack.rb:26:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware.rb:17:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware.rb:30:in `run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/stack.rb:22:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/middleware/world.rb:30:in `execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:505:in `block (2 levels) in execute_run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:504:in `catch'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:504:in `block in execute_run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:419:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:419:in `block in with_error_handling'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:419:in `catch'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:419:in `with_error_handling'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:499:in `execute_run'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/action.rb:260:in `execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:9:in `block (2 levels) in execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract.rb:155:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract.rb:155:in `with_meta_calculation'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:8:in `block in execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:22:in `open_action'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:7:in `execute'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/executors/parallel/worker.rb:15:in `block in on_message'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:74:in `block in assigns'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:73:in `tap'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:73:in `assigns'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matching.rb:56:in `match_value'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matching.rb:36:in `block in match?'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matching.rb:35:in `each'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matching.rb:35:in `match?'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/algebrick-0.7.3/lib/algebrick/matching.rb:23:in `match'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/executors/parallel/worker.rb:12:in `on_message'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/context.rb:46:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/executes_context.rb:7:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/dynflow-0.8.10/lib/dynflow/actor.rb:26:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/awaits.rb:15:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/sets_results.rb:14:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/buffer.rb:38:in `process_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/buffer.rb:31:in `process_envelopes?'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/buffer.rb:20:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/termination.rb:55:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/removes_child.rb:10:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/behaviour/sets_results.rb:14:in `on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/core.rb:161:in `process_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/core.rb:95:in `block in on_envelope'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/core.rb:118:in `block (2 levels) in schedule_execution'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/synchronization/mri_lockable_object.rb:62:in `block in synchronize'
 | /usr/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/synchronization/mri_lockable_object.rb:62:in `synchronize'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-edge-0.2.0/lib/concurrent/actor/core.rb:115:in `block in schedule_execution'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/serialized_execution.rb:18:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/serialized_execution.rb:18:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/serialized_execution.rb:96:in `work'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/serialized_execution.rb:77:in `block in call_job'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:348:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:348:in `run_task'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:337:in `block (3 levels) in create_worker'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:320:in `loop'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:320:in `block (2 levels) in create_worker'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:319:in `catch'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/concurrent-ruby-1.0.1/lib/concurrent/executor/ruby_thread_pool_executor.rb:319:in `block in create_worker'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/logging-2.1.0/lib/logging/diagnostic_context.rb:450:in `call'
 | /usr/share/foreman/vendor/ruby/1.9.1/gems/logging-2.1.0/lib/logging/diagnostic_context.rb:450:in `block in create_with_logging_context'
Actions #1

Updated by Marek Hulán almost 8 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF