group::import and integrate - HTTP 500 errors from DB statement timeout
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
Summary
On 2025-01-10, users for a GitLab Dedicated customer reported in support ticket (Internal only) on spike in HTTP 500 errors when making requests to the following endpoints, with the exception message PG::QueryCanceled: ERROR: canceling statement due to statement timeout. Dedicated SRE assessed that it was not an infrastructure issue and likely an application bug.
This bug report was created on the advice of groupdatabase frameworks out of this Request for Help issue (Internal only), for product to review the endpoints and their SQL to identify the cause of the DB statement timeout.
| meta.caller_id | feature_category | exception.class |
|---|---|---|
| GET /api/:version/groups/:id/hooks | integrations | ActiveRecord::QueryCanceled |
| Groups::Settings::IntegrationsController#index | integrations | ActionView::Template::Error |
Relevant logs and/or screenshots
SQL queries can be found in this Google Sheets: link (Internal only).
Output of checks
This bug happens on GitLab Dedicated