gitlab升级后的数据库迁移问题

Question

最近，我对gitlab进行了升级，之后，很少有数据库迁移尚未被迁移，并且显示为下降状态。

我们已经尝试过:迁移，但是仍然有一些迁移失败了。

== 20200213224220 AddSprints: migrating =======================================
-- create_table(:sprints, {:id=>:bigserial})
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::ReadOnlySqlTransaction: ERROR:  cannot execute CREATE TABLE in a read-only transaction
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20200213224220_add_sprints.rb:7:in `change'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: PG::ReadOnlySqlTransaction: ERROR:  cannot execute CREATE TABLE in a read-only transaction
/opt/gitlab/embedded/service/gitlab-rails/db/migrate/20200213224220_add_sprints.rb:7:in `change'
/opt/gitlab/embedded/bin/bundle:23:in `load'
/opt/gitlab/embedded/bin/bundle:23:in `<main>'

Answer 1

试一试

sudo touch /opt/gitlab/embedded/service/gitlab-rails/db/migrate/*

或

sudo chmod -R 777 /opt/gitlab/embedded/service/gitlab-rails/

再运行一次迁移。