global search level - applying label filter is causing 500 error

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

Summary

I'm experiencing 500 error when I apply some label filter.

Screenshot_2024-12-05_at_17.29.07

from kibana:

/*application:web,correlation_id:01JEBTD3HE618HF76VG5YXMJ7Q,endpoint_id:SearchController#show,db_config_database:gitlabhq_production,db_config_name:main_replica*/ SELECT "labels".* FROM ((SELECT "labels".* FROM "labels" WHERE "labels"."group_id" IN (SELECT "projects"."namespace_id" FROM "projects" INNER JOIN "namespaces" ON "namespaces"."id" = "projects"."namespace_id" WHERE "namespaces"."type" = $1))
UNION
(SELECT "labels".* FROM "labels" WHERE "labels"."project_id" IN (SELECT "projects"."id" FROM ((SELECT "projects"."id" FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects") AND ("project_features"."issues_access_level" IN ($2, $3) OR "project_features"."issues_access_level" IS NULL))
UNION
(SELECT "projects"."id" FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects") AND ("project_features"."merge_requests_access_level" IN ($4, $5) OR "project_features"."merge_requests_access_level" IS NULL))) projects WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects")))) labels WHERE "labels"."title" = $6 ORDER BY "labels"."title" ASC
[lib/gitlab/database/load_balancing/connection_proxy.rb:111:in `public_send', lib/gitlab/database/load_balancing/connection_proxy.rb:111:in `block in read_using_load_balancer', lib/gitlab/database/load_balancing/load_balancer.rb:65:in `read', lib/gitlab/database/load_balancing/connection_proxy.rb:110:in `read_using_load_balancer', lib/gitlab/database/load_balancing/connection_proxy.rb:48:in `select_all', ee/lib/search/elastic/filters.rb:954:in `each_with_object', ee/lib/search/elastic/filters.rb:954:in `group_labels_by_name', ee/lib/search/elastic/filters.rb:923:in `find_labels_by_name', ee/lib/search/elastic/filters.rb:226:in `by_label_ids', ee/lib/search/elastic/work_item_query_builder.rb:27:in `build', ee/lib/search/elastic/query_builder.rb:9:in `build', ee/lib/gitlab/elastic/search_results.rb:409:in `block in issues', ee/lib/gitlab/elastic/search_results.rb:406:in `issues', ee/lib/gitlab/elastic/search_results.rb:122:in `failed?', app/views/search/show.html.haml:12, app/controllers/application_controller.rb:156:in `render', app/controllers/search_controller.rb:307:in `render_timeout', lib/gitlab/middleware/action_controller_static_context.rb:23:in `call', ee/lib/omni_auth/strategies/group_saml.rb:41:in `other_phase', lib/gitlab/metrics/elasticsearch_rack_middleware.rb:16:in `call', lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `block in call', lib/gitlab/sidekiq_sharding/validator.rb:42:in `enabled', lib/gitlab/middleware/sidekiq_shard_awareness_validation.rb:20:in `call', lib/gitlab/middleware/memory_report.rb:13:in `call', lib/gitlab/middleware/speedscope.rb:13:in `call', lib/gitlab/database/load_balancing/rack_middleware.rb:23:in `call', lib/gitlab/middleware/rails_queue_duration.rb:33:in `call', lib/gitlab/etag_caching/middleware.rb:21:in `call', lib/gitlab/metrics/rack_middleware.rb:16:in `block in call', lib/gitlab/metrics/web_transaction.rb:46:in `run', lib/gitlab/metrics/rack_middleware.rb:16:in `call', lib/gitlab/middleware/go.rb:21:in `call', lib/gitlab/middleware/query_analyzer.rb:11:in `block in call', lib/gitlab/database/query_analyzer.rb:83:in `within', lib/gitlab/middleware/query_analyzer.rb:11:in `call', lib/ci/job_token/middleware.rb:11:in `call', lib/gitlab/middleware/multipart.rb:173:in `call', lib/gitlab/middleware/read_only/controller.rb:50:in `call', lib/gitlab/middleware/read_only.rb:18:in `call', lib/gitlab/middleware/unauthenticated_session_expiry.rb:18:in `call', lib/gitlab/middleware/strip_cookies.rb:29:in `call', lib/gitlab/middleware/same_site_cookies.rb:27:in `call', lib/gitlab/middleware/path_traversal_check.rb:40:in `call', lib/gitlab/middleware/handle_malformed_strings.rb:21:in `call', lib/gitlab/middleware/basic_health_check.rb:25:in `call', lib/gitlab/middleware/handle_ip_spoof_attack_error.rb:25:in `call', lib/gitlab/middleware/request_context.rb:15:in `call', lib/gitlab/middleware/webhook_recursion_detection.rb:15:in `call', config/initializers/fix_local_cache_middleware.rb:11:in `call', lib/gitlab/middleware/compressed_json.rb:44:in `call', lib/gitlab/middleware/rack_multipart_tempfile_factory.rb:19:in `call', lib/gitlab/middleware/sidekiq_web_static.rb:20:in `call', lib/gitlab/metrics/requests_rack_middleware.rb:79:in `call', lib/gitlab/middleware/release_env.rb:12:in `call']

Steps to reproduce

  1. load this global issues search: https://gitlab.com/search?repository_ref=f28b8717&scope=issues&search=epics+scope+in+global+search
  2. apply the groupglobal search label filter
  3. click apply

this is the url generated with the label filter applied (yields 500 error): https://gitlab.com/search?repository_ref=f28b8717&scope=issues&search=epics+scope+in+global+search&label_name%5B%5D=group%3A%3Aglobal+search

What is the current bug behavior?

500 error

What is the expected correct behavior?

not 500 error

Relevant logs and/or screenshots

https://log.gprd.gitlab.net/app/r/s/IdqvQ

Possible fixes

Edited by 🤖 GitLab Bot 🤖