Skip to content
Snippets Groups Projects
New issue look: Off

Getting 502/500 Error after upgrade from 7.3.2 to 7.4.0

    • Closed Issue created by username-removed-63212 @rsakhale

    After I upgraded from 7.3.2 to 7.4.0, I am getting 502/500 Error

    First it comes as 502 for couple of minutes and later the error turns into 500

    Steps I followed Stopped GitLab Server by

    sudo gitlab-ctl stop

    Updgraded using following command

    sudo dpkg -i gitlab_7.4.0-omnibus-1_amd64.deb

    Reconfigured GitLab server

    sudo gitlab-ctl reconfigured

    After this, I again restarted gitlab-ctl

    sudo gitlab-ctl restart

    Operating System: Ubuntu 12.04 LTS

    Please let me know if any logs I can provide for better debug

    Designs

      Child items ...

      2. Activity

      • username-removed-2900
        username-removed-2900 @razer6 ·
        Maintainer

        Please provide production.log

      • username-removed-64123
        username-removed-64123 @schiefer ·

        We have the same problem. production.log: Completed 500 Internal Server Error in 10ms

        ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "members" does not exist LINE 5: WHERE a.attrelid = '"members"'::regclass ^
        SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"members"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum ): app/models/user.rb:295:in authorized_projects' app/controllers/dashboard_controller.rb:77:in load_projects'

        Operating System: Ubuntu 14.04.1 LTS

      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        I am also getting same error as above, please see below

        Processing by DashboardController#show as HTML
PG::Error: ERROR:  relation "members" does not exist
LINE 5:                WHERE a.attrelid = '"members"'::regclass
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                FROM pg_attribute a LEFT JOIN pg_attrdef d
                  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
               WHERE a.attrelid = '"members"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum

Completed 500 Internal Server Error in 22ms

