ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

chili1.txt

migration log after repository deletion - Serg Zhum, 2011-07-25 06:06 am

Download (19 kB)

 
1
# RAILS_ENV="production" rake db:migrate
2
==  BuildProjectsTree: migrating ==============================================
3
==  BuildProjectsTree: migrated (0.4724s) =====================================
4
5
==  RemoveProjectsProjectsCount: migrating ====================================
6
-- remove_column(:projects, :projects_count)
7
   -> 0.1241s
8
==  RemoveProjectsProjectsCount: migrated (0.1243s) ===========================
9
10
==  AddOpenIdAuthenticationTables: migrating ==================================
11
-- create_table(:open_id_authentication_associations, {:force=>true})
12
   -> 0.0722s
13
-- create_table(:open_id_authentication_nonces, {:force=>true})
14
   -> 0.0833s
15
==  AddOpenIdAuthenticationTables: migrated (0.1558s) =========================
16
17
==  AddIdentityUrlToUsers: migrating ==========================================
18
-- add_column(:users, :identity_url, :string)
19
   -> 0.1077s
20
==  AddIdentityUrlToUsers: migrated (0.1078s) =================================
21
22
==  AddWatchersUserIdTypeIndex: migrating =====================================
23
-- add_index(:watchers, [:user_id, :watchable_type], {:name=>:watchers_user_id_type})
24
   -> 0.2011s
25
==  AddWatchersUserIdTypeIndex: migrated (0.2013s) ============================
26
27
==  AddQueriesSortCriteria: migrating =========================================
28
-- add_column(:queries, :sort_criteria, :text)
29
   -> 0.1076s
30
==  AddQueriesSortCriteria: migrated (0.1077s) ================================
31
32
==  AddProjectsTrackersUniqueIndex: migrating =================================
33
-- add_index(:projects_trackers, [:project_id, :tracker_id], {:unique=>true, :name=>:projects_trackers_unique})
34
   -> 0.1117s
35
==  AddProjectsTrackersUniqueIndex: migrated (0.1328s) ========================
36
37
==  ExtendSettingsName: migrating =============================================
38
-- change_column(:settings, :name, :string, {:null=>false, :limit=>255, :default=>""})
39
   -> 0.1253s
40
==  ExtendSettingsName: migrated (0.1255s) ====================================
41
42
==  AddTypeToEnumerations: migrating ==========================================
43
-- add_column(:enumerations, :type, :string)
44
   -> 0.0993s
45
==  AddTypeToEnumerations: migrated (0.0994s) =================================
46
47
==  UpdateEnumerationsToSti: migrating ========================================
48
==  UpdateEnumerationsToSti: migrated (0.0410s) ===============================
49
50
==  AddActiveFieldToEnumerations: migrating ===================================
51
-- add_column(:enumerations, :active, :boolean, {:null=>false, :default=>true})
52
   -> 0.1076s
53
==  AddActiveFieldToEnumerations: migrated (0.1078s) ==========================
54
55
==  AddProjectToEnumerations: migrating =======================================
56
-- add_column(:enumerations, :project_id, :integer, {:null=>true, :default=>nil})
57
   -> 0.1076s
58
-- add_index(:enumerations, :project_id)
59
   -> 0.1916s
60
==  AddProjectToEnumerations: migrated (0.3083s) ==============================
61
62
==  AddParentIdToEnumerations: migrating ======================================
63
-- add_column(:enumerations, :parent_id, :integer, {:null=>true, :default=>nil})
64
   -> 0.0993s
65
==  AddParentIdToEnumerations: migrated (0.0994s) =============================
66
67
==  AddQueriesGroupBy: migrating ==============================================
68
-- add_column(:queries, :group_by, :string)
69
   -> 0.0995s
70
==  AddQueriesGroupBy: migrated (0.0996s) =====================================
71
72
==  CreateMemberRoles: migrating ==============================================
73
-- create_table(:member_roles)
74
   -> 0.0659s
75
==  CreateMemberRoles: migrated (0.0661s) =====================================
76
77
==  PopulateMemberRoles: migrating ============================================
78
==  PopulateMemberRoles: migrated (0.9319s) ===================================
79
80
==  DropMembersRoleId: migrating ==============================================
81
-- remove_column(:members, :role_id)
82
   -> 0.1164s
