PG::QueryCanceled: ERROR: canceling statement due to statement timeout when viewing group members on GitLab.com

Summary

Frequently, the URL https://gitlab.com/groups/<group name>/-/group_members results in a 500 error and the page is not rendered.

Steps to reproduce

  1. Attempt to access the URL which will be shared in a confidential comment on this issue.

What is the current bug behavior?

The page does not render and a 500 error is produced.

What is the expected correct behavior?

The page of group members should be displayed without error.

Relevant logs and/or screenshots

Partial stack trace (full stack can be observed in Sentry:

  from app/serializers/base_serializer.rb:16:in `represent'
  from app/serializers/member_serializer.rb:11:in `represent'
  from app/helpers/groups/group_members_helper.rb:33:in `group_members_serialized'
  from app/helpers/groups/group_members_helper.rb:43:in `group_members_list_data'
  from ee/app/helpers/ee/groups/group_members_helper.rb:8:in `group_members_list_data'
  from app/helpers/groups/group_members_helper.rb:10:in `group_members_app_data'
  from ee/app/helpers/ee/groups/group_members_helper.rb:18:in `group_members_app_data'
  from app/views/groups/group_members/index.html.haml:28

Results of GitLab environment info

The group in question contains a high number of members (>3000), however it has also been observed with membership of (1000+) also.

Edited by Chris Stone