ActiveRecord::StatementInvalid (PG::Error: ERROR:  relation "members" does not exist
LINE 5:                WHERE a.attrelid = '"members"'::regclass
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                FROM pg_attribute a LEFT JOIN pg_attrdef d
                  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
               WHERE a.attrelid = '"members"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum
):
  app/models/user.rb:295:in `authorized_projects'
  app/controllers/dashboard_controller.rb:77:in `load_projects'
      • username-removed-55677
        username-removed-55677 @mrimann ·

        I also see this error on Ubuntu 14.04 LTS.

        Not sure if it helps, but before I upgraded, I opened the help page of my Gitlab-Installation (https://gitlab.mydomain.tld/help) as it shows the exact version number of Gitlab. After the upgrade finished, I reloaded that page without any problems. But clicking any other link on Gitlab (e.g. going to a certain project) ended up in that error 500 being shown - while the help page was reloadable without any error.

      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        I too can access the help page, and shows the version as

        GitLab 7.4.0 ba76dbc
      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        Can anyone please help us get this issue fixed

      • username-removed-2900
        username-removed-2900 @razer6 ·
        Maintainer

        It seems somehow your database didn't get migrated.

        Can you look at a couple of things, please?

        1. Look in the database at the members table and tell me what columns are there.
        2. On your server, run the rails console (from the gitlab home/install directory as the git user): bundle exec rails console production
        3. Then run this in the console and tell me the database version: ActiveRecord::Migrator.current_version
      • Achilleas Pipinellis
        Achilleas Pipinellis @axil ·
        Maintainer

        @razer6 OP has omnibus, so in step 2, accessing the rails console would be sudo gitlab-rails console.

      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        Thanks @axil for the step 2, I was searching a lot for proper solution

        ActiveRecord::Migrator.current_version command outputs as below

        irb(main):001:0> ActiveRecord::Migrator.current_version
=> 20140907220153

        Can you please help me identify how I could connect the database and check for table members

      • username-removed-2900
        username-removed-2900 @razer6 ·
        Maintainer

        @axil Thank you, missed that :frowning:

        @rohansakhale You are on an old database version. 7.4 is supposed to be 2014007100818. Either you missed that step, or there was an error during the migrations.

        What happens if you execute sudo gitlab-ctl reconfigure again? What's the output?

      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        Here's the complete output when I try to reconfigure

        [2014-10-25T16:22:28+04:00] INFO: Forking chef instance to converge...
[2014-10-25T16:22:28+04:00] INFO: *** Chef 11.12.2 ***
[2014-10-25T16:22:28+04:00] INFO: Chef-client pid: 11524
[2014-10-25T16:22:30+04:00] INFO: Setting the run_list to ["recipe[gitlab]"] from CLI options
[2014-10-25T16:22:30+04:00] INFO: Run List is [recipe[gitlab]]
[2014-10-25T16:22:30+04:00] INFO: Run List expands to [gitlab]
[2014-10-25T16:22:30+04:00] INFO: Starting Chef Run for rohan.saiashirwad.in
[2014-10-25T16:22:30+04:00] INFO: Running start handlers
[2014-10-25T16:22:30+04:00] INFO: Start handlers complete.
[2014-10-25T16:22:31+04:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab] from prior resource (CHEF-3694)
[2014-10-25T16:22:31+04:00] WARN: Previous directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:40:in `from_file'
[2014-10-25T16:22:31+04:00] WARN: Current  directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/users.rb:23:in `from_file'
[2014-10-25T16:22:33+04:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab/gitlab-rails/etc] from prior resource (CHEF-3694)
[2014-10-25T16:22:33+04:00] WARN: Previous directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/gitlab-rails.rb:36:in `block in from_file'
[2014-10-25T16:22:33+04:00] WARN: Current  directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/definitions/unicorn_config.rb:21:in `block in from_file'
[2014-10-25T16:22:33+04:00] WARN: Cloning resource attributes for service[unicorn] from prior resource (CHEF-3694)
[2014-10-25T16:22:33+04:00] WARN: Previous service[unicorn]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-25T16:22:33+04:00] WARN: Current  service[unicorn]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
[2014-10-25T16:22:33+04:00] WARN: Cloning resource attributes for service[sidekiq] from prior resource (CHEF-3694)
[2014-10-25T16:22:33+04:00] WARN: Previous service[sidekiq]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-25T16:22:33+04:00] WARN: Current  service[sidekiq]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
[2014-10-25T16:22:34+04:00] INFO: execute[chown -R root:root /opt/gitlab/embedded/service/gitlab-rails/public] ran successfully
[2014-10-25T16:22:35+04:00] INFO: execute[initctl status gitlab-runsvdir] ran successfully
[2014-10-25T16:22:36+04:00] INFO: Chef Run complete in 6.253081744 seconds
[2014-10-25T16:22:36+04:00] INFO: Running report handlers
[2014-10-25T16:22:36+04:00] INFO: Report handlers complete
gitlab Reconfigured!
      • username-removed-2900
        username-removed-2900 @razer6 ·
        Maintainer

        What's the output of sudo gitlab-ctl status when doing the reconfiguration?

      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        After reconfiguration is done, output for sudo gitlab-ctl status is

        run: logrotate: (pid 10746) 1093s; run: log: (pid 334) 203348s
run: nginx: (pid 2483) 202710s; run: log: (pid 338) 203348s
run: postgresql: (pid 2492) 202709s; run: log: (pid 328) 203348s
run: redis: (pid 2500) 202709s; run: log: (pid 329) 203348s
run: sidekiq: (pid 2506) 202708s; run: log: (pid 330) 203348s
run: unicorn: (pid 2511) 202707s; run: log: (pid 327) 203348s
      • username-removed-2900
        username-removed-2900 @razer6 ·
        Maintainer

        While reconfiguration, unicorn and sidekiq need to be stopped!

        This is described in the update guide:

        sudo gitlab-ctl stop unicorn
sudo gitlab-ctl stop sidekiq
      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        While upgrading I had stopped GitLab by sudo gitlab-ctl stop

        Again, I ran above commands and reconfigured gitlab thats outputs as below

        [2014-10-25T16:58:53+04:00] INFO: Forking chef instance to converge...
