As per http://doc.gitlab.com/ce/install/installation.html#initialize-database-and-activate-advanced-features, running rake gitlab:setup should setup the database. However, it only works if I'm following it with a rake db:migrate, otherwise I get an error when trying to run a simple User.all from the console:
root@ip-10-112-47-195:/home/admin# gitlabhq run rake gitlab:setup
This will create the necessary database tables and seed the database.
You will lose any previous data stored in the database.
Do you want to continue (yes/no)? yes
gitlabhq already exists
-- enable_extension("plpgsql")
-> 0.0055s
-- create_table("broadcast_messages", {:force=>true})
-> 0.0885s
-- create_table("deploy_keys_projects", {:force=>true})
-> 0.0187s
-- add_index("deploy_keys_projects", ["project_id"], {:name=>"index_deploy_keys_projects_on_project_id", :using=>:btree})
-> 0.0235s
-- create_table("emails", {:force=>true})
-> 0.0201s
-- add_index("emails", ["email"], {:name=>"index_emails_on_email", :unique=>true, :using=>:btree})
-> 0.0196s
-- add_index("emails", ["user_id"], {:name=>"index_emails_on_user_id", :using=>:btree})
-> 0.0257s
-- create_table("events", {:force=>true})
-> 0.0306s
-- add_index("events", ["action"], {:name=>"index_events_on_action", :using=>:btree})
-> 0.0194s
-- add_index("events", ["author_id"], {:name=>"index_events_on_author_id", :using=>:btree})
-> 0.0199s
-- add_index("events", ["created_at"], {:name=>"index_events_on_created_at", :using=>:btree})
-> 0.0198s
-- add_index("events", ["project_id"], {:name=>"index_events_on_project_id", :using=>:btree})
-> 0.0198s
-- add_index("events", ["target_id"], {:name=>"index_events_on_target_id", :using=>:btree})
-> 0.0203s
-- add_index("events", ["target_type"], {:name=>"index_events_on_target_type", :using=>:btree})
-> 0.0153s
-- create_table("forked_project_links", {:force=>true})
-> 0.0201s
-- add_index("forked_project_links", ["forked_to_project_id"], {:name=>"index_forked_project_links_on_forked_to_project_id", :unique=>true, :using=>:btree})
-> 0.0185s
-- create_table("issues", {:force=>true})
-> 0.0369s
-- add_index("issues", ["assignee_id"], {:name=>"index_issues_on_assignee_id", :using=>:btree})
-> 0.0121s
-- add_index("issues", ["author_id"], {:name=>"index_issues_on_author_id", :using=>:btree})
-> 0.0200s
-- add_index("issues", ["created_at"], {:name=>"index_issues_on_created_at", :using=>:btree})
-> 0.0236s
-- add_index("issues", ["milestone_id"], {:name=>"index_issues_on_milestone_id", :using=>:btree})
-> 0.0144s
-- add_index("issues", ["project_id"], {:name=>"index_issues_on_project_id", :using=>:btree})
-> 0.0214s
-- add_index("issues", ["title"], {:name=>"index_issues_on_title", :using=>:btree})
-> 0.0198s
-- create_table("keys", {:force=>true})
-> 0.0326s
-- add_index("keys", ["user_id"], {:name=>"index_keys_on_user_id", :using=>:btree})
-> 0.0194s
-- create_table("merge_request_diffs", {:force=>true})
-> 0.0313s
-- add_index("merge_request_diffs", ["merge_request_id"], {:name=>"index_merge_request_diffs_on_merge_request_id", :unique=>true, :using=>:btree})
-> 0.0242s
-- create_table("merge_requests", {:force=>true})
-> 0.0325s
-- add_index("merge_requests", ["assignee_id"], {:name=>"index_merge_requests_on_assignee_id", :using=>:btree})
-> 0.0193s
-- add_index("merge_requests", ["author_id"], {:name=>"index_merge_requests_on_author_id", :using=>:btree})
-> 0.0158s
-- add_index("merge_requests", ["created_at"], {:name=>"index_merge_requests_on_created_at", :using=>:btree})
-> 0.0160s
-- add_index("merge_requests", ["milestone_id"], {:name=>"index_merge_requests_on_milestone_id", :using=>:btree})
-> 0.0198s
-- add_index("merge_requests", ["source_branch"], {:name=>"index_merge_requests_on_source_branch", :using=>:btree})
-> 0.0182s
-- add_index("merge_requests", ["source_project_id"], {:name=>"index_merge_requests_on_source_project_id", :using=>:btree})
-> 0.0214s
-- add_index("merge_requests", ["target_branch"], {:name=>"index_merge_requests_on_target_branch", :using=>:btree})
-> 0.0179s
-- add_index("merge_requests", ["title"], {:name=>"index_merge_requests_on_title", :using=>:btree})
-> 0.0292s
-- create_table("milestones", {:force=>true})
-> 0.0459s
-- add_index("milestones", ["due_date"], {:name=>"index_milestones_on_due_date", :using=>:btree})
-> 0.0388s
-- add_index("milestones", ["project_id"], {:name=>"index_milestones_on_project_id", :using=>:btree})
-> 0.0402s
-- create_table("namespaces", {:force=>true})
-> 0.0701s
-- add_index("namespaces", ["name"], {:name=>"index_namespaces_on_name", :using=>:btree})
-> 0.0399s
-- add_index("namespaces", ["owner_id"], {:name=>"index_namespaces_on_owner_id", :using=>:btree})
-> 0.0291s
-- add_index("namespaces", ["path"], {:name=>"index_namespaces_on_path", :using=>:btree})
-> 0.0364s
-- add_index("namespaces", ["type"], {:name=>"index_namespaces_on_type", :using=>:btree})
-> 0.0195s
-- create_table("notes", {:force=>true})
-> 0.0293s
-- add_index("notes", ["author_id"], {:name=>"index_notes_on_author_id", :using=>:btree})
-> 0.0186s
-- add_index("notes", ["commit_id"], {:name=>"index_notes_on_commit_id", :using=>:btree})
-> 0.0192s
-- add_index("notes", ["created_at"], {:name=>"index_notes_on_created_at", :using=>:btree})
-> 0.0207s
-- add_index("notes", ["noteable_id", "noteable_type"], {:name=>"index_notes_on_noteable_id_and_noteable_type", :using=>:btree})
-> 0.0156s
-- add_index("notes", ["noteable_type"], {:name=>"index_notes_on_noteable_type", :using=>:btree})
-> 0.0151s
-- add_index("notes", ["project_id", "noteable_type"], {:name=>"index_notes_on_project_id_and_noteable_type", :using=>:btree})
-> 0.0205s
-- add_index("notes", ["project_id"], {:name=>"index_notes_on_project_id", :using=>:btree})
-> 0.0177s
-- create_table("projects", {:force=>true})
-> 0.0350s
-- add_index("projects", ["creator_id"], {:name=>"index_projects_on_creator_id", :using=>:btree})
-> 0.0193s
-- add_index("projects", ["last_activity_at"], {:name=>"index_projects_on_last_activity_at", :using=>:btree})
-> 0.0197s
-- add_index("projects", ["namespace_id"], {:name=>"index_projects_on_namespace_id", :using=>:btree})
-> 0.0198s
-- create_table("protected_branches", {:force=>true})
-> 0.0200s
-- add_index("protected_branches", ["project_id"], {:name=>"index_protected_branches_on_project_id", :using=>:btree})
-> 0.0195s
-- create_table("services", {:force=>true})
-> 0.0330s
-- add_index("services", ["project_id"], {:name=>"index_services_on_project_id", :using=>:btree})
-> 0.0107s
-- create_table("snippets", {:force=>true})
-> 0.0327s
-- add_index("snippets", ["author_id"], {:name=>"index_snippets_on_author_id", :using=>:btree})
-> 0.0194s
-- add_index("snippets", ["created_at"], {:name=>"index_snippets_on_created_at", :using=>:btree})
-> 0.0200s
-- add_index("snippets", ["expires_at"], {:name=>"index_snippets_on_expires_at", :using=>:btree})
-> 0.0196s
-- add_index("snippets", ["project_id"], {:name=>"index_snippets_on_project_id", :using=>:btree})
-> 0.0170s
-- create_table("taggings", {:force=>true})
-> 0.0311s
-- add_index("taggings", ["tag_id"], {:name=>"index_taggings_on_tag_id", :using=>:btree})
-> 0.0243s
-- add_index("taggings", ["taggable_id", "taggable_type", "context"], {:name=>"index_taggings_on_taggable_id_and_taggable_type_and_context", :using=>:btree})
-> 0.0196s
-- create_table("tags", {:force=>true})
-> 0.0196s
-- create_table("users", {:force=>true})
-> 0.0365s
-- add_index("users", ["admin"], {:name=>"index_users_on_admin", :using=>:btree})
-> 0.0192s
-- add_index("users", ["authentication_token"], {:name=>"index_users_on_authentication_token", :unique=>true, :using=>:btree})
-> 0.0199s
-- add_index("users", ["confirmation_token"], {:name=>"index_users_on_confirmation_token", :unique=>true, :using=>:btree})
-> 0.0202s
-- add_index("users", ["email"], {:name=>"index_users_on_email", :unique=>true, :using=>:btree})
-> 0.0197s
-- add_index("users", ["extern_uid", "provider"], {:name=>"index_users_on_extern_uid_and_provider", :unique=>true, :using=>:btree})
-> 0.0196s
-- add_index("users", ["name"], {:name=>"index_users_on_name", :using=>:btree})
-> 0.0199s
-- add_index("users", ["reset_password_token"], {:name=>"index_users_on_reset_password_token", :unique=>true, :using=>:btree})
-> 0.0204s
-- add_index("users", ["username"], {:name=>"index_users_on_username", :using=>:btree})
-> 0.0193s
-- create_table("users_groups", {:force=>true})
-> 0.0241s
-- add_index("users_groups", ["user_id"], {:name=>"index_users_groups_on_user_id", :using=>:btree})
-> 0.0197s
-- create_table("users_projects", {:force=>true})
-> 0.0200s
-- add_index("users_projects", ["project_access"], {:name=>"index_users_projects_on_project_access", :using=>:btree})
-> 0.0196s
-- add_index("users_projects", ["project_id"], {:name=>"index_users_projects_on_project_id", :using=>:btree})
-> 0.0199s
-- add_index("users_projects", ["user_id"], {:name=>"index_users_projects_on_user_id", :using=>:btree})
-> 0.0201s
-- create_table("web_hooks", {:force=>true})
-> 0.0325s
-- add_index("web_hooks", ["project_id"], {:name=>"index_web_hooks_on_project_id", :using=>:btree})
-> 0.0191s
-- initialize_schema_migrations_table()
-> 0.0202s
== Seed from /opt/gitlabhq/db/fixtures/production/001_admin.rb
2014-04-03T09:27:32Z 5993 TID-osq19s6to INFO: Sidekiq client with redis options {:url=>"redis://localhost:6379", :namespace=>"resque:gitlab"}
Administrator account created:
[email protected]
password......5iveL!feroot@ip-10-112-47-195:/home/admin# echo 'puts User.all' | gitlabhq run console
Instance method "lock!" is already defined in ActiveRecord::Base, use generic helper instead or set StateMachine::Machine.ignore_method_conflicts = true.
Loading production environment (Rails 4.0.3)
Switch to inspect mode.
puts User.all
PG::Error: ERROR: relation "users" does not exist
LINE 1: SELECT "users".* FROM "users"
^
: SELECT "users".* FROM "users"
ActiveRecord::StatementInvalid: PG::Error: ERROR: relation "users" does not exist
LINE 1: SELECT "users".* FROM "users"
^
: SELECT "users".* FROM "users"
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/postgresql_adapter.rb:774:in `exec'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/postgresql_adapter.rb:774:in `exec_no_cache'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:138:in `block in exec_query'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_adapter.rb:435:in `block in log'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.3/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_adapter.rb:430:in `log'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:137:in `exec_query'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/postgresql_adapter.rb:891:in `select'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract/database_statements.rb:24:in `select_all'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/querying.rb:36:in `find_by_sql'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/relation.rb:585:in `exec_queries'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/relation.rb:471:in `load'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/relation.rb:220:in `to_a'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.3/lib/active_record/relation/delegation.rb:12:in `to_ary'
from (irb):1:in `puts'
from (irb):1:in `puts'
from (irb):1
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/railties-4.0.3/lib/rails/commands/console.rb:90:in `start'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/railties-4.0.3/lib/rails/commands/console.rb:9:in `start'
from /opt/gitlabhq/vendor/bundle/ruby/2.0.0/gems/railties-4.0.3/lib/rails/commands.rb:62:in `<top (required)>'
from bin/rails:8:in `require'
from bin/rails:8:in `<main>'Running rake db:migrate fixes the issue:
root@ip-10-112-47-195:/home/admin# gitlabhq run rake db:migrate
== InitSchema: migrating =====================================================
-- create_table("events", {:force=>true})
-> 0.0536s
-- add_index("events", ["action"], {:name=>"index_events_on_action", :using=>:btree})
-> 0.0156s
-- add_index("events", ["author_id"], {:name=>"index_events_on_author_id", :using=>:btree})
-> 0.0625s
-- add_index("events", ["created_at"], {:name=>"index_events_on_created_at", :using=>:btree})
-> 0.0212s
-- add_index("events", ["project_id"], {:name=>"index_events_on_project_id", :using=>:btree})
-> 0.0164s
-- add_index("events", ["target_id"], {:name=>"index_events_on_target_id", :using=>:btree})
-> 0.0196s
-- add_index("events", ["target_type"], {:name=>"index_events_on_target_type", :using=>:btree})
-> 0.0158s
-- create_table("issues", {:force=>true})
-> 0.0322s
-- add_index("issues", ["assignee_id"], {:name=>"index_issues_on_assignee_id", :using=>:btree})
-> 0.0154s
-- add_index("issues", ["author_id"], {:name=>"index_issues_on_author_id", :using=>:btree})
-> 0.0159s
-- add_index("issues", ["closed"], {:name=>"index_issues_on_closed", :using=>:btree})
-> 0.0160s
-- add_index("issues", ["created_at"], {:name=>"index_issues_on_created_at", :using=>:btree})
-> 0.0159s
-- add_index("issues", ["milestone_id"], {:name=>"index_issues_on_milestone_id", :using=>:btree})
-> 0.0158s
-- add_index("issues", ["project_id"], {:name=>"index_issues_on_project_id", :using=>:btree})
-> 0.0157s
-- add_index("issues", ["title"], {:name=>"index_issues_on_title", :using=>:btree})
-> 0.0160s
-- create_table("keys", {:force=>true})
-> 0.0281s
-- add_index("keys", ["identifier"], {:name=>"index_keys_on_identifier", :using=>:btree})
-> 0.0198s
-- add_index("keys", ["project_id"], {:name=>"index_keys_on_project_id", :using=>:btree})
-> 0.0104s
-- add_index("keys", ["user_id"], {:name=>"index_keys_on_user_id", :using=>:btree})
-> 0.0132s
-- create_table("merge_requests", {:force=>true})
-> 0.0280s
-- add_index("merge_requests", ["assignee_id"], {:name=>"index_merge_requests_on_assignee_id", :using=>:btree})
-> 0.0199s
-- add_index("merge_requests", ["author_id"], {:name=>"index_merge_requests_on_author_id", :using=>:btree})
-> 0.0159s
-- add_index("merge_requests", ["closed"], {:name=>"index_merge_requests_on_closed", :using=>:btree})
-> 0.0158s
-- add_index("merge_requests", ["created_at"], {:name=>"index_merge_requests_on_created_at", :using=>:btree})
-> 0.0160s
-- add_index("merge_requests", ["milestone_id"], {:name=>"index_merge_requests_on_milestone_id", :using=>:btree})
-> 0.0156s
-- add_index("merge_requests", ["project_id"], {:name=>"index_merge_requests_on_project_id", :using=>:btree})
-> 0.0162s
-- add_index("merge_requests", ["source_branch"], {:name=>"index_merge_requests_on_source_branch", :using=>:btree})
-> 0.0157s
-- add_index("merge_requests", ["target_branch"], {:name=>"index_merge_requests_on_target_branch", :using=>:btree})
-> 0.0159s
-- add_index("merge_requests", ["title"], {:name=>"index_merge_requests_on_title", :using=>:btree})
-> 0.0200s
-- create_table("milestones", {:force=>true})
-> 0.0314s
-- add_index("milestones", ["due_date"], {:name=>"index_milestones_on_due_date", :using=>:btree})
-> 0.0122s
-- add_index("milestones", ["project_id"], {:name=>"index_milestones_on_project_id", :using=>:btree})
-> 0.0139s
-- create_table("namespaces", {:force=>true})
-> 0.0222s
-- add_index("namespaces", ["name"], {:name=>"index_namespaces_on_name", :using=>:btree})
-> 0.0161s
-- add_index("namespaces", ["owner_id"], {:name=>"index_namespaces_on_owner_id", :using=>:btree})
-> 0.0154s
-- add_index("namespaces", ["path"], {:name=>"index_namespaces_on_path", :using=>:btree})
-> 0.0161s
-- add_index("namespaces", ["type"], {:name=>"index_namespaces_on_type", :using=>:btree})
-> 0.0157s
-- create_table("notes", {:force=>true})
-> 0.0235s
-- add_index("notes", ["commit_id"], {:name=>"index_notes_on_commit_id", :using=>:btree})
-> 0.0122s
-- add_index("notes", ["created_at"], {:name=>"index_notes_on_created_at", :using=>:btree})
-> 0.0160s
-- add_index("notes", ["noteable_type"], {:name=>"index_notes_on_noteable_type", :using=>:btree})
-> 0.0199s
-- add_index("notes", ["project_id", "noteable_type"], {:name=>"index_notes_on_project_id_and_noteable_type", :using=>:btree})
-> 0.0158s
-- add_index("notes", ["project_id"], {:name=>"index_notes_on_project_id", :using=>:btree})
-> 0.0162s
-- create_table("projects", {:force=>true})
-> 0.0298s
-- add_index("projects", ["namespace_id"], {:name=>"index_projects_on_namespace_id", :using=>:btree})
-> 0.0140s
-- add_index("projects", ["owner_id"], {:name=>"index_projects_on_owner_id", :using=>:btree})
-> 0.0159s
-- create_table("protected_branches", {:force=>true})
-> 0.0197s
-- create_table("services", {:force=>true})
-> 0.0321s
-- add_index("services", ["project_id"], {:name=>"index_services_on_project_id", :using=>:btree})
-> 0.0158s
-- create_table("snippets", {:force=>true})
-> 0.0280s
-- add_index("snippets", ["created_at"], {:name=>"index_snippets_on_created_at", :using=>:btree})
-> 0.0185s
-- add_index("snippets", ["expires_at"], {:name=>"index_snippets_on_expires_at", :using=>:btree})
-> 0.0129s
-- add_index("snippets", ["project_id"], {:name=>"index_snippets_on_project_id", :using=>:btree})
-> 0.0161s
-- create_table("taggings", {:force=>true})
-> 0.0323s
-- add_index("taggings", ["tag_id"], {:name=>"index_taggings_on_tag_id", :using=>:btree})
-> 0.0196s
-- add_index("taggings", ["taggable_id", "taggable_type", "context"], {:name=>"index_taggings_on_taggable_id_and_taggable_type_and_context", :using=>:btree})
-> 0.0198s
-- create_table("tags", {:force=>true})
-> 0.0161s
-- create_table("user_team_project_relationships", {:force=>true})
-> 0.0108s
-- create_table("user_team_user_relationships", {:force=>true})
-> 0.0170s
-- create_table("user_teams", {:force=>true})
-> 0.0240s
-- create_table("users", {:force=>true})
-> 0.0238s
-- add_index("users", ["admin"], {:name=>"index_users_on_admin", :using=>:btree})
-> 0.0154s
-- add_index("users", ["blocked"], {:name=>"index_users_on_blocked", :using=>:btree})
-> 0.0125s
-- add_index("users", ["email"], {:name=>"index_users_on_email", :unique=>true, :using=>:btree})
-> 0.0156s
-- add_index("users", ["extern_uid", "provider"], {:name=>"index_users_on_extern_uid_and_provider", :unique=>true, :using=>:btree})
-> 0.0160s
-- add_index("users", ["name"], {:name=>"index_users_on_name", :using=>:btree})
-> 0.0158s
-- add_index("users", ["reset_password_token"], {:name=>"index_users_on_reset_password_token", :unique=>true, :using=>:btree})
-> 0.0159s
-- add_index("users", ["username"], {:name=>"index_users_on_username", :using=>:btree})
-> 0.0158s
-- create_table("users_projects", {:force=>true})
-> 0.0163s
-- add_index("users_projects", ["project_access"], {:name=>"index_users_projects_on_project_access", :using=>:btree})
-> 0.0157s
-- add_index("users_projects", ["project_id"], {:name=>"index_users_projects_on_project_id", :using=>:btree})
-> 0.0119s
-- add_index("users_projects", ["user_id"], {:name=>"index_users_projects_on_user_id", :using=>:btree})
-> 0.0156s
-- create_table("web_hooks", {:force=>true})
-> 0.0283s
-- create_table("wikis", {:force=>true})
-> 0.0319s
-- add_index("wikis", ["project_id"], {:name=>"index_wikis_on_project_id", :using=>:btree})
-> 0.0157s
-- add_index("wikis", ["slug"], {:name=>"index_wikis_on_slug", :using=>:btree})
-> 0.0157s
== InitSchema: migrated (1.4778s) ============================================
== RenameOwnerToCreatorForProject: migrating =================================
-- rename_column(:projects, :owner_id, :creator_id)
-> 0.0333s
== RenameOwnerToCreatorForProject: migrated (0.0338s) ========================
== AddPublicToProject: migrating =============================================
-- add_column(:projects, :public, :boolean, {:default=>false, :null=>false})
-> 0.1132s
== AddPublicToProject: migrated (0.1136s) ====================================
== AddIssuesTrackerToProject: migrating ======================================
-- add_column(:projects, :issues_tracker, :string, {:default=>:gitlab, :null=>false})
-> 0.0598s
== AddIssuesTrackerToProject: migrated (0.0600s) =============================
== AddUserPermissions: migrating =============================================
-- add_column(:users, :can_create_group, :boolean, {:default=>true, :null=>false})
-> 0.1139s
-- add_column(:users, :can_create_team, :boolean, {:default=>true, :null=>false})
-> 0.1157s
== AddUserPermissions: migrated (0.2300s) ====================================
== RemovePrivateFlagFromProject: migrating ===================================
-- remove_column(:projects, :private_flag)
-> 0.0009s
== RemovePrivateFlagFromProject: migrated (0.0009s) ==========================
== AddDescriptionToNamsespace: migrating =====================================
-- add_column(:namespaces, :description, :string, {:default=>"", :null=>false})
-> 0.0718s
== AddDescriptionToNamsespace: migrated (0.0720s) ============================
== AddDescriptionToTeams: migrating ==========================================
-- add_column(:user_teams, :description, :string, {:default=>"", :null=>false})
-> 0.0289s
== AddDescriptionToTeams: migrated (0.0291s) =================================
== AddIssuesTrackerIdToProject: migrating ====================================
-- add_column(:projects, :issues_tracker_id, :string)
-> 0.0009s
== AddIssuesTrackerIdToProject: migrated (0.0010s) ===========================
== RenameStateToMergeStatusInMilestone: migrating ============================
-- rename_column(:merge_requests, :state, :merge_status)
-> 0.0053s
== RenameStateToMergeStatusInMilestone: migrated (0.0055s) ===================
== AddStateToIssue: migrating ================================================
-- add_column(:issues, :state, :string)
-> 0.0008s
== AddStateToIssue: migrated (0.0011s) =======================================
== AddStateToMergeRequest: migrating =========================================
-- add_column(:merge_requests, :state, :string)
-> 0.0008s
== AddStateToMergeRequest: migrated (0.0010s) ================================
== AddStateToMilestone: migrating ============================================
-- add_column(:milestones, :state, :string)
-> 0.0008s
== AddStateToMilestone: migrated (0.0010s) ===================================
== ConvertClosedToStateInIssue: migrating ====================================
== ConvertClosedToStateInIssue: migrated (0.0076s) ===========================
== ConvertClosedToStateInMergeRequest: migrating =============================
== ConvertClosedToStateInMergeRequest: migrated (0.0051s) ====================
== ConvertClosedToStateInMilestone: migrating ================================
== ConvertClosedToStateInMilestone: migrated (0.0018s) =======================
== RemoveMergedFromMergeRequest: migrating ===================================
-- remove_column(:merge_requests, :merged)
-> 0.0006s
== RemoveMergedFromMergeRequest: migrated (0.0008s) ==========================
== RemoveClosedFromIssue: migrating ==========================================
-- remove_column(:issues, :closed)
-> 0.0007s
== RemoveClosedFromIssue: migrated (0.0009s) =================================
== RemoveClosedFromMergeRequest: migrating ===================================
-- remove_column(:merge_requests, :closed)
-> 0.0007s
== RemoveClosedFromMergeRequest: migrated (0.0009s) ==========================
== RemoveClosedFromMilestone: migrating ======================================
-- remove_column(:milestones, :closed)
-> 0.0006s
== RemoveClosedFromMilestone: migrated (0.0010s) =============================
== AddNewMergeStatusToMergeRequest: migrating ================================
-- add_column(:merge_requests, :new_merge_status, :string)
-> 0.0009s
== AddNewMergeStatusToMergeRequest: migrated (0.0011s) =======================
== ConvertMergeStatusInMergeRequest: migrating ===============================
== ConvertMergeStatusInMergeRequest: migrated (0.0019s) ======================
== RemoveMergeStatusFromMergeRequest: migrating ==============================
-- remove_column(:merge_requests, :merge_status)
-> 0.0005s
== RemoveMergeStatusFromMergeRequest: migrated (0.0007s) =====================
== RenameNewMergeStatusToMergeStatusInMilestone: migrating ===================
-- rename_column(:merge_requests, :new_merge_status, :merge_status)
-> 0.0044s
== RenameNewMergeStatusToMergeStatusInMilestone: migrated (0.0046s) ==========
== AddStateToUser: migrating =================================================
-- add_column(:users, :state, :string)
-> 0.0008s
== AddStateToUser: migrated (0.0010s) ========================================
== ConvertBlockedToState: migrating ==========================================
== ConvertBlockedToState: migrated (0.0029s) =================================
== RemoveBlockedFromUser: migrating ==========================================
-- remove_column(:users, :blocked)
-> 0.0008s
== RemoveBlockedFromUser: migrated (0.0010s) =================================
== UserColorScheme: migrating ================================================
-- add_column(:users, :color_scheme_id, :integer, {:null=>false, :default=>1})
-> 0.1036s
-- remove_column(:users, :dark_scheme)
-> 0.0005s
== UserColorScheme: migrated (0.1058s) =======================================
== AddSnippetsToFeatures: migrating ==========================================
-- add_column(:projects, :snippets_enabled, :boolean, {:null=>false, :default=>true})
-> 0.0559s
== AddSnippetsToFeatures: migrated (0.0561s) =================================
== CreateForkedProjectLinks: migrating =======================================
-- create_table(:forked_project_links)
-> 0.0131s
-- add_index(:forked_project_links, :forked_to_project_id, {:unique=>true})
-> 0.0119s
== CreateForkedProjectLinks: migrated (0.0252s) ==============================
== AddPrivateToSnippets: migrating ===========================================
-- add_column(:snippets, :private, :boolean, {:null=>false, :default=>true})
-> 0.0670s
== AddPrivateToSnippets: migrated (0.0672s) ==================================
== AddTypeToSnippets: migrating ==============================================
-- add_column(:snippets, :type, :string)
-> 0.0009s
== AddTypeToSnippets: migrated (0.0009s) =====================================
== ChangeProjectIdToNullInSnipepts: migrating ================================
-- change_column(:snippets, :project_id, :integer, {:null=>true})
-> 0.0156s
== ChangeProjectIdToNullInSnipepts: migrated (0.0159s) =======================
== AddTypeValueForSnippets: migrating ========================================
== AddTypeValueForSnippets: migrated (0.0029s) ===============================
== AddNotificationLevelToUser: migrating =====================================
-- add_column(:users, :notification_level, :integer, {:null=>false, :default=>1})
-> 0.1116s
== AddNotificationLevelToUser: migrated (0.1118s) ============================
== AddIndexToUsersAuthenticationToken: migrating =============================
-- add_index(:users, :authentication_token, {:unique=>true})
-> 0.0228s
== AddIndexToUsersAuthenticationToken: migrated (0.0231s) ====================
== AddLastActivityColumnIntoProject: migrating ===============================
-- add_column(:projects, :last_activity_at, :datetime)
-> 0.0008s
-- add_index(:projects, :last_activity_at)
-> 0.0195s
== AddLastActivityColumnIntoProject: migrated (0.0252s) ======================
== AddNotificationLevelToUserProject: migrating ==============================
-- add_column(:users_projects, :notification_level, :integer, {:null=>false, :default=>3})
-> 0.0634s
== AddNotificationLevelToUserProject: migrated (0.0637s) =====================
== RemoveWikiTable: migrating ================================================
-- drop_table(:wikis)
-> 0.0120s
== RemoveWikiTable: migrated (0.0124s) =======================================
== AllowMergesForForks: migrating ============================================
-- add_column(:merge_requests, :target_project_id, :integer, {:null=>true})
-> 0.0016s
-- change_column(:merge_requests, :target_project_id, :integer, {:null=>false})
-> 0.0011s
-- rename_column(:merge_requests, :project_id, :source_project_id)
-> 0.0058s
== AllowMergesForForks: migrated (0.0105s) ===================================
== AddTypeToKey: migrating ===================================================
-- add_column(:keys, :type, :string)
-> 0.0008s
== AddTypeToKey: migrated (0.0010s) ==========================================
== CreateDeployKeysProjects: migrating =======================================
-- create_table(:deploy_keys_projects)
-> 0.0197s
== CreateDeployKeysProjects: migrated (0.0199s) ==============================
== RemoveProjectIdFromKey: migrating =========================================
Migrate deploy keys:
Done
-- remove_column(:keys, :project_id)
-> 0.0006s
== RemoveProjectIdFromKey: migrated (0.0142s) ================================
== AddMoreFieldsToService: migrating =========================================
-- add_column(:services, :subdomain, :string)
-> 0.0009s
-- add_column(:services, :room, :string)
-> 0.0004s
== AddMoreFieldsToService: migrated (0.0017s) ================================
== AddSystemToNotes: migrating ===============================================
-- add_column(:notes, :system, :boolean, {:default=>false, :null=>false})
-> 0.0961s
== AddSystemToNotes: migrated (0.1023s) ======================================
== IncreaseSnippetTextColumnSize: migrating ==================================
-- change_column(:snippets, :content, :text, {:limit=>4294967295})
-> 0.0008s
== IncreaseSnippetTextColumnSize: migrated (0.0008s) =========================
== AddPasswordExpiresAtToUsers: migrating ====================================
-- add_column(:users, :password_expires_at, :datetime)
-> 0.0007s
== AddPasswordExpiresAtToUsers: migrated (0.0010s) ===========================
== AddCreatedByIdToUser: migrating ===========================================
-- add_column(:users, :created_by_id, :integer)
-> 0.0008s
== AddCreatedByIdToUser: migrated (0.0010s) ==================================
== AddImprotedToProject: migrating ===========================================
-- add_column(:projects, :imported, :boolean, {:default=>false, :null=>false})
-> 0.0690s
== AddImprotedToProject: migrated (0.0693s) ==================================
== CreateUsersGroups: migrating ==============================================
-- create_table(:users_groups)
-> 0.0170s
== CreateUsersGroups: migrated (0.0172s) =====================================
== AddNotificationLevelToUserGroup: migrating ================================
-- add_column(:users_groups, :notification_level, :integer, {:null=>false, :default=>3})
-> 0.0267s
== AddNotificationLevelToUserGroup: migrated (0.0270s) =======================
== AddMoreDbIndex: migrating =================================================
-- add_index(:deploy_keys_projects, :project_id)
-> 0.0154s
-- add_index(:web_hooks, :project_id)
-> 0.0084s
-- add_index(:protected_branches, :project_id)
-> 0.0097s
-- add_index(:users_groups, :user_id)
-> 0.0152s
-- add_index(:snippets, :author_id)
-> 0.0162s
-- add_index(:notes, :author_id)
-> 0.0237s
-- add_index(:notes, [:noteable_id, :noteable_type])
-> 0.0143s
== AddMoreDbIndex: migrated (0.1038s) ========================================
== AddFingerprintToKey: migrating ============================================
-- add_column(:keys, :fingerprint, :string)
-> 0.0008s
-- remove_column(:keys, :identifier)
-> 0.0005s
== AddFingerprintToKey: migrated (0.0018s) ===================================
== AddStDiffToNote: migrating ================================================
-- add_column(:notes, :st_diff, :text, {:null=>true})
-> 0.0007s
== AddStDiffToNote: migrated (0.0010s) =======================================
== AddPermissionCheckToUser: migrating =======================================
-- add_column(:users, :last_credential_check_at, :datetime)
-> 0.0009s
== AddPermissionCheckToUser: migrated (0.0011s) ==============================
== AddImportUrlToProject: migrating ==========================================
-- add_column(:projects, :import_url, :string)
-> 0.0008s
== AddImportUrlToProject: migrated (0.0010s) =================================
== AddInternalIdsToIssuesAndMr: migrating ====================================
-- add_column(:issues, :iid, :integer)
-> 0.0009s
-- add_column(:merge_requests, :iid, :integer)
-> 0.0005s
== AddInternalIdsToIssuesAndMr: migrated (0.0018s) ===========================
== RemoveDeprecatedTables: migrating =========================================
-- drop_table(:user_teams)
-> 0.0013s
-- drop_table(:user_team_project_relationships)
-> 0.0008s
-- drop_table(:user_team_user_relationships)
-> 0.0007s
== RemoveDeprecatedTables: migrated (0.0033s) ================================
== AddInternalIdsToMilestones: migrating =====================================
-- add_column(:milestones, :iid, :integer)
-> 0.0007s
== AddInternalIdsToMilestones: migrated (0.0010s) ============================
== AddDescriptionToMergeRequest: migrating ===================================
-- add_column(:merge_requests, :description, :text, {:null=>true})
-> 0.0008s
== AddDescriptionToMergeRequest: migrated (0.0010s) ==========================
== ChangeOwnerIdForGroup: migrating ==========================================
-- change_column(:namespaces, :owner_id, :integer, {:null=>true})
-> 0.0158s
== ChangeOwnerIdForGroup: migrated (0.0161s) =================================
== AddAvatarToUsers: migrating ===============================================
-- add_column(:users, :avatar, :string)
-> 0.0009s
== AddAvatarToUsers: migrated (0.0011s) ======================================
== AddConfirmableToUsers: migrating ==========================================
-- add_column(:users, :confirmation_token, :string)
-> 0.0009s
-- add_column(:users, :confirmed_at, :datetime)
-> 0.0004s
-- add_column(:users, :confirmation_sent_at, :datetime)
-> 0.0004s
-- add_column(:users, :unconfirmed_email, :string)
-> 0.0004s
-- add_index(:users, :confirmation_token, {:unique=>true})
-> 0.0202s
== AddConfirmableToUsers: migrated (0.0248s) =================================
== RemoveDefaultBranch: migrating ============================================
-- remove_column(:projects, :default_branch)
-> 0.0006s
== RemoveDefaultBranch: migrated (0.0009s) ===================================
== CreateBroadcastMessages: migrating ========================================
-- create_table(:broadcast_messages)
-> 0.0311s
== CreateBroadcastMessages: migrated (0.0314s) ===============================
== AddVisibilityLevelToProjects: migrating ===================================
-- add_column(:projects, :visibility_level, :integer, {:default=>0, :null=>false})
-> 0.0997s
-- remove_column(:projects, :public)
-> 0.0005s
== AddVisibilityLevelToProjects: migrated (0.1020s) ==========================
== AddArchivedToProjects: migrating ==========================================
-- add_column(:projects, :archived, :boolean, {:default=>false, :null=>false})
-> 0.0652s
== AddArchivedToProjects: migrated (0.0654s) =================================
== AddColorAndFontToBroadcastMessages: migrating =============================
-- add_column(:broadcast_messages, :color, :string)
-> 0.0008s
-- add_column(:broadcast_messages, :font, :string)
-> 0.0004s
== AddColorAndFontToBroadcastMessages: migrated (0.0014s) ====================
== AddEventFieldsForWebHook: migrating =======================================
-- add_column(:web_hooks, :push_events, :boolean, {:default=>true, :null=>false})
-> 0.0475s
-- add_column(:web_hooks, :issues_events, :boolean, {:default=>false, :null=>false})
-> 0.0360s
-- add_column(:web_hooks, :merge_requests_events, :boolean, {:default=>false, :null=>false})
-> 0.0359s
== AddEventFieldsForWebHook: migrated (0.1198s) ==============================
== AddHideNoSshKeyToUsers: migrating =========================================
-- add_column(:users, :hide_no_ssh_key, :boolean, {:default=>false})
-> 0.1227s
== AddHideNoSshKeyToUsers: migrated (0.1229s) ================================
== AddRecipientsToService: migrating =========================================
-- add_column(:services, :recipients, :text)
-> 0.0009s
== AddRecipientsToService: migrated (0.0010s) ================================
== AddWebsiteUrlToUsers: migrating ===========================================
-- add_column(:users, :website_url, :string, {:null=>false, :default=>""})
-> 0.1397s
== AddWebsiteUrlToUsers: migrated (0.1399s) ==================================
== CreateMergeRequestDiffs: migrating ========================================
-- create_table(:merge_request_diffs)
-> 0.0354s
== CreateMergeRequestDiffs: migrated (0.0355s) ===============================
== MigrateMrDiffs: migrating =================================================
-- execute("INSERT INTO merge_request_diffs ( merge_request_id, st_commits, st_diffs ) SELECT id, st_commits, st_diffs FROM merge_requests")
-> 0.0007s
== MigrateMrDiffs: migrated (0.0010s) ========================================
== RemoveMRdiffFields: migrating =============================================
-- remove_column(:merge_requests, :st_commits)
-> 0.0006s
-- remove_column(:merge_requests, :st_diffs)
-> 0.0003s
== RemoveMRdiffFields: migrated (0.0013s) ====================================
== AddGroupAvatars: migrating ================================================
-- add_column(:namespaces, :avatar, :string)
-> 0.0008s
== AddGroupAvatars: migrated (0.0010s) =======================================
== CreateEmails: migrating ===================================================
-- create_table(:emails)
-> 0.0158s
-- add_index(:emails, :user_id)
-> 0.0191s
-- add_index(:emails, :email, {:unique=>true})
-> 0.0156s
== CreateEmails: migrated (0.0513s) ==========================================
== AddApiKeyToServices: migrating ============================================
-- add_column(:services, :api_key, :string)
-> 0.0008s
== AddApiKeyToServices: migrated (0.0011s) ===================================
== AddIndexMergeRequestDiffsOnMergeRequestId: migrating ======================
-- add_index(:merge_request_diffs, :merge_request_id, {:unique=>true})
-> 0.0150s
== AddIndexMergeRequestDiffsOnMergeRequestId: migrated (0.0153s) =============
== AddTagPushHooksToProjectHook: migrating ===================================
-- add_column(:web_hooks, :tag_push_events, :boolean, {:default=>false})
-> 0.0330s
== AddTagPushHooksToProjectHook: migrated (0.0332s) ==========================
== AddImportStatusToProject: migrating =======================================
-- add_column(:projects, :import_status, :string)
-> 0.0009s
== AddImportStatusToProject: migrated (0.0011s) ==============================
== MigrateAlreadyImportedProjects: migrating =================================
-- remove_column(:projects, :imported)
-> 0.0007s
== MigrateAlreadyImportedProjects: migrated (0.0034s) ========================
root@ip-10-112-47-195:/home/admin# echo 'puts User.all' | gitlabhq run console
Instance method "lock!" is already defined in ActiveRecord::Base, use generic helper instead or set StateMachine::Machine.ignore_method_conflicts = true.
Both MergeRequestDiff and its :state machine have defined a different default for "state". Use only one or the other for defining defaults to avoid unexpected behaviors.
Loading production environment (Rails 4.0.3)
Switch to inspect mode.
puts User.all
nil
root@ip-10-112-47-195:/home/admin# gitlabhq run rake db:seed_fu
== Seed from /opt/gitlabhq/db/fixtures/production/001_admin.rb
2014-04-03T09:40:09Z 6206 TID-osoyv9fnw INFO: Sidekiq client with redis options {:url=>"redis://localhost:6379", :namespace=>"resque:gitlab"}
Administrator account created:
[email protected]
password......5iveL!feroot@ip-10-112-47-195:/home/admin# echo 'User.all.map(&:email)' | gitlabhq run console
Instance method "lock!" is already defined in ActiveRecord::Base, use generic helper instead or set StateMachine::Machine.ignore_method_conflicts = true.
Both MergeRequestDiff and its :state machine have defined a different default for "state". Use only one or the other for defining defaults to avoid unexpected behaviors.
Loading production environment (Rails 4.0.3)
Switch to inspect mode.
User.all.map(&:email)
["[email protected]"]
I'm having a similar error for some reason. Not really sure why:
Started GET "/" for 127.0.0.1 at 2014-11-10 10:28:51 -0500
Processing by DashboardController#show as HTML
PG::Error: ERROR: relation "users_groups" does not exist
LINE 5: WHERE a.attrelid = '"users_groups"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"users_groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Completed 500 Internal Server Error in 125ms
ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "users_groups" does not exist
LINE 5: WHERE a.attrelid = '"users_groups"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"users_groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
):
app/models/user.rb:285:in
authorized_projects' app/controllers/dashboard_controller.rb:77:inload_projects'app/controllers/application_controller.rb:59:in `set_current_user_for_thread'