Project

General

Profile

Defect #27283 » migration-error-trace.txt

Akiko Takano, 2017-10-24 18:09

 
1
== 20141122124142 AddWikiRedirectsRedirectsToWikiId: migrated (2.4166s) =======
2

    
3
== 20150113194759 CreateEmailAddresses: migrating =============================
4
-- adapter_name()
5
   -> 0.0005s
6
-- adapter_name()
7
   -> 0.0003s
8
-- create_table(:email_addresses, {:id=>:integer})
9
rake aborted!
10
StandardError: An error has occurred, all later migrations canceled:
11

    
12
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
13
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query'
14
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query'
15
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt'
16
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query'
17
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
18
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
19
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
20
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
21
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
22
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'
23
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'
24
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
25
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'
26
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
27
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute'
28
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
29
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
30
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing'
31
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time'
32
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time'
33
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing'
34
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table'
35
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table'
36
/tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change'
37
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration'
38
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
39
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate'
40
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
41
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate'
42
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate'
43
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
44
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction'
45
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
46
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
47
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each'
48
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock'
49
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate'
50
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock'
51
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate'
52
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up'
53
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate'
54
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
55
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
56
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
57
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query'
58
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query'
59
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt'
60
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query'
61
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
62
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
63
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
64
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
65
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
66
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'
67
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'
68
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
69
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'
70
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
71
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute'
72
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
73
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
74
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing'
75
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time'
76
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time'
77
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing'
78
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table'
79
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table'
80
/tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change'
81
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration'
82
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
83
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate'
84
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
85
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate'
86
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate'
87
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
88
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction'
89
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
90
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
91
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each'
92
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock'
93
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate'
94
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock'
95
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate'
96
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up'
97
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate'
98
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
99
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
100
Mysql2::Error: Invalid default value for 'updated_on'
101
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `_query'
102
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in `block in query'
103
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `handle_interrupt'
104
/usr/local/bundle/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in `query'
105
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:214:in `block (2 levels) in execute'
106
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
107
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
108
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
109
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:213:in `block in execute'
110
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'
111
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'
112
/usr/local/bundle/gems/activesupport-5.1.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
113
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'
114
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:212:in `execute'
115
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/mysql/database_statements.rb:22:in `execute'
116
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'
117
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:363:in `create_table'
118
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:849:in `block in method_missing'
119
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `block in say_with_time'
120
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:818:in `say_with_time'
121
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:838:in `method_missing'
122
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:45:in `create_table'
123
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration/compatibility.rb:91:in `create_table'
124
/tmp/redmine/db/migrate/20150113194759_create_email_addresses.rb:3:in `change'
125
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:792:in `exec_migration'
126
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
127
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:775:in `block in migrate'
128
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
129
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:774:in `migrate'
130
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:953:in `migrate'
131
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
132
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1300:in `ddl_transaction'
133
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
134
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
135
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `each'
136
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1200:in `migrate_without_lock'
137
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `block in migrate'
138
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1317:in `with_advisory_lock'
139
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1148:in `migrate'
140
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:1007:in `up'
141
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/migration.rb:985:in `migrate'
142
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
143
/usr/local/bundle/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
144
Tasks: TOP => db:migrate
145
(See full trace by running task with --trace)
(2-2/4)