Remove Gitlab::QueryLimiting in `Projects::CommitsController#signatures`

What does this MR do and why?

This MR enables Gitlab::QueryLimiting in Projects::CommitsController#signatures since the executed SQL in the signatures method is currently below the threshold of 100 queries per request.

This seems to have improved by the changes added in the last 9 months. One of the clear examples is that the RELEASE SAVEPOINTS statements are now ignored from the threshold count !152586 (merged). That removes approximately 12 SQL statements from the executed queries counter.

Before

The spec/features/projects/commit/cherry_pick_spec.rb spec was failing with the following error:

Too many SQL queries were executed in Projects::CommitsController#signatures (application/json): a maximum of 100 is allowed but 101 SQL queries were executed
0: SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."path" = 'user1/project-3' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,db_config_name:main,line:/app/models/concerns/routable.rb:41:in `find_by_full_path'*/
1: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" = 124 LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,db_config_name:main,line:/app/models/concerns/routable.rb:51:in `find_by_full_path'*/
2: SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."last_credential_check_at", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."public_email", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."note", "users"."unlock_token", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."last_activity_on", "users"."notified_of_own_activity", "users"."preferred_language", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress" FROM "users" WHERE "users"."id" = 266 LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/project.rb:3187:in `created_and_owned_by_banned_user?'*/
3: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 394 LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:11:in `access_restricted?'*/
4: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 394 LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/ee/app/policies/ee/project_policy.rb:203:in `block (2 levels) in <module:ProjectPolicy>'*/
5: SELECT MAX("project_authorizations"."access_level") AS "maximum_access_level", "project_authorizations"."user_id" AS "project_authorizations_user_id" FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 124 AND "project_authorizations"."user_id" = 266 GROUP BY "project_authorizations"."user_id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/project_team.rb:193:in `block in max_member_access_for_user_ids'*/
6: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 124 AND "routes"."source_type" = 'Project' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/routable.rb:190:in `full_attribute'*/
7: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 394 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/routable.rb:190:in `full_attribute'*/
8: SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 124 LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/policies/project_policy.rb:994:in `access_allowed_to?'*/
9: SELECT DISTINCT ON (sha) * FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 124 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."sha" IN ('3f413f50b12dca674428488968a8d80cb7da2bf5', 'b83d6e391c22777fca1ed3012fce84f633d7fed0', '498214de67004b1da3d820901307bed2a68a8ef6', '1b12f15a11fc6e62177bef08f47bc7b5ce50b141', '38008cb17ce1466d8fec2dfa6f6ab8dcfe5cf49e', '6907208d755b60ebeacb2e9dfea74c92c3449a1f', 'c347ca2e140aa667b968e51ed0ffe055501fe4f4', 'd59c60028b053793cecfb4022de34602e1a9218e', '281d3a76f31c812dbf48abce82ccf6860adedd81', 'a5391128b0ef5d21df5dd23d98557f4ef12fae20', '54fcc214b94e78d7a41a9a8fe6d87a5e59500e51', 'be93687618e4b132087f430a4d8fc3a609c9b77c', '048721d90c449b244b7b4c53a9186b04330174ec', '5f923865dde3436854e9ceb9cdb7815618d4e849', 'd2d430676773caa88cdaf7c55944073b2fd5561a', '2ea1f3dec713d940208fb5ce4a38765ecb5d3f73', '59e29889be61e6e0e5e223bfa9ac2721d31605b8', '66eceea0db202bb39c4e445e8ca28689645366c5', '08f22f255f082689c0d7d39d19205085311542bc', '19e2e9b4ef76b422ce1154af39a91323ccc57434', 'c642fe9b8b9f28f9225d7ea953fe14e74748d53b', '9a944d90955aaf45f6d0c88f30e27f8d2c41cec0', 'c7fbe50c7c7419d9701eebe64b1fdacc3df5b9dd', 'e56497bb5f03a90a51293fc6d516788730953899', '4cd80ccab63c82b4bad16faa5193fbd2aa06df40', '5937ac0a7beb003549fc5fd26fc247adbce4a52e', '570e7b2abdd848b95f2f578043fc23bd6f6fd24d', '6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9', 'd14d6c0abdd253381df51a723d58691b2ee1ab08', 'c1acaa58bbcbc3eafe538cb8274ba387047b69f8', 'ae73cb07c9eeaf35924a10f713b364d32b2dd34f', '874797c3a73b60d2187ed6e2fcabd289ff75171e', '2f63565e7aac07bcdadb654e253078b727143ec4', '33f3729a45c02fc67d00adb1b8bca394b0e761d9', '913c66a37b4a45b9769037c55c2d238bd0942d2e', 'cfe32cf61b73a0d5e9f13e774abde7ff789b1660', '6d394385cf567f80a8fd85055db1ab4c5295806f', '1a0b36b3cdad1d2ee32457c102a8c0b7056fa863') AND "ci_pipelines"."ref" = 'master' ORDER BY "ci_pipelines"."sha" ASC, "ci_pipelines"."id" DESC /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:ci,line:/app/models/ci/pipeline.rb:533:in `latest_pipeline_per_commit'*/
10: SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."last_credential_check_at", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."public_email", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."note", "users"."unlock_token", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."last_activity_on", "users"."notified_of_own_activity", "users"."preferred_language", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress" FROM ((SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."last_credential_check_at", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."public_email", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."note", "users"."unlock_token", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."last_activity_on", "users"."notified_of_own_activity", "users"."preferred_language", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress" FROM "users" WHERE (LOWER("users"."email") IN (LOWER('dmitriy.zaporozhets@gmail.com'), LOWER('job@gitlab.com'), LOWER('tiagonbotelho@hotmail.com'), LOWER('stanhu@gmail.com'), LOWER('gitlab@winniehell.de'), LOWER('douwe@gitlab.com'), LOWER('jneen@jneen.net'), LOWER('dbalexandre@gmail.com'), LOWER('marin@gitlab.com'), LOWER('maxlazio@gmail.com'), LOWER('minsik.yoon@samsung.com'), LOWER('stanhu@packetzoom.com'), LOWER('sytse@gitlab.com'), LOWER('marmis85@gmail.com'))) AND "users"."confirmed_at" IS NOT NULL)
UNION
(SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."last_credential_check_at", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."public_email", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."note", "users"."unlock_token", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."last_activity_on", "users"."notified_of_own_activity", "users"."preferred_language", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress" FROM "users" INNER JOIN "emails" ON "emails"."user_id" = "users"."id" WHERE "emails"."email" IN ('dmitriy.zaporozhets@gmail.com', 'job@gitlab.com', 'tiagonbotelho@hotmail.com', 'stanhu@gmail.com', 'gitlab@winniehell.de', 'douwe@gitlab.com', 'jneen@jneen.net', 'dbalexandre@gmail.com', 'marin@gitlab.com', 'maxlazio@gmail.com', 'minsik.yoon@samsung.com', 'stanhu@packetzoom.com', 'sytse@gitlab.com', 'marmis85@gmail.com') AND "emails"."confirmed_at" IS NOT NULL AND "users"."confirmed_at" IS NOT NULL)) users /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/commit.rb:304:in `block (2 levels) in lazy_author'*/
11: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" = 124 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/banzai/reference_parser/base_parser.rb:190:in `collection_objects_for_ids'*/
12: SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 124 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/banzai/reference_parser/base_parser.rb:190:in `collection_objects_for_ids'*/
13: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 394 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/preloaders/project_policy_preloader.rb:16:in `execute'*/
14: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 394 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/preloaders/project_policy_preloader.rb:16:in `execute'*/
15: SELECT "users"."id", "users"."email", "users"."encrypted_password", "users"."reset_password_token", "users"."reset_password_sent_at", "users"."remember_created_at", "users"."sign_in_count", "users"."current_sign_in_at", "users"."last_sign_in_at", "users"."current_sign_in_ip", "users"."last_sign_in_ip", "users"."created_at", "users"."updated_at", "users"."name", "users"."admin", "users"."projects_limit", "users"."failed_attempts", "users"."locked_at", "users"."username", "users"."can_create_group", "users"."can_create_team", "users"."state", "users"."color_scheme_id", "users"."password_expires_at", "users"."created_by_id", "users"."last_credential_check_at", "users"."avatar", "users"."confirmation_token", "users"."confirmed_at", "users"."confirmation_sent_at", "users"."unconfirmed_email", "users"."hide_no_ssh_key", "users"."admin_email_unsubscribed_at", "users"."notification_email", "users"."hide_no_password", "users"."password_automatically_set", "users"."encrypted_otp_secret", "users"."encrypted_otp_secret_iv", "users"."encrypted_otp_secret_salt", "users"."otp_required_for_login", "users"."otp_backup_codes", "users"."public_email", "users"."dashboard", "users"."project_view", "users"."consumed_timestep", "users"."layout", "users"."hide_project_limit", "users"."note", "users"."unlock_token", "users"."otp_grace_period_started_at", "users"."external", "users"."incoming_email_token", "users"."auditor", "users"."require_two_factor_authentication_from_group", "users"."two_factor_grace_period", "users"."last_activity_on", "users"."notified_of_own_activity", "users"."preferred_language", "users"."theme_id", "users"."accepted_term_id", "users"."feed_token", "users"."private_profile", "users"."roadmap_layout", "users"."include_private_contributions", "users"."commit_email", "users"."group_view", "users"."managing_group_id", "users"."first_name", "users"."last_name", "users"."static_object_token", "users"."role", "users"."user_type", "users"."static_object_token_encrypted", "users"."otp_secret_expires_at", "users"."onboarding_in_progress" FROM "users" WHERE "users"."id" = 266 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/preloaders/project_policy_preloader.rb:16:in `execute'*/
16: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id", "project_authorizations"."user_id", "project_authorizations"."access_level" FROM "projects" LEFT OUTER JOIN "project_authorizations" AS project_authorizations ON "project_authorizations"."project_id" = "projects"."id" AND "project_authorizations"."user_id" = 266 WHERE "projects"."id" = 124 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/preloaders/user_max_access_level_in_projects_preloader.rb:32:in `execute'*/
17: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
18: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
19: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
20: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
21: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
22: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:53.530050', '2023-09-07 17:22:53.530050', 124, '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
23: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
24: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
25: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
26: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
27: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
28: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
29: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:53.865781', '2023-09-07 17:22:53.865781', 124, '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
30: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
31: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
32: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
33: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
34: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
35: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
36: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:54.191102', '2023-09-07 17:22:54.191102', 124, '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
37: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
38: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xd14d6c0abdd253381df51a723d58691b2ee1ab08' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
39: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
40: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
41: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xd14d6c0abdd253381df51a723d58691b2ee1ab08' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
42: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
43: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:54.531935', '2023-09-07 17:22:54.531935', 124, '\xd14d6c0abdd253381df51a723d58691b2ee1ab08', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
44: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
45: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
46: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
47: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
48: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
49: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
50: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:54.860067', '2023-09-07 17:22:54.860067', 124, '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
51: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
52: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
53: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
54: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
55: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
56: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
57: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:55.184462', '2023-09-07 17:22:55.184462', 124, '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
58: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
59: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x874797c3a73b60d2187ed6e2fcabd289ff75171e' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
60: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
61: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
62: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x874797c3a73b60d2187ed6e2fcabd289ff75171e' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
63: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
64: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:55.510863', '2023-09-07 17:22:55.510863', 124, '\x874797c3a73b60d2187ed6e2fcabd289ff75171e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
65: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
66: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x2f63565e7aac07bcdadb654e253078b727143ec4' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
67: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
68: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
69: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x2f63565e7aac07bcdadb654e253078b727143ec4' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
70: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
71: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:55.800801', '2023-09-07 17:22:55.800801', 124, '\x2f63565e7aac07bcdadb654e253078b727143ec4', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
72: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
73: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
74: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
75: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
76: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
77: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
78: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:56.089362', '2023-09-07 17:22:56.089362', 124, '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
79: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
80: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x913c66a37b4a45b9769037c55c2d238bd0942d2e' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
81: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
82: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
83: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x913c66a37b4a45b9769037c55c2d238bd0942d2e' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
84: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
85: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:56.389164', '2023-09-07 17:22:56.389164', 124, '\x913c66a37b4a45b9769037c55c2d238bd0942d2e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
86: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
87: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
88: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
89: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
90: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
91: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
92: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:56.686781', '2023-09-07 17:22:56.686781', 124, '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
93: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
94: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6d394385cf567f80a8fd85055db1ab4c5295806f' /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
95: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
96: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
97: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6d394385cf567f80a8fd85055db1ab4c5295806f' LIMIT 1 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:79:in `safe_find_or_create_by'*/
98: SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
99: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2023-09-07 17:22:56.983947', '2023-09-07 17:22:56.983947', 124, '\x6d394385cf567f80a8fd85055db1ab4c5295806f', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:87:in `block in safe_find_or_create_by'*/
100: RELEASE SAVEPOINT active_record_2 /*application:test,correlation_id:01H9RAP2QBTM4TS95FPQE9TC1K,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/database.rb:390:in `block in transaction'*/
# ./lib/gitlab/query_limiting/transaction.rb:62:in `act_upon_results'

More context: #424527 (comment 1972358045)

Current

Note: I forced the act_upon_results method in lib/gitlab/query_limiting/transaction.rb to log the SQL executed.

Too many SQL queries were executed in Projects::CommitsController#signatures (application/json): a maximum of 100 is allowed but 82 SQL queries were executed
0: SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."path" = 'user1/project-1' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,db_config_name:main,line:/app/models/concerns/routable.rb:34:in `find_by_full_path'*/
1: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM find_projects_by_id(75) AS projects WHERE ("projects"."id" IS NOT NULL) LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:14:in `_query_by_sql'*/
2: SELECT "namespaces"."id", "namespaces"."name", "namespaces"."path", "namespaces"."owner_id", "namespaces"."created_at", "namespaces"."updated_at", "namespaces"."type", "namespaces"."description", "namespaces"."avatar", "namespaces"."membership_lock", "namespaces"."share_with_group_lock", "namespaces"."visibility_level", "namespaces"."request_access_enabled", "namespaces"."ldap_sync_status", "namespaces"."ldap_sync_error", "namespaces"."ldap_sync_last_update_at", "namespaces"."ldap_sync_last_successful_update_at", "namespaces"."ldap_sync_last_sync_at", "namespaces"."description_html", "namespaces"."lfs_enabled", "namespaces"."parent_id", "namespaces"."shared_runners_minutes_limit", "namespaces"."repository_size_limit", "namespaces"."require_two_factor_authentication", "namespaces"."two_factor_grace_period", "namespaces"."cached_markdown_version", "namespaces"."project_creation_level", "namespaces"."runners_token", "namespaces"."file_template_project_id", "namespaces"."saml_discovery_token", "namespaces"."runners_token_encrypted", "namespaces"."custom_project_templates_group_id", "namespaces"."auto_devops_enabled", "namespaces"."extra_shared_runners_minutes_limit", "namespaces"."last_ci_minutes_notification_at", "namespaces"."last_ci_minutes_usage_notification_level", "namespaces"."subgroup_creation_level", "namespaces"."max_pages_size", "namespaces"."max_artifacts_size", "namespaces"."mentions_disabled", "namespaces"."default_branch_protection", "namespaces"."max_personal_access_token_lifetime", "namespaces"."push_rule_id", "namespaces"."shared_runners_enabled", "namespaces"."allow_descendants_override_disabled_shared_runners", "namespaces"."traversal_ids", "namespaces"."organization_id" FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 119 LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
3: SELECT "namespace_bans".* FROM "namespace_bans" WHERE "namespace_bans"."user_id" = 45 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/ee/app/policies/ee/project_policy.rb:194:in `block (2 levels) in <module:ProjectPolicy>'*/
4: SELECT "users".* FROM find_users_by_id(45) AS users WHERE ("users"."id" IS NOT NULL) LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
5: SELECT MAX("project_authorizations"."access_level") AS "maximum_access_level", "project_authorizations"."user_id" AS "project_authorizations_user_id" FROM "project_authorizations" WHERE "project_authorizations"."project_id" = 75 AND "project_authorizations"."user_id" = 45 GROUP BY "project_authorizations"."user_id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/project_team.rb:198:in `block in max_member_access_for_user_ids'*/
6: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 75 AND "routes"."source_type" = 'Project' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/routable.rb:163:in `full_attribute'*/
7: SELECT "namespaces"."id", "namespaces"."name", "namespaces"."path", "namespaces"."owner_id", "namespaces"."created_at", "namespaces"."updated_at", "namespaces"."type", "namespaces"."description", "namespaces"."avatar", "namespaces"."membership_lock", "namespaces"."share_with_group_lock", "namespaces"."visibility_level", "namespaces"."request_access_enabled", "namespaces"."ldap_sync_status", "namespaces"."ldap_sync_error", "namespaces"."ldap_sync_last_update_at", "namespaces"."ldap_sync_last_successful_update_at", "namespaces"."ldap_sync_last_sync_at", "namespaces"."description_html", "namespaces"."lfs_enabled", "namespaces"."parent_id", "namespaces"."shared_runners_minutes_limit", "namespaces"."repository_size_limit", "namespaces"."require_two_factor_authentication", "namespaces"."two_factor_grace_period", "namespaces"."cached_markdown_version", "namespaces"."project_creation_level", "namespaces"."runners_token", "namespaces"."file_template_project_id", "namespaces"."saml_discovery_token", "namespaces"."runners_token_encrypted", "namespaces"."custom_project_templates_group_id", "namespaces"."auto_devops_enabled", "namespaces"."extra_shared_runners_minutes_limit", "namespaces"."last_ci_minutes_notification_at", "namespaces"."last_ci_minutes_usage_notification_level", "namespaces"."subgroup_creation_level", "namespaces"."max_pages_size", "namespaces"."max_artifacts_size", "namespaces"."mentions_disabled", "namespaces"."default_branch_protection", "namespaces"."max_personal_access_token_lifetime", "namespaces"."push_rule_id", "namespaces"."shared_runners_enabled", "namespaces"."allow_descendants_override_disabled_shared_runners", "namespaces"."traversal_ids", "namespaces"."organization_id" FROM find_namespaces_by_id(119) AS namespaces WHERE ("namespaces"."id" IS NOT NULL) LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
8: SELECT "namespace_settings"."created_at", "namespace_settings"."updated_at", "namespace_settings"."namespace_id", "namespace_settings"."prevent_forking_outside_group", "namespace_settings"."allow_mfa_for_subgroups", "namespace_settings"."default_branch_name", "namespace_settings"."repository_read_only", "namespace_settings"."resource_access_token_creation_allowed", "namespace_settings"."prevent_sharing_groups_outside_hierarchy", "namespace_settings"."new_user_signups_cap", "namespace_settings"."setup_for_company", "namespace_settings"."jobs_to_be_done", "namespace_settings"."runner_token_expiration_interval", "namespace_settings"."subgroup_runner_token_expiration_interval", "namespace_settings"."project_runner_token_expiration_interval", "namespace_settings"."show_diff_preview_in_email", "namespace_settings"."enabled_git_access_protocol", "namespace_settings"."unique_project_download_limit", "namespace_settings"."unique_project_download_limit_interval_in_seconds", "namespace_settings"."unique_project_download_limit_allowlist", "namespace_settings"."auto_ban_user_on_excessive_projects_download", "namespace_settings"."only_allow_merge_if_pipeline_succeeds", "namespace_settings"."allow_merge_on_skipped_pipeline", "namespace_settings"."only_allow_merge_if_all_discussions_are_resolved", "namespace_settings"."default_compliance_framework_id", "namespace_settings"."runner_registration_enabled", "namespace_settings"."allow_runner_registration_token", "namespace_settings"."unique_project_download_limit_alertlist", "namespace_settings"."emails_enabled", "namespace_settings"."experiment_features_enabled", "namespace_settings"."default_branch_protection_defaults", "namespace_settings"."service_access_tokens_expiration_enforced", "namespace_settings"."product_analytics_enabled", "namespace_settings"."allow_merge_without_pipeline", "namespace_settings"."enforce_ssh_certificates", "namespace_settings"."toggle_security_policy_custom_ci", "namespace_settings"."lock_toggle_security_policy_custom_ci", "namespace_settings"."math_rendering_limits_enabled", "namespace_settings"."lock_math_rendering_limits_enabled", "namespace_settings"."duo_features_enabled", "namespace_settings"."lock_duo_features_enabled", "namespace_settings"."disable_personal_access_tokens", "namespace_settings"."enable_auto_assign_gitlab_duo_pro_seats", "namespace_settings"."remove_dormant_members", "namespace_settings"."remove_dormant_members_period", "namespace_settings"."early_access_program_participant", "namespace_settings"."early_access_program_joined_by_id" FROM "namespace_settings" WHERE "namespace_settings"."namespace_id" = 119 LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gon_helper.rb:112:in `push_namespace_setting'*/
9: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 119 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/routable.rb:163:in `full_attribute'*/
10: SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 75 LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/policies/project_policy.rb:1121:in `access_allowed_to?'*/
11: SELECT DISTINCT ON (sha) * FROM "ci_pipelines" WHERE "ci_pipelines"."project_id" = 75 AND ("ci_pipelines"."source" IN (1, 2, 3, 4, 5, 6, 7, 8, 10, 11) OR "ci_pipelines"."source" IS NULL) AND "ci_pipelines"."sha" IN ('5790a047570ec033c7808609ac01016715a8e669', 'b83d6e391c22777fca1ed3012fce84f633d7fed0', '498214de67004b1da3d820901307bed2a68a8ef6', '1b12f15a11fc6e62177bef08f47bc7b5ce50b141', '38008cb17ce1466d8fec2dfa6f6ab8dcfe5cf49e', '6907208d755b60ebeacb2e9dfea74c92c3449a1f', 'c347ca2e140aa667b968e51ed0ffe055501fe4f4', 'd59c60028b053793cecfb4022de34602e1a9218e', '281d3a76f31c812dbf48abce82ccf6860adedd81', 'a5391128b0ef5d21df5dd23d98557f4ef12fae20', '54fcc214b94e78d7a41a9a8fe6d87a5e59500e51', 'be93687618e4b132087f430a4d8fc3a609c9b77c', '048721d90c449b244b7b4c53a9186b04330174ec', '5f923865dde3436854e9ceb9cdb7815618d4e849', 'd2d430676773caa88cdaf7c55944073b2fd5561a', '2ea1f3dec713d940208fb5ce4a38765ecb5d3f73', '59e29889be61e6e0e5e223bfa9ac2721d31605b8', '66eceea0db202bb39c4e445e8ca28689645366c5', '08f22f255f082689c0d7d39d19205085311542bc', '19e2e9b4ef76b422ce1154af39a91323ccc57434', 'c642fe9b8b9f28f9225d7ea953fe14e74748d53b', '9a944d90955aaf45f6d0c88f30e27f8d2c41cec0', 'c7fbe50c7c7419d9701eebe64b1fdacc3df5b9dd', 'e56497bb5f03a90a51293fc6d516788730953899', '4cd80ccab63c82b4bad16faa5193fbd2aa06df40', '5937ac0a7beb003549fc5fd26fc247adbce4a52e', '570e7b2abdd848b95f2f578043fc23bd6f6fd24d', '6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9', 'd14d6c0abdd253381df51a723d58691b2ee1ab08', 'c1acaa58bbcbc3eafe538cb8274ba387047b69f8', 'ae73cb07c9eeaf35924a10f713b364d32b2dd34f', '874797c3a73b60d2187ed6e2fcabd289ff75171e', '2f63565e7aac07bcdadb654e253078b727143ec4', '33f3729a45c02fc67d00adb1b8bca394b0e761d9', '913c66a37b4a45b9769037c55c2d238bd0942d2e', 'cfe32cf61b73a0d5e9f13e774abde7ff789b1660', '6d394385cf567f80a8fd85055db1ab4c5295806f', '1a0b36b3cdad1d2ee32457c102a8c0b7056fa863') AND "ci_pipelines"."ref" = 'master' ORDER BY "ci_pipelines"."sha" ASC, "ci_pipelines"."id" DESC /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:ci,line:/app/models/ci/pipeline.rb:547:in `latest_pipeline_per_commit'*/
12: SELECT "users".* FROM ((SELECT "users".* FROM "users" WHERE (LOWER("users"."email") IN (LOWER('user1@example.org'), LOWER('job@gitlab.com'), LOWER('tiagonbotelho@hotmail.com'), LOWER('stanhu@gmail.com'), LOWER('gitlab@winniehell.de'), LOWER('douwe@gitlab.com'), LOWER('jneen@jneen.net'), LOWER('dbalexandre@gmail.com'), LOWER('marin@gitlab.com'), LOWER('maxlazio@gmail.com'), LOWER('minsik.yoon@samsung.com'), LOWER('stanhu@packetzoom.com'), LOWER('sytse@gitlab.com'), LOWER('marmis85@gmail.com'), LOWER('dmitriy.zaporozhets@gmail.com'))) AND "users"."confirmed_at" IS NOT NULL)
UNION
(SELECT "users".* FROM "users" INNER JOIN "emails" ON "emails"."user_id" = "users"."id" WHERE "emails"."email" IN ('user1@example.org', 'job@gitlab.com', 'tiagonbotelho@hotmail.com', 'stanhu@gmail.com', 'gitlab@winniehell.de', 'douwe@gitlab.com', 'jneen@jneen.net', 'dbalexandre@gmail.com', 'marin@gitlab.com', 'maxlazio@gmail.com', 'minsik.yoon@samsung.com', 'stanhu@packetzoom.com', 'sytse@gitlab.com', 'marmis85@gmail.com', 'dmitriy.zaporozhets@gmail.com') AND "emails"."confirmed_at" IS NOT NULL AND "users"."confirmed_at" IS NOT NULL)) users /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
13: SELECT "emails".* FROM "emails" WHERE "emails"."user_id" = 45 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/commit.rb:307:in `block (2 levels) in lazy_author'*/
14: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id" FROM "projects" WHERE "projects"."id" = 75 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
15: SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 75 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/banzai/reference_parser/base_parser.rb:190:in `collection_objects_for_ids'*/
16: SELECT "organizations".* FROM "organizations" WHERE "organizations"."id" = 1044 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/preloaders/project_policy_preloader.rb:16:in `execute'*/
17: SELECT "namespaces"."id", "namespaces"."name", "namespaces"."path", "namespaces"."owner_id", "namespaces"."created_at", "namespaces"."updated_at", "namespaces"."type", "namespaces"."description", "namespaces"."avatar", "namespaces"."membership_lock", "namespaces"."share_with_group_lock", "namespaces"."visibility_level", "namespaces"."request_access_enabled", "namespaces"."ldap_sync_status", "namespaces"."ldap_sync_error", "namespaces"."ldap_sync_last_update_at", "namespaces"."ldap_sync_last_successful_update_at", "namespaces"."ldap_sync_last_sync_at", "namespaces"."description_html", "namespaces"."lfs_enabled", "namespaces"."parent_id", "namespaces"."shared_runners_minutes_limit", "namespaces"."repository_size_limit", "namespaces"."require_two_factor_authentication", "namespaces"."two_factor_grace_period", "namespaces"."cached_markdown_version", "namespaces"."project_creation_level", "namespaces"."runners_token", "namespaces"."file_template_project_id", "namespaces"."saml_discovery_token", "namespaces"."runners_token_encrypted", "namespaces"."custom_project_templates_group_id", "namespaces"."auto_devops_enabled", "namespaces"."extra_shared_runners_minutes_limit", "namespaces"."last_ci_minutes_notification_at", "namespaces"."last_ci_minutes_usage_notification_level", "namespaces"."subgroup_creation_level", "namespaces"."max_pages_size", "namespaces"."max_artifacts_size", "namespaces"."mentions_disabled", "namespaces"."default_branch_protection", "namespaces"."max_personal_access_token_lifetime", "namespaces"."push_rule_id", "namespaces"."shared_runners_enabled", "namespaces"."allow_descendants_override_disabled_shared_runners", "namespaces"."traversal_ids", "namespaces"."organization_id" FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 119 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
18: SELECT "namespaces"."id", "namespaces"."name", "namespaces"."path", "namespaces"."owner_id", "namespaces"."created_at", "namespaces"."updated_at", "namespaces"."type", "namespaces"."description", "namespaces"."avatar", "namespaces"."membership_lock", "namespaces"."share_with_group_lock", "namespaces"."visibility_level", "namespaces"."request_access_enabled", "namespaces"."ldap_sync_status", "namespaces"."ldap_sync_error", "namespaces"."ldap_sync_last_update_at", "namespaces"."ldap_sync_last_successful_update_at", "namespaces"."ldap_sync_last_sync_at", "namespaces"."description_html", "namespaces"."lfs_enabled", "namespaces"."parent_id", "namespaces"."shared_runners_minutes_limit", "namespaces"."repository_size_limit", "namespaces"."require_two_factor_authentication", "namespaces"."two_factor_grace_period", "namespaces"."cached_markdown_version", "namespaces"."project_creation_level", "namespaces"."runners_token", "namespaces"."file_template_project_id", "namespaces"."saml_discovery_token", "namespaces"."runners_token_encrypted", "namespaces"."custom_project_templates_group_id", "namespaces"."auto_devops_enabled", "namespaces"."extra_shared_runners_minutes_limit", "namespaces"."last_ci_minutes_notification_at", "namespaces"."last_ci_minutes_usage_notification_level", "namespaces"."subgroup_creation_level", "namespaces"."max_pages_size", "namespaces"."max_artifacts_size", "namespaces"."mentions_disabled", "namespaces"."default_branch_protection", "namespaces"."max_personal_access_token_lifetime", "namespaces"."push_rule_id", "namespaces"."shared_runners_enabled", "namespaces"."allow_descendants_override_disabled_shared_runners", "namespaces"."traversal_ids", "namespaces"."organization_id" FROM "namespaces" WHERE "namespaces"."id" = 119 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
19: SELECT "users".* FROM "users" WHERE "users"."id" = 45 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
20: SELECT "projects"."id", "projects"."name", "projects"."path", "projects"."description", "projects"."created_at", "projects"."updated_at", "projects"."creator_id", "projects"."namespace_id", "projects"."last_activity_at", "projects"."import_url", "projects"."visibility_level", "projects"."archived", "projects"."avatar", "projects"."merge_requests_template", "projects"."star_count", "projects"."merge_requests_rebase_enabled", "projects"."import_type", "projects"."import_source", "projects"."approvals_before_merge", "projects"."reset_approvals_on_push", "projects"."merge_requests_ff_only_enabled", "projects"."issues_template", "projects"."mirror", "projects"."mirror_last_update_at", "projects"."mirror_last_successful_update_at", "projects"."mirror_user_id", "projects"."shared_runners_enabled", "projects"."runners_token", "projects"."build_allow_git_fetch", "projects"."build_timeout", "projects"."mirror_trigger_builds", "projects"."pending_delete", "projects"."public_builds", "projects"."last_repository_check_failed", "projects"."last_repository_check_at", "projects"."only_allow_merge_if_pipeline_succeeds", "projects"."has_external_issue_tracker", "projects"."repository_storage", "projects"."repository_read_only", "projects"."request_access_enabled", "projects"."has_external_wiki", "projects"."ci_config_path", "projects"."lfs_enabled", "projects"."description_html", "projects"."only_allow_merge_if_all_discussions_are_resolved", "projects"."repository_size_limit", "projects"."printing_merge_request_link_enabled", "projects"."auto_cancel_pending_pipelines", "projects"."service_desk_enabled", "projects"."cached_markdown_version", "projects"."delete_error", "projects"."last_repository_updated_at", "projects"."disable_overriding_approvers_per_merge_request", "projects"."storage_version", "projects"."resolve_outdated_diff_discussions", "projects"."remote_mirror_available_overridden", "projects"."only_mirror_protected_branches", "projects"."pull_mirror_available_overridden", "projects"."jobs_cache_index", "projects"."external_authorization_classification_label", "projects"."mirror_overwrites_diverged_branches", "projects"."pages_https_only", "projects"."external_webhook_token", "projects"."packages_enabled", "projects"."merge_requests_author_approval", "projects"."pool_repository_id", "projects"."runners_token_encrypted", "projects"."bfg_object_map", "projects"."detected_repository_languages", "projects"."merge_requests_disable_committers_approval", "projects"."require_password_to_approve", "projects"."max_pages_size", "projects"."max_artifacts_size", "projects"."pull_mirror_branch_prefix", "projects"."remove_source_branch_after_merge", "projects"."marked_for_deletion_at", "projects"."marked_for_deletion_by_user_id", "projects"."autoclose_referenced_issues", "projects"."suggestion_commit_message", "projects"."project_namespace_id", "projects"."hidden", "projects"."organization_id", "project_authorizations"."user_id", "project_authorizations"."access_level" FROM "projects" LEFT OUTER JOIN "project_authorizations" AS project_authorizations ON "project_authorizations"."project_id" = "projects"."id" AND "project_authorizations"."user_id" = 45 WHERE "projects"."id" = 75 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/concerns/use_sql_function_for_primary_key_lookups.rb:12:in `_query_by_sql'*/
21: SELECT "project_group_links"."id" AS t0_r0, "project_group_links"."project_id" AS t0_r1, "project_group_links"."group_id" AS t0_r2, "project_group_links"."created_at" AS t0_r3, "project_group_links"."updated_at" AS t0_r4, "project_group_links"."group_access" AS t0_r5, "project_group_links"."expires_at" AS t0_r6, "namespaces"."id" AS t1_r0, "namespaces"."name" AS t1_r1, "namespaces"."path" AS t1_r2, "namespaces"."owner_id" AS t1_r3, "namespaces"."created_at" AS t1_r4, "namespaces"."updated_at" AS t1_r5, "namespaces"."type" AS t1_r6, "namespaces"."description" AS t1_r7, "namespaces"."avatar" AS t1_r8, "namespaces"."membership_lock" AS t1_r9, "namespaces"."share_with_group_lock" AS t1_r10, "namespaces"."visibility_level" AS t1_r11, "namespaces"."request_access_enabled" AS t1_r12, "namespaces"."ldap_sync_status" AS t1_r13, "namespaces"."ldap_sync_error" AS t1_r14, "namespaces"."ldap_sync_last_update_at" AS t1_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t1_r16, "namespaces"."ldap_sync_last_sync_at" AS t1_r17, "namespaces"."description_html" AS t1_r18, "namespaces"."lfs_enabled" AS t1_r19, "namespaces"."parent_id" AS t1_r20, "namespaces"."shared_runners_minutes_limit" AS t1_r21, "namespaces"."repository_size_limit" AS t1_r22, "namespaces"."require_two_factor_authentication" AS t1_r23, "namespaces"."two_factor_grace_period" AS t1_r24, "namespaces"."cached_markdown_version" AS t1_r25, "namespaces"."project_creation_level" AS t1_r26, "namespaces"."runners_token" AS t1_r27, "namespaces"."file_template_project_id" AS t1_r28, "namespaces"."saml_discovery_token" AS t1_r29, "namespaces"."runners_token_encrypted" AS t1_r30, "namespaces"."custom_project_templates_group_id" AS t1_r31, "namespaces"."auto_devops_enabled" AS t1_r32, "namespaces"."extra_shared_runners_minutes_limit" AS t1_r33, "namespaces"."last_ci_minutes_notification_at" AS t1_r34, "namespaces"."last_ci_minutes_usage_notification_level" AS t1_r35, "namespaces"."subgroup_creation_level" AS t1_r36, "namespaces"."max_pages_size" AS t1_r37, "namespaces"."max_artifacts_size" AS t1_r38, "namespaces"."mentions_disabled" AS t1_r39, "namespaces"."default_branch_protection" AS t1_r40, "namespaces"."max_personal_access_token_lifetime" AS t1_r41, "namespaces"."push_rule_id" AS t1_r42, "namespaces"."shared_runners_enabled" AS t1_r43, "namespaces"."allow_descendants_override_disabled_shared_runners" AS t1_r44, "namespaces"."traversal_ids" AS t1_r45, "namespaces"."organization_id" AS t1_r46 FROM "project_group_links" LEFT OUTER JOIN "namespaces" ON "namespaces"."id" = "project_group_links"."group_id" AND "namespaces"."type" = 'Group' WHERE "namespaces"."type" = 'Group' AND "project_group_links"."project_id" = 75 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/ee/app/models/ee/preloaders/project_policy_preloader.rb:14:in `execute'*/
22: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
23: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
24: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
25: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
26: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:43.866707', '2024-07-03 00:55:43.866707', 75, '\x5937ac0a7beb003549fc5fd26fc247adbce4a52e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
27: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
28: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
29: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
30: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
31: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:44.415867', '2024-07-03 00:55:44.415867', 75, '\x570e7b2abdd848b95f2f578043fc23bd6f6fd24d', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
32: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
33: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
34: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
35: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
36: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:44.860719', '2024-07-03 00:55:44.860719', 75, '\x6f6d7e7ed97bb5f0054f2b1df789b39ca89b6ff9', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
37: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xd14d6c0abdd253381df51a723d58691b2ee1ab08' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
38: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
39: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
40: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xd14d6c0abdd253381df51a723d58691b2ee1ab08' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
41: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:45.278903', '2024-07-03 00:55:45.278903', 75, '\xd14d6c0abdd253381df51a723d58691b2ee1ab08', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
42: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
43: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
44: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
45: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
46: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:45.686054', '2024-07-03 00:55:45.686054', 75, '\xc1acaa58bbcbc3eafe538cb8274ba387047b69f8', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
47: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
48: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
49: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
50: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
51: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:46.116112', '2024-07-03 00:55:46.116112', 75, '\xae73cb07c9eeaf35924a10f713b364d32b2dd34f', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
52: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x874797c3a73b60d2187ed6e2fcabd289ff75171e' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
53: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
54: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
55: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x874797c3a73b60d2187ed6e2fcabd289ff75171e' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
56: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:46.524426', '2024-07-03 00:55:46.524426', 75, '\x874797c3a73b60d2187ed6e2fcabd289ff75171e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
57: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x2f63565e7aac07bcdadb654e253078b727143ec4' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
58: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
59: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
60: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x2f63565e7aac07bcdadb654e253078b727143ec4' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
61: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:47.085337', '2024-07-03 00:55:47.085337', 75, '\x2f63565e7aac07bcdadb654e253078b727143ec4', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
62: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
63: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
64: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
65: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
66: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:47.480449', '2024-07-03 00:55:47.480449', 75, '\x33f3729a45c02fc67d00adb1b8bca394b0e761d9', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
67: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x913c66a37b4a45b9769037c55c2d238bd0942d2e' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
68: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
69: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
70: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x913c66a37b4a45b9769037c55c2d238bd0942d2e' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
71: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:47.873054', '2024-07-03 00:55:47.873054', 75, '\x913c66a37b4a45b9769037c55c2d238bd0942d2e', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
72: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
73: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
74: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
75: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
76: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:48.272679', '2024-07-03 00:55:48.272679', 75, '\xcfe32cf61b73a0d5e9f13e774abde7ff789b1660', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/
77: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6d394385cf567f80a8fd85055db1ab4c5295806f' /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/signed_commit.rb:61:in `block in lazy_signature'*/
78: SELECT "gpg_keys".* FROM "gpg_keys" WHERE "gpg_keys"."primary_keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
79: SELECT "gpg_key_subkeys".* FROM "gpg_key_subkeys" WHERE "gpg_key_subkeys"."keyid" = '\x627c5f589f467f17' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/lib/gitlab/gpg/commit.rb:122:in `find_gpg_key'*/
80: SELECT "gpg_signatures".* FROM "gpg_signatures" WHERE "gpg_signatures"."commit_sha" = '\x6d394385cf567f80a8fd85055db1ab4c5295806f' LIMIT 1 /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:82:in `safe_find_or_create_by'*/
81: INSERT INTO "gpg_signatures" ("created_at", "updated_at", "project_id", "commit_sha", "gpg_key_primary_keyid", "verification_status") VALUES ('2024-07-03 00:55:48.671642', '2024-07-03 00:55:48.671642', 75, '\x6d394385cf567f80a8fd85055db1ab4c5295806f', '\x627c5f589f467f17', 5) RETURNING "id" /*application:test,correlation_id:01J1V1E4RJJTZJ8PATTVWNMDCJ,endpoint_id:Projects::CommitsController#signatures,db_config_name:main,line:/app/models/application_record.rb:90:in `block in safe_find_or_create_by'*/

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

• Checkout to this MR branch: 424527-optimize-projects-commits-controller-signatures
• Run bin/rspec spec/features/projects/commit/cherry_pick_spec.rb locally.
• The test should pass.

Related to #424527 (closed)