[2014-10-25T16:58:53+04:00] INFO: *** Chef 11.12.2 ***
[2014-10-25T16:58:53+04:00] INFO: Chef-client pid: 1091
[2014-10-25T16:58:55+04:00] INFO: Setting the run_list to ["recipe[gitlab]"] from CLI options
[2014-10-25T16:58:55+04:00] INFO: Run List is [recipe[gitlab]]
[2014-10-25T16:58:55+04:00] INFO: Run List expands to [gitlab]
[2014-10-25T16:58:55+04:00] INFO: Starting Chef Run for rohan.saiashirwad.in
[2014-10-25T16:58:55+04:00] INFO: Running start handlers
[2014-10-25T16:58:55+04:00] INFO: Start handlers complete.
[2014-10-25T16:58:55+04:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab] from prior resource (CHEF-3694)
[2014-10-25T16:58:55+04:00] WARN: Previous directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:40:in `from_file'
[2014-10-25T16:58:55+04:00] WARN: Current  directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/users.rb:23:in `from_file'
[2014-10-25T16:58:57+04:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab/gitlab-rails/etc] from prior resource (CHEF-3694)
[2014-10-25T16:58:57+04:00] WARN: Previous directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/gitlab-rails.rb:36:in `block in from_file'
[2014-10-25T16:58:57+04:00] WARN: Current  directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/definitions/unicorn_config.rb:21:in `block in from_file'
[2014-10-25T16:58:57+04:00] WARN: Cloning resource attributes for service[unicorn] from prior resource (CHEF-3694)
[2014-10-25T16:58:57+04:00] WARN: Previous service[unicorn]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-25T16:58:57+04:00] WARN: Current  service[unicorn]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
[2014-10-25T16:58:57+04:00] WARN: Cloning resource attributes for service[sidekiq] from prior resource (CHEF-3694)
[2014-10-25T16:58:57+04:00] WARN: Previous service[sidekiq]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-25T16:58:57+04:00] WARN: Current  service[sidekiq]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
[2014-10-25T16:58:58+04:00] INFO: execute[chown -R root:root /opt/gitlab/embedded/service/gitlab-rails/public] ran successfully
[2014-10-25T16:58:59+04:00] INFO: execute[initctl status gitlab-runsvdir] ran successfully
[2014-10-25T16:58:59+04:00] INFO: Chef Run complete in 4.651086489 seconds
[2014-10-25T16:58:59+04:00] INFO: Running report handlers
[2014-10-25T16:58:59+04:00] INFO: Report handlers complete
gitlab Reconfigured!
      • username-removed-63212
        username-removed-63212 @rsakhale ·
        Author

        I see it was my mistake while upgrading I stopped the gitlab-ctl server which also stopped postgre-sql.

        I re-upgraded to 7.4.2 following the upgrade steps and everything is working fine.

        Thanks All for your help :thumbsup:

      • username-removed-63212 Status changed to closed

        Status changed to closed

      • username-removed-65576
        username-removed-65576 @semrah ·

        Sorry to reopen the same issue. But I made the same mistake. I upgraded with everything stoped and now I have the same errors. I tried stopping only unicorn and sidekiq and trying to sudo gitlab-ctl reconfigure

        • My schema is on version 20140907220153
        • My log on the last reconfigure shows like this:
        Starting Chef Client, version 11.12.2
Compiling Cookbooks...
Recipe: gitlab::default
  * directory[/etc/gitlab] action create (up to date)
