Skip to content

ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR: canceling statement due to statement timeout

https://sentry.gitlab.net/gitlab/gitlabcom/issues/774411/

PG::QueryCanceled: ERROR:  canceling statement due to statement timeout

  /opt/gitlab/embedded/service/gitlab-rails/config/initializers/peek.rb:18:in `async_exec_params'
    super(*args)
  /opt/gitlab/embedded/service/gitlab-rails/config/initializers/peek.rb:18:in `exec_params'
    super(*args)
  active_record/connection_adapters/postgresql_adapter.rb:624:in `block (2 levels) in exec_no_cache'
    @connection.exec_params(sql, type_casted_binds)
  active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
    yield
  active_support/concurrency/share_lock.rb:185:in `yield_shares'
    yield
...
(146 additional frame(s) were not displayed)

ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT  "members".* FROM "members" INNER JOIN "users" "users_members" ON "users_members"."id" = "members"."user_id" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND (members.id IN (SELECT "members"."id" FROM "members" WHERE "members"."type" IN ('GroupMember') AND "members"."source_id" = 4506745 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL) OR members.id IN (SELECT "members"."id" FROM "members" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" IN (WITH RECURSIVE "base_and_ancestors" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 2276951
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = "base_and_ancestors"."parent_id") SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND ("members"."user_id" NOT IN (SELECT "users"."id" FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "members"."source_id" = 4506745 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL)))) AND (("users"."name" ILIKE '%gus%' OR "users"."username" ILIKE '%gus%') OR "users"."email" = 'gus') ORDER BY users.name ASC NULLS LAST LIMIT 50 OFFSET 0

ActiveRecord::StatementInvalid: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT  "members".* FROM "members" INNER JOIN "users" "users_members" ON "users_members"."id" = "members"."user_id" LEFT OUTER JOIN "users" ON "members"."user_id" = "users"."id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND (members.id IN (SELECT "members"."id" FROM "members" WHERE "members"."type" IN ('GroupMember') AND "members"."source_id" = 4506745 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL) OR members.id IN (SELECT "members"."id" FROM "members" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL AND "members"."source_id" IN (WITH RECURSIVE "base_and_ancestors" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 2276951
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = "base_and_ancestors"."parent_id") SELECT "id" FROM "base_and_ancestors" AS "namespaces") AND ("members"."user_id" NOT IN (SELECT "users"."id" FROM "users" INNER JOIN "members" ON "users"."id" = "members"."user_id" WHERE "members"."type" IN ('GroupMember') AND "members"."source_type" = 'Namespace' AND "members"."source_id" = 4506745 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL)))) AND (("users"."name" ILIKE '%gus%' OR "users"."username" ILIKE '%gus%') OR "users"."email" = 'gus') ORDER BY users.name ASC NULLS LAST LIMIT 50 OFFSET 0

This error is encountered when searching the member list of a project within a group.

Edited by Tristan