Database migration fails after installing the recently released GitLab 12.0.0 package on Debian stretch
Dear GitLab-Team,
first things first: Thanks for the paramount work you are constantly putting into the excellent software you are conceiving. We would not know how to live without GitLab these days.
After we always have been impressed how streamlined the installation process usually works, we are currently experiencing a significant hiccup after installing GitLab 12.0.0 packages for Debian stretch which have been released just a few hours ago.
The database migration fails and our instance is now essentially broken, so we are humbly asking for some know-how about how to unbrick it. We will share the relevant excerpt of the stacktrace by means of the next comment. The very SQL statement which is failing is:
ALTER TABLE epics
ADD CONSTRAINT fk_25b99c1be3
FOREIGN KEY (parent_id)
REFERENCES epics (id)
ON DELETE CASCADE
NOT VALID;
The error message is
PG::UndefinedColumn: ERROR: column "parent_id" referenced in foreign key constraint does not exist
We would appreciate very much if someone could give us an idea how to best proceed on that. Thanks already for your efforts!
With kind regards, Andreas.