83
==  DropMembersRoleId: migrated (0.1165s) =====================================
84
85
==  FixMessagesStickyNull: migrating ==========================================
86
==  FixMessagesStickyNull: migrated (0.0077s) =================================
87
88
==  PopulateUsersType: migrating ==============================================
89
==  PopulateUsersType: migrated (0.0162s) =====================================
90
91
==  CreateGroupsUsers: migrating ==============================================
92
-- create_table(:groups_users, {:id=>false})
93
   -> 0.0659s
94
-- add_index(:groups_users, [:group_id, :user_id], {:unique=>true, :name=>:groups_users_ids})
95
   -> 0.0916s
96
==  CreateGroupsUsers: migrated (0.1578s) =====================================
97
98
==  AddMemberRolesInheritedFrom: migrating ====================================
99
-- add_column(:member_roles, :inherited_from, :integer)
100
   -> 0.0995s
101
==  AddMemberRolesInheritedFrom: migrated (0.0996s) ===========================
102
103
==  FixUsersCustomValues: migrating ===========================================
104
==  FixUsersCustomValues: migrated (0.0025s) ==================================
105
106
==  AddMissingIndexesToWorkflows: migrating ===================================
107
-- add_index(:workflows, :old_status_id)
108
   -> 0.1247s
109
-- add_index(:workflows, :role_id)
110
   -> 0.1836s
111
-- add_index(:workflows, :new_status_id)
112
   -> 0.1256s
113
==  AddMissingIndexesToWorkflows: migrated (0.4343s) ==========================
114
115
==  AddMissingIndexesToCustomFieldsProjects: migrating ========================
116
-- add_index(:custom_fields_projects, [:custom_field_id, :project_id])
117
   -> 0.0995s
118
==  AddMissingIndexesToCustomFieldsProjects: migrated (0.0996s) ===============
119
120
==  AddMissingIndexesToMessages: migrating ====================================
121
-- add_index(:messages, :last_reply_id)
122
   -> 0.1163s
123
-- add_index(:messages, :author_id)
124
   -> 0.1169s
125
==  AddMissingIndexesToMessages: migrated (0.2334s) ===========================
126
127
==  AddMissingIndexesToRepositories: migrating ================================
128
-- add_index(:repositories, :project_id)
129
   -> 0.1078s
130
==  AddMissingIndexesToRepositories: migrated (0.1080s) =======================
131
132
==  AddMissingIndexesToComments: migrating ====================================
133
-- add_index(:comments, [:commented_id, :commented_type])
134
   -> 0.1078s
135
-- add_index(:comments, :author_id)
136
   -> 0.1000s
137
==  AddMissingIndexesToComments: migrated (0.2080s) ===========================
138
139
==  AddMissingIndexesToEnumerations: migrating ================================
140
-- add_index(:enumerations, [:id, :type])
141
   -> 0.1495s
142
==  AddMissingIndexesToEnumerations: migrated (0.1496s) =======================
143
144
==  AddMissingIndexesToWikiPages: migrating ===================================
145
-- add_index(:wiki_pages, :wiki_id)
146
   -> 0.1162s
147
-- add_index(:wiki_pages, :parent_id)
148
   -> 0.1086s
149
==  AddMissingIndexesToWikiPages: migrated (0.2250s) ==========================
150
151
==  AddMissingIndexesToWatchers: migrating ====================================
152
-- add_index(:watchers, :user_id)
153
   -> 0.1867s
154
-- add_index(:watchers, [:watchable_id, :watchable_type])
155
   -> 0.2283s
156
==  AddMissingIndexesToWatchers: migrated (0.4152s) ===========================
157
158
==  AddMissingIndexesToAuthSources: migrating =================================
159
-- add_index(:auth_sources, [:id, :type])
160
   -> 0.1036s
161
==  AddMissingIndexesToAuthSources: migrated (0.1038s) ========================
162
163
==  AddMissingIndexesToDocuments: migrating ===================================
164
-- add_index(:documents, :category_id)
165
   -> 0.1203s
166
==  AddMissingIndexesToDocuments: migrated (0.1204s) ==========================
167
168
==  AddMissingIndexesToTokens: migrating ======================================
169
-- add_index(:tokens, :user_id)
170
   -> 0.1579s
