Add statement_timeout check to the check GitLab configuration rake task
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
What
Add another check to the check GitLab configuration rake task. Confirm the statement_timeout to be set to a value greater than 0 (default 60 secs) per our PostgreSQL tuning in the documented requirements
Why
A statement timeout prevents runaway issues with locks and the database rejecting new clients. It also helps prevent a database related issue from eventually causing downtime. One minute matches the Puma rack timeout setting.
These rake tasks are also part of the pre-upgrade and post-upgrade checks, which should help catch the fact that it is not set prior to an upgrade.
Edited by 🤖 GitLab Bot 🤖