[2014-10-29T11:16:58+01:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab] from prior resource (CHEF-3694)
[2014-10-29T11:16:58+01:00] WARN: Previous directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:40:in `from_file'
[2014-10-29T11:16:58+01:00] WARN: Current  directory[/var/opt/gitlab]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/users.rb:23:in `from_file'
[2014-10-29T11:16:59+01:00] WARN: Cloning resource attributes for directory[/var/opt/gitlab/gitlab-rails/etc] from prior resource (CHEF-3694)
[2014-10-29T11:16:59+01:00] WARN: Previous directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/gitlab-rails.rb:36:in `block in from_file'
[2014-10-29T11:16:59+01:00] WARN: Current  directory[/var/opt/gitlab/gitlab-rails/etc]: /opt/gitlab/embedded/cookbooks/gitlab/definitions/unicorn_config.rb:21:in `block in from_file'
[2014-10-29T11:16:59+01:00] WARN: Cloning resource attributes for service[unicorn] from prior resource (CHEF-3694)
[2014-10-29T11:16:59+01:00] WARN: Previous service[unicorn]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-29T11:16:59+01:00] WARN: Current  service[unicorn]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
[2014-10-29T11:16:59+01:00] WARN: Cloning resource attributes for service[sidekiq] from prior resource (CHEF-3694)
[2014-10-29T11:16:59+01:00] WARN: Previous service[sidekiq]: /opt/gitlab/embedded/cookbooks/gitlab/recipes/default.rb:60:in `block in from_file'
[2014-10-29T11:16:59+01:00] WARN: Current  service[sidekiq]: /opt/gitlab/embedded/cookbooks/runit/definitions/runit_service.rb:191:in `block in from_file'
Converging 176 resources
  * directory[/etc/gitlab] action nothing (skipped due to action :nothing)
  * directory[/var/opt/gitlab] action create (up to date)
Recipe: gitlab::users
  * directory[/var/opt/gitlab] action create (up to date)
  * group[git] action create (up to date)
  * user[git] action create (up to date)
  * template[/var/opt/gitlab/.gitconfig] action create (up to date)
Recipe: gitlab::web-server
  * group[gitlab-www] action create (up to date)
  * user[gitlab-www] action create (up to date)
Recipe: gitlab::gitlab-shell
  * directory[/var/opt/gitlab/git-data/repositories] action create (up to date)
  * directory[/var/opt/gitlab/.ssh] action create (up to date)
  * file[/var/opt/gitlab/.ssh/authorized_keys] action create (up to date)
  * file[/opt/gitlab/embedded/service/gitlab-shell/authorized_keys.lock] action create (up to date)
  * execute[chcon --recursive --type ssh_home_t /var/opt/gitlab/.ssh] action run (skipped due to only_if)
  * directory[/var/log/gitlab/gitlab-shell/] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-shell] action create (up to date)
  * directory[/var/opt/gitlab/git-data] action create (up to date)
  * template[/var/opt/gitlab/gitlab-shell/config.yml] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-shell/config.yml] action create (up to date)
Recipe: gitlab::gitlab-rails
  * directory[/var/opt/gitlab/gitlab-rails/etc] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails/working] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails/tmp] action create (up to date)
  * directory[/var/opt/gitlab/backups] action create (up to date)
  * directory[/var/log/gitlab/gitlab-rails] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails/uploads] action create (up to date)
  * directory[/opt/gitlab/etc/gitlab-rails/env] action create (up to date)
  * template[/opt/gitlab/etc/gitlab-rails/gitlab-rails-rc] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/secret] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/.secret] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/database.yml] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/database.yml] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/resque.yml] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/resque.yml] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/aws.yml] action delete (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/aws.yml] action delete (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/smtp_settings.rb] action delete (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/smtp_settings.rb] action delete (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/gitlab.yml] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/gitlab.yml] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/rack_attack.rb] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/config/initializers/rack_attack.rb] action create (up to date)
  * directory[/var/opt/gitlab/git-data/gitlab-satellites] action create (up to date)
  * file[/opt/gitlab/etc/gitlab-rails/env/HOME] action create (up to date)
  * file[/opt/gitlab/etc/gitlab-rails/env/RAILS_ENV] action create (up to date)
  * file[/opt/gitlab/etc/gitlab-rails/env/BUNDLE_GEMFILE] action create (up to date)
  * file[/opt/gitlab/etc/gitlab-rails/env/PATH] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/tmp] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/public/uploads] action create (up to date)
  * link[/opt/gitlab/embedded/service/gitlab-rails/log] action create (up to date)
  * link[/var/log/gitlab/gitlab-rails/sidekiq.log] action create (skipped due to not_if)
  * file[/opt/gitlab/embedded/service/gitlab-rails/db/schema.rb] action create (up to date)
  * remote_file[/var/opt/gitlab/gitlab-rails/VERSION] action create (up to date)
  * execute[chown -R root:root /opt/gitlab/embedded/service/gitlab-rails/public] action run
    - execute chown -R root:root /opt/gitlab/embedded/service/gitlab-rails/public

  * execute[clear the gitlab-rails cache] action nothing (skipped due to action :nothing)
