Bug #14760
Updated by Marek Hulán over 8 years ago
After upgrade of foreman and foreman-chef db migrate fails when using mysql/mariadb. foreman-rake db:migrate <pre> == 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) </pre>