Timeout paging through `gitlab-org` labels
https://sentry.gitlap.com/gitlab/gitlabcom/issues/511456/
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_adapter.rb:592:in `block in exec_no_cache'
log(sql, name, binds) { @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
...
(189 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT "labels".* FROM "labels" WHERE (labels.id IN (SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" = 9970
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" IN (SELECT "projects"."namespace_id" FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970 AND "namespaces"."type" = 'Group')
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970))) ORDER BY "labels"."title" ASC LIMIT 20 OFFSET 100
ActionView::Template::Error: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT "labels".* FROM "labels" WHERE (labels.id IN (SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" = 9970
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" IN (SELECT "projects"."namespace_id" FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970 AND "namespaces"."type" = 'Group')
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970))) ORDER BY "labels"."title" ASC LIMIT 20 OFFSET 100
ActionView::Template::Error: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
: SELECT "labels".* FROM "labels" WHERE (labels.id IN (SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" = 9970
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."group_id" IN (SELECT "projects"."namespace_id" FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970 AND "namespaces"."type" = 'Group')
UNION
SELECT "labels"."id" FROM "labels" WHERE "labels"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 1273957 AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (10,20)) AND "projects"."archived" = 'f' AND "projects"."namespace_id" = 9970))) ORDER BY "labels"."title" ASC LIMIT 20 OFFSET 100