Recipe: gitlab::default
  * service[unicorn] action nothing (up to date)
  * service[sidekiq] action nothing (up to date)
Recipe: runit::upstart
  * cookbook_file[/etc/init/gitlab-runsvdir.conf] action create (up to date)
  * execute[initctl status gitlab-runsvdir] action run
    - execute initctl status gitlab-runsvdir

  * execute[initctl start gitlab-runsvdir] action run (skipped due to only_if)
Recipe: gitlab::redis
  * group[gitlab-redis] action create (up to date)
  * user[gitlab-redis] action create (up to date)
  * directory[/var/opt/gitlab/redis] action create (up to date)
  * directory[/var/log/gitlab/redis] action create (up to date)
  * template[/var/opt/gitlab/redis/redis.conf] action create (up to date)
  * directory[/opt/gitlab/sv/redis] action create (up to date)
  * directory[/opt/gitlab/sv/redis/log] action create (up to date)
  * directory[/opt/gitlab/sv/redis/log/main] action create (up to date)
  * template[/opt/gitlab/sv/redis/run] action create (up to date)
  * template[/opt/gitlab/sv/redis/log/run] action create (up to date)
  * template[/var/log/gitlab/redis/config] action create (up to date)
  * ruby_block[reload redis svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/redis/down] action delete (up to date)
  * link[/opt/gitlab/init/redis] action create (up to date)
  * link[/opt/gitlab/service/redis] action create (up to date)
  * ruby_block[supervise_redis_sleep] action run (skipped due to not_if)
  * service[redis] action nothing (skipped due to action :nothing)
Recipe: gitlab::postgresql
  * group[gitlab-psql] action create (up to date)
  * user[gitlab-psql] action create (up to date)
  * directory[/var/opt/gitlab/postgresql] action create (up to date)
  * directory[/var/opt/gitlab/postgresql/data] action create (up to date)
  * directory[/var/log/gitlab/postgresql] action create (up to date)
  * link[/var/opt/gitlab/postgresql/data] action create (skipped due to not_if)
  * file[/var/opt/gitlab/postgresql/.profile] action create (up to date)
  * service[procps] action nothing (skipped due to action :nothing)
  * template[/etc/sysctl.d/90-postgresql.conf] action create (up to date)
  * execute[/opt/gitlab/embedded/bin/initdb -D /var/opt/gitlab/postgresql/data -E UTF8] action run (skipped due to not_if)
  * template[/var/opt/gitlab/postgresql/data/postgresql.conf] action create (up to date)
  * template[/var/opt/gitlab/postgresql/data/pg_hba.conf] action create (up to date)
  * template[/var/opt/gitlab/postgresql/data/pg_ident.conf] action create (up to date)
  * directory[/opt/gitlab/sv/postgresql] action create (up to date)
  * directory[/opt/gitlab/sv/postgresql/log] action create (up to date)
  * directory[/opt/gitlab/sv/postgresql/log/main] action create (up to date)
  * template[/opt/gitlab/sv/postgresql/run] action create (up to date)
  * template[/opt/gitlab/sv/postgresql/log/run] action create (up to date)
  * template[/var/log/gitlab/postgresql/config] action create (up to date)
  * ruby_block[reload postgresql svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/postgresql/down] action delete (up to date)
  * directory[/opt/gitlab/sv/postgresql/control] action create (up to date)
  * template[/opt/gitlab/sv/postgresql/control/t] action create (up to date)
  * link[/opt/gitlab/init/postgresql] action create (up to date)
  * link[/opt/gitlab/service/postgresql] action create (up to date)
  * ruby_block[supervise_postgresql_sleep] action run (skipped due to not_if)
  * service[postgresql] action nothing (skipped due to action :nothing)
  * execute[create gitlab database user] action run (skipped due to not_if)
  * execute[create gitlabhq_production database] action run (skipped due to not_if)
