DB timeout querying for LOW vulnerabilities
This report is currently timing-out: https://gitlab.com/gitlab-org/gitlab/-/security/vulnerability_report/?severity=LOW
https://sentry.gitlab.net/gitlab/gitlabcom/issues/2599792/?referrer=gitlab_plugin
PG::QueryCanceled: ERROR: canceling statement due to statement timeout
active_record/connection_adapters/postgresql_adapter.rb:675:in `exec_params'
@connection.exec_params(sql, type_casted_binds)
graphql/types/relay/base_connection.rb:107:in `nodes'
@object.edge_nodes
graphql/schema/field.rb:692:in `public_send'
obj.public_send(@resolver_method)
graphql/schema/field.rb:692:in `block in public_send_field'
obj.public_send(@resolver_method)
graphql/schema/field.rb:733:in `block in with_extensions'
yield(obj, args)
...
(245 additional frame(s) were not displayed)
ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
Implementation plan
-
Use new vulnerability_reads
model to speed up the query, blocked by #335503 (closed)
Edited by Jonathan Schafer