Skip to content

GitLab

  • Menu
    • Projects Groups Snippets
      Help
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • G gitlabhq1
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 21
    • Issues 21
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 12
    • Merge requests 12
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Infrastructure Registry
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • gpt
  • large_projects
  • gitlabhq1
  • Issues
  • #7156

Closed
Open
Created 11 years ago by Administrator@rootOwner
  • New issue

  • Report abuse

  • New issue

  • Report abuse

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:inset_current_user_for_thread'

Linked issues
0


  • Administrator
    Administrator @root · 11 years ago
    Owner

    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)

  • Administrator
    Administrator @root · 11 years ago
    Owner

    Created by: chrisDeFouRire

    To fix the problem for the time being, I've used

    alter table projects add column imported TINYINT default 0;

    By Administrator on 2014-06-19T10:28:53 (imported from GitLab project)

  • Administrator
    Administrator @root · 10 years ago
    Owner

    Created by: Razer6

    Strange issue. Since you've fixed it, I'm closing

    By Administrator on 2014-08-13T16:02:11 (imported from GitLab project)

  • You're only seeing other activity in the feed. To add a comment, switch to one of the following options.
Please register or sign in to reply
0 Assignees
Assign to
Milestone
No milestone
None
None
Time tracking
Due date
None
None
0
Labels
None
Assign labels
  • No matching results
  • Manage project labels
Confidentiality
Not confidential

You are going to turn on confidentiality. Only team members with at least Reporter access will be able to see and leave comments on the issue.

Lock issue
Unlocked
participants
Reference:

Menu

Projects Groups Snippets
Help