GitLab PostgreSQL error: Missing chunk number 0 for toast value 98380 in pg_toast_2619

Question

I recently relocated my GitLab installation on Ubuntu 22.04 LTS from /dev/sda to /dev/sdb. Edit: I stopped every services and cloned the /dev/sda to /dev/sdb by the following command:

dd if=/dev/sda of=/dev/sdb

However, I'm encountering several issues with my GitLab after that:

1. I'm unable to view my files in the branch with ref_type=heads, receiving the following error:

An error occurred while loading the file. Please try again.

2. I'm also unable to merge requests. Every time I attempt to merge, it fails with this error:

Merge failed. Refreshing in 7 seconds to show the updated status.

I'm trying to view the current logs in /var/log/gitlab/postgresql and the production.log file, and I keep encountering the following error:

ERROR: missing chunk number 0 for toast value 98380 in pg_toast_2619

Has anyone experienced similar issues or can provide guidance on how to resolve these errors? Thank you!

Answer 1

There are some answers to a similar scenario on stackoverflow

They indicate that specifically pg_toast_2619 is a technical table which holds analytical data and can be recreated, so it seems to be a recoverable scenario.

The currently most favored answer suggests:

1. Stop your server and make a physical copy of your data directory to a secure place;
2. Since pg_statistic is populated by ANALYZE, just clean it DELETE FROM pg_catalog.pg_statistic; and issue an ANALYZE afterwards.