Recipe: gitlab::unicorn
  * directory[/var/log/gitlab/unicorn] action create (up to date)
  * directory[/opt/gitlab/var/unicorn] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails/sockets] action create (up to date)
  * directory[/var/opt/gitlab/gitlab-rails/etc] action create (up to date)
  * template[/var/opt/gitlab/gitlab-rails/etc/unicorn.rb] action create (up to date)
  * directory[/opt/gitlab/sv/unicorn] action create (up to date)
  * directory[/opt/gitlab/sv/unicorn/log] action create (up to date)
  * directory[/opt/gitlab/sv/unicorn/log/main] action create (up to date)
  * template[/opt/gitlab/sv/unicorn/run] action create (up to date)
  * template[/opt/gitlab/sv/unicorn/log/run] action create (up to date)
  * template[/var/log/gitlab/unicorn/config] action create (up to date)
  * ruby_block[reload unicorn svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/unicorn/down] action delete (up to date)
  * link[/opt/gitlab/init/unicorn] action create (up to date)
  * link[/opt/gitlab/service/unicorn] action create (up to date)
  * ruby_block[supervise_unicorn_sleep] action run (skipped due to not_if)
  * service[unicorn] action nothing (skipped due to action :nothing)
Recipe: gitlab::sidekiq
  * directory[/var/log/gitlab/sidekiq] action create (up to date)
  * directory[/opt/gitlab/sv/sidekiq] action create (up to date)
  * directory[/opt/gitlab/sv/sidekiq/log] action create (up to date)
  * directory[/opt/gitlab/sv/sidekiq/log/main] action create (up to date)
  * template[/opt/gitlab/sv/sidekiq/run] action create (up to date)
  * template[/opt/gitlab/sv/sidekiq/log/run] action create (up to date)
  * template[/var/log/gitlab/sidekiq/config] action create (up to date)
  * ruby_block[reload sidekiq svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/sidekiq/down] action delete (up to date)
  * link[/opt/gitlab/init/sidekiq] action create (up to date)
  * link[/opt/gitlab/service/sidekiq] action create (up to date)
  * ruby_block[supervise_sidekiq_sleep] action run (skipped due to not_if)
  * service[sidekiq] action nothing (skipped due to action :nothing)
Recipe: gitlab::nginx
  * directory[/var/opt/gitlab/nginx] action create (up to date)
  * directory[/var/opt/gitlab/nginx/conf] action create (up to date)
  * directory[/var/log/gitlab/nginx] action create (up to date)
  * link[/var/opt/gitlab/nginx/logs] action create (up to date)
  * template[/var/opt/gitlab/nginx/conf/gitlab-http.conf] action create (up to date)
  * template[/var/opt/gitlab/nginx/conf/nginx.conf] action create (up to date)
  * directory[/opt/gitlab/sv/nginx] action create (up to date)
  * directory[/opt/gitlab/sv/nginx/log] action create (up to date)
  * directory[/opt/gitlab/sv/nginx/log/main] action create (up to date)
  * template[/opt/gitlab/sv/nginx/run] action create (up to date)
  * template[/opt/gitlab/sv/nginx/log/run] action create (up to date)
  * template[/var/log/gitlab/nginx/config] action create (up to date)
  * ruby_block[reload nginx svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/nginx/down] action delete (up to date)
  * link[/opt/gitlab/init/nginx] action create (up to date)
  * link[/opt/gitlab/service/nginx] action create (up to date)
  * ruby_block[supervise_nginx_sleep] action run (skipped due to not_if)
  * service[nginx] action nothing (skipped due to action :nothing)
Recipe: gitlab::remote-syslog_disable
  * link[/opt/gitlab/service/remote-syslog] action delete (up to date)
