Project

General

Profile

Actions
Copy link

Bug #14760

closed

foreman-chef 0.3.1 foreman-rake db:migrate fails when using mysql/mariadb

Added by Elias Abacioglu over 8 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
High
Assignee:
Marek Hulán
Category:
foreman_chef
Target version:
foreman_chef 0.4.0
Difficulty:
trivial
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman_chef/pull/46
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

After upgrade of foreman and foreman-chef db migrate fails when using mysql/mariadb.

foreman-rake db:migrate
== 20150916141657 CreateChefEnvironment: migrating ============================
-- create_table(:foreman_chef_environments)
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: BLOB/TEXT column 'description' can't have a default value: CREATE TABLE `foreman_chef_environments` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255) DEFAULT '' NOT NULL, `description` text DEFAULT '', `chef_proxy_id` int(11) NOT NULL, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB/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/abstract/schema_statements.rb:205:in `create_table'
/usr/share/foreman/vendor/ruby/1.9.1/gems/foreigner-1.7.4/lib/foreigner/connection_adapters/abstract/schema_statements.rb:14:in `create_table'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:460:in `create_table'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:656:in `block in method_missing'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `block in say_with_time'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:628:in `say_with_time'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:648:in `method_missing'
/usr/share/foreman/vendor/ruby/1.9.1/gems/foreman_chef-0.3.1/db/migrate/20150916141657_create_chef_environment.rb:3:in `up'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:605:in `exec_migration'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:585:in `block in migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:584:in `migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:759:in `migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:1046:in `ddl_transaction'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:959:in `block in migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `each'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:955:in `migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:814:in `up'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/migration.rb:792:in `migrate'
/usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-4.1.14.2/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
/usr/bin/rake1.9.1:32:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
Actions
Copy link
 #1

Updated by Marek Hulán over 8 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Tomer Brisker over 8 years ago

  • Project changed from Foreman to Chef
  • Category changed from DB migrations to foreman_chef
Actions
Copy link
 #3

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Marek Hulán
  • Pull request https://github.com/theforeman/foreman_chef/pull/46 added
Actions
Copy link
 #4

Updated by Marek Hulán over 8 years ago

  • Translation missing: en.field_release set to 148
Actions
Copy link
 #5

Updated by Marek Hulán over 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF