I’m getting the following error when trying to upgrade GitLab CE:
Dumping database …
Dumping PostgreSQL database gitlabhq_production … pg_dump: Dumping the contents of table “events” failed: PQgetResult() failed.
pg_dump: Error message from server: ERROR: unexpected chunk size 1893 (expected 1010) in final chunk 1 for toast value 36854 in pg_toast_16418
pg_dump: The command was: COPY public.events (id, target_type, target_id, title, data, project_id, created_at, updated_at, action, author_id) TO stdout;
Which appears to be a corrupted public.events table. I don’t think I have a backup of the database where the public.events table is not corrupted.
I’ve seen a couple of posts online on how to fix the corruption (I know nothing about PostgreSQL) but I don’t know what data this table contains.
Does anyone know what this table contains, the corruption doesn’t seem to be affecting the operation of our GitLab environment?
What would be the best way to fix the corruption?