crash on db migrate 7.12 -> 7.13rc1
Hi,
Following the 7.12 to 7.13 upgrade guide when i run the task for db:migrate the following crash occurs :
== 20150609141121 AddSessionExpireDelayForApplicationSettings: migrating ======
-- add_column(:application_settings, :session_expire_delay, :integer, {:default=>10080, :null=>false})
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::DuplicateColumn: ERROR: column "session_expire_delay" of relation "application_settings" already exists
: ALTER TABLE "application_settings" ADD COLUMN "session_expire_delay" integer DEFAULT 10080 NOT NULL/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activesupport-4.1.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/schema_statements.rb:375:in `add_column'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/schema_statements.rb:398:in `add_column'
/opt/gits/gitlab/config/initializers/postgresql_limit_fix.rb:15:in `add_column_with_limit_filter'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:656:in `block in method_missing'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `block in say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:648:in `method_missing'
/opt/gits/gitlab/db/migrate/20150609141121_add_session_expire_delay_for_application_settings.rb:3:in `change'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:602:in `exec_migration'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:585:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:584:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:759:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/transactions.rb:208:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:959:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `each'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:814:in `up'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:792:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
ActiveRecord::StatementInvalid: PG::DuplicateColumn: ERROR: column "session_expire_delay" of relation "application_settings" already exists
: ALTER TABLE "application_settings" ADD COLUMN "session_expire_delay" integer DEFAULT 10080 NOT NULL
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activesupport-4.1.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/schema_statements.rb:375:in `add_column'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/schema_statements.rb:398:in `add_column'
/opt/gits/gitlab/config/initializers/postgresql_limit_fix.rb:15:in `add_column_with_limit_filter'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:656:in `block in method_missing'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `block in say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:648:in `method_missing'
/opt/gits/gitlab/db/migrate/20150609141121_add_session_expire_delay_for_application_settings.rb:3:in `change'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:602:in `exec_migration'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:585:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:584:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:759:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/transactions.rb:208:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:959:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `each'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:814:in `up'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:792:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
PG::DuplicateColumn: ERROR: column "session_expire_delay" of relation "application_settings" already exists
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activesupport-4.1.11/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/schema_statements.rb:375:in `add_column'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/postgresql/schema_statements.rb:398:in `add_column'
/opt/gits/gitlab/config/initializers/postgresql_limit_fix.rb:15:in `add_column_with_limit_filter'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:656:in `block in method_missing'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `block in say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:628:in `say_with_time'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:648:in `method_missing'
/opt/gits/gitlab/db/migrate/20150609141121_add_session_expire_delay_for_application_settings.rb:3:in `change'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:602:in `exec_migration'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:586:in `block (2 levels) in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:585:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:584:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:759:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `block in ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/transactions.rb:208:in `transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:1044:in `ddl_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:997:in `execute_migration_in_transaction'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:959:in `block in migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `each'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:955:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:814:in `up'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/migration.rb:792:in `migrate'
/opt/gits/gitlab/vendor/bundle/ruby/2.2.0/gems/activerecord-4.1.11/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate
How to fix ? regards,