171
==  AddMissingIndexesToTokens: migrated (0.1580s) =============================
172
173
==  AddMissingIndexesToChangesets: migrating ==================================
174
-- add_index(:changesets, :user_id)
175
   -> 0.1116s
176
-- add_index(:changesets, :repository_id)
177
   -> 0.1083s
178
==  AddMissingIndexesToChangesets: migrated (0.2200s) =========================
179
180
==  AddMissingIndexesToIssueCategories: migrating =============================
181
-- add_index(:issue_categories, :assigned_to_id)
182
   -> 0.1076s
183
==  AddMissingIndexesToIssueCategories: migrated (0.1077s) ====================
184
185
==  AddMissingIndexesToMemberRoles: migrating =================================
186
-- add_index(:member_roles, :member_id)
187
   -> 0.0994s
188
-- add_index(:member_roles, :role_id)
189
   -> 0.1082s
190
==  AddMissingIndexesToMemberRoles: migrated (0.2078s) ========================
191
192
==  AddMissingIndexesToBoards: migrating ======================================
193
-- add_index(:boards, :last_message_id)
194
   -> 0.1046s
195
==  AddMissingIndexesToBoards: migrated (0.1047s) =============================
196
197
==  AddMissingIndexesToUserPreferences: migrating =============================
198
-- add_index(:user_preferences, :user_id)
199
   -> 0.1078s
200
==  AddMissingIndexesToUserPreferences: migrated (0.1079s) ====================
201
202
==  AddMissingIndexesToIssues: migrating ======================================
203
-- add_index(:issues, :status_id)
204
   -> 0.1715s
205
-- add_index(:issues, :category_id)
206
   -> 0.1940s
207
-- add_index(:issues, :assigned_to_id)
208
   -> 0.1369s
209
-- add_index(:issues, :fixed_version_id)
210
   -> 0.1535s
211
-- add_index(:issues, :tracker_id)
212
   -> 0.1616s
213
-- add_index(:issues, :priority_id)
214
   -> 0.1629s
215
-- add_index(:issues, :author_id)
216
   -> 0.1785s
217
==  AddMissingIndexesToIssues: migrated (1.1596s) =============================
218
219
==  AddMissingIndexesToMembers: migrating =====================================
220
-- add_index(:members, :user_id)
221
   -> 0.1161s
222
-- add_index(:members, :project_id)
223
   -> 0.1084s
224
==  AddMissingIndexesToMembers: migrated (0.2247s) ============================
225
226
==  AddMissingIndexesToCustomFields: migrating ================================
227
-- add_index(:custom_fields, [:id, :type])
228
   -> 0.0994s
229
==  AddMissingIndexesToCustomFields: migrated (0.0996s) =======================
230
231
==  AddMissingIndexesToQueries: migrating =====================================
232
-- add_index(:queries, :project_id)
233
   -> 0.0993s
234
-- add_index(:queries, :user_id)
235
   -> 0.1000s
236
==  AddMissingIndexesToQueries: migrated (0.1995s) ============================
237
238
==  AddMissingIndexesToTimeEntries: migrating =================================
239
-- add_index(:time_entries, :activity_id)
240
   -> 0.0994s
241
-- add_index(:time_entries, :user_id)
242
   -> 0.1334s
243
==  AddMissingIndexesToTimeEntries: migrated (0.2331s) ========================
244
245
==  AddMissingIndexesToNews: migrating ========================================
246
-- add_index(:news, :author_id)
247
   -> 0.1535s
248
==  AddMissingIndexesToNews: migrated (0.1536s) ===============================
249
250
==  AddMissingIndexesToUsers: migrating =======================================
251
-- add_index(:users, [:id, :type])
252
   -> 0.1205s
253
-- add_index(:users, :auth_source_id)
254
   -> 0.1084s
255
==  AddMissingIndexesToUsers: migrated (0.2291s) ==============================
256
257
==  AddMissingIndexesToAttachments: migrating =================================
258
-- add_index(:attachments, [:container_id, :container_type])
259
   -> 0.1167s
260
-- add_index(:attachments, :author_id)
261
   -> 0.1257s
