search

sameersbn / docker-gitlab

Dockerized GitLab
http://www.damagehead.com/docker-gitlab/
MIT License
7.9k stars 2.14k forks source link

Migration Failed in 9.1.0-1 #1195

Open Kaleesastha opened 7 years ago

Kaleesastha commented 7 years ago

We are moving into the latest release of gitlab version 9.1.0-1. During migration we are experienced with DataBase Migration issue. The detailed log is given below,

*2017-04-26T18:45:20.814520000Z Configuring nginx::gitlab... 2017-04-26T18:45:20.844647000Z Configuring nginx::gitlab::ssl... 2017-04-26T18:45:20.874463000Z Configuring nginx::gitlab::hsts... 2017-04-26T18:45:20.894269000Z Configuring nginx::gitlab-pages... 2017-04-26T18:45:20.990357000Z Migrating database... 2017-04-26T18:45:36.797448000Z Missing Rails.application.secrets.jws_private_key for production environment. The secret will be generated and stored in config/secrets.yml. 2017-04-26T18:45:37.846065000Z rake aborted! 2017-04-26T18:45:37.846623000Z StandardError: An error has occurred, all later migrations canceled: 2017-04-26T18:45:37.847381000Z Mysql2::Error: Duplicate column name 'coverage_regex': ALTER TABLE ci_builds ADD coverage_regex varchar(255)/home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in query' 2017-04-26T18:45:37.847757000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inblock in execute' 2017-04-26T18:45:37.848124000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in block in log' 2017-04-26T18:45:37.848526000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:ininstrument' 2017-04-26T18:45:37.848904000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in log' 2017-04-26T18:45:37.849268000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inexecute' 2017-04-26T18:45:37.849654000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in execute' 2017-04-26T18:45:37.850015000Z /home/git/gitlab/config/initializers/connection_fix.rb:20:inexecute' 2017-04-26T18:45:37.850469000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:407:in add_column' 2017-04-26T18:45:37.850796000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:inblock in method_missing' 2017-04-26T18:45:37.851111000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in block in say_with_time' 2017-04-26T18:45:37.851449000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:insay_with_time' 2017-04-26T18:45:37.851755000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in method_missing' 2017-04-26T18:45:37.852056000Z /home/git/gitlab/db/migrate/20161114024742_add_coverage_regex_to_builds.rb:11:inchange' 2017-04-26T18:45:37.852407000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:608:in exec_migration' 2017-04-26T18:45:37.852734000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' 2017-04-26T18:45:37.853040000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in block in migrate' 2017-04-26T18:45:37.853365000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' 2017-04-26T18:45:37.853687000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in migrate' 2017-04-26T18:45:37.854010000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:inmigrate' 2017-04-26T18:45:37.854342000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' 2017-04-26T18:45:37.854665000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:inddl_transaction' 2017-04-26T18:45:37.854986000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in execute_migration_in_transaction' 2017-04-26T18:45:37.855318000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:inblock in migrate' 2017-04-26T18:45:37.855644000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in each' 2017-04-26T18:45:37.855954000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:inmigrate' 2017-04-26T18:45:37.856274000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in up' 2017-04-26T18:45:37.856609000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:inmigrate' 2017-04-26T18:45:37.856915000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in migrate' 2017-04-26T18:45:37.857224000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:inblock (2 levels) in <top (required)>' 2017-04-26T18:45:37.857538000Z ActiveRecord::StatementInvalid: Mysql2::Error: Duplicate column name 'coverage_regex': ALTER TABLE ci_builds ADD coverage_regex varchar(255) 2017-04-26T18:45:37.857858000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in query' 2017-04-26T18:45:37.858180000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inblock in execute' 2017-04-26T18:45:37.858503000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in block in log' 2017-04-26T18:45:37.858806000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:ininstrument' 2017-04-26T18:45:37.859229000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in log' 2017-04-26T18:45:37.859746000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inexecute' 2017-04-26T18:45:37.860207000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in execute' 2017-04-26T18:45:37.860533000Z /home/git/gitlab/config/initializers/connection_fix.rb:20:inexecute' 2017-04-26T18:45:37.860837000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:407:in add_column' 2017-04-26T18:45:37.861139000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:inblock in method_missing' 2017-04-26T18:45:37.861458000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in block in say_with_time' 2017-04-26T18:45:37.861763000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:insay_with_time' 2017-04-26T18:45:37.862066000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in method_missing' 2017-04-26T18:45:37.862377000Z /home/git/gitlab/db/migrate/20161114024742_add_coverage_regex_to_builds.rb:11:inchange' 2017-04-26T18:45:37.862681000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:608:in exec_migration' 2017-04-26T18:45:37.862985000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' 2017-04-26T18:45:37.863286000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in block in migrate' 2017-04-26T18:45:37.863607000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' 2017-04-26T18:45:37.863915000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in migrate' 2017-04-26T18:45:37.864216000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:inmigrate' 2017-04-26T18:45:37.864533000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' 2017-04-26T18:45:37.864836000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:inddl_transaction' 2017-04-26T18:45:37.865138000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in execute_migration_in_transaction' 2017-04-26T18:45:37.865450000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:inblock in migrate' 2017-04-26T18:45:37.865755000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in each' 2017-04-26T18:45:37.866056000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:inmigrate' 2017-04-26T18:45:37.866564000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in up' 2017-04-26T18:45:37.866853000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:inmigrate' 2017-04-26T18:45:37.867132000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in migrate' 2017-04-26T18:45:37.867424000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:inblock (2 levels) in <top (required)>' 2017-04-26T18:45:37.867704000Z Mysql2::Error: Duplicate column name 'coverage_regex' 2017-04-26T18:45:37.868073000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:in query' 2017-04-26T18:45:37.868533000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inblock in execute' 2017-04-26T18:45:37.868980000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in block in log' 2017-04-26T18:45:37.869278000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:ininstrument' 2017-04-26T18:45:37.869571000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in log' 2017-04-26T18:45:37.869854000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:309:inexecute' 2017-04-26T18:45:37.870133000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/mysql2_adapter.rb:225:in execute' 2017-04-26T18:45:37.870426000Z /home/git/gitlab/config/initializers/connection_fix.rb:20:inexecute' 2017-04-26T18:45:37.870708000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:407:in add_column' 2017-04-26T18:45:37.870988000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:665:inblock in method_missing' 2017-04-26T18:45:37.871265000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:in block in say_with_time' 2017-04-26T18:45:37.871563000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:634:insay_with_time' 2017-04-26T18:45:37.871847000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:654:in method_missing' 2017-04-26T18:45:37.872127000Z /home/git/gitlab/db/migrate/20161114024742_add_coverage_regex_to_builds.rb:11:inchange' 2017-04-26T18:45:37.872418000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:608:in exec_migration' 2017-04-26T18:45:37.872706000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' 2017-04-26T18:45:37.872987000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:591:in block in migrate' 2017-04-26T18:45:37.873270000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' 2017-04-26T18:45:37.873559000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:590:in migrate' 2017-04-26T18:45:37.873842000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:768:inmigrate' 2017-04-26T18:45:37.874124000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' 2017-04-26T18:45:37.874414000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:1046:inddl_transaction' 2017-04-26T18:45:37.874699000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:997:in execute_migration_in_transaction' 2017-04-26T18:45:37.874978000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:959:inblock in migrate' 2017-04-26T18:45:37.875256000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:in each' 2017-04-26T18:45:37.875543000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:955:inmigrate' 2017-04-26T18:45:37.875823000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:823:in up' 2017-04-26T18:45:37.876105000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/migration.rb:801:inmigrate' 2017-04-26T18:45:37.876395000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/tasks/database_tasks.rb:137:in migrate' 2017-04-26T18:45:37.876675000Z /home/git/gitlab/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.8/lib/active_record/railties/databases.rake:44:inblock (2 levels) in <top (required)>' 2017-04-26T18:45:37.876956000Z Tasks: TOP => db:migrate 2017-04-26T18:45:37.877234000Z (See full trace by running task with --trace)*

Couldn't proceed further. Kindly help me to overcome this issue. Your suggestions are highly appreciated.

Thanks, Kaleeswaran

frostieDE commented 7 years ago

What version are you migrating from?

Note: This issue was also posted on the GitLab issue tracker.

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had any activity for the last 60 days. It will be closed if no further activity occurs during the next 7 days. Thank you for your contributions.