ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
https://sentry.gitlap.com/gitlab/gitlabcom/issues/217838/
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
peek/views/pg.rb:17:in `async_exec'
super(*args)
peek/views/pg.rb:17:in `async_exec'
super(*args)
active_record/connection_adapters/postgresql/database_statements.rb:155:in `block in execute'
@connection.async_exec(sql)
active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
:binds => binds) { yield }
active_support/notifications/instrumenter.rb:20:in `instrument'
yield payload
...
(46 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: WITH events_for_update AS (
SELECT DISTINCT ON (target_id, action) target_id, action, author_id, updated_at
FROM events
WHERE target_id BETWEEN 1343658 AND 7177918
AND target_type = 'MergeRequest'
AND action IN (3,7)
ORDER BY target_id, action, id DESC
)
UPDATE merge_request_metrics met
SET latest_closed_at = latest_closed.updated_at,
latest_closed_by_id = latest_closed.author_id,
merged_by_id = latest_merged.author_id
FROM (SELECT * FROM events_for_update WHERE action = 3) AS latest_closed
FULL OUTER JOIN
(SELECT * FROM events_for_update WHERE action = 7) AS latest_merged
USING (target_id)
WHERE target_id = merge_request_id;
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: WITH events_for_update AS (
SELECT DISTINCT ON (target_id, action) target_id, action, author_id, updated_at
FROM events
WHERE target_id BETWEEN 1343658 AND 7177918
AND target_type = 'MergeRequest'
AND action IN (3,7)
ORDER BY target_id, action, id DESC
)
UPDATE merge_request_metrics met
SET latest_closed_at = latest_closed.updated_at,
latest_closed_by_id = latest_closed.author_id,
merged_by_id = latest_merged.author_id
FROM (SELECT * FROM events_for_update WHERE action = 3) AS latest_closed
FULL OUTER JOIN
(SELECT * FROM events_for_update WHERE action = 7) AS latest_merged
USING (target_id)
WHERE target_id = merge_request_id;