Gitlab omnibus postgresql upgrade on 13.12.8

Hi. We have a system running gitlab 13.12.8 and want to do the pg_upgrade from 11.11 to 12.6 before moving to the latest gitlab, but are getting an error from the database and I don’t know what to do about it.

The last few lines of the error log:
pg_restore: creating FK CONSTRAINT “public.analytics_cycle_analytics_group_stages fk_rails_5a22f40223”
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 12305; 2606 18927 FK CONSTRAINT analytics_cycle_analytics_group_stages fk_rails_5a22f40223 gitlab
pg_restore: error: could not execute query: ERROR: could not seek to end of file “base/16401/2666”: Operation not permitted
Command was: ALTER TABLE ONLY “public”.“analytics_cycle_analytics_group_stages” ADD CONSTRAINT “fk_rails_5a22f40223” FOREIGN KEY (“start_event_label_id”) REFERENCES “public”.“labels”(“id”) ON DELETE CASCADE;

I’m not sure where the permission problem came from, but the filesystem itself looks ok, so it might be some internal DB permissions that are messed up. Any thoughts on how I might be able to fix it/get past this?

Thanks.

does anyone have a suggestion for this one? Thanks.

conversation is continued on https://gitlab.com/gitlab-org/omnibus-gitlab/-/issues/6313

(this forum entry is one of only two google results for this error :scream_cat: )

1 Like