GitLab

Created by: podhy

When migrating to new version 6 from 5.4. DB migrate tool throws error on PostgreSQL:

** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Invoke db:load_config (first_time) ** Execute db:load_config ** Execute db:migrate == AllowMergesForForks: migrating ============================================ -- add_column(:merge_requests, :target_project_id, :integer, {:null=>false}) rake aborted! An error has occurred, this and all later migrations canceled:

PG::Error: ERROR: column "target_project_id" contains null values : ALTER TABLE "merge_requests" ADD COLUMN "target_project_id" integer NOT NULL/home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in exec' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:650:inblock in execute' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:649:inexecute' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1022:in add_column' /home/git/gitlab/config/initializers/postgresql_limit_fix.rb:15:inadd_column_with_limit_filter' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:466:in block in method_missing' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:438:inblock in say_with_time' /usr/lib64/ruby/1.9.1/benchmark.rb:280:in measure' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:438:insay_with_time' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:458:in method_missing' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:334:inmethod_missing' /home/git/gitlab/db/migrate/20130419190306_allow_merges_for_forks.rb:3:in up' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:370:inup' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:410:in block (2 levels) in migrate' /usr/lib64/ruby/1.9.1/benchmark.rb:280:inmeasure' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:410:in block in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:inwith_connection' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:389:in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:528:inmigrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:720:in block (2 levels) in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:775:incall' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:775:in block in ddl_transaction' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract/database_statements.rb:192:intransaction' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/transactions.rb:208:in transaction' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:775:inddl_transaction' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:719:in block in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:700:ineach' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:700:in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:570:inup' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/migration.rb:551:in migrate' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.13/lib/active_record/railties/databases.rake:193:inblock (2 levels) in <top (required)>' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:236:in call' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:236:inblock in execute' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:231:in each' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:231:inexecute' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:175:in block in invoke_with_call_chain' /usr/lib64/ruby/1.9.1/monitor.rb:211:inmon_synchronize' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:168:in invoke_with_call_chain' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/task.rb:161:ininvoke' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:149:in invoke_task' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:in each' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:106:inblock in top_level' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:115:in run_with_threads' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:100:intop_level' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:78:in block in run' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:165:instandard_exception_handling' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/lib/rake/application.rb:75:in run' /home/git/gitlab/vendor/bundle/ruby/1.9.1/gems/rake-10.1.0/bin/rake:33:in<top (required)>' /home/git/gitlab/vendor/bundle/ruby/1.9.1/bin/rake:23:in load' /home/git/gitlab/vendor/bundle/ruby/1.9.1/bin/rake:23:in' Tasks: TOP => db:migrate