DB Migration Error: relation "tags" already exists; schema difference
Summary
When upgrading between minor releases (e.g. 9.0 to 9.1 or 10.4 to 10.5), I get the following error:
PG::DuplicateTable: ERROR: relation "tags" already exists
The table in Postgres has 3 columns, but the table definition in the migration file has only two.
Steps to reproduce
Upgrade between minor releases. It should include the migration file 20180626233449_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb
Run db migration step:
bundle exec rake db:migrate RAILS_ENV=production
What is the current bug behavior?
I get the following message, followed by a very long stack trace.
== 20180626233449 ActsAsTaggableOnMigration: migrating ========================
-- create_table(:tags)
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::DuplicateTable: ERROR: relation "tags" already exists
: CREATE TABLE "tags" ("id" serial primary key, "name" character varying)
What is the expected correct behavior?
Db migration should complete without errors.
Relevant logs and/or screenshots
Expand for full error and stack trace
== 20180626233449 ActsAsTaggableOnMigration: migrating ======================== -- create_table(:tags) rake aborted! StandardError: An error has occurred, this and all later migrations canceled:PG::DuplicateTable: ERROR: relation "tags" already exists : CREATE TABLE "tags" ("id" serial primary key, "name" character varying) /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:inblock in execute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in
block in log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in
log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:inexecute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/schema_statements.rb:222:in
create_table' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:665:inblock in method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:in
block in say_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:insay_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:654:in
method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:416:inmethod_missing' /home/git/gitlab/db/migrate/20180626233449_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb:4:in
up' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:571:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:611:in
exec_migration' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:591:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:590:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:768:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1023:in
block in execute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:inblock in ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
block in transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/transaction.rb:184:inwithin_new_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220:intransaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:in
ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1022:inexecute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:984:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:ineach' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:823:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:801:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:139:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/railties/databases.rake:44:in
block (2 levels) in <top (required)>' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/rake-12.3.0/exe/rake:27:in<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:in
load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:inkernel_load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:28:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:424:inexec' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:ininvoke_command' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor.rb:387:in
dispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:27:indispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in
start' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:18:instart' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:30:in
block in <top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/friendly_errors.rb:124:inwith_friendly_errors' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:22:in
<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:inload' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:in
' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:ineval' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:in
'Caused by: ActiveRecord::StatementInvalid: PG::DuplicateTable: ERROR: relation "tags" already exists : CREATE TABLE "tags" ("id" serial primary key, "name" character varying) /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:inblock in execute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in
block in log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in
log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:inexecute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/schema_statements.rb:222:in
create_table' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:665:inblock in method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:in
block in say_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:insay_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:654:in
method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:416:inmethod_missing' /home/git/gitlab/db/migrate/20180626233449_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb:4:in
up' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:571:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:611:in
exec_migration' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:591:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:590:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:768:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1023:in
block in execute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:inblock in ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
block in transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/transaction.rb:184:inwithin_new_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220:intransaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:in
ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1022:inexecute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:984:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:ineach' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:823:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:801:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:139:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/railties/databases.rake:44:in
block (2 levels) in <top (required)>' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/rake-12.3.0/exe/rake:27:in<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:in
load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:inkernel_load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:28:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:424:inexec' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:ininvoke_command' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor.rb:387:in
dispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:27:indispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in
start' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:18:instart' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:30:in
block in <top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/friendly_errors.rb:124:inwith_friendly_errors' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:22:in
<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:inload' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:in
' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:ineval' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:in
'Caused by: PG::DuplicateTable: ERROR: relation "tags" already exists /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in
async_exec' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:155:inblock in execute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in
block in log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in
log' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:inexecute' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/schema_statements.rb:222:in
create_table' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:665:inblock in method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:in
block in say_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:634:insay_with_time' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:654:in
method_missing' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:416:inmethod_missing' /home/git/gitlab/db/migrate/20180626233449_acts_as_taggable_on_migration.acts_as_taggable_on_engine.rb:4:in
up' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:571:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:611:in
exec_migration' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:591:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:590:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:768:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1023:in
block in execute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:inblock in ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
block in transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/transaction.rb:184:inwithin_new_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/transactions.rb:220:intransaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1069:in
ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:1022:inexecute_migration_in_transaction' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:984:in
block in migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:ineach' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:980:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:823:inup' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/migration.rb:801:in
migrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/tasks/database_tasks.rb:139:inmigrate' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.10/lib/active_record/railties/databases.rake:44:in
block (2 levels) in <top (required)>' /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/rake-12.3.0/exe/rake:27:in<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:in
load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:74:inkernel_load' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli/exec.rb:28:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:424:inexec' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in
run' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:ininvoke_command' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor.rb:387:in
dispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:27:indispatch' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in
start' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/cli.rb:18:instart' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:30:in
block in <top (required)>' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/lib/bundler/friendly_errors.rb:124:inwith_friendly_errors' /home/git/.rvm/gems/ruby-2.3.7/gems/bundler-1.16.3/exe/bundle:22:in
<top (required)>' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:inload' /home/git/.rvm/gems/ruby-2.3.7/bin/bundle:22:in
' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:ineval' /home/git/.rvm/gems/ruby-2.3.7/bin/ruby_executable_hooks:24:in
' Tasks: TOP => db:migrate (See full trace by running task with --trace)
The actual table in Postgres looks like this; notice that it has three columns, not just two:
gitlabhq_production=# \d tags Table "public.tags" Column | Type | Collation | Nullable | Default ----------------+------------------------+-----------+----------+---------------------------------- id | integer | | not null | nextval('tags_id_seq'::regclass) name | character varying(255) | | | taggings_count | integer | | | 0 Indexes: "tags_pkey" PRIMARY KEY, btree (id) "index_tags_on_name" UNIQUE, btree (name)
Output of checks
Results of GitLab environment info
Expand for output related to GitLab environment info
System information System: Current User: git Using RVM: yes RVM Version: 1.27.0 Ruby Version: 2.3.7p456 Gem Version: 2.5.2.3 Bundler Version:1.16.3 Rake Version: 12.3.0 Redis Version: 2.8.13 Git Version: 2.18.0 Sidekiq Version:5.0.5 Go Version: go1.8.3 linux/amd64GitLab information Version: 10.5.8 Revision: 40e125820c9 Directory: /home/git/gitlab DB Adapter: postgresql URL: https://silver.example.com HTTP Clone URL: https://silver.example.com/some-group/some-project.git SSH Clone URL: git@silver.example.com:some-group/some-project.git Using LDAP: yes Using Omniauth: no
GitLab Shell Version: 6.0.3 Repository storage paths:
- default: /home/git/repositories Hooks: /home/git/gitlab-shell/hooks Git: /usr/local/bin/git
Results of GitLab application Check
Expand for output related to the GitLab application check
Checking GitLab Shell ...GitLab Shell version >= 6.0.3 ? ... OK (6.0.3) Repo base directory exists? default... yes Repo storage directories are symlinks? default... no Repo paths owned by git:root, or git:git? default... yes Repo paths access is drwxrws---? default... yes hooks directories in repos are links: ... Administrator / testproject2 ... ok Andrew / Test Project ... repository is empty LCOFIS / FISHomePage ... ok LCOFIS / FISLogin ... repository is empty LCOFIS / FISSuiteBC ... ok LCOFIS / FISSuite.NET ... ok LCOFIS / kickstart ... ok LCOFIS / oracleTools ... ok LCOFIS / pki ... ok LCOFIS / PostgresBackup ... ok LCOFIS / SeaCollection ... ok LCOFIS / SeaCollectionWeb ... ok LCOFIS / SeaTrackLibrary ... ok LCOFIS / server_cfg ... ok LCOFIS / FISExtensionMethods ... ok LCOFIS / FISStyles ... ok LCOFIS / FISUtilities ... ok LCOFIS / MyExtensionMethods ... ok LCOFIS / nagios_cfg ... ok LCOFIS / oraclePassword ... ok LCOFIS / puppet ... ok LCOFIS / attrxfr ... ok LCOFIS / AttrXfrWebDev ... ok LCOFIS / OSUtils ... ok LCOFIS / CMS ... ok LCOFIS / ArticleTracking ... ok James / PostgresTools ... repository is empty LCOFIS / PostgresTools ... ok Evan / www ... ok LCOFIS / AttrXfrWebProduction ... ok LCOFIS / USMaterials ... repository is empty LCOFIS / FISDataService ... ok LCOFIS / SeaCollectionClientsBackups ... ok LCOFIS / orapass ... ok Andrew / DockerTesting ... ok LCOFIS / scan ... ok Andrew / DockerDemo ... ok LCOFIS / inventory ... ok LCOFIS / FisFactoryServices ... ok LCOFIS / oralog ... ok LCOFIS / postfix ... ok LCOFIS / centos7_systemd ... ok LCOFIS / tftp ... ok LCOFIS / getput ... ok Andrew / Git-demo ... ok Andrew / DockerMicroservice ... ok LCOFIS / FISGetPutMicroservice ... ok Andrew / andrewtest ... repository is empty LCOFIS / nginx_test ... ok LCOFIS / FailLabelStation ... ok LCOFIS / WebCaptureStation ... ok LCOFIS / SomeLDAP ... ok Andrew / test ... repository is empty LCOFIS / CMSRequestService ... ok LCOFIS / cmscrudservice ... ok LCOFIS / CMSGUI_Legacy ... ok LCOFIS / CMSSBR_Legacy ... ok LCOFIS / CMSXfr ... ok LCOFIS / DFSArchive ... ok LCOFIS / nagios_plugins ... ok Running /home/git/gitlab-shell/bin/check Check GitLab API access: OK Redis available via internal API: OK
Access to /home/git/.ssh/authorized_keys: OK gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Sidekiq ...
Running? ... yes Number of Sidekiq processes ... 1
Checking Sidekiq ... Finished
Reply by email is disabled in config/gitlab.yml Checking LDAP ...
Server: ldapmain LDAP authentication... Anonymous. No
bind_dn
orpassword
configured LDAP users with access to your GitLab server (only showing the first 100 results) DN: uid=32,ou=people,o=example.com,o=sds uid: 32 DN: uid=58,ou=people,o=example.com,o=sds uid: 58 ...Checking LDAP ... Finished
Checking GitLab ...
Git configured correctly? ... yes Database config exists? ... yes All migrations up? ... yes Database contains orphaned GroupMembers? ... no GitLab config exists? ... yes GitLab config up to date? ... yes Log directory writable? ... yes Tmp directory writable? ... yes Uploads directory exists? ... yes Uploads directory has correct permissions? ... yes Uploads directory tmp has correct permissions? ... yes Init script exists? ... yes Init script up-to-date? ... yes Projects have namespace: ... Administrator / testproject2 ... yes Andrew / Test Project ... yes LCOFIS / FISHomePage ... yes LCOFIS / FISLogin ... yes LCOFIS / FISSuiteBC ... yes LCOFIS / FISSuite.NET ... yes LCOFIS / kickstart ... yes LCOFIS / oracleTools ... yes LCOFIS / pki ... yes LCOFIS / PostgresBackup ... yes LCOFIS / SeaCollection ... yes LCOFIS / SeaCollectionWeb ... yes LCOFIS / SeaTrackLibrary ... yes LCOFIS / server_cfg ... yes LCOFIS / FISExtensionMethods ... yes LCOFIS / FISStyles ... yes LCOFIS / FISUtilities ... yes LCOFIS / MyExtensionMethods ... yes LCOFIS / nagios_cfg ... yes LCOFIS / oraclePassword ... yes LCOFIS / puppet ... yes LCOFIS / attrxfr ... yes LCOFIS / AttrXfrWebDev ... yes LCOFIS / OSUtils ... yes LCOFIS / CMS ... yes LCOFIS / ArticleTracking ... yes James / PostgresTools ... yes LCOFIS / PostgresTools ... yes Evan / www ... yes LCOFIS / AttrXfrWebProduction ... yes LCOFIS / USMaterials ... yes LCOFIS / FISDataService ... yes LCOFIS / SeaCollectionClientsBackups ... yes LCOFIS / orapass ... yes Andrew / DockerTesting ... yes LCOFIS / scan ... yes Andrew / DockerDemo ... yes LCOFIS / inventory ... yes LCOFIS / FisFactoryServices ... yes LCOFIS / oralog ... yes LCOFIS / postfix ... yes LCOFIS / centos7_systemd ... yes LCOFIS / tftp ... yes LCOFIS / getput ... yes Andrew / Git-demo ... yes Andrew / DockerMicroservice ... yes LCOFIS / FISGetPutMicroservice ... yes Andrew / andrewtest ... yes LCOFIS / nginx_test ... yes LCOFIS / FailLabelStation ... yes LCOFIS / WebCaptureStation ... yes LCOFIS / SomeLDAP ... yes Andrew / test ... yes LCOFIS / CMSRequestService ... yes LCOFIS / cmscrudservice ... yes LCOFIS / CMSGUI_Legacy ... yes LCOFIS / CMSSBR_Legacy ... yes LCOFIS / CMSXfr ... yes LCOFIS / DFSArchive ... yes LCOFIS / nagios_plugins ... yes Redis version >= 2.8.0? ... yes Ruby version >= 2.3.5 ? ... yes (2.3.7) Git version >= 2.9.5 ? ... yes (2.18.0) Git user has default SSH configuration? ... yes Active users: ... 9
Checking GitLab ... Finished