262
==  AddMissingIndexesToAttachments: migrated (0.2427s) ========================
263
264
==  AddMissingIndexesToWikiContents: migrating ================================
265
-- add_index(:wiki_contents, :author_id)
266
   -> 0.1399s
267
==  AddMissingIndexesToWikiContents: migrated (0.1400s) =======================
268
269
==  AddMissingIndexesToCustomValues: migrating ================================
270
-- add_index(:custom_values, :custom_field_id)
271
   -> 0.0993s
272
==  AddMissingIndexesToCustomValues: migrated (0.0994s) =======================
273
274
==  AddMissingIndexesToJournals: migrating ====================================
275
-- add_index(:journals, :user_id)
276
   -> 0.2225s
277
-- add_index(:journals, :journalized_id)
278
   -> 0.2636s
279
==  AddMissingIndexesToJournals: migrated (0.4863s) ===========================
280
281
==  AddMissingIndexesToIssueRelations: migrating ==============================
282
-- add_index(:issue_relations, :issue_from_id)
283
   -> 0.1028s
284
-- add_index(:issue_relations, :issue_to_id)
285
   -> 0.1083s
286
==  AddMissingIndexesToIssueRelations: migrated (0.2112s) =====================
287
288
==  AddMissingIndexesToWikiRedirects: migrating ===============================
289
-- add_index(:wiki_redirects, :wiki_id)
290
   -> 0.1079s
291
==  AddMissingIndexesToWikiRedirects: migrated (0.1080s) ======================
292
293
==  AddMissingIndexesToCustomFieldsTrackers: migrating ========================
294
-- add_index(:custom_fields_trackers, [:custom_field_id, :tracker_id])
295
   -> 0.0992s
296
==  AddMissingIndexesToCustomFieldsTrackers: migrated (0.0993s) ===============
297
298
==  AddActivityIndexes: migrating =============================================
299
-- add_index(:journals, :created_on)
300
   -> 0.7744s
301
-- add_index(:changesets, :committed_on)
302
   -> 0.1247s
303
-- add_index(:wiki_content_versions, :updated_on)
304
   -> 0.6233s
305
-- add_index(:messages, :created_on)
306
   -> 0.1249s
307
-- add_index(:issues, :created_on)
308
   -> 0.1288s
309
-- add_index(:news, :created_on)
310
   -> 0.0917s
311
-- add_index(:attachments, :created_on)
312
   -> 0.1087s
313
-- add_index(:documents, :created_on)
314
   -> 0.0917s
315
-- add_index(:time_entries, :created_on)
316
   -> 0.0833s
317
==  AddActivityIndexes: migrated (2.1526s) ====================================
318
319
==  AddVersionsStatus: migrating ==============================================
320
-- add_column(:versions, :status, :string, {:default=>"open"})
321
   -> 0.1325s
322
==  AddVersionsStatus: migrated (0.1407s) =====================================
323
324
==  AddViewIssuesPermission: migrating ========================================
325
==  AddViewIssuesPermission: migrated (0.0743s) ===============================
326
327
==  AddDefaultDoneRatioToIssueStatus: migrating ===============================
328
-- add_column(:issue_statuses, :default_done_ratio, :integer)
329
   -> 0.0993s
330
==  AddDefaultDoneRatioToIssueStatus: migrated (0.0994s) ======================
331
332
==  AddVersionsSharing: migrating =============================================
333
-- add_column(:versions, :sharing, :string, {:null=>false, :default=>"none"})
334
   -> 0.0994s
335
-- add_index(:versions, :sharing)
336
   -> 0.1332s
337
==  AddVersionsSharing: migrated (0.2328s) ====================================
338
339
==  AddLftAndRgtIndexesToProjects: migrating ==================================
340
-- add_index(:projects, :lft)
341
   -> 0.1077s
342
-- add_index(:projects, :rgt)
343
   -> 0.1166s
344
==  AddLftAndRgtIndexesToProjects: migrated (0.2245s) =========================
345
346
==  AddIndexToSettingsName: migrating =========================================
347
-- add_index(:settings, :name)
348
   -> 0.1328s
349
==  AddIndexToSettingsName: migrated (0.1329s) ================================
350
351
==  AddIndexesToIssueStatus: migrating ========================================
352
-- add_index(:issue_statuses, :position)
353
   -> 0.0994s
354
-- add_index(:issue_statuses, :is_closed)
355
   -> 0.1751s
