== 20141122124142 AddWikiRedirectsRedirectsToWikiId: migrated (2.4166s) ======= == 20150113194759 CreateEmailAddresses: migrating ============================= -- adapter_name() -> 0.0005s -- adapter_name() -> 0.0003s -- create_table(:email_addresses, {:id=>:integer}) rake aborted! StandardError: An error has occurred, all later migrations canceled: Mysql2::Error: Invalid default value for 'updated_on': CREATE TABLE `email_addresses` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` int NOT NULL, `address` varchar(255) NOT NULL, `is_default` tinyint(1) DEFAULT 0 NOT NULL, `notify` tinyint(1) DEFAULT 1 NOT NULL, `created_on` timestamp NOT NULL, `updated_on` timestamp NOT NULL) ENGINE=InnoDB /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table' /tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in ' ActiveRecord::StatementInvalid: Mysql2::Error: Invalid default value for 'updated_on': CREATE TABLE `email_addresses` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` int NOT NULL, `address` varchar(255) NOT NULL, `is_default` tinyint(1) DEFAULT 0 NOT NULL, `notify` tinyint(1) DEFAULT 1 NOT NULL, `created_on` timestamp NOT NULL, `updated_on` timestamp NOT NULL) ENGINE=InnoDB /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table' /tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in ' Mysql2::Error: Invalid default value for 'updated_on' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt' /usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log' /usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table' /tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate' /usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in ' Tasks: TOP => db:migrate (See full trace by running task with --trace)