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

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

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

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:611:in `block (2 levels) in exec_no_cache'
    @connection.exec_params(sql, type_casted_binds)
  active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    yield
  active_support/concurrency/share_lock.rb:187:in `yield_shares'
    yield
...
(160 additional frame(s) were not displayed)

ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT  "members".* FROM "members" 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" = 5169210 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" = 4249178
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" = 5169210 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL))) AND "members"."invite_token" IS NULL AND "members"."requested_at" IS NULL ORDER BY "members"."id" ASC LIMIT 100 OFFSET 200

ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout
: SELECT  "members".* FROM "members" 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" = 5169210 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" = 4249178
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" = 5169210 AND "members"."source_type" = 'Namespace' AND "members"."requested_at" IS NULL))) AND "members"."invite_token" IS NULL AND "members"."requested_at" IS NULL ORDER BY "members"."id" ASC LIMIT 100 OFFSET 200

Related Support Tickets (internal)

Edited by 🤖 GitLab Bot 🤖