356
-- add_index(:issue_statuses, :is_default)
357
   -> 0.1000s
358
==  AddIndexesToIssueStatus: migrated (0.3748s) ===============================
359
360
==  RemoveEnumerationsOpt: migrating ==========================================
361
-- remove_column(:enumerations, :opt)
362
   -> 0.0994s
363
==  RemoveEnumerationsOpt: migrated (0.0995s) =================================
364
365
==  ChangeWikiContentsTextLimit: migrating ====================================
366
-- change_column(:wiki_contents, :text, :text, {:limit=>16777216})
367
   -> 0.4020s
368
-- change_column(:wiki_content_versions, :data, :binary, {:limit=>16777216})
369
   -> 1.3896s
370
==  ChangeWikiContentsTextLimit: migrated (1.7998s) ===========================
371
372
==  ChangeUsersMailNotificationToString: migrating ============================
373
-- rename_column(:users, :mail_notification, :mail_notification_bool)
374
   -> 0.1159s
375
-- add_column(:users, :mail_notification, :string, {:null=>false, :default=>""})
376
   -> 0.1001s
377
-- remove_column(:users, :mail_notification_bool)
378
   -> 0.1003s
379
==  ChangeUsersMailNotificationToString: migrated (0.4334s) ===================
380
381
==  UpdateMailNotificationValues: migrating ===================================
382
==  UpdateMailNotificationValues: migrated (0.0000s) ==========================
383
384
==  AddIndexOnChangesetsScmid: migrating ======================================
385
-- add_index(:changesets, [:repository_id, :scmid], {:name=>:changesets_repos_scmid})
386
   -> 0.1161s
387
==  AddIndexOnChangesetsScmid: migrated (0.1163s) =============================
388
389
==  AddIssuesNestedSetsColumns: migrating =====================================
390
-- add_column(:issues, :parent_id, :integer, {:default=>nil})
391
   -> 0.1446s
392
-- add_column(:issues, :root_id, :integer, {:default=>nil})
393
   -> 0.2381s
394
-- add_column(:issues, :lft, :integer, {:default=>nil})
395
   -> 0.1286s
396
-- add_column(:issues, :rgt, :integer, {:default=>nil})
397
   -> 0.1548s
398
==  AddIssuesNestedSetsColumns: migrated (0.7028s) ============================
399
400
==  AddIndexOnIssuesNestedSet: migrating ======================================
401
-- add_index(:issues, [:root_id, :lft, :rgt])
402
   -> 0.1642s
403
==  AddIndexOnIssuesNestedSet: migrated (0.1643s) =============================
404
405
==  ChangeChangesPathLengthLimit: migrating ===================================
406
-- change_column(:changes, :path, :text, {:null=>true, :default=>nil})
407
   -> 0.0993s
408
-- change_column(:changes, :path, :text, {:null=>false})
409
   -> 0.0998s
410
-- change_column(:changes, :from_path, :text)
411
   -> 0.1082s
412
==  ChangeChangesPathLengthLimit: migrated (0.3076s) ==========================
413
414
==  PrepareJournalsForActsAsJournalized: migrating ============================
415
-- change_table(:journals)
416
   -> 2.8805s
417
==  PrepareJournalsForActsAsJournalized: migrated (2.8809s) ===================
418
419
==  UpdateJournalsForActsAsJournalized: migrating =============================
420
-- Updating existing Journals...
421
   -> 46.5184s
422
-- change_table(:journals)
423
   -> 0.2060s
424
==  UpdateJournalsForActsAsJournalized: migrated (46.7247s) ===================
425
426
==  BuildInitialJournalsForActsAsJournalized: migrating =======================
427
-- Building initial journals for Message
428
rake aborted!
429
An error has occurred, all later migrations canceled:
430
431
Mysql::Error: Unknown column 'members.role_id' in 'field list': SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`role_id` AS t0_r3, `members`.`created_on` AS t0_r4, `members`.`mail_notification` AS t0_r5, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification_bool` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `users`.`mail_notification` AS t1_r16, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members`  LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND  (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' )  LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`)  LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 14 AND (users.type='User' AND users.status=1)) 
432
433
Tasks: TOP => db:migrate
434
(See full trace by running task with --trace)