Hi,
since several versions I have issues migrating my gitlab database.

When I run:
sudo -u gitlab bundle exec rake db:migrate RAILS_ENV=production

I get following error:
Errno::EACCES: Permission denied @ rb_sysopen - /usr/share/webapps/gitlab/.gitlab_workhorse_secret

Permissions seem to have an issue:
root@http-new /usr/share/webapps/gitlab # namei -mo /etc/webapps/gitlab/gitlab_workhorse_secret :(
f: /etc/webapps/gitlab/gitlab_workhorse_secret
drwxr-xr-x root root /
drwxr-xr-x root root etc
drwxr-xr-x root root webapps
drwxr-x--- gitlab gitlab gitlab
-rw-rw---- root 105 gitlab_workhorse_secret

When I run:
sudo chown gitlab:gitlab /etc/webapps/gitlab/gitlab_workhorse_secret

and migration again, I get:
Errno::EACCES: Permission denied @ rb_sysopen - /usr/share/webapps/gitlab/db/schema.rb

I read somewhere that db/schema.rb needs to be writable because it gets changed in migration process ...

So I do:
sudo chown gitlab:gitlab db/schema.rb

and rerun migration. Now the command works without issues and sometimes migrate tables.

A further problem is, that the file db/schema.rb is different to the one upstream: https://www.diffnow.com/?report=jtf0b
Some database tables in my setup are different to upstream now and this often results in errors using Gitlab :(

Best regards,
Jonas