# RAILS_ENV="production" rake db:migrate == BuildProjectsTree: migrating ============================================== == BuildProjectsTree: migrated (0.4724s) ===================================== == RemoveProjectsProjectsCount: migrating ==================================== -- remove_column(:projects, :projects_count) -> 0.1241s == RemoveProjectsProjectsCount: migrated (0.1243s) =========================== == AddOpenIdAuthenticationTables: migrating ================================== -- create_table(:open_id_authentication_associations, {:force=>true}) -> 0.0722s -- create_table(:open_id_authentication_nonces, {:force=>true}) -> 0.0833s == AddOpenIdAuthenticationTables: migrated (0.1558s) ========================= == AddIdentityUrlToUsers: migrating ========================================== -- add_column(:users, :identity_url, :string) -> 0.1077s == AddIdentityUrlToUsers: migrated (0.1078s) ================================= == AddWatchersUserIdTypeIndex: migrating ===================================== -- add_index(:watchers, [:user_id, :watchable_type], {:name=>:watchers_user_id_type}) -> 0.2011s == AddWatchersUserIdTypeIndex: migrated (0.2013s) ============================ == AddQueriesSortCriteria: migrating ========================================= -- add_column(:queries, :sort_criteria, :text) -> 0.1076s == AddQueriesSortCriteria: migrated (0.1077s) ================================ == AddProjectsTrackersUniqueIndex: migrating ================================= -- add_index(:projects_trackers, [:project_id, :tracker_id], {:unique=>true, :name=>:projects_trackers_unique}) -> 0.1117s == AddProjectsTrackersUniqueIndex: migrated (0.1328s) ======================== == ExtendSettingsName: migrating ============================================= -- change_column(:settings, :name, :string, {:null=>false, :limit=>255, :default=>""}) -> 0.1253s == ExtendSettingsName: migrated (0.1255s) ==================================== == AddTypeToEnumerations: migrating ========================================== -- add_column(:enumerations, :type, :string) -> 0.0993s == AddTypeToEnumerations: migrated (0.0994s) ================================= == UpdateEnumerationsToSti: migrating ======================================== == UpdateEnumerationsToSti: migrated (0.0410s) =============================== == AddActiveFieldToEnumerations: migrating =================================== -- add_column(:enumerations, :active, :boolean, {:null=>false, :default=>true}) -> 0.1076s == AddActiveFieldToEnumerations: migrated (0.1078s) ========================== == AddProjectToEnumerations: migrating ======================================= -- add_column(:enumerations, :project_id, :integer, {:null=>true, :default=>nil}) -> 0.1076s -- add_index(:enumerations, :project_id) -> 0.1916s == AddProjectToEnumerations: migrated (0.3083s) ============================== == AddParentIdToEnumerations: migrating ====================================== -- add_column(:enumerations, :parent_id, :integer, {:null=>true, :default=>nil}) -> 0.0993s == AddParentIdToEnumerations: migrated (0.0994s) ============================= == AddQueriesGroupBy: migrating ============================================== -- add_column(:queries, :group_by, :string) -> 0.0995s == AddQueriesGroupBy: migrated (0.0996s) ===================================== == CreateMemberRoles: migrating ============================================== -- create_table(:member_roles) -> 0.0659s == CreateMemberRoles: migrated (0.0661s) ===================================== == PopulateMemberRoles: migrating ============================================ == PopulateMemberRoles: migrated (0.9319s) =================================== == DropMembersRoleId: migrating ============================================== -- remove_column(:members, :role_id) -> 0.1164s == DropMembersRoleId: migrated (0.1165s) ===================================== == FixMessagesStickyNull: migrating ========================================== == FixMessagesStickyNull: migrated (0.0077s) ================================= == PopulateUsersType: migrating ============================================== == PopulateUsersType: migrated (0.0162s) ===================================== == CreateGroupsUsers: migrating ============================================== -- create_table(:groups_users, {:id=>false}) -> 0.0659s -- add_index(:groups_users, [:group_id, :user_id], {:unique=>true, :name=>:groups_users_ids}) -> 0.0916s == CreateGroupsUsers: migrated (0.1578s) ===================================== == AddMemberRolesInheritedFrom: migrating ==================================== -- add_column(:member_roles, :inherited_from, :integer) -> 0.0995s == AddMemberRolesInheritedFrom: migrated (0.0996s) =========================== == FixUsersCustomValues: migrating =========================================== == FixUsersCustomValues: migrated (0.0025s) ================================== == AddMissingIndexesToWorkflows: migrating =================================== -- add_index(:workflows, :old_status_id) -> 0.1247s -- add_index(:workflows, :role_id) -> 0.1836s -- add_index(:workflows, :new_status_id) -> 0.1256s == AddMissingIndexesToWorkflows: migrated (0.4343s) ========================== == AddMissingIndexesToCustomFieldsProjects: migrating ======================== -- add_index(:custom_fields_projects, [:custom_field_id, :project_id]) -> 0.0995s == AddMissingIndexesToCustomFieldsProjects: migrated (0.0996s) =============== == AddMissingIndexesToMessages: migrating ==================================== -- add_index(:messages, :last_reply_id) -> 0.1163s -- add_index(:messages, :author_id) -> 0.1169s == AddMissingIndexesToMessages: migrated (0.2334s) =========================== == AddMissingIndexesToRepositories: migrating ================================ -- add_index(:repositories, :project_id) -> 0.1078s == AddMissingIndexesToRepositories: migrated (0.1080s) ======================= == AddMissingIndexesToComments: migrating ==================================== -- add_index(:comments, [:commented_id, :commented_type]) -> 0.1078s -- add_index(:comments, :author_id) -> 0.1000s == AddMissingIndexesToComments: migrated (0.2080s) =========================== == AddMissingIndexesToEnumerations: migrating ================================ -- add_index(:enumerations, [:id, :type]) -> 0.1495s == AddMissingIndexesToEnumerations: migrated (0.1496s) ======================= == AddMissingIndexesToWikiPages: migrating =================================== -- add_index(:wiki_pages, :wiki_id) -> 0.1162s -- add_index(:wiki_pages, :parent_id) -> 0.1086s == AddMissingIndexesToWikiPages: migrated (0.2250s) ========================== == AddMissingIndexesToWatchers: migrating ==================================== -- add_index(:watchers, :user_id) -> 0.1867s -- add_index(:watchers, [:watchable_id, :watchable_type]) -> 0.2283s == AddMissingIndexesToWatchers: migrated (0.4152s) =========================== == AddMissingIndexesToAuthSources: migrating ================================= -- add_index(:auth_sources, [:id, :type]) -> 0.1036s == AddMissingIndexesToAuthSources: migrated (0.1038s) ======================== == AddMissingIndexesToDocuments: migrating =================================== -- add_index(:documents, :category_id) -> 0.1203s == AddMissingIndexesToDocuments: migrated (0.1204s) ========================== == AddMissingIndexesToTokens: migrating ====================================== -- add_index(:tokens, :user_id) -> 0.1579s == AddMissingIndexesToTokens: migrated (0.1580s) ============================= == AddMissingIndexesToChangesets: migrating ================================== -- add_index(:changesets, :user_id) -> 0.1116s -- add_index(:changesets, :repository_id) -> 0.1083s == AddMissingIndexesToChangesets: migrated (0.2200s) ========================= == AddMissingIndexesToIssueCategories: migrating ============================= -- add_index(:issue_categories, :assigned_to_id) -> 0.1076s == AddMissingIndexesToIssueCategories: migrated (0.1077s) ==================== == AddMissingIndexesToMemberRoles: migrating ================================= -- add_index(:member_roles, :member_id) -> 0.0994s -- add_index(:member_roles, :role_id) -> 0.1082s == AddMissingIndexesToMemberRoles: migrated (0.2078s) ======================== == AddMissingIndexesToBoards: migrating ====================================== -- add_index(:boards, :last_message_id) -> 0.1046s == AddMissingIndexesToBoards: migrated (0.1047s) ============================= == AddMissingIndexesToUserPreferences: migrating ============================= -- add_index(:user_preferences, :user_id) -> 0.1078s == AddMissingIndexesToUserPreferences: migrated (0.1079s) ==================== == AddMissingIndexesToIssues: migrating ====================================== -- add_index(:issues, :status_id) -> 0.1715s -- add_index(:issues, :category_id) -> 0.1940s -- add_index(:issues, :assigned_to_id) -> 0.1369s -- add_index(:issues, :fixed_version_id) -> 0.1535s -- add_index(:issues, :tracker_id) -> 0.1616s -- add_index(:issues, :priority_id) -> 0.1629s -- add_index(:issues, :author_id) -> 0.1785s == AddMissingIndexesToIssues: migrated (1.1596s) ============================= == AddMissingIndexesToMembers: migrating ===================================== -- add_index(:members, :user_id) -> 0.1161s -- add_index(:members, :project_id) -> 0.1084s == AddMissingIndexesToMembers: migrated (0.2247s) ============================ == AddMissingIndexesToCustomFields: migrating ================================ -- add_index(:custom_fields, [:id, :type]) -> 0.0994s == AddMissingIndexesToCustomFields: migrated (0.0996s) ======================= == AddMissingIndexesToQueries: migrating ===================================== -- add_index(:queries, :project_id) -> 0.0993s -- add_index(:queries, :user_id) -> 0.1000s == AddMissingIndexesToQueries: migrated (0.1995s) ============================ == AddMissingIndexesToTimeEntries: migrating ================================= -- add_index(:time_entries, :activity_id) -> 0.0994s -- add_index(:time_entries, :user_id) -> 0.1334s == AddMissingIndexesToTimeEntries: migrated (0.2331s) ======================== == AddMissingIndexesToNews: migrating ======================================== -- add_index(:news, :author_id) -> 0.1535s == AddMissingIndexesToNews: migrated (0.1536s) =============================== == AddMissingIndexesToUsers: migrating ======================================= -- add_index(:users, [:id, :type]) -> 0.1205s -- add_index(:users, :auth_source_id) -> 0.1084s == AddMissingIndexesToUsers: migrated (0.2291s) ============================== == AddMissingIndexesToAttachments: migrating ================================= -- add_index(:attachments, [:container_id, :container_type]) -> 0.1167s -- add_index(:attachments, :author_id) -> 0.1257s == AddMissingIndexesToAttachments: migrated (0.2427s) ======================== == AddMissingIndexesToWikiContents: migrating ================================ -- add_index(:wiki_contents, :author_id) -> 0.1399s == AddMissingIndexesToWikiContents: migrated (0.1400s) ======================= == AddMissingIndexesToCustomValues: migrating ================================ -- add_index(:custom_values, :custom_field_id) -> 0.0993s == AddMissingIndexesToCustomValues: migrated (0.0994s) ======================= == AddMissingIndexesToJournals: migrating ==================================== -- add_index(:journals, :user_id) -> 0.2225s -- add_index(:journals, :journalized_id) -> 0.2636s == AddMissingIndexesToJournals: migrated (0.4863s) =========================== == AddMissingIndexesToIssueRelations: migrating ============================== -- add_index(:issue_relations, :issue_from_id) -> 0.1028s -- add_index(:issue_relations, :issue_to_id) -> 0.1083s == AddMissingIndexesToIssueRelations: migrated (0.2112s) ===================== == AddMissingIndexesToWikiRedirects: migrating =============================== -- add_index(:wiki_redirects, :wiki_id) -> 0.1079s == AddMissingIndexesToWikiRedirects: migrated (0.1080s) ====================== == AddMissingIndexesToCustomFieldsTrackers: migrating ======================== -- add_index(:custom_fields_trackers, [:custom_field_id, :tracker_id]) -> 0.0992s == AddMissingIndexesToCustomFieldsTrackers: migrated (0.0993s) =============== == AddActivityIndexes: migrating ============================================= -- add_index(:journals, :created_on) -> 0.7744s -- add_index(:changesets, :committed_on) -> 0.1247s -- add_index(:wiki_content_versions, :updated_on) -> 0.6233s -- add_index(:messages, :created_on) -> 0.1249s -- add_index(:issues, :created_on) -> 0.1288s -- add_index(:news, :created_on) -> 0.0917s -- add_index(:attachments, :created_on) -> 0.1087s -- add_index(:documents, :created_on) -> 0.0917s -- add_index(:time_entries, :created_on) -> 0.0833s == AddActivityIndexes: migrated (2.1526s) ==================================== == AddVersionsStatus: migrating ============================================== -- add_column(:versions, :status, :string, {:default=>"open"}) -> 0.1325s == AddVersionsStatus: migrated (0.1407s) ===================================== == AddViewIssuesPermission: migrating ======================================== == AddViewIssuesPermission: migrated (0.0743s) =============================== == AddDefaultDoneRatioToIssueStatus: migrating =============================== -- add_column(:issue_statuses, :default_done_ratio, :integer) -> 0.0993s == AddDefaultDoneRatioToIssueStatus: migrated (0.0994s) ====================== == AddVersionsSharing: migrating ============================================= -- add_column(:versions, :sharing, :string, {:null=>false, :default=>"none"}) -> 0.0994s -- add_index(:versions, :sharing) -> 0.1332s == AddVersionsSharing: migrated (0.2328s) ==================================== == AddLftAndRgtIndexesToProjects: migrating ================================== -- add_index(:projects, :lft) -> 0.1077s -- add_index(:projects, :rgt) -> 0.1166s == AddLftAndRgtIndexesToProjects: migrated (0.2245s) ========================= == AddIndexToSettingsName: migrating ========================================= -- add_index(:settings, :name) -> 0.1328s == AddIndexToSettingsName: migrated (0.1329s) ================================ == AddIndexesToIssueStatus: migrating ======================================== -- add_index(:issue_statuses, :position) -> 0.0994s -- add_index(:issue_statuses, :is_closed) -> 0.1751s -- add_index(:issue_statuses, :is_default) -> 0.1000s == AddIndexesToIssueStatus: migrated (0.3748s) =============================== == RemoveEnumerationsOpt: migrating ========================================== -- remove_column(:enumerations, :opt) -> 0.0994s == RemoveEnumerationsOpt: migrated (0.0995s) ================================= == ChangeWikiContentsTextLimit: migrating ==================================== -- change_column(:wiki_contents, :text, :text, {:limit=>16777216}) -> 0.4020s -- change_column(:wiki_content_versions, :data, :binary, {:limit=>16777216}) -> 1.3896s == ChangeWikiContentsTextLimit: migrated (1.7998s) =========================== == ChangeUsersMailNotificationToString: migrating ============================ -- rename_column(:users, :mail_notification, :mail_notification_bool) -> 0.1159s -- add_column(:users, :mail_notification, :string, {:null=>false, :default=>""}) -> 0.1001s -- remove_column(:users, :mail_notification_bool) -> 0.1003s == ChangeUsersMailNotificationToString: migrated (0.4334s) =================== == UpdateMailNotificationValues: migrating =================================== == UpdateMailNotificationValues: migrated (0.0000s) ========================== == AddIndexOnChangesetsScmid: migrating ====================================== -- add_index(:changesets, [:repository_id, :scmid], {:name=>:changesets_repos_scmid}) -> 0.1161s == AddIndexOnChangesetsScmid: migrated (0.1163s) ============================= == AddIssuesNestedSetsColumns: migrating ===================================== -- add_column(:issues, :parent_id, :integer, {:default=>nil}) -> 0.1446s -- add_column(:issues, :root_id, :integer, {:default=>nil}) -> 0.2381s -- add_column(:issues, :lft, :integer, {:default=>nil}) -> 0.1286s -- add_column(:issues, :rgt, :integer, {:default=>nil}) -> 0.1548s == AddIssuesNestedSetsColumns: migrated (0.7028s) ============================ == AddIndexOnIssuesNestedSet: migrating ====================================== -- add_index(:issues, [:root_id, :lft, :rgt]) -> 0.1642s == AddIndexOnIssuesNestedSet: migrated (0.1643s) ============================= == ChangeChangesPathLengthLimit: migrating =================================== -- change_column(:changes, :path, :text, {:null=>true, :default=>nil}) -> 0.0993s -- change_column(:changes, :path, :text, {:null=>false}) -> 0.0998s -- change_column(:changes, :from_path, :text) -> 0.1082s == ChangeChangesPathLengthLimit: migrated (0.3076s) ========================== == PrepareJournalsForActsAsJournalized: migrating ============================ -- change_table(:journals) -> 2.8805s == PrepareJournalsForActsAsJournalized: migrated (2.8809s) =================== == UpdateJournalsForActsAsJournalized: migrating ============================= -- Updating existing Journals... -> 46.5184s -- change_table(:journals) -> 0.2060s == UpdateJournalsForActsAsJournalized: migrated (46.7247s) =================== == BuildInitialJournalsForActsAsJournalized: migrating ======================= -- Building initial journals for Message rake aborted! An error has occurred, all later migrations canceled: 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)) Tasks: TOP => db:migrate (See full trace by running task with --trace)