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.