Recipe: gitlab::logrotate
  * directory[/var/opt/gitlab/logrotate] action create (up to date)
  * directory[/var/opt/gitlab/logrotate/logrotate.d] action create (up to date)
  * directory[/var/log/gitlab/logrotate] action create (up to date)
  * template[/var/opt/gitlab/logrotate/logrotate.conf] action create (up to date)
  * template[/var/opt/gitlab/logrotate/logrotate.d/nginx] action create (up to date)
  * template[/var/opt/gitlab/logrotate/logrotate.d/unicorn] action create (up to date)
  * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-rails] action create (up to date)
  * template[/var/opt/gitlab/logrotate/logrotate.d/gitlab-shell] action create (up to date)
  * directory[/opt/gitlab/sv/logrotate] action create (up to date)
  * directory[/opt/gitlab/sv/logrotate/log] action create (up to date)
  * directory[/opt/gitlab/sv/logrotate/log/main] action create (up to date)
  * template[/opt/gitlab/sv/logrotate/run] action create (up to date)
  * template[/opt/gitlab/sv/logrotate/log/run] action create (up to date)
  * template[/var/log/gitlab/logrotate/config] action create (up to date)
  * ruby_block[reload logrotate svlogd configuration] action nothing (skipped due to action :nothing)
  * file[/opt/gitlab/sv/logrotate/down] action delete (up to date)
  * link[/opt/gitlab/init/logrotate] action create (up to date)
  * link[/opt/gitlab/service/logrotate] action create (up to date)
  * ruby_block[supervise_logrotate_sleep] action run (skipped due to not_if)
  * service[logrotate] action nothing (skipped due to action :nothing)
Recipe: gitlab::database_migrations
  * execute[initialize database] action nothing (skipped due to action :nothing)
  * bash[migrate database] action nothing (skipped due to action :nothing)

Running handlers:
Running handlers complete

Chef Client finished, 2/147 resources updated in 3.702060266 seconds
gitlab Reconfigured!
      • username-removed-65576
        username-removed-65576 @semrah ·

        FIXED

        Just in case someone like me stumbles upon this issue. This was my fix:

        • sudo gitlab-rake gitlab:app:check informed me that my migrations where off.
        • sudo gitlab-rake db:migrate RAILS_ENV=production Fixed the migrations.
        • sudo gitlab-ctl restart to finish it off.

        Now it's perfectly working, thanks.

      • username-removed-65916
        username-removed-65916 @siriuskr ·

        Trying to go from 7.0 to 7.4 and getting this error with the post aboves fix.

        sudo gitlab-rake gitlab:app:check

        /opt/gitlab# gitlab-rake gitlab:app:check
Checking GitLab ...

Database config exists? ... yes
Database is SQLite ... no
All migrations up? ... no
  Try fixing it:
  sudo -u git -H bundle exec rake db:migrate RAILS_ENV=production
  Please fix the error above and rerun the checks.
Database contains orphaned GroupMembers? ... rake aborted!
ActiveRecord::StatementInvalid: PG::Error: ERROR:  relation "members" does not exist
LINE 5:                WHERE a.attrelid = '"members"'::regclass
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                FROM pg_attribute a LEFT JOIN pg_attrdef d
                  ON a.attrelid = d.adrelid AND a.attnum = d.adnum
               WHERE a.attrelid = '"members"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum

PG::Error: ERROR:  relation "members" does not exist
LINE 5:                WHERE a.attrelid = '"members"'::regclass
                                          ^

Tasks: TOP => gitlab:app:check
(See full trace by running task with --trace)

        gitlab-rake db:migrate RAILS_ENV=production

        /opt/gitlab# gitlab-rake db:migrate RAILS_ENV=production
== 20140907220153 SerializeServiceProperties: migrating =======================
-- add_column(:services, :properties, :text)
   -> 0.0012s
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

Validation failed: Webhook can't be blank
ActiveRecord::RecordInvalid: Validation failed: Webhook can't be blank

Tasks: TOP => db:migrate
(See full trace by running task with --trace)
      Please register or sign in to reply