Migration 20210906145021_link_repository_id is timing out due to a large number of project

One of our customers (internal) performed an upgrade to GitLab 14.4.4. However, they encountered the following error during the database migration:

STDOUT: praefect sql-migrate: fail: pq: canceling statement due to statement timeout handling 20210906145021_link_repository_id

We tried setting the statement timeout to 0 but we hit the internal timeout (3600 seconds) of gitlab-ctl reconfigure.

The customer have ~95,000 projects and they have ~320,000 entries in the storage_repositories table.

This happens when the customer tried to upgrade from GitLab 14.3.4 to GitLab 14.4.4.

Edited Jan 06, 2022 by Julian Paul Dasmarinas

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information