Running a package install after a cleanse-uninstall results in a db:migrate error during reconfigure ( on centos7)
On a centos7 machine, on trying to upgrade to the lastest omnibus packages, when I run gitlab-ctl reconfigure, after cleanising & uninstalling the the previously installed omnibus package, I get the following error.
Running handlers:
[2015-04-22T10:24:42-07:00] ERROR: Running exception handlers
Running handlers complete
[2015-04-22T10:24:42-07:00] ERROR: Exception handlers complete
[2015-04-22T10:24:42-07:00] FATAL: Stacktrace dumped to /opt/gitlab/embedded/cookbooks/cache/chef-stacktrace.out
Chef Client failed. 78 resources updated in 73.077566983 seconds
[2015-04-22T10:24:42-07:00] ERROR: bash[migrate gitlab-rails database] (gitlab::database_migrations line 19) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'
---- Begin output of "bash" "/tmp/chef-script20150422-17298-o9zvd5" ----
STDOUT: rake aborted!
ActiveRecord::NoDatabaseError: FATAL: role "gitlab" does not exist
Run `$ bin/rake db:create db:migrate` to create your database
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/postgresql_adapter.rb:898:in `rescue in connect'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/postgresql_adapter.rb:888:in `connect'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/postgresql_adapter.rb:568:in `initialize'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:435:in `new_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:445:in `checkout_new_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `acquire_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:351:in `block in checkout'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:350:in `checkout'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:541:in `retrieve_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_handling.rb:113:in `retrieve_connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/connection_handling.rb:87:in `connection'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/migration.rb:916:in `initialize'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/migration.rb:814:in `new'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/migration.rb:814:in `up'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/migration.rb:792:in `migrate'
/opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.1.9/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
PG::Error: FATAL: role "gitlab" does not exist
Run `$ bin/rake db:create db:migrate` to create your database
---- End output of "bash" "/tmp/chef-script20150422-17298-o9zvd5" ----
Ran "bash" "/tmp/chef-script20150422-17298-o9zvd5" returned 1
[2015-04-22T10:24:42-07:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)
Reproduction steps were:
1. sudo gitlab-ctl cleanse
2. sudo gitlab-ctl uninstall
3. rpm -e gitlab
4. Install the omnibus package for centos7
5. Run gitlab-ctl reconfigure
The postgres logs are:
==> /var/log/gitlab/postgresql/current <==
2015-04-22_17:23:46.42789 LOG: database system was shut down at 2015-04-22 17:23:42 GMT
2015-04-22_17:23:46.50343 LOG: database system is ready to accept connections
2015-04-22_17:23:46.51961 LOG: autovacuum launcher started
2015-04-22_17:24:42.36167 FATAL: role "gitlab" does not exist
Note: When reconfigure is run again, this issue is not seen and Gitlab is reconfigured