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
- 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
- Error in Sentry (Internal link)
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