Frequent Error 500 When Searching with Multiple Labels and created_desc for Issues

Summary

I have a bookmark for the following links to search for issues in Category:Vulnerability Management and general issues in ~"Accepting merge requests". Most of the times after searching I encounter an Error 500. In these cases, the loading takes a longer-than-usual time (didn't measure how long it takes yet).

• https://gitlab.com/gitlab-org/gitlab/-/issues?label_name%5B%5D=Accepting+merge+requests&label_name%5B%5D=Category%3AVulnerability+Management&label_name%5B%5D=frontend&scope=all&sort=created_date&state=opened&utf8=%E2%9C%93
• (I had to add a label and switch from created_desc to created_asc to cause the error.) https://gitlab.com/gitlab-org/gitlab/-/issues?assignee_id=None&label_name%5B%5D=Accepting+merge+requests&label_name%5B%5D=frontend&not%5Blabel_name%5D%5B%5D=Category%3AVulnerability+Management&scope=all&sort=created_asc&state=opened&utf8=%E2%9C%93
• Link that I found by testing: https://gitlab.com/gitlab-org/gitlab/-/issues?label_name%5B%5D=backend&not%5Blabel_name%5D%5B%5D=Accepting+merge+requests&not%5Blabel_name%5D%5B%5D=Category%3AVulnerability+Management&not%5Blabel_name%5D%5B%5D=performance&scope=all&sort=created_date&state=opened&utf8=%E2%9C%93

Steps to reproduce

This might be difficult to reproduce because when you retry it works again. That seems to me as if some form of time-bound caching is involved.

1. Open one of the links
2. See the error 500 (500 Whoops, something went wrong on our end.)

OR

1. Open one of the links
2. Search for an additional label, so that the result still contains more than one page of issues
3. If you don't see the error, change the filter direction (Created ascending <-> descending)
4. See the error 500

Example Project

The bug happens in gitlab-org/gitlab (so this project), possibly related to the big number of issues (and related MRs/labels?).

What is the current bug behavior?

I encounter Error 500s for complex searches.

What is the expected correct behavior?

I can search for issues without encountering errors.

Relevant logs and/or screenshots

Output of checks

This bug happens on GitLab.com.

Possible fixes

Here's a video of me trying to speedrun the error (only the last 30 seconds are relevant): https://youtu.be/jFPG0Z_NPWQ

I'm still not sure what causes it and that's why it took so long, probably. Also, sorry that I didn't upload it here directly but the source file was over 10MB and I figured YouTube is ok.

changed the description

mentioned in issue gitlab-org/quality/triage-reports#508 (closed)

mentioned in issue gitlab-org/quality/triage-reports#510 (closed)

added devopsplan groupproject management severity3 typebug labels

added issues label

added sectiondev label

mentioned in issue gitlab-org/quality/triage-reports#533 (closed)

mentioned in issue gitlab-org/quality/triage-reports#609 (closed)

mentioned in issue gitlab-org/quality/triage-reports#674 (closed)

mentioned in issue gitlab-org/quality/triage-reports#707 (closed)

mentioned in issue gitlab-org/quality/triage-reports#797 (closed)

added vintage label

Hi @KevSlashNull ,

Thanks for raising this bug.

Contributions like this are vital to help make GitLab a better product.

We would be grateful for your help in verifying whether your bug report requires further attention from the team. If you think this bug still exists, and is reproducible with the latest stable version of GitLab, please comment on this issue.

This issue has been inactive for more than 12 months now and based on the policy for inactive bugs, will be closed in 7 days.

Thanks for your contributions to make GitLab better!

added stale label

Hi @KevSlashNull ,

Based on the policy for inactive bugs, this issue is now being closed.

If you think this bug still exists, and is reproducible with the latest stable version of GitLab, please reopen this issue.

Thanks for your contributions to make GitLab better!

closed

added auto closed label