HTTP 500 errors after 6.5.5 -> 6.9.2 upgrade
Closed
HTTP 500 errors after 6.5.5 -> 6.9.2 upgrade
Created by: chrisDeFouRire
I've ran bundle exec rake db:migrate RAILS_ENV=production
(because health checks suggested so, and now pass without a problem) and it did migrate things, but now /admin/projects or /public fail with an 500 error.
I didn't find any relevant information, except #5913 (closed) which relates (but vastly different version numbers). This gitlab runs in Docker (https://github.com/sameersbn/docker-gitlab)
Can you help me? Thanks!
Full stacktrace below
Started GET "/public" for 82.240.obfu.scated at 2014-06-19 09:48:43 +0000
Processing by Public::ProjectsController#index as HTML
Mysql2::Error: Unknown column 'projects.imported' in 'field list': SELECT projects
.id
AS t0_r0, projects
.name
AS t0_r1, projects
.path
AS t0_r2, projects
.description
AS t0_r3, projects
.created_at
AS t0_r4, projects
.updated_at
AS t0_r5, projects
.creator_id
AS t0_r6, projects
.issues_enabled
AS t0_r7, projects
.wall_enabled
AS t0_r8, projects
.merge_requests_enabled
AS t0_r9, projects
.wiki_enabled
AS t0_r10, projects
.namespace_id
AS t0_r11, projects
.issues_tracker
AS t0_r12, projects
.issues_tracker_id
AS t0_r13, projects
.snippets_enabled
AS t0_r14, projects
.last_activity_at
AS t0_r15, projects
.imported
AS t0_r16, projects
.import_url
AS t0_r17, projects
.visibility_level
AS t0_r18, projects
.archived
AS t0_r19, namespaces
.id
AS t1_r0, namespaces
.name
AS t1_r1, namespaces
.path
AS t1_r2, namespaces
.owner_id
AS t1_r3, namespaces
.created_at
AS t1_r4, namespaces
.updated_at
AS t1_r5, namespaces
.type
AS t1_r6, namespaces
.description
AS t1_r7, namespaces
.avatar
AS t1_r8 FROM projects
LEFT OUTER JOIN namespaces
ON namespaces
.id
= projects
.namespace_id
WHERE projects
.visibility_level
IN (20, 10) ORDER BY namespaces.path, projects.name ASC LIMIT 20 OFFSET 0
Completed 500 Internal Server Error in 31ms
ActionView::Template::Error (Mysql2::Error: Unknown column 'projects.imported' in 'field list': SELECT projects
.id
AS t0_r0, projects
.name
AS t0_r1, projects
.path
AS t0_r2, projects
.description
AS t0_r3, projects
.created_at
AS t0_r4, projects
.updated_at
AS t0_r5, projects
.creator_id
AS t0_r6, projects
.issues_enabled
AS t0_r7, projects
.wall_enabled
AS t0_r8, projects
.merge_requests_enabled
AS t0_r9, projects
.wiki_enabled
AS t0_r10, projects
.namespace_id
AS t0_r11, projects
.issues_tracker
AS t0_r12, projects
.issues_tracker_id
AS t0_r13, projects
.snippets_enabled
AS t0_r14, projects
.last_activity_at
AS t0_r15, projects
.imported
AS t0_r16, projects
.import_url
AS t0_r17, projects
.visibility_level
AS t0_r18, projects
.archived
AS t0_r19, namespaces
.id
AS t1_r0, namespaces
.name
AS t1_r1, namespaces
.path
AS t1_r2, namespaces
.owner_id
AS t1_r3, namespaces
.created_at
AS t1_r4, namespaces
.updated_at
AS t1_r5, namespaces
.type
AS t1_r6, namespaces
.description
AS t1_r7, namespaces
.avatar
AS t1_r8 FROM projects
LEFT OUTER JOIN namespaces
ON namespaces
.id
= projects
.namespace_id
WHERE projects
.visibility_level
IN (20, 10) ORDER BY namespaces.path, projects.name ASC LIMIT 20 OFFSET 0):
36: %hr
37: .public-projects
38: %ul.bordered-list.top-list
39: - @projects.each do |project|
40: %li
41: %h4
42: = link_to project_path(project) do
app/views/public/projects/index.html.haml:39:in _app_views_public_projects_index_html_haml__2889640718129604002_70678020' app/controllers/application_controller.rb:59:in
set_current_user_for_thread'
Created by: chrisDeFouRire
here is the migration log, as I think the problem comes from migrations.
It seems the bogus migration might be : == 20140313092127 MigrateAlreadyImportedProjects: migrating =================== -- remove_column(:projects, :imported) -> 0.0103s == 20140313092127 MigrateAlreadyImportedProjects: migrated (0.0333s) ==========
But I don't know how this could be...
== 20130809124851 AddPermissionCheckToUser: migrating ========================= -- add_column(:users, :last_credential_check_at, :datetime) -> 0.1660s == 20130809124851 AddPermissionCheckToUser: migrated (0.1692s) ================
== 20140214102325 AddApiKeyToServices: migrating ============================== -- add_column(:services, :api_key, :string) -> 0.0137s == 20140214102325 AddApiKeyToServices: migrated (0.0162s) =====================
== 20140304005354 AddIndexMergeRequestDiffsOnMergeRequestId: migrating ======== -- add_index(:merge_request_diffs, :merge_request_id, {:unique=>true}) -> 0.0479s == 20140304005354 AddIndexMergeRequestDiffsOnMergeRequestId: migrated (0.0500s)
== 20140305193308 AddTagPushHooksToProjectHook: migrating ===================== -- add_column(:web_hooks, :tag_push_events, :boolean, {:default=>false}) -> 0.0107s == 20140305193308 AddTagPushHooksToProjectHook: migrated (0.0130s) ============
== 20140312145357 AddImportStatusToProject: migrating ========================= -- add_column(:projects, :import_status, :string) -> 0.0150s == 20140312145357 AddImportStatusToProject: migrated (0.0169s) ================
== 20140313092127 MigrateAlreadyImportedProjects: migrating =================== -- remove_column(:projects, :imported) -> 0.0103s == 20140313092127 MigrateAlreadyImportedProjects: migrated (0.0333s) ==========
== 20140407135544 FixNamespaces: migrating ==================================== == 20140407135544 FixNamespaces: migrated (0.0272s) ===========================
== 20140414131055 ChangeStateToAllowEmptyMergeRequestDiffs: migrating ========= -- change_column(:merge_request_diffs, :state, :string, {:null=>true, :default=>nil}) -> 0.0146s == 20140414131055 ChangeStateToAllowEmptyMergeRequestDiffs: migrated (0.0291s)
== 20140415124820 LimitsToMysql: migrating ==================================== -- change_column(:merge_request_diffs, :st_commits, :text, {:limit=>2147483647}) -> 0.0050s -- change_column(:merge_request_diffs, :st_diffs, :text, {:limit=>2147483647}) -> 0.0077s -- change_column(:snippets, :content, :text, {:limit=>2147483647}) -> 0.0091s -- change_column(:notes, :st_diff, :text, {:limit=>2147483647}) -> 0.0151s == 20140415124820 LimitsToMysql: migrated (0.0454s) ===========================
== 20140416074002 AddIndexOnIid: migrating ==================================== -- add_index(:issues, [:project_id, :iid], {:unique=>true}) -> 0.0245s -- add_index(:merge_requests, [:target_project_id, :iid], {:unique=>true}) -> 0.0211s -- add_index(:milestones, [:project_id, :iid], {:unique=>true}) -> 0.1430s == 20140416074002 AddIndexOnIid: migrated (0.2234s) ===========================
== 20140416185734 IndexOnCurrentSignInAt: migrating =========================== -- add_index(:users, :current_sign_in_at) -> 0.0161s == 20140416185734 IndexOnCurrentSignInAt: migrated (0.0191s) ==================
== 20140428105831 AddNotesIndexUpdatedAt: migrating =========================== -- add_index(:notes, :updated_at) -> 0.0165s == 20140428105831 AddNotesIndexUpdatedAt: migrated (0.0191s) ==================
== 20140502115131 AddRepoSizeToDb: migrating ================================== -- add_column(:projects, :repository_size, :float, {:default=>0}) -> 0.0133s == 20140502115131 AddRepoSizeToDb: migrated (0.0158s) =========================
== 20140502125220 MigrateRepoSize: migrating ================================== .....................Done == 20140502125220 MigrateRepoSize: migrated (2.8210s) =========================
By Administrator on 2014-06-19T10:21:09 (imported from GitLab project)