Failure/Error: raise(error) if raise_error?
Gitlab::QueryLimiting::Transaction::ThresholdExceededError:
Too many SQL queries were executed in Projects::IssuesController#create: a maximum of 100 is allowed but 103 SQL queries were executed
0: SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."avatar" AS t0_r12, "projects"."merge_requests_template" AS t0_r13, "projects"."star_count" AS t0_r14, "projects"."merge_requests_rebase_enabled" AS t0_r15, "projects"."import_type" AS t0_r16, "projects"."import_source" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_last_update_at" AS t0_r23, "projects"."mirror_last_successful_update_at" AS t0_r24, "projects"."mirror_user_id" AS t0_r25, "projects"."shared_runners_enabled" AS t0_r26, "projects"."runners_token" AS t0_r27, "projects"."build_allow_git_fetch" AS t0_r28, "projects"."build_timeout" AS t0_r29, "projects"."mirror_trigger_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."public_builds" AS t0_r32, "projects"."last_repository_check_failed" AS t0_r33, "projects"."last_repository_check_at" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."repository_read_only" AS t0_r38, "projects"."request_access_enabled" AS t0_r39, "projects"."has_external_wiki" AS t0_r40, "projects"."ci_config_path" AS t0_r41, "projects"."lfs_enabled" AS t0_r42, "projects"."description_html" AS t0_r43, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r44, "projects"."repository_size_limit" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."service_desk_enabled" AS t0_r48, "projects"."cached_markdown_version" AS t0_r49, "projects"."delete_error" AS t0_r50, "projects"."last_repository_updated_at" AS t0_r51, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."pages_https_only" AS t0_r61, "projects"."external_webhook_token" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."max_pages_size" AS t0_r71, "projects"."max_artifacts_size" AS t0_r72, "projects"."pull_mirror_branch_prefix" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."autoclose_referenced_issues" AS t0_r77, "projects"."suggestion_commit_message" AS t0_r78, "projects"."project_namespace_id" AS t0_r79, "projects"."hidden" AS t0_r80, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6, "routes"."namespace_id" AS t1_r7 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" WHERE "routes"."path" = 'namespace59/project-59' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,db_config_name:main,line:/app/models/concerns/routable.rb:29:in `find_by_full_path'*/
1: SELECT "user_details"."user_id", "user_details"."job_title", "user_details"."bio", "user_details"."webauthn_xid", "user_details"."provisioned_by_group_id", "user_details"."pronouns", "user_details"."pronunciation", "user_details"."registration_objective", "user_details"."phone", "user_details"."linkedin", "user_details"."twitter", "user_details"."skype", "user_details"."website_url", "user_details"."location", "user_details"."organization", "user_details"."password_last_changed_at", "user_details"."onboarding_step_url", "user_details"."discord", "user_details"."enterprise_group_id", "user_details"."enterprise_group_associated_at" FROM "user_details" WHERE "user_details"."user_id" = 171 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/user.rb:2144:in `user_detail'*/
2: SELECT 1 AS one FROM "identities" WHERE "identities"."user_id" = 171 AND (provider LIKE 'ldap%' AND extern_uid IS NOT NULL) LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/user.rb:1431:in `ldap_user?'*/
3: SELECT "user_preferences"."id", "user_preferences"."user_id", "user_preferences"."issue_notes_filter", "user_preferences"."merge_request_notes_filter", "user_preferences"."created_at", "user_preferences"."updated_at", "user_preferences"."epics_sort", "user_preferences"."roadmap_epics_state", "user_preferences"."epic_notes_filter", "user_preferences"."issues_sort", "user_preferences"."merge_requests_sort", "user_preferences"."roadmaps_sort", "user_preferences"."first_day_of_week", "user_preferences"."timezone", "user_preferences"."time_display_relative", "user_preferences"."projects_sort", "user_preferences"."show_whitespace_in_diffs", "user_preferences"."sourcegraph_enabled", "user_preferences"."setup_for_company", "user_preferences"."render_whitespace_in_code", "user_preferences"."tab_width", "user_preferences"."view_diffs_file_by_file", "user_preferences"."gitpod_enabled", "user_preferences"."markdown_surround_selection", "user_preferences"."diffs_deletion_color", "user_preferences"."diffs_addition_color", "user_preferences"."markdown_automatic_lists", "user_preferences"."use_new_navigation", "user_preferences"."achievements_enabled", "user_preferences"."pinned_nav_items", "user_preferences"."pass_user_identities_to_ci_jwt", "user_preferences"."enabled_following", "user_preferences"."visibility_pipeline_id_type", "user_preferences"."project_shortcut_buttons", "user_preferences"."enabled_zoekt" FROM "user_preferences" WHERE "user_preferences"."user_id" = 171 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/user.rb:2140:in `user_preference'*/
4: SELECT "projects"."id" AS t0_r0, "projects"."name" AS t0_r1, "projects"."path" AS t0_r2, "projects"."description" AS t0_r3, "projects"."created_at" AS t0_r4, "projects"."updated_at" AS t0_r5, "projects"."creator_id" AS t0_r6, "projects"."namespace_id" AS t0_r7, "projects"."last_activity_at" AS t0_r8, "projects"."import_url" AS t0_r9, "projects"."visibility_level" AS t0_r10, "projects"."archived" AS t0_r11, "projects"."avatar" AS t0_r12, "projects"."merge_requests_template" AS t0_r13, "projects"."star_count" AS t0_r14, "projects"."merge_requests_rebase_enabled" AS t0_r15, "projects"."import_type" AS t0_r16, "projects"."import_source" AS t0_r17, "projects"."approvals_before_merge" AS t0_r18, "projects"."reset_approvals_on_push" AS t0_r19, "projects"."merge_requests_ff_only_enabled" AS t0_r20, "projects"."issues_template" AS t0_r21, "projects"."mirror" AS t0_r22, "projects"."mirror_last_update_at" AS t0_r23, "projects"."mirror_last_successful_update_at" AS t0_r24, "projects"."mirror_user_id" AS t0_r25, "projects"."shared_runners_enabled" AS t0_r26, "projects"."runners_token" AS t0_r27, "projects"."build_allow_git_fetch" AS t0_r28, "projects"."build_timeout" AS t0_r29, "projects"."mirror_trigger_builds" AS t0_r30, "projects"."pending_delete" AS t0_r31, "projects"."public_builds" AS t0_r32, "projects"."last_repository_check_failed" AS t0_r33, "projects"."last_repository_check_at" AS t0_r34, "projects"."only_allow_merge_if_pipeline_succeeds" AS t0_r35, "projects"."has_external_issue_tracker" AS t0_r36, "projects"."repository_storage" AS t0_r37, "projects"."repository_read_only" AS t0_r38, "projects"."request_access_enabled" AS t0_r39, "projects"."has_external_wiki" AS t0_r40, "projects"."ci_config_path" AS t0_r41, "projects"."lfs_enabled" AS t0_r42, "projects"."description_html" AS t0_r43, "projects"."only_allow_merge_if_all_discussions_are_resolved" AS t0_r44, "projects"."repository_size_limit" AS t0_r45, "projects"."printing_merge_request_link_enabled" AS t0_r46, "projects"."auto_cancel_pending_pipelines" AS t0_r47, "projects"."service_desk_enabled" AS t0_r48, "projects"."cached_markdown_version" AS t0_r49, "projects"."delete_error" AS t0_r50, "projects"."last_repository_updated_at" AS t0_r51, "projects"."disable_overriding_approvers_per_merge_request" AS t0_r52, "projects"."storage_version" AS t0_r53, "projects"."resolve_outdated_diff_discussions" AS t0_r54, "projects"."remote_mirror_available_overridden" AS t0_r55, "projects"."only_mirror_protected_branches" AS t0_r56, "projects"."pull_mirror_available_overridden" AS t0_r57, "projects"."jobs_cache_index" AS t0_r58, "projects"."external_authorization_classification_label" AS t0_r59, "projects"."mirror_overwrites_diverged_branches" AS t0_r60, "projects"."pages_https_only" AS t0_r61, "projects"."external_webhook_token" AS t0_r62, "projects"."packages_enabled" AS t0_r63, "projects"."merge_requests_author_approval" AS t0_r64, "projects"."pool_repository_id" AS t0_r65, "projects"."runners_token_encrypted" AS t0_r66, "projects"."bfg_object_map" AS t0_r67, "projects"."detected_repository_languages" AS t0_r68, "projects"."merge_requests_disable_committers_approval" AS t0_r69, "projects"."require_password_to_approve" AS t0_r70, "projects"."max_pages_size" AS t0_r71, "projects"."max_artifacts_size" AS t0_r72, "projects"."pull_mirror_branch_prefix" AS t0_r73, "projects"."remove_source_branch_after_merge" AS t0_r74, "projects"."marked_for_deletion_at" AS t0_r75, "projects"."marked_for_deletion_by_user_id" AS t0_r76, "projects"."autoclose_referenced_issues" AS t0_r77, "projects"."suggestion_commit_message" AS t0_r78, "projects"."project_namespace_id" AS t0_r79, "projects"."hidden" AS t0_r80, "routes"."id" AS t1_r0, "routes"."source_id" AS t1_r1, "routes"."source_type" AS t1_r2, "routes"."path" AS t1_r3, "routes"."created_at" AS t1_r4, "routes"."updated_at" AS t1_r5, "routes"."name" AS t1_r6, "routes"."namespace_id" AS t1_r7 FROM "projects" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Project' AND "routes"."source_id" = "projects"."id" WHERE "routes"."path" = 'namespace59/project-59' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:29:in `find_by_full_path'*/
5: SELECT "users".* FROM "users" WHERE "users"."id" = 169 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:3161:in `created_and_owned_by_banned_user?'*/
6: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/ee/lib/gitlab/auth/group_saml/sso_enforcer.rb:11:in `access_restricted?'*/
7: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/ee/app/policies/ee/project_policy.rb:201:in `block (2 levels) in <module:ProjectPolicy>'*/
8: 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" = 59 AND "project_authorizations"."user_id" = 171 GROUP BY "project_authorizations"."user_id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project_team.rb:192:in `block in max_member_access_for_user_ids'*/
9: SELECT "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:2079:in `feature_available?'*/
10: SELECT "issues"."id", "issues"."title", "issues"."author_id", "issues"."project_id", "issues"."created_at", "issues"."updated_at", "issues"."description", "issues"."milestone_id", "issues"."iid", "issues"."updated_by_id", "issues"."weight", "issues"."confidential", "issues"."due_date", "issues"."moved_to_id", "issues"."lock_version", "issues"."title_html", "issues"."description_html", "issues"."time_estimate", "issues"."relative_position", "issues"."service_desk_reply_to", "issues"."cached_markdown_version", "issues"."last_edited_at", "issues"."last_edited_by_id", "issues"."discussion_locked", "issues"."closed_at", "issues"."closed_by_id", "issues"."state_id", "issues"."duplicated_to_id", "issues"."promoted_to_epic_id", "issues"."health_status", "issues"."external_key", "issues"."sprint_id", "issues"."blocking_issues_count", "issues"."upvotes_count", "issues"."work_item_type_id", "issues"."namespace_id", "issues"."start_date" FROM "issues" WHERE "issues"."project_id" = 59 AND "issues"."iid" IS NULL LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/controllers/projects/issues_controller.rb:449:in `add_related_issue'*/
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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/issuable_finder/params.rb:108:in `block in project'*/
12: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/issuable_finder.rb:517:in `block in root_group'*/
13: SELECT "merge_requests".* FROM "merge_requests" WHERE (NOT EXISTS (SELECT 1 FROM "banned_users" WHERE (merge_requests.author_id = banned_users.user_id))) AND "merge_requests"."target_project_id" = 59 AND "merge_requests"."iid" = 1 /* allow_cross_joins_across_databases */ LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/concerns/finder_methods.rb:12:in `find_by'*/
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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/policies/issuable_policy.rb:62:in `subject_container'*/
15: SELECT "users".* FROM "users" WHERE "users"."id" = 169 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/merge_request.rb:2070:in `hidden?'*/
16: SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 30 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association'*/
17: SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 30 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/merge_request_diff.rb:339:in `commit_shas'*/
18: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM ((SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest')
UNION ALL
(SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (59, 59) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('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'))) notes WHERE "notes"."type" IN ('DiffNote', 'DiscussionNote') AND "notes"."noteable_type" IN ('MergeRequest', 'DesignManagement::Design') AND "notes"."system" = FALSE ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
19: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 31 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/helpers/routing/projects_helper.rb:55:in `merge_request_url'*/
21: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/config/routes.rb:312:in `block (4 levels) in <top (required)>'*/
22: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 230 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:149:in `full_attribute'*/
23: SELECT "users".* FROM "users" WHERE "users"."id" = 169 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/issues/build_service.rb:62:in `item_for_discussion'*/
24: SELECT "work_item_types".* FROM "work_item_types" WHERE "work_item_types"."namespace_id" IS NULL AND "work_item_types"."base_type" = 0 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/work_items/type.rb:69:in `default_by_type'*/
25: SELECT "users".* FROM "users" WHERE "users"."id" = 0 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/issuable_base_service.rb:116:in `user_can_read?'*/
26: SELECT "users".* FROM "users" WHERE "users"."id" = 169 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:1821:in `owner'*/
27: SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:812:in `ensure_namespace_id'*/
28: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Project' AND "namespaces"."id" = 231 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:812:in `ensure_namespace_id'*/
29: SELECT "namespaces"."id" AS t0_r0, "namespaces"."name" AS t0_r1, "namespaces"."path" AS t0_r2, "namespaces"."owner_id" AS t0_r3, "namespaces"."created_at" AS t0_r4, "namespaces"."updated_at" AS t0_r5, "namespaces"."type" AS t0_r6, "namespaces"."description" AS t0_r7, "namespaces"."avatar" AS t0_r8, "namespaces"."membership_lock" AS t0_r9, "namespaces"."share_with_group_lock" AS t0_r10, "namespaces"."visibility_level" AS t0_r11, "namespaces"."request_access_enabled" AS t0_r12, "namespaces"."ldap_sync_status" AS t0_r13, "namespaces"."ldap_sync_error" AS t0_r14, "namespaces"."ldap_sync_last_update_at" AS t0_r15, "namespaces"."ldap_sync_last_successful_update_at" AS t0_r16, "namespaces"."ldap_sync_last_sync_at" AS t0_r17, "namespaces"."description_html" AS t0_r18, "namespaces"."lfs_enabled" AS t0_r19, "namespaces"."parent_id" AS t0_r20, "namespaces"."shared_runners_minutes_limit" AS t0_r21, "namespaces"."repository_size_limit" AS t0_r22, "namespaces"."require_two_factor_authentication" AS t0_r23, "namespaces"."two_factor_grace_period" AS t0_r24, "namespaces"."cached_markdown_version" AS t0_r25, "namespaces"."project_creation_level" AS t0_r26, "namespaces"."runners_token" AS t0_r27, "namespaces"."file_template_project_id" AS t0_r28, "namespaces"."saml_discovery_token" AS t0_r29, "namespaces"."runners_token_encrypted" AS t0_r30, "namespaces"."custom_project_templates_group_id" AS t0_r31, "namespaces"."auto_devops_enabled" AS t0_r32, "namespaces"."extra_shared_runners_minutes_limit" AS t0_r33, "namespaces"."last_ci_minutes_notification_at" AS t0_r34, "namespaces"."last_ci_minutes_usage_notification_level" AS t0_r35, "namespaces"."subgroup_creation_level" AS t0_r36, "namespaces"."emails_disabled" AS t0_r37, "namespaces"."max_pages_size" AS t0_r38, "namespaces"."max_artifacts_size" AS t0_r39, "namespaces"."mentions_disabled" AS t0_r40, "namespaces"."default_branch_protection" AS t0_r41, "namespaces"."unlock_membership_to_ldap" AS t0_r42, "namespaces"."max_personal_access_token_lifetime" AS t0_r43, "namespaces"."push_rule_id" AS t0_r44, "namespaces"."shared_runners_enabled" AS t0_r45, "namespaces"."allow_descendants_override_disabled_shared_runners" AS t0_r46, "namespaces"."traversal_ids" AS t0_r47, "namespaces"."organization_id" AS t0_r48, "users"."id" AS t1_r0, "users"."email" AS t1_r1, "users"."encrypted_password" AS t1_r2, "users"."reset_password_token" AS t1_r3, "users"."reset_password_sent_at" AS t1_r4, "users"."remember_created_at" AS t1_r5, "users"."sign_in_count" AS t1_r6, "users"."current_sign_in_at" AS t1_r7, "users"."last_sign_in_at" AS t1_r8, "users"."current_sign_in_ip" AS t1_r9, "users"."last_sign_in_ip" AS t1_r10, "users"."created_at" AS t1_r11, "users"."updated_at" AS t1_r12, "users"."name" AS t1_r13, "users"."admin" AS t1_r14, "users"."projects_limit" AS t1_r15, "users"."failed_attempts" AS t1_r16, "users"."locked_at" AS t1_r17, "users"."username" AS t1_r18, "users"."can_create_group" AS t1_r19, "users"."can_create_team" AS t1_r20, "users"."state" AS t1_r21, "users"."color_scheme_id" AS t1_r22, "users"."password_expires_at" AS t1_r23, "users"."created_by_id" AS t1_r24, "users"."last_credential_check_at" AS t1_r25, "users"."avatar" AS t1_r26, "users"."confirmation_token" AS t1_r27, "users"."confirmed_at" AS t1_r28, "users"."confirmation_sent_at" AS t1_r29, "users"."unconfirmed_email" AS t1_r30, "users"."hide_no_ssh_key" AS t1_r31, "users"."admin_email_unsubscribed_at" AS t1_r32, "users"."notification_email" AS t1_r33, "users"."hide_no_password" AS t1_r34, "users"."password_automatically_set" AS t1_r35, "users"."encrypted_otp_secret" AS t1_r36, "users"."encrypted_otp_secret_iv" AS t1_r37, "users"."encrypted_otp_secret_salt" AS t1_r38, "users"."otp_required_for_login" AS t1_r39, "users"."otp_backup_codes" AS t1_r40, "users"."public_email" AS t1_r41, "users"."dashboard" AS t1_r42, "users"."project_view" AS t1_r43, "users"."consumed_timestep" AS t1_r44, "users"."layout" AS t1_r45, "users"."hide_project_limit" AS t1_r46, "users"."note" AS t1_r47, "users"."unlock_token" AS t1_r48, "users"."otp_grace_period_started_at" AS t1_r49, "users"."external" AS t1_r50, "users"."incoming_email_token" AS t1_r51, "users"."auditor" AS t1_r52, "users"."require_two_factor_authentication_from_group" AS t1_r53, "users"."two_factor_grace_period" AS t1_r54, "users"."last_activity_on" AS t1_r55, "users"."notified_of_own_activity" AS t1_r56, "users"."preferred_language" AS t1_r57, "users"."email_opted_in" AS t1_r58, "users"."email_opted_in_ip" AS t1_r59, "users"."email_opted_in_source_id" AS t1_r60, "users"."email_opted_in_at" AS t1_r61, "users"."theme_id" AS t1_r62, "users"."accepted_term_id" AS t1_r63, "users"."feed_token" AS t1_r64, "users"."private_profile" AS t1_r65, "users"."roadmap_layout" AS t1_r66, "users"."include_private_contributions" AS t1_r67, "users"."commit_email" AS t1_r68, "users"."group_view" AS t1_r69, "users"."managing_group_id" AS t1_r70, "users"."first_name" AS t1_r71, "users"."last_name" AS t1_r72, "users"."static_object_token" AS t1_r73, "users"."role" AS t1_r74, "users"."user_type" AS t1_r75, "users"."static_object_token_encrypted" AS t1_r76, "users"."otp_secret_expires_at" AS t1_r77, "users"."onboarding_in_progress" AS t1_r78, "routes"."id" AS t2_r0, "routes"."source_id" AS t2_r1, "routes"."source_type" AS t2_r2, "routes"."path" AS t2_r3, "routes"."created_at" AS t2_r4, "routes"."updated_at" AS t2_r5, "routes"."name" AS t2_r6, "routes"."namespace_id" AS t2_r7 FROM "namespaces" LEFT OUTER JOIN "users" ON "users"."id" = "namespaces"."owner_id" LEFT OUTER JOIN "routes" ON "routes"."source_type" = 'Namespace' AND "routes"."source_id" = "namespaces"."id" WHERE ((LOWER(routes.path) = LOWER('namespace59'))) /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/references/user_reference_filter.rb:72:in `block in namespaces'*/
30: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."target_project_id" = 59 AND "merge_requests"."iid" = 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/references/reference_cache.rb:94:in `block in load_records_per_parent'*/
31: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 230 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:149:in `full_attribute'*/
32: SELECT 1 AS one FROM "custom_emoji" WHERE "custom_emoji"."namespace_id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/custom_emoji_filter.rb:52:in `block in has_custom_emoji?'*/
33: UPDATE "internal_ids" SET "last_value" = ("internal_ids"."last_value" + 1) WHERE "internal_ids"."namespace_id" = 231 AND "internal_ids"."usage" = 0 RETURNING "last_value" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/internal_id.rb:164:in `update_record!'*/
34: SELECT "internal_ids"."last_value" FROM "internal_ids" WHERE "internal_ids"."project_id" = 59 AND "internal_ids"."usage" = 0 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:79:in `block in <class:Issue>'*/
35: SELECT MAX("issues"."iid") FROM "issues" WHERE "issues"."namespace_id" = 231 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:80:in `block in <class:Issue>'*/
36: INSERT INTO "internal_ids" ("project_id","namespace_id","usage","last_value") VALUES (NULL, 231, 0, 1) ON CONFLICT DO NOTHING RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/internal_id.rb:178:in `create_record!'*/
37: INSERT INTO "issues" ("title", "author_id", "project_id", "created_at", "updated_at", "description", "iid", "title_html", "description_html", "time_estimate", "cached_markdown_version", "work_item_type_id", "namespace_id", "lock_version") VALUES ('Follow-up from "My title 34"', 171, 59, '2023-08-02 10:21:33.505926', '2023-08-02 10:21:33.505926', 'The following discussion from !1 should be addressed:
- [ ] @namespace59 started a [discussion](http://127.0.0.1:42163/namespace59/project-59/-/merge_requests/1#note_27):
> My title 35', 1, 'Follow-up from "My title 34"', '<p data-sourcepos="1:1-1:53" dir="auto">The following discussion from <a href="/namespace59/project-59/-/merge_requests/1" data-reference-type="merge_request" data-original="!1" data-link="false" data-link-reference="false" data-project="59" data-merge-request="31" data-project-path="namespace59/project-59" data-iid="1" data-container="body" data-placement="top" title="My title 34" class="gfm gfm-merge_request">!1</a> should be addressed:</p>
<ul data-sourcepos="3:1-5:17" class="task-list" dir="auto">
<li data-sourcepos="3:1-5:17" class="task-list-item">
<p data-sourcepos="3:3-3:117"><task-button></task-button><input type="checkbox" class="task-list-item-checkbox" disabled> <a href="/namespace59" data-reference-type="user" data-user="169" data-container="body" data-placement="top" class="gfm gfm-project_member js-user-link" title="Sidney Jones134">@namespace59</a> started a <a href="http://127.0.0.1:42163/namespace59/project-59/-/merge_requests/1#note_27" rel="nofollow noreferrer noopener" target="_blank">discussion</a>:</p>
<blockquote data-sourcepos="5:5-5:17">
<p data-sourcepos="5:7-5:17">My title 35</p>
</blockquote>
</li>
</ul>', 0, 2097152, 1, 231, 0) RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/issuable_base_service.rb:369:in `transaction_create'*/
38: INSERT INTO "issue_user_mentions" ("mentioned_users_ids","mentioned_groups_ids","mentioned_projects_ids","issue_id","note_id") VALUES ('{169}', NULL, NULL, 2, NULL) ON CONFLICT ("issue_id") WHERE (note_id IS NULL) DO UPDATE SET "mentioned_users_ids"=excluded."mentioned_users_ids","mentioned_groups_ids"=excluded."mentioned_groups_ids","mentioned_projects_ids"=excluded."mentioned_projects_ids","note_id"=excluded."note_id" RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/cache_markdown_field.rb:180:in `store_mentions!'*/
39: SELECT 1 AS one FROM "labels" INNER JOIN "label_links" ON "labels"."id" = "label_links"."label_id" INNER JOIN "lists" ON "lists"."label_id" = "labels"."id" WHERE "label_links"."target_id" = 2 AND "label_links"."target_type" = 'Issue' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue/metrics.rb:35:in `issue_assigned_to_list_label?'*/
40: INSERT INTO issue_metrics (issue_id, first_associated_with_milestone_at, first_added_to_board_at, created_at, updated_at)
VALUES (2, NULL, NULL, NOW(), NOW())
ON CONFLICT (issue_id)
DO UPDATE SET
first_associated_with_milestone_at = LEAST(issue_metrics.first_associated_with_milestone_at, EXCLUDED.first_associated_with_milestone_at),
first_added_to_board_at = LEAST(issue_metrics.first_added_to_board_at, EXCLUDED.first_added_to_board_at),
updated_at = NOW()
RETURNING id
/*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue/metrics.rb:29:in `record!'*/
41: RELEASE SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/issuable_base_service.rb:237:in `create'*/
42: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Project' AND "namespaces"."id" = 231 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:796:in `record_create_action'*/
43: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/gitlab/usage_data_counters/issue_activity_unique_counter.rb:222:in `get_params_from_container'*/
44: 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" FROM "projects" WHERE "projects"."project_namespace_id" = 231 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/gitlab/usage_data_counters/issue_activity_unique_counter.rb:222:in `get_params_from_container'*/
45: SELECT "plans".* FROM "plans" WHERE "plans"."name" = 'default' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/plan.rb:17:in `block in default'*/
46: INSERT INTO "issue_search_data" ("project_id","issue_id","search_vector","created_at","updated_at") VALUES (59, 2, setweight(to_tsvector('english', 'Follow-up from "My title 34"'), 'A') || setweight(to_tsvector('english', 'The following discussion from !1 should be addressed:
- [ ] @namespace59 started a [discussion](http://127.0.0.1:42163/namespace59/project-59/-/merge_requests/1#note_27):
> My title 35'), 'B'), CURRENT_TIMESTAMP, CURRENT_TIMESTAMP) ON CONFLICT ("project_id","issue_id") DO UPDATE SET updated_at=(CASE WHEN ("issue_search_data"."search_vector" IS NOT DISTINCT FROM excluded."search_vector") THEN "issue_search_data".updated_at ELSE CURRENT_TIMESTAMP END),"search_vector"=excluded."search_vector" RETURNING "project_id","issue_id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/issue.rb:787:in `persist_pg_full_text_search_vector'*/
47: 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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/issuable_finder/params.rb:108:in `block in project'*/
48: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/issuable_finder.rb:517:in `block in root_group'*/
49: SELECT "merge_requests".* FROM "merge_requests" WHERE (NOT EXISTS (SELECT 1 FROM "banned_users" WHERE (merge_requests.author_id = banned_users.user_id))) AND "merge_requests"."target_project_id" = 59 AND "merge_requests"."iid" = 1 /* allow_cross_joins_across_databases */ LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/finders/concerns/finder_methods.rb:12:in `find_by'*/
50: SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 30 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association'*/
51: SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 30 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/merge_request_diff.rb:339:in `commit_shas'*/
52: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM ((SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest')
UNION ALL
(SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (59, 59) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('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'))) notes WHERE "notes"."type" IN ('DiffNote', 'DiscussionNote') AND "notes"."noteable_type" IN ('MergeRequest', 'DesignManagement::Design') AND "notes"."system" = FALSE ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
53: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 31 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
54: UPDATE "notes" SET "updated_at" = '2023-08-02 10:21:33.769090', "resolved_at" = '2023-08-02 10:21:33.769090', "resolved_by_id" = 171 WHERE "notes"."id" = 27 AND "notes"."type" IN ('DiffNote', 'DiscussionNote') AND "notes"."noteable_type" IN ('MergeRequest', 'DesignManagement::Design') AND "notes"."system" = FALSE AND "notes"."resolved_at" IS NULL /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/resolvable_note.rb:27:in `resolve!'*/
55: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."id" = 27 ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/resolvable_discussion.rb:117:in `update'*/
56: 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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/noteable.rb:183:in `note_etag_key'*/
57: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/config/routes.rb:312:in `block (4 levels) in <top (required)>'*/
58: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 230 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:149:in `full_attribute'*/
59: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 31 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:419:in `noteable'*/
60: SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 30 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association'*/
61: SELECT "merge_request_diff_commits"."sha" FROM "merge_request_diff_commits" WHERE "merge_request_diff_commits"."merge_request_diff_id" = 30 ORDER BY "merge_request_diff_commits"."merge_request_diff_id" ASC, "merge_request_diff_commits"."relative_order" ASC LIMIT 100 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/merge_request_diff.rb:339:in `commit_shas'*/
62: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM ((SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest')
UNION ALL
(SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."system" = FALSE AND "notes"."project_id" IN (59, 59) AND "notes"."noteable_type" = 'Commit' AND "notes"."commit_id" IN ('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'))) notes WHERE "notes"."type" IN ('DiffNote', 'DiscussionNote') AND "notes"."noteable_type" IN ('MergeRequest', 'DesignManagement::Design') AND "notes"."system" = FALSE ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
63: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 31 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/discussion.rb:47:in `group_by'*/
64: SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:123:in `block in <class:Note>'*/
65: 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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:123:in `block in <class:Note>'*/
66: INSERT INTO "notes" ("note", "noteable_type", "author_id", "created_at", "updated_at", "project_id", "noteable_id", "system", "discussion_id", "note_html", "cached_markdown_version") VALUES ('resolved all threads', 'MergeRequest', 171, '2023-08-02 10:21:33.837082', '2023-08-02 10:21:33.851132', 59, 31, TRUE, '6902b6ed20d73436994b3285e3ed90068f74fe1b', '<p data-sourcepos="1:1-1:20" dir="auto">resolved all threads</p>', 2097152) RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/base_service.rb:19:in `create_note'*/
67: INSERT INTO "system_note_metadata" ("action", "created_at", "updated_at", "note_id") VALUES ('discussion', '2023-08-02 10:21:33.869948', '2023-08-02 10:21:33.869948', 28) RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/base_service.rb:19:in `create_note'*/
68: DELETE FROM "merge_request_user_mentions" WHERE "merge_request_user_mentions"."merge_request_id" = 31 AND "merge_request_user_mentions"."note_id" = 28 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/cache_markdown_field.rb:182:in `store_mentions!'*/
69: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/config/routes.rb:312:in `block (4 levels) in <top (required)>'*/
70: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 230 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:149:in `full_attribute'*/
71: RELEASE SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/base_service.rb:19:in `create_note'*/
72: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/ee/app/models/ee/project.rb:679:in `triggered_hooks'*/
73: SELECT "web_hooks".* FROM "web_hooks" WHERE "web_hooks"."type" = 'ProjectHook' AND "web_hooks"."project_id" = 59 AND (recent_failures <= 3 OR (recent_failures > 3 AND (disabled_until IS NOT NULL) AND (disabled_until < '2023-08-02 10:21:33.912281'))) AND "web_hooks"."merge_requests_events" = TRUE AND (recent_failures <= 3 OR (recent_failures > 3 AND (disabled_until IS NOT NULL) AND (disabled_until < '2023-08-02 10:21:33.913103'))) /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/triggerable_hooks.rb:37:in `select_active'*/
74: SELECT "web_hooks".* FROM "web_hooks" WHERE "web_hooks"."type" = 'SystemHook' AND "web_hooks"."merge_requests_events" = TRUE ORDER BY "web_hooks"."id" ASC LIMIT 1000 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_hooks_service.rb:13:in `execute_hooks'*/
75: SELECT "integrations".* FROM "integrations" WHERE "integrations"."project_id" = 59 AND "integrations"."merge_requests_events" = TRUE AND "integrations"."active" = TRUE /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:1864:in `block in execute_integrations'*/
76: SELECT "external_status_checks"."id", "external_status_checks"."project_id", "external_status_checks"."created_at", "external_status_checks"."updated_at", "external_status_checks"."external_url", "external_status_checks"."name" FROM "external_status_checks" WHERE "external_status_checks"."project_id" = 59 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/ee/app/models/ee/project.rb:660:in `execute_external_compliance_hooks'*/
77: SELECT 1 AS one FROM "jira_connect_subscriptions" WHERE "jira_connect_subscriptions"."namespace_id" IN (SELECT "namespaces"."id" FROM "namespaces" WHERE "namespaces"."type" = 'User' AND "namespaces"."id" = 230) LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:2875:in `jira_subscription_exists?'*/
78: SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:419:in `noteable'*/
79: SELECT "merge_requests".* FROM "merge_requests" WHERE "merge_requests"."id" = 31 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:419:in `noteable'*/
80: SELECT "merge_request_diffs".* FROM "merge_request_diffs" WHERE "merge_request_diffs"."id" = 30 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/manual_inverse_association.rb:9:in `block in manual_inverse_association'*/
81: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."discussion_id" = '7a787577cdeb3a296d412028cedd0acc53821bba' ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:254:in `find_discussion'*/
82: 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" FROM "projects" WHERE "projects"."id" = 59 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:123:in `block in <class:Note>'*/
83: SELECT "issues"."id", "issues"."title", "issues"."author_id", "issues"."project_id", "issues"."created_at", "issues"."updated_at", "issues"."description", "issues"."milestone_id", "issues"."iid", "issues"."updated_by_id", "issues"."weight", "issues"."confidential", "issues"."due_date", "issues"."moved_to_id", "issues"."lock_version", "issues"."title_html", "issues"."description_html", "issues"."time_estimate", "issues"."relative_position", "issues"."service_desk_reply_to", "issues"."cached_markdown_version", "issues"."last_edited_at", "issues"."last_edited_by_id", "issues"."discussion_locked", "issues"."closed_at", "issues"."closed_by_id", "issues"."state_id", "issues"."duplicated_to_id", "issues"."promoted_to_epic_id", "issues"."health_status", "issues"."external_key", "issues"."sprint_id", "issues"."blocking_issues_count", "issues"."upvotes_count", "issues"."work_item_type_id", "issues"."namespace_id", "issues"."start_date" FROM "issues" WHERE "issues"."project_id" = 59 AND "issues"."iid" = 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/references/reference_cache.rb:94:in `block in load_records_per_parent'*/
84: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 231 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/references/reference_cache.rb:94:in `block in load_records_per_parent'*/
85: SELECT "work_item_types".* FROM "work_item_types" WHERE "work_item_types"."id" = 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/banzai/filter/references/reference_cache.rb:94:in `block in load_records_per_parent'*/
86: INSERT INTO "notes" ("note", "noteable_type", "author_id", "created_at", "updated_at", "project_id", "line_code", "noteable_id", "system", "type", "position", "original_position", "discussion_id", "note_html", "cached_markdown_version") VALUES ('created #1 to continue this discussion', 'MergeRequest', 171, '2023-08-02 10:21:33.947947', '2023-08-02 10:21:34.060945', 59, '2f6fcd96b88b36ce98c38da085c795a27d92a3dd_15_14', 31, TRUE, 'DiffNote', '--- !ruby/object:Gitlab::Diff::Position
attributes:
:base_sha: ae73cb07c9eeaf35924a10f713b364d32b2dd34f
:start_sha: 0b4bc9a49b562e85de7cc9e834518ea6828729b9
:head_sha: b83d6e391c22777fca1ed3012fce84f633d7fed0
:old_path: files/ruby/popen.rb
:new_path: files/ruby/popen.rb
:position_type: text
:old_line:
:new_line: 14
:line_range:
:ignore_whitespace_change: false
', '--- !ruby/object:Gitlab::Diff::Position
attributes:
:base_sha: ae73cb07c9eeaf35924a10f713b364d32b2dd34f
:start_sha: 0b4bc9a49b562e85de7cc9e834518ea6828729b9
:head_sha: b83d6e391c22777fca1ed3012fce84f633d7fed0
:old_path: files/ruby/popen.rb
:new_path: files/ruby/popen.rb
:position_type: text
:old_line:
:new_line: 14
:line_range:
:ignore_whitespace_change: false
', '7a787577cdeb3a296d412028cedd0acc53821bba', '<p data-sourcepos="1:1-1:38" dir="auto">created <a href="/namespace59/project-59/-/issues/1" data-reference-type="issue" data-original="#1" data-link="false" data-link-reference="false" data-project="59" data-issue="2" data-project-path="namespace59/project-59" data-iid="1" data-issue-type="issue" data-container="body" data-placement="top" title=''Follow-up from "My title 34"'' class="gfm gfm-issue">#1</a> to continue this discussion</p>', 2097152) RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/merge_requests_service.rb:53:in `discussion_continued_in_issue'*/
87: DELETE FROM "merge_request_user_mentions" WHERE "merge_request_user_mentions"."merge_request_id" = 31 AND "merge_request_user_mentions"."note_id" = 29 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/cache_markdown_field.rb:182:in `store_mentions!'*/
88: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/config/routes.rb:312:in `block (4 levels) in <top (required)>'*/
89: SELECT "routes".* FROM "routes" WHERE "routes"."source_id" = 230 AND "routes"."source_type" = 'Namespace' LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/routable.rb:149:in `full_attribute'*/
90: RELEASE SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/merge_requests_service.rb:53:in `discussion_continued_in_issue'*/
91: SELECT "note_diff_files"."id", "note_diff_files"."diff", "note_diff_files"."new_file", "note_diff_files"."renamed_file", "note_diff_files"."deleted_file", "note_diff_files"."a_mode", "note_diff_files"."b_mode", "note_diff_files"."new_path", "note_diff_files"."old_path", "note_diff_files"."diff_note_id" FROM "note_diff_files" WHERE "note_diff_files"."diff_note_id" = 29 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/diff_note.rb:144:in `should_create_diff_file?'*/
92: SELECT "notes"."note", "notes"."noteable_type", "notes"."author_id", "notes"."created_at", "notes"."updated_at", "notes"."project_id", "notes"."attachment", "notes"."line_code", "notes"."commit_id", "notes"."noteable_id", "notes"."system", "notes"."st_diff", "notes"."updated_by_id", "notes"."type", "notes"."position", "notes"."original_position", "notes"."resolved_at", "notes"."resolved_by_id", "notes"."discussion_id", "notes"."note_html", "notes"."cached_markdown_version", "notes"."change_position", "notes"."resolved_by_push", "notes"."review_id", "notes"."confidential", "notes"."last_edited_at", "notes"."internal", "notes"."id", "notes"."namespace_id" FROM "notes" WHERE "notes"."noteable_id" = 31 AND "notes"."noteable_type" = 'MergeRequest' AND "notes"."discussion_id" = '7a787577cdeb3a296d412028cedd0acc53821bba' ORDER BY "notes"."created_at" ASC, "notes"."id" ASC /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/note.rb:254:in `find_discussion'*/
93: SELECT "system_note_metadata"."id", "system_note_metadata"."commit_count", "system_note_metadata"."action", "system_note_metadata"."created_at", "system_note_metadata"."updated_at", "system_note_metadata"."description_version_id", "system_note_metadata"."note_id" FROM "system_note_metadata" WHERE "system_note_metadata"."note_id" = 29 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/system_notes/merge_requests_service.rb:54:in `block in discussion_continued_in_issue'*/
94: SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
95: INSERT INTO "system_note_metadata" ("action", "created_at", "updated_at", "note_id") VALUES ('discussion', '2023-08-02 10:21:34.174868', '2023-08-02 10:21:34.174868', 29) RETURNING "id" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
96: RELEASE SAVEPOINT active_record_1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/lib/gitlab/database.rb:385:in `block in transaction'*/
97: SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 230 LIMIT 1 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/ee/app/models/ee/project.rb:679:in `triggered_hooks'*/
98: SELECT "web_hooks".* FROM "web_hooks" WHERE "web_hooks"."type" = 'ProjectHook' AND "web_hooks"."project_id" = 59 AND (recent_failures <= 3 OR (recent_failures > 3 AND (disabled_until IS NOT NULL) AND (disabled_until < '2023-08-02 10:21:34.209389'))) AND "web_hooks"."issues_events" = TRUE AND (recent_failures <= 3 OR (recent_failures > 3 AND (disabled_until IS NOT NULL) AND (disabled_until < '2023-08-02 10:21:34.210273'))) /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/triggerable_hooks.rb:37:in `select_active'*/
99: SELECT "integrations".* FROM "integrations" WHERE "integrations"."project_id" = 59 AND "integrations"."issues_events" = TRUE AND "integrations"."active" = TRUE /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/project.rb:1864:in `block in execute_integrations'*/
100: SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 2 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/time_trackable.rb:48:in `total_time_spent'*/
101: SELECT SUM("timelogs"."time_spent") FROM "timelogs" WHERE "timelogs"."issue_id" = 2 /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/models/concerns/time_trackable.rb:48:in `total_time_spent'*/
102: SELECT COUNT(*) AS "count_all", "issues"."confidential" AS "issues_confidential" FROM "issues" WHERE ("issues"."state_id" IN (1)) AND "issues"."project_id" = 59 GROUP BY "issues"."confidential" /*application:test,correlation_id:01H6TW8QTGRFWQHWM2RCX1YDE2,endpoint_id:Projects::IssuesController#create,db_config_name:main,line:/app/services/projects/open_issues_count_service.rb:47:in `refresh_cache'*/
Shared Example Group: "creating an issue for a thread" called from ./spec/features/issues/create_issue_for_discussions_in_merge_request_spec.rb:56