Skip to content

Use partition filter for queries on builds and metadata

Marius Bobin requested to merge 423054-partition-filter-ci-builds-metadata into master

What does this MR do and why?

  • it adds a where condition on partition_id to updates and deletes on p_ci_builds and p_ci_builds_metadata triggered from ActiveRecord updates and deletes/destroys
  • it adds a partition_id equals condition to ActiveRecord joins., e.q. Ci::Build.where(name: 'something').joins(:pipeline) produces SELECT "p_ci_builds".* FROM "p_ci_builds" INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = 'Ci::Build' AND "p_ci_builds"."name" = 'something'
  • it preloads the relations using the partition_id of the current records, Ci::Build.limit(5).preload(:pipeline, :metadata) produces:
  Ci::Build Load (3.4ms)  SELECT "p_ci_builds".* FROM "p_ci_builds" WHERE "p_ci_builds"."type" = 'Ci::Build' LIMIT 5 /*application:console,db_config_name:ci,console_hostname:rocket-sled.local,console_username:marius,line:bin/rails:4:in `<main>'*/
  Ci::Pipeline Load (4.4ms)  SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines" WHERE "ci_pipelines"."partition_id" = 100 AND "ci_pipelines"."id" IN (89, 106) /*application:console,db_config_name:ci,console_hostname:rocket-sled.local,console_username:marius,line:bin/rails:4:in `<main>'*/
  Ci::BuildMetadata Load (4.7ms)  SELECT "p_ci_builds_metadata".* FROM "p_ci_builds_metadata" WHERE "p_ci_builds_metadata"."partition_id" = 100 AND "p_ci_builds_metadata"."build_id" IN (490, 491, 1019, 1020, 1022) /*application:console,db_config_name:ci,console_hostname:rocket-sled.local,console_username:marius,line:bin/rails:4:in `<main>'*/

We need to update the queries to use the partition filter because we want to add more partitions and this will improve the performance: https://www.postgresql.org/docs/14/ddl-partitioning.html#DDL-PARTITION-PRUNING

Screenshots or screen recordings

Here is a list of new queries that use partition_id filters:

List of queries
  • DELETE FROM "p_ci_builds" WHERE "p_ci_builds"."id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:4a9813f35ddb1b5518ca152cef8361a0,db_config_name:ci,line:/spec/support/shared_examples/loose_foreign_keys/have_loose_foreign_key.rb:76:in `block (2 levels) in '*/
  • DELETE FROM "p_ci_builds_metadata" WHERE "p_ci_builds_metadata"."id" = $1 AND "p_ci_builds_metadata"."partition_id" = $2 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/ci/metadatable.rb:57:in `block in degenerate!'*/
  • INSERT INTO "ci_pipelines" ("ref", "sha", "created_at", "updated_at", "project_id", "status", "started_at", "source", "iid", "partition_id", "lock_version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING "id" /*application:test,correlation_id:a1a3ef60ff03213c16c8489195f0ae57,db_config_name:ci,line:/lib/gitlab/seeders/ci/runner/runner_fleet_pipeline_seeder.rb:126:in `create_pipeline'*/
  • INSERT INTO "p_ci_builds" ("status", "created_at", "updated_at", "started_at", "runner_id", "commit_id", "name", "ref", "type", "project_id", "queued_at", "retried", "scheduling_type", "partition_id", "lock_version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING "id" /*application:test,correlation_id:a1a3ef60ff03213c16c8489195f0ae57,db_config_name:ci,line::90:in `tap'*/
  • SELECT "ci_build_report_results".* FROM "ci_build_report_results" INNER JOIN "p_ci_builds" ON "ci_build_report_results"."build_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) /*application:test,correlation_id:26b8fe636ce0f51ba0c0744408a34476,endpoint_id:Projects::Pipelines::TestsController#summary,db_config_name:ci,line:/lib/gitlab/ci/reports/test_suite_summary.rb:23:in `total_time'*/
  • SELECT "ci_job_artifacts"."project_id" AS t0_r0, "ci_job_artifacts"."file_type" AS t0_r1, "ci_job_artifacts"."size" AS t0_r2, "ci_job_artifacts"."created_at" AS t0_r3, "ci_job_artifacts"."updated_at" AS t0_r4, "ci_job_artifacts"."expire_at" AS t0_r5, "ci_job_artifacts"."file" AS t0_r6, "ci_job_artifacts"."file_store" AS t0_r7, "ci_job_artifacts"."file_sha256" AS t0_r8, "ci_job_artifacts"."file_format" AS t0_r9, "ci_job_artifacts"."file_location" AS t0_r10, "ci_job_artifacts"."id" AS t0_r11, "ci_job_artifacts"."job_id" AS t0_r12, "ci_job_artifacts"."locked" AS t0_r13, "ci_job_artifacts"."partition_id" AS t0_r14, "ci_job_artifacts"."accessibility" AS t0_r15, "ci_job_artifacts"."file_final_path" AS t0_r16, "jobs_ci_job_artifacts"."status" AS t1_r0, "jobs_ci_job_artifacts"."finished_at" AS t1_r1, "jobs_ci_job_artifacts"."created_at" AS t1_r2, "jobs_ci_job_artifacts"."updated_at" AS t1_r3, "jobs_ci_job_artifacts"."started_at" AS t1_r4, "jobs_ci_job_artifacts"."runner_id" AS t1_r5, "jobs_ci_job_artifacts"."coverage" AS t1_r6, "jobs_ci_job_artifacts"."commit_id" AS t1_r7, "jobs_ci_job_artifacts"."name" AS t1_r8, "jobs_ci_job_artifacts"."options" AS t1_r9, "jobs_ci_job_artifacts"."allow_failure" AS t1_r10, "jobs_ci_job_artifacts"."stage" AS t1_r11, "jobs_ci_job_artifacts"."trigger_request_id" AS t1_r12, "jobs_ci_job_artifacts"."stage_idx" AS t1_r13, "jobs_ci_job_artifacts"."tag" AS t1_r14, "jobs_ci_job_artifacts"."ref" AS t1_r15, "jobs_ci_job_artifacts"."user_id" AS t1_r16, "jobs_ci_job_artifacts"."type" AS t1_r17, "jobs_ci_job_artifacts"."target_url" AS t1_r18, "jobs_ci_job_artifacts"."description" AS t1_r19, "jobs_ci_job_artifacts"."project_id" AS t1_r20, "jobs_ci_job_artifacts"."erased_by_id" AS t1_r21, "jobs_ci_job_artifacts"."erased_at" AS t1_r22, "jobs_ci_job_artifacts"."artifacts_expire_at" AS t1_r23, "jobs_ci_job_artifacts"."environment" AS t1_r24, "jobs_ci_job_artifacts"."when" AS t1_r25, "jobs_ci_job_artifacts"."yaml_variables" AS t1_r26, "jobs_ci_job_artifacts"."queued_at" AS t1_r27, "jobs_ci_job_artifacts"."lock_version" AS t1_r28, "jobs_ci_job_artifacts"."coverage_regex" AS t1_r29, "jobs_ci_job_artifacts"."auto_canceled_by_id" AS t1_r30, "jobs_ci_job_artifacts"."retried" AS t1_r31, "jobs_ci_job_artifacts"."protected" AS t1_r32, "jobs_ci_job_artifacts"."failure_reason" AS t1_r33, "jobs_ci_job_artifacts"."scheduled_at" AS t1_r34, "jobs_ci_job_artifacts"."token_encrypted" AS t1_r35, "jobs_ci_job_artifacts"."upstream_pipeline_id" AS t1_r36, "jobs_ci_job_artifacts"."resource_group_id" AS t1_r37, "jobs_ci_job_artifacts"."waiting_for_resource_at" AS t1_r38, "jobs_ci_job_artifacts"."processed" AS t1_r39, "jobs_ci_job_artifacts"."scheduling_type" AS t1_r40, "jobs_ci_job_artifacts"."id" AS t1_r41, "jobs_ci_job_artifacts"."stage_id" AS t1_r42, "jobs_ci_job_artifacts"."partition_id" AS t1_r43, "jobs_ci_job_artifacts"."auto_canceled_by_partition_id" AS t1_r44 FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" INNER JOIN "p_ci_builds" "jobs_ci_job_artifacts" ON "jobs_ci_job_artifacts"."id" = "ci_job_artifacts"."job_id" AND "jobs_ci_job_artifacts"."type" = $1 WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (expire_at IS NULL OR expire_at > $6 OR EXISTS (SELECT $7 FROM "ci_pipelines" WHERE "ci_pipelines"."locked" = $8 AND ("ci_pipelines".id = "p_ci_builds".commit_id))) AND "ci_job_artifacts"."file_type" IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30) /*application:test,correlation_id:7a2d92c79a5affa2998139a2fed4b2d0,endpoint_id:Projects::PipelinesController#downloadable_artifacts,db_config_name:ci,line:/app/serializers/ci/downloadable_artifact_entity.rb:11:in `block in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:16fda38a987db07586c912087e8a0c25,db_config_name:ci,line:/spec/controllers/projects/pipelines/tests_controller_spec.rb:60:in `block (5 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "ci_job_artifacts"."file_type" = $4 ORDER BY "ci_job_artifacts"."id" DESC LIMIT $5 /*application:test,correlation_id:6a2cb9e1d293666af3044b1ff5390b87,db_config_name:ci,line:/spec/factories/ci/reports/security/reports.rb:26:in `block (4 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "ci_job_artifacts"."id" ASC LIMIT $4 /*application:test,correlation_id:9cb19c0cd64bc29de1d05e4ca4c686a8,db_config_name:ci,line:/spec/controllers/projects/pipelines/tests_controller_spec.rb:45:in `block (5 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "ci_job_artifacts"."id" DESC LIMIT $4 /*application:test,correlation_id:76f9e6a5bdc0aed7d71b43801cd5eb9f,db_config_name:ci,line:/ee/spec/lib/gitlab/ci/parsers/security/dependency_list_spec.rb:14:in `block (3 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "p_ci_builds"."id" = "ci_job_artifacts"."job_id" AND "p_ci_builds"."type" = $1 INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "ci_pipelines"."locked" = $2 /*application:test,correlation_id:3ac8d384eb43d67e13f0dc29f8fade1c,db_config_name:ci,line:/spec/models/ci/job_artifact_spec.rb:364:in `block (4 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "p_ci_builds"."id" = "ci_job_artifacts"."job_id" AND "p_ci_builds"."type" = $1 INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "ci_pipelines"."sha" = $2 AND "ci_pipelines"."project_id" = $3 /*application:test,correlation_id:3bf52b99550d7e258cf2d04115fdbaba,db_config_name:ci,line:/spec/models/ci/job_artifact_spec.rb:329:in `block (3 levels) in '*/
  • SELECT "ci_job_artifacts".* FROM "ci_job_artifacts" WHERE "ci_job_artifacts"."id" IN (SELECT max(ci_job_artifacts.id) as id FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "ci_job_artifacts"."file_type" IN ($4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30) GROUP BY "ci_job_artifacts"."file_type") /*application:test,correlation_id:bffe78e11718fc798fe64b65f5d179ab,db_config_name:ci,line:/app/models/ci/pipeline.rb:773:in `group_by'*/
  • SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines" WHERE "ci_pipelines"."id" = $1 AND "ci_pipelines"."partition_id" = $2 LIMIT $3 /*application:test,correlation_id:cd88a1ed-94a3-4454-a909-9bded34674ba,endpoint_id:PUT /api/:version/jobs/:id,db_config_name:ci,line:/ee/app/services/ci/minutes/track_live_consumption_service.rb:88:in `consumption_since_last_update'*/
  • SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines" WHERE "ci_pipelines"."id" = $1 AND (NOT EXISTS (SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $2 AND ("p_ci_builds".commit_id = "ci_pipelines".id) AND ("p_ci_builds"."status" IN ($3,$4,$5)) AND "p_ci_builds_metadata"."id" NOT IN (SELECT "p_ci_builds_metadata"."id" FROM "p_ci_builds_metadata" WHERE ("p_ci_builds_metadata".build_id = "p_ci_builds".id) AND "p_ci_builds_metadata"."interruptible" = $6))) /*application:test,correlation_id:2afe18d4a6cdd477c9e163da7d516a76,endpoint_id:Ci::CancelRedundantPipelinesWorker,db_config_name:ci,line:/app/services/ci/pipeline_creation/cancel_redundant_pipelines_service.rb:78:in `auto_cancel_interruptible_pipelines'*/
  • SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines" WHERE "ci_pipelines"."partition_id" = $1 AND "ci_pipelines"."id" = $2 /*application:test,correlation_id:0d74e710903b1cd27550b5dd7118e858,endpoint_id:Projects::Security::ScannedResourcesController#index,db_config_name:ci,line:/app/models/ci/pipeline.rb:1342:in `block in security_reports'*/
  • SELECT "ci_sources_pipelines"."id", "ci_sources_pipelines"."project_id", "ci_sources_pipelines"."source_project_id", "ci_sources_pipelines"."source_job_id", "ci_sources_pipelines"."partition_id", "ci_sources_pipelines"."source_partition_id", "ci_sources_pipelines"."pipeline_id", "ci_sources_pipelines"."source_pipeline_id" FROM "ci_sources_pipelines" ORDER BY "ci_sources_pipelines"."id" DESC LIMIT $1 /*application:test,correlation_id:c491e4c44555dae11ea3522bb40b4c0e,db_config_name:ci,line:/ee/spec/requests/api/ci/triggers_spec.rb:72:in `block (6 levels) in '*/
  • SELECT "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."status" IN ($3)) /*application:test,correlation_id:739b9f2d761a3b3bb2ed33331383d57c,db_config_name:ci,line:/spec/services/ci/cancel_pipeline_service_spec.rb:72:in `block (5 levels) in '*/
  • SELECT "p_ci_builds"."id" FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) /*application:test,db_config_name:ci,line:/spec/requests/api/graphql/project/pipeline_spec.rb:299:in `block (3 levels) in '*/
  • SELECT "p_ci_builds"."id", "p_ci_builds"."name", "p_ci_builds"."status", "p_ci_builds"."allow_failure", "p_ci_builds"."stage_idx", "p_ci_builds"."processed", "p_ci_builds"."lock_version" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."stage_idx" ASC /*application:test,correlation_id:0e449e925cd46c1b82f6a1dc3dd754c3,endpoint_id:PipelineProcessWorker,db_config_name:ci,line:/app/services/ci/pipeline_processing/atomic_processing_service/status_collection.rb:119:in `block in all_jobs'*/
  • SELECT "p_ci_builds"."name" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" NOT IN ($3, $4) ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC /*application:test,correlation_id:475c7ef51e4cce0c742080b1848fb769,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:1383:in `builds_names'*/
  • SELECT "p_ci_builds"."name" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:51f0b778d900ebaef033893d3d86ad61,db_config_name:ci,line:/ee/spec/lib/gitlab/ci/templates/Jobs/browser_performance_testing_gitlab_ci_yaml_spec.rb:34:in `block (3 levels) in '*/
  • SELECT "p_ci_builds"."name" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."stage_id" ASC /*application:test,correlation_id:2fa395413567b17b70be4a3f0ca3c479,db_config_name:ci,line:/spec/services/ci/create_pipeline_service_spec.rb:1634:in `block (6 levels) in '*/
  • SELECT "p_ci_builds"."name", "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:0f7f5a4267fc1f3adc0f11c520e96ea4,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:50:in `current_state'*/
  • SELECT "p_ci_builds"."name", "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) ORDER BY "p_ci_builds"."name" ASC /*application:test,correlation_id:7bf4b05746ee0c228ad3c24734ea2600,db_config_name:ci,line:/spec/services/ci/reset_skipped_jobs_service_spec.rb:416:in `check_jobs_statuses'*/
  • SELECT "p_ci_builds"."name", "p_ci_builds_metadata".interruptible FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:58648d7270f11dbb16dc7a4c21b2cc63,db_config_name:ci,line:/spec/services/ci/create_pipeline_service_spec.rb:296:in `block (6 levels) in '*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 /*application:test,correlation_id:f515ed889b5f1e86900809658e7a55b4,db_config_name:ci,line:/spec/models/ci/build_spec.rb:5197:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."id" = $5 /*application:test,correlation_id:a23c6458-1c7f-4574-ba9a-55a8ef30c3e0,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/graphql/resolvers/ci/test_suite_resolver.rb:19:in `resolve'*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."retried" = $3 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."commit_id" = $4 /*application:test,correlation_id:167355fd578dfb508a343e22364c34c0,db_config_name:ci,line:/lib/gitlab/data_builder/pipeline.rb:60:in `preload_builds'*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($7)) /*application:test,correlation_id:4bb33c6b-20d7-4e96-b830-b2b776ff865a,endpoint_id:Projects::EnvironmentsController#show,db_config_name:ci,line:/app/models/deployment.rb:188:in `last_deployment_group_for_environment'*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15, "ci_job_artifacts"."project_id" AS t2_r0, "ci_job_artifacts"."file_type" AS t2_r1, "ci_job_artifacts"."size" AS t2_r2, "ci_job_artifacts"."created_at" AS t2_r3, "ci_job_artifacts"."updated_at" AS t2_r4, "ci_job_artifacts"."expire_at" AS t2_r5, "ci_job_artifacts"."file" AS t2_r6, "ci_job_artifacts"."file_store" AS t2_r7, "ci_job_artifacts"."file_sha256" AS t2_r8, "ci_job_artifacts"."file_format" AS t2_r9, "ci_job_artifacts"."file_location" AS t2_r10, "ci_job_artifacts"."id" AS t2_r11, "ci_job_artifacts"."job_id" AS t2_r12, "ci_job_artifacts"."locked" AS t2_r13, "ci_job_artifacts"."partition_id" AS t2_r14, "ci_job_artifacts"."accessibility" AS t2_r15, "ci_job_artifacts"."file_final_path" AS t2_r16 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" LEFT OUTER JOIN "ci_job_artifacts" ON "ci_job_artifacts"."file_type" = $1 AND "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds_metadata"."has_exposed_artifacts" = $6 ORDER BY "p_ci_builds"."id" ASC LIMIT $7 /*application:test,correlation_id:d158c86c51dc975d8ac7f668287829e3,db_config_name:ci,line:/app/services/ci/find_exposed_artifacts_service.rb:18:in `for_pipeline'*/
  • SELECT "p_ci_builds"."status" AS t0_r0, "p_ci_builds"."finished_at" AS t0_r1, "p_ci_builds"."created_at" AS t0_r2, "p_ci_builds"."updated_at" AS t0_r3, "p_ci_builds"."started_at" AS t0_r4, "p_ci_builds"."runner_id" AS t0_r5, "p_ci_builds"."coverage" AS t0_r6, "p_ci_builds"."commit_id" AS t0_r7, "p_ci_builds"."name" AS t0_r8, "p_ci_builds"."options" AS t0_r9, "p_ci_builds"."allow_failure" AS t0_r10, "p_ci_builds"."stage" AS t0_r11, "p_ci_builds"."trigger_request_id" AS t0_r12, "p_ci_builds"."stage_idx" AS t0_r13, "p_ci_builds"."tag" AS t0_r14, "p_ci_builds"."ref" AS t0_r15, "p_ci_builds"."user_id" AS t0_r16, "p_ci_builds"."type" AS t0_r17, "p_ci_builds"."target_url" AS t0_r18, "p_ci_builds"."description" AS t0_r19, "p_ci_builds"."project_id" AS t0_r20, "p_ci_builds"."erased_by_id" AS t0_r21, "p_ci_builds"."erased_at" AS t0_r22, "p_ci_builds"."artifacts_expire_at" AS t0_r23, "p_ci_builds"."environment" AS t0_r24, "p_ci_builds"."when" AS t0_r25, "p_ci_builds"."yaml_variables" AS t0_r26, "p_ci_builds"."queued_at" AS t0_r27, "p_ci_builds"."lock_version" AS t0_r28, "p_ci_builds"."coverage_regex" AS t0_r29, "p_ci_builds"."auto_canceled_by_id" AS t0_r30, "p_ci_builds"."retried" AS t0_r31, "p_ci_builds"."protected" AS t0_r32, "p_ci_builds"."failure_reason" AS t0_r33, "p_ci_builds"."scheduled_at" AS t0_r34, "p_ci_builds"."token_encrypted" AS t0_r35, "p_ci_builds"."upstream_pipeline_id" AS t0_r36, "p_ci_builds"."resource_group_id" AS t0_r37, "p_ci_builds"."waiting_for_resource_at" AS t0_r38, "p_ci_builds"."processed" AS t0_r39, "p_ci_builds"."scheduling_type" AS t0_r40, "p_ci_builds"."id" AS t0_r41, "p_ci_builds"."stage_id" AS t0_r42, "p_ci_builds"."partition_id" AS t0_r43, "p_ci_builds"."auto_canceled_by_partition_id" AS t0_r44, "p_ci_builds_metadata"."project_id" AS t1_r0, "p_ci_builds_metadata"."timeout" AS t1_r1, "p_ci_builds_metadata"."timeout_source" AS t1_r2, "p_ci_builds_metadata"."interruptible" AS t1_r3, "p_ci_builds_metadata"."config_options" AS t1_r4, "p_ci_builds_metadata"."config_variables" AS t1_r5, "p_ci_builds_metadata"."has_exposed_artifacts" AS t1_r6, "p_ci_builds_metadata"."environment_auto_stop_in" AS t1_r7, "p_ci_builds_metadata"."expanded_environment_name" AS t1_r8, "p_ci_builds_metadata"."secrets" AS t1_r9, "p_ci_builds_metadata"."build_id" AS t1_r10, "p_ci_builds_metadata"."id" AS t1_r11, "p_ci_builds_metadata"."runtime_runner_features" AS t1_r12, "p_ci_builds_metadata"."id_tokens" AS t1_r13, "p_ci_builds_metadata"."partition_id" AS t1_r14, "p_ci_builds_metadata"."debug_trace_enabled" AS t1_r15, "ci_job_artifacts"."project_id" AS t2_r0, "ci_job_artifacts"."file_type" AS t2_r1, "ci_job_artifacts"."size" AS t2_r2, "ci_job_artifacts"."created_at" AS t2_r3, "ci_job_artifacts"."updated_at" AS t2_r4, "ci_job_artifacts"."expire_at" AS t2_r5, "ci_job_artifacts"."file" AS t2_r6, "ci_job_artifacts"."file_store" AS t2_r7, "ci_job_artifacts"."file_sha256" AS t2_r8, "ci_job_artifacts"."file_format" AS t2_r9, "ci_job_artifacts"."file_location" AS t2_r10, "ci_job_artifacts"."id" AS t2_r11, "ci_job_artifacts"."job_id" AS t2_r12, "ci_job_artifacts"."locked" AS t2_r13, "ci_job_artifacts"."partition_id" AS t2_r14, "ci_job_artifacts"."accessibility" AS t2_r15, "ci_job_artifacts"."file_final_path" AS t2_r16 FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" LEFT OUTER JOIN "ci_job_artifacts" ON "ci_job_artifacts"."file_type" = $1 AND "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds_metadata"."has_exposed_artifacts" = $3 /*application:test,correlation_id:6d84b7fd6feb0540c2c5e5b0938f8aec,db_config_name:ci,line:/spec/models/ci/build_spec.rb:341:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:00850da7020c65041edc592c34bc6ee9,db_config_name:ci,line:/spec/services/ci/cancel_pipeline_service_spec.rb:58:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC /*application:test,correlation_id:fa747bab8cc9c111881f14d4a591cdf4,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:1407:in `all_builds_statuses'*/
  • SELECT "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:c50404adaefc530d1f645b1bfcae81af,db_config_name:ci,line:/spec/models/ci/pipeline_spec.rb:3123:in `block (3 levels) in '*/
  • SELECT "p_ci_builds"."status" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:874dc6512b492396f3eb9c0113a1207d,db_config_name:ci,line:/spec/workers/ci/cancel_redundant_pipelines_worker_spec.rb:49:in `block (5 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."allow_failure" FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."retried" = $3 OR "p_ci_builds"."retried" IS NULL) /*application:test,correlation_id:d100ec5d6d76b4e3c249894b3380236b,db_config_name:ci,line:/lib/gitlab/ci/status/composite.rb:112:in `consume_all_jobs'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "ci_job_artifacts" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND "ci_job_artifacts"."file_type" = $5 ORDER BY "p_ci_builds"."id" DESC LIMIT $6 /*application:test,correlation_id:7d60a41d579fb76f417e76f243446d98,endpoint_id:Projects::LicensesController#index,db_config_name:ci,line:/ee/lib/gitlab/license_scanning/sbom_scanner.rb:56:in `latest_build_for_default_branch'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."id" = $1 LIMIT $2 /*application:test,correlation_id:23f159dc58b09541dc3bad6aa35dabc7,db_config_name:ci,line:/app/workers/ci/merge_requests/add_todo_when_build_fails_worker.rb:17:in `perform'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 ORDER BY "p_ci_builds"."id" DESC LIMIT $2 /*application:test,correlation_id:87a14de3a87c118e666d4a0823e49bab,db_config_name:ci,line:/spec/support_specs/database/prevent_cross_joins_spec.rb:95:in `ci_only_query'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "ci_runners" ON "ci_runners"."id" = "p_ci_builds"."runner_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."status" IN ($4,$5,$6,$7)) AND "ci_runners"."runner_type" = $8 /*application:test,correlation_id:ae5382ff-25e4-4f39-81bb-26b38d53f197,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/ee/lib/gitlab/ci/minutes/pipeline_consumption.rb:33:in `group_by'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds_metadata".config_options -> $4 -> $5 ?| array[$6,$7]) ORDER BY "p_ci_builds"."id" DESC LIMIT $8 /*application:test,correlation_id:01HE5FMXSDZSP126GN1VTBN5Z8,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:122:in `block in limited_nodes'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds_metadata".config_options -> $4 -> $5 ?| array[$6]) /*application:test,correlation_id:651dd7cc15466f783e8e1b5c7101ce56,endpoint_id:Projects::Security::ConfigurationController#show,db_config_name:ci,line:/app/models/concerns/security/latest_pipeline_information.rb:24:in `latest_security_builds'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."name" = $3 AND "p_ci_builds"."status" = $4 LIMIT $5 /*application:test,correlation_id:531daf3bcea01d3476edf5f840d083eb,db_config_name:ci,line:/spec/services/ci/retry_pipeline_service_spec.rb:106:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."name" = $3 ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC LIMIT $4 /*application:test,correlation_id:dfc78ffe36503da29ccfb81abb77da10,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:977:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" IN ($3, $4, $5, $6, $7, $8, $9) ORDER BY "p_ci_builds"."id" ASC LIMIT $10 /*application:test,correlation_id:d100ec5d6d76b4e3c249894b3380236b,db_config_name:ci,line:/app/services/ci/drop_pipeline_service.rb:20:in `block in execute'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" NOT IN ($3, $4) AND ("p_ci_builds"."status" IN ($5)) AND "p_ci_builds"."name" = $6 ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC LIMIT $7 /*application:test,correlation_id:9429b0ca17942d4a7fd1c05e581841f9,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:1439:in `enqueue_scheduled'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" NOT IN ($3, $4) AND ("p_ci_builds"."status" IN ($5)) ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC /*application:test,correlation_id:d03531a06c77d49a3d145a99615db787,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:886:in `block (5 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" NOT IN ($3, $4) ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC LIMIT $5 /*application:test,correlation_id:5eae2c7e5f49b55c6ea6d9f642bb506e,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:551:in `block (5 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."type" = $3 ORDER BY "p_ci_builds"."id" DESC LIMIT $4 /*application:test,correlation_id:55e829de6b01a5b110897d7a6bedd58c,db_config_name:ci,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:122:in `block in limited_nodes'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."when" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) ORDER BY "p_ci_builds"."id" DESC LIMIT $5 /*application:test,correlation_id:01HE5F34BAYQTA5HRPEPGCMNY2,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:122:in `block in limited_nodes'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."when" = $3 ORDER BY "p_ci_builds"."id" DESC LIMIT $4 /*application:test,correlation_id:d30c44448b364dbc934bcd31f1b179c2,db_config_name:ci,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:122:in `block in limited_nodes'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."retried" = $3 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."stage_id" = $4 /*application:test,correlation_id:01HE5F37H564QJ608GFNDVWT2Q,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/models/preloaders/commit_status_preloader.rb:23:in `objects'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."status" IN ($3)) ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC /*application:test,correlation_id:db4d5cf1d6155c5a2c6d0456b44e3327,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:927:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 ORDER BY "p_ci_builds"."id" ASC LIMIT $3 /*application:test,correlation_id:c391a8890de90e030a2172cce88e1314,db_config_name:ci,line:/spec/support/shared_examples/ci/create_pipeline_service_environment_shared_examples.rb:162:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 ORDER BY "p_ci_builds"."id" DESC LIMIT $3 /*application:test,correlation_id:01HE5EE4WET5EDYXPHGB4VDTF4,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:122:in `block in limited_nodes'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 ORDER BY "p_ci_builds"."stage_idx" ASC, "p_ci_builds"."id" ASC /*application:test,correlation_id:a871a1e1e34f909b6fd0de313145e55b,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:1393:in `each_with_object'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:57ad270a-7933-4987-9146-bf6329050c07,endpoint_id:POST /api/:version/projects/:id/(ref/:ref/)trigger/pipeline,db_config_name:ci,line:/app/models/ci/pipeline.rb:734:in `map'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."name" = $4 /*application:test,correlation_id:a8b7272a78a952718b6d2971e28232de,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:63:in `event_on_jobs'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."name" = $4 LIMIT $5 /*application:test,correlation_id:6e176df2-afd5-4216-8b22-1bfeb2aa97b7,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/graphql/types/ci/pipeline_type.rb:229:in `job'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND ("p_ci_builds"."retried" = $2 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."status" IN ($4)) /*application:test,correlation_id:0b15b01c37a364a428c871a819ac28f9,db_config_name:ci,line:/app/views/notify/pipeline_failed_email.text.erb:35:in `_app_views_notify_pipeline_failed_email_text_erb___2928960390813054601_650431800'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."partition_id" = $1 AND "p_ci_builds"."commit_id" IN ($2, $3) /*application:test,correlation_id:b2d9b839c26dec8b041a07866b3fb5d7,db_config_name:ci,line:/app/graphql/resolvers/project_pipeline_resolver.rb:34:in `block in resolve'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:f010b0f8de2a09faa5a75f4d91f42f54,db_config_name:ci,line:/lib/gitlab/ci/pipeline/chain/create.rb:36:in `flat_map'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."retried" = $3 ORDER BY "p_ci_builds"."name" ASC, "p_ci_builds"."id" DESC /*application:test,correlation_id:01HE5F16FNVS7MB0FWHDPDDB1V,endpoint_id:Projects::PipelinesController#stage,db_config_name:ci,line:/app/models/preloaders/commit_status_preloader.rb:23:in `objects'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."retried" = $3 OR "p_ci_builds"."retried" IS NULL) ORDER BY "p_ci_builds"."name" ASC /*application:test,correlation_id:675a3ebf5b9f4a2d57caf20ef395a4ab,db_config_name:ci,line:/app/models/ci/group.rb:73:in `sort_by'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."id" = $4 /*application:test,correlation_id:c4362c24d7be03cf49dc3a2da4b12920,db_config_name:ci,line:/ee/app/services/ci/pipeline_creation/drop_not_runnable_builds_service.rb:45:in `drop_all_builds'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."name" = $4 LIMIT $5 /*application:test,correlation_id:4f1b08f2c1c764c0e4a50e6bc7c346ed,db_config_name:ci,line:/ee/spec/services/ci/process_pipeline_service_spec.rb:64:in `update_build_status'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."coverage" IS NOT NULL /*application:test,correlation_id:01HE5EQPEHB60QXJ649E2T8T10,endpoint_id:Projects::MergeRequests::ContentController#widget,db_config_name:ci,line:/app/serializers/base_serializer.rb:16:in `represent'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."when" = $5 AND "p_ci_builds"."status" IN ($6, $7, $8, $9, $10) /*application:test,correlation_id:5c85dcef4aa34cbe0a9e33295372859a,endpoint_id:OperationsController#index,db_config_name:ci,line:/app/models/ci/build.rb:392:in `reject'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($5)) /*application:test,correlation_id:5fff67f68475486e1430bbaa287adf71,endpoint_id:Projects::PipelinesController#failures,db_config_name:ci,line:/app/controllers/projects/pipelines_controller.rb:152:in `failures'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($5)) ORDER BY "p_ci_builds"."id" DESC LIMIT $7 OFFSET $6 /*application:test,correlation_id:33c061b0-0252-4e2d-ab34-e76a0cde60b1,endpoint_id:GET /api/:version/projects/:id/pipelines/:pipeline_id/jobs,db_config_name:ci,line:/lib/api/ci/pipelines.rb:188:in `block (2 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" = $6)) /*application:test,correlation_id:6dc7cb04-b40c-4ba7-830e-f37b75e67e59,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/models/ci/pipeline.rb:1157:in `block in codequality_reports'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" = $6)) AND ("p_ci_builds"."status" IN ($7)) LIMIT $8 /*application:test,correlation_id:88f171fe30b97418c46ac392df0cf43b,db_config_name:ci,line:/app/services/ci/test_failure_history_service.rb:41:in `should_track_failures?'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" = $6)) ORDER BY "p_ci_builds"."id" ASC LIMIT $7 /*application:test,correlation_id:dbbf942d-008c-49b7-822a-12b310bf9985,endpoint_id:GET /api/:version/projects/:id/pipelines/:pipeline_id/test_report,db_config_name:ci,line:/app/models/ci/pipeline.rb:1141:in `block in test_reports'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" IN ($6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27))) AND "p_ci_builds"."name" = $28 LIMIT $29 /*application:test,correlation_id:47b7486c9bda093769ba47823309d9d5,db_config_name:ci,line:/app/models/ci/pipeline.rb:1079:in `find_job_with_archive_artifacts'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" IN ($6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27))) AND "p_ci_builds"."name" IS NULL LIMIT $28 /*application:test,correlation_id:951811c978dd6c59e20d00fe2081c2ed,db_config_name:ci,line:/app/models/ci/pipeline.rb:1079:in `find_job_with_archive_artifacts'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $5 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" IN ($6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27))) AND (artifacts_expire_at IS NULL OR artifacts_expire_at > $28) /*application:test,correlation_id:8b5ae1ecfd3e71d470dbfdb67389d973,endpoint_id:Projects::BranchesController#index,db_config_name:ci,line:/app/models/ci/pipeline.rb:1086:in `latest_builds_with_artifacts'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) ORDER BY "p_ci_builds"."id" DESC /*application:test,correlation_id:31ee720ef6f9e608fce0eefc354367c9,db_config_name:ci,line:/spec/finders/ci/jobs_finder_spec.rb:248:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."id" ASC LIMIT $4 /*application:test,correlation_id:bb60a6924fa00b9db8a9b1c15a279aa6,db_config_name:ci,line:/spec/models/ci/group_spec.rb:104:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."id" DESC /*application:test,correlation_id:8f199ad6803eb20c06a4ccaa1c41387f,db_config_name:ci,line:/spec/finders/ci/jobs_finder_spec.rb:263:in `block (5 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."stage_id" ASC /*application:test,correlation_id:4d390468cc721994c105803ebe49464c,db_config_name:ci,line:/spec/services/ci/create_pipeline_service_spec.rb:1226:in `map'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" IN ($2, $3, $4) AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($6)) AND "p_ci_builds"."ref" = $7 AND "p_ci_builds"."name" = $8 /*application:test,correlation_id:97ed38773888818648a3dd77b3d0c421,db_config_name:ci,line:/lib/gitlab/ci/badge/coverage/report.rb:68:in `max_by'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."commit_id" = $3 /*application:test,correlation_id:7e607b7e628ee80b80a48d41fc09a1d7,endpoint_id:Projects::PipelinesController#security,db_config_name:ci,line:/app/controllers/projects/pipelines_controller.rb:279:in `pipeline'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."partition_id" = $2 AND ("p_ci_builds"."status" IN ($3)) AND "p_ci_builds"."commit_id" = $4 /*application:test,correlation_id:8c09705cc34e2b50ae7c1d2fd768af2b,endpoint_id:Projects::MergeRequests::CreationsController#pipelines,db_config_name:ci,line:/app/serializers/base_serializer.rb:15:in `represent'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."stage_id" = $2 AND "p_ci_builds"."partition_id" = $3 ORDER BY "p_ci_builds"."id" ASC LIMIT $4 /*application:test,correlation_id:b3b44519b8aada920954b8bb9dc371d2,db_config_name:ci,line:/spec/lib/bulk_imports/projects/pipelines/ci_pipelines_pipeline_spec.rb:129:in `block (4 levels) in '*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."upstream_pipeline_id" = $2 /*application:test,correlation_id:1d8f7939ed21c06d98060534d8928803,db_config_name:ci,line:/ee/app/services/ee/ci/pipeline_bridge_status_service.rb:10:in `execute'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."name" = $7 LIMIT $8 /*application:test,correlation_id:7ab34164c12a02c2ee82cec1d552583b,db_config_name:ci,line:/spec/services/ci/reset_skipped_jobs_service_spec.rb:412:in `find_job'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($7)) ORDER BY "p_ci_builds"."id" ASC LIMIT $8 /*application:test,correlation_id:57d5f03c02841b29312447b925562151,db_config_name:ci,line:/app/services/ci/retry_pipeline_service.rb:19:in `execute'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."stage_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."status" IN ($6)) /*application:test,correlation_id:b7b3c6abbd088099250b85d873b97fe5,db_config_name:ci,line:/app/services/ci/play_manual_stage_service.rb:12:in `execute'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM ((SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."id" IN (SELECT max("p_ci_builds".id) as id FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND ("p_ci_builds"."retried" = $3 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($4)) AND "p_ci_builds"."name" = $5 AND "p_ci_builds"."ref" = $6 AND "p_ci_builds"."project_id" = $7))) p_ci_builds WHERE "p_ci_builds"."type" = $8 LIMIT $9 /*application:test,correlation_id:225d7b261652759121e8c2c16031254f,db_config_name:ci,line:/ee/app/models/ee/ci/build_dependencies.rb:32:in `fetch_cross_project'*/
  • SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM ((WITH RECURSIVE "base_and_descendants" AS ((SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."id" = $4) UNION (SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds", "base_and_descendants", "ci_build_needs" WHERE "p_ci_builds"."type" IN ($5, $6, $7) AND "ci_build_needs"."build_id" = "p_ci_builds"."id" AND "ci_build_needs"."name" = "base_and_descendants"."name" AND "p_ci_builds"."commit_id" = "base_and_descendants"."commit_id")) SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "base_and_descendants" AS "p_ci_builds") UNION (SELECT "p_ci_builds"."status", "p_ci_builds"."finished_at", "p_ci_builds"."created_at", "p_ci_builds"."updated_at", "p_ci_builds"."started_at", "p_ci_builds"."runner_id", "p_ci_builds"."coverage", "p_ci_builds"."commit_id", "p_ci_builds"."name", "p_ci_builds"."options", "p_ci_builds"."allow_failure", "p_ci_builds"."stage", "p_ci_builds"."trigger_request_id", "p_ci_builds"."stage_idx", "p_ci_builds"."tag", "p_ci_builds"."ref", "p_ci_builds"."user_id", "p_ci_builds"."type", "p_ci_builds"."target_url", "p_ci_builds"."description", "p_ci_builds"."project_id", "p_ci_builds"."erased_by_id", "p_ci_builds"."erased_at", "p_ci_builds"."artifacts_expire_at", "p_ci_builds"."environment", "p_ci_builds"."when", "p_ci_builds"."yaml_variables", "p_ci_builds"."queued_at", "p_ci_builds"."lock_version", "p_ci_builds"."coverage_regex", "p_ci_builds"."auto_canceled_by_id", "p_ci_builds"."retried", "p_ci_builds"."protected", "p_ci_builds"."failure_reason", "p_ci_builds"."scheduled_at", "p_ci_builds"."token_encrypted", "p_ci_builds"."upstream_pipeline_id", "p_ci_builds"."resource_group_id", "p_ci_builds"."waiting_for_resource_at", "p_ci_builds"."processed", "p_ci_builds"."scheduling_type", "p_ci_builds"."id", "p_ci_builds"."stage_id", "p_ci_builds"."partition_id", "p_ci_builds"."auto_canceled_by_partition_id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($8, $9, $10) AND "p_ci_builds"."commit_id" = $11 AND "p_ci_builds"."partition_id" = $12 AND (stage_idx > $13))) p_ci_builds WHERE "p_ci_builds"."type" IN ($14, $15, $16) AND "p_ci_builds"."commit_id" = $17 AND "p_ci_builds"."partition_id" = $18 AND ("p_ci_builds"."status" IN ($19)) ORDER BY "p_ci_builds"."stage_idx" ASC /*application:test,correlation_id:5470c7a6-7a5d-4a6d-859c-548e226bc25a,endpoint_id:POST /api/:version/projects/:id/jobs/:job_id/retry,db_config_name:ci,line:/app/services/ci/reset_skipped_jobs_service.rb:68:in `to_h'*/
  • SELECT "p_ci_builds_metadata".* FROM "p_ci_builds_metadata" WHERE "p_ci_builds_metadata"."build_id" = $1 AND "p_ci_builds_metadata"."partition_id" = $2 LIMIT $3 /*application:test,correlation_id:a8dc1462-bf72-4bd2-93aa-9b5fc426d583,endpoint_id:PUT /api/:version/jobs/:id,db_config_name:ci,line:/app/models/concerns/ci/metadatable.rb:112:in `read_metadata_attribute'*/
  • SELECT "p_ci_builds_metadata".* FROM "p_ci_builds_metadata" WHERE "p_ci_builds_metadata"."partition_id" = $1 AND "p_ci_builds_metadata"."build_id" IN ($2, $3) /*application:test,correlation_id:01HE5F9327JQMJS0R2DWYMQMK1,endpoint_id:Projects::EnvironmentsController#index,db_config_name:ci,line:/app/models/preloaders/environments/deployment_preloader.rb:36:in `load_deployment_association'*/
  • SELECT $1 AS one FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "p_ci_builds"."id" = "ci_job_artifacts"."job_id" AND "p_ci_builds"."type" = $2 INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "ci_pipelines"."locked" = $3 LIMIT $4 /*application:test,correlation_id:8964ce7e773dd2e67473b2d6404e61aa,db_config_name:ci,line:/spec/models/ci/job_artifact_spec.rb:354:in `block (4 levels) in '*/
  • SELECT $1 AS one FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" LEFT OUTER JOIN "ci_job_artifacts" ON "ci_job_artifacts"."file_type" = $2 AND "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $3 AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds_metadata"."has_exposed_artifacts" = $7 LIMIT $8 /*application:test,correlation_id:01HE5ER4DTA0W1Z8HG2B411DZ2,endpoint_id:Projects::MergeRequests::ContentController#cached_widget,db_config_name:ci,line:/app/models/ci/pipeline.rb:1176:in `has_exposed_artifacts?'*/
  • SELECT $1 AS one FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" LEFT OUTER JOIN "ci_job_artifacts" ON "ci_job_artifacts"."file_type" = $2 AND "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $3 AND "p_ci_builds_metadata"."has_exposed_artifacts" = $4 LIMIT $5 /*application:test,correlation_id:752f03fb26292a31bea06085d978b7b3,db_config_name:ci,line:/spec/models/ci/build_spec.rb:349:in `block (4 levels) in '*/
  • SELECT $1 AS one FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds_metadata".config_options -> $5 -> $6 ?| array[$7,$8,$9,$10,$11,$12,$13,$14,$15,$16]) LIMIT $17 /*application:test,correlation_id:b16bb025e3a0f241e88e0f54214ae7af,db_config_name:ci,line:/spec/support/shared_examples/finders/security/jobs_finder_shared_examples.rb:46:in `block (5 levels) in '*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."name" = $4 AND "p_ci_builds"."type" != $5 LIMIT $6 /*application:test,correlation_id:7ff64580-8ab3-416d-8c1b-b21b0de7d0f2,endpoint_id:POST /api/:version/projects/:id/statuses/:sha,db_config_name:ci,line:/app/models/generic_commit_status.rb:27:in `name_uniqueness_across_types'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."status" IN ($4, $5, $6, $7, $8, $9, $10) LIMIT $11 /*application:test,correlation_id:1e86786c53c68b35787266b5f6ca4578,db_config_name:ci,line:/app/models/ci/pipeline.rb:698:in `cancelable?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."processed" = $4 OR "p_ci_builds"."processed" IS NULL) AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) LIMIT $6 /*application:test,correlation_id:d45254210b0c704e232810cfba96d2f3,endpoint_id:PipelineProcessWorker,db_config_name:ci,line:/app/models/ci/pipeline.rb:808:in `needs_processing?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 LIMIT $4 /*application:test,correlation_id:2d0c7a2bdaf26216891c477bebe0292f,db_config_name:ci,line:/spec/services/ci/create_pipeline_service/rate_limit_spec.rb:25:in `block (4 levels) in '*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($6,$7)) LIMIT $8 /*application:test,correlation_id:7dd46621cf7ebbfff9ce58fe01fa52d4,db_config_name:ci,line:/app/models/ci/pipeline.rb:694:in `retryable?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $6 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" = $7)) LIMIT $8 /*application:test,correlation_id:42904ce5-ee64-4301-9254-c951bddc1eaf,endpoint_id:Projects::DependenciesController#index,db_config_name:ci,line:/app/models/ci/pipeline.rb:1110:in `has_reports?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $6 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND ("ci_job_artifacts"."file_type" IN ($7, $8, $9, $10, $11, $12, $13, $14) OR "ci_job_artifacts"."file_type" = $15))) LIMIT $16 /*application:test,correlation_id:01HE5EZAE0AVNM5Y0BEV5YH5RR,endpoint_id:Projects::MergeRequestsController#security_reports,db_config_name:ci,line:/app/models/ci/pipeline.rb:1115:in `complete_and_has_reports?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 LIMIT $5 /*application:test,correlation_id:9451262cf862a2852b92cd993f95cecd,db_config_name:ci,line:/spec/services/merge_requests/create_pipeline_service_spec.rb:60:in `block (4 levels) in '*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($2, $3, $4) AND "p_ci_builds"."commit_id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."scheduling_type" = $7 LIMIT $8 /*application:test,correlation_id:3e021bc52b9a6f4db6c2eb29d8d8aa52,db_config_name:ci,line:/app/models/ci/pipeline.rb:585:in `uses_needs?'*/
  • SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($2, $3, $4) AND "p_ci_builds"."commit_id" = $5 AND "p_ci_builds"."partition_id" = $6 AND ("p_ci_builds"."retried" = $7 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."when" = $8 AND "p_ci_builds"."status" IN ($9, $10, $11, $12, $13) LIMIT $14 /*application:test,correlation_id:c18216cdb7e907afc46d404b33b3c4d6,db_config_name:ci,line:/spec/models/ci/pipeline_spec.rb:2233:in `block (3 levels) in '*/
  • SELECT *, (SELECT ARRAY_AGG(name) FROM "ci_build_needs" WHERE ("p_ci_builds".id = "ci_build_needs".build_id)) as aggregated_needs_names FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:0cbd69d58e578fc87e916ed6f71857dd,db_config_name:ci,line:/spec/models/ci/processable_spec.rb:351:in `block (5 levels) in '*/
  • SELECT *, (SELECT ARRAY_AGG(name) FROM "ci_build_needs" WHERE ("p_ci_builds".id = "ci_build_needs".build_id)) as aggregated_needs_names FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 ORDER BY "p_ci_builds"."id" ASC LIMIT $6 /*application:test,correlation_id:2d72938c348b8f7c38fe81cb96e2a9dc,db_config_name:ci,line:/spec/models/ci/processable_spec.rb:365:in `block (5 levels) in '*/
  • SELECT *, (SELECT ARRAY_AGG(name) FROM "ci_build_needs" WHERE ("p_ci_builds".id = "ci_build_needs".build_id)) as aggregated_needs_names FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."id" = $7 AND ("p_ci_builds"."status" IN ($8)) ORDER BY "p_ci_builds"."stage_idx" ASC /*application:test,correlation_id:1e86786c53c68b35787266b5f6ca4578,endpoint_id:Ci::InitialPipelineProcessWorker,db_config_name:ci,line:/app/services/ci/pipeline_processing/atomic_processing_service.rb:76:in `update_jobs!'*/
  • SELECT COUNT("p_ci_builds"."id") FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:d16348906f587e91b273e84e6c2dbdd0,db_config_name:ci,line:/app/models/ci/pipeline.rb:593:in `total_size'*/
  • SELECT COUNT(*) FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "ci_job_artifacts"."job_id" = "p_ci_builds"."id" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:dc1310274090f1078c42421d3ce1a96e,db_config_name:ci,line:/spec/models/ci/job_artifact_spec.rb:764:in `block (4 levels) in '*/
  • SELECT COUNT(*) FROM "ci_pipelines" INNER JOIN "p_ci_builds" ON "p_ci_builds"."commit_id" = "ci_pipelines"."id" AND "p_ci_builds"."partition_id" = "ci_pipelines"."partition_id" WHERE "ci_pipelines"."created_at" > $1 AND ("ci_pipelines"."status" IN ($2,$3,$4,$5,$6,$7)) /*application:test,correlation_id:eeb5bc0c0c18a1cfb009fadb52f5c053,db_config_name:ci,line:/app/models/ci/pipeline.rb:516:in `jobs_count_in_alive_pipelines'*/
  • SELECT COUNT(*) FROM "ci_pipelines" INNER JOIN "p_ci_builds" ON "p_ci_builds"."commit_id" = "ci_pipelines"."id" AND "p_ci_builds"."partition_id" = "ci_pipelines"."partition_id" WHERE "ci_pipelines"."project_id" = $1 AND "ci_pipelines"."created_at" > $2 AND ("ci_pipelines"."status" IN ($3,$4,$5,$6,$7,$8)) /*application:test,correlation_id:e315d7c8-62ac-4986-8fda-d79af9238956,endpoint_id:graphql:unknown,db_config_name:ci,line:/app/models/ci/pipeline.rb:516:in `jobs_count_in_alive_pipelines'*/
  • SELECT COUNT(*) FROM "ci_pipelines" INNER JOIN "p_ci_builds" ON "p_ci_builds"."commit_id" = "ci_pipelines"."id" AND "p_ci_builds"."type" = $1 AND "p_ci_builds"."partition_id" = "ci_pipelines"."partition_id" WHERE "ci_pipelines"."created_at" > $2 AND ("ci_pipelines"."status" IN ($3,$4,$5,$6,$7,$8)) /*application:test,correlation_id:a202f53c204d47d4413ee2f240a7ee55,db_config_name:ci,line:/app/models/ci/pipeline.rb:520:in `builds_count_in_alive_pipelines'*/
  • SELECT COUNT(*) FROM "ci_pipelines" INNER JOIN "p_ci_builds" ON "p_ci_builds"."commit_id" = "ci_pipelines"."id" AND "p_ci_builds"."type" = $1 AND "p_ci_builds"."partition_id" = "ci_pipelines"."partition_id" WHERE "ci_pipelines"."user_id" = $2 AND "ci_pipelines"."created_at" > $3 AND ("ci_pipelines"."status" IN ($4,$5,$6,$7,$8,$9)) /*application:test,correlation_id:correlation-id,db_config_name:ci,line:/app/models/ci/pipeline.rb:520:in `builds_count_in_alive_pipelines'*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:07af034eabde672eb27d97f9fca1d602,db_config_name:ci,line:/spec/features/projects/pipelines/pipeline_spec.rb:636:in `block (5 levels) in '*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 AND "p_ci_builds"."status" NOT IN ($3, $4) AND ("p_ci_builds"."status" IN ($5)) /*application:test,correlation_id:d285a114245584d3f91b1a884d49f2ca,db_config_name:ci,line:/spec/services/ci/pipeline_processing/atomic_processing_service_spec.rb:118:in `block (4 levels) in '*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:42e2c2d184fadce46b13f5ae8b7ecdbe,db_config_name:ci,line:/spec/models/ci/stage_spec.rb:20:in `block (4 levels) in '*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:9ba5fabb146956162fe23a95d4404eaf,db_config_name:ci,line:/spec/requests/api/ci/triggers_spec.rb:52:in `block (4 levels) in '*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."retried" = $4 AND "p_ci_builds"."name" = $5 /*application:test,correlation_id:6411544b-7da7-4a10-94d0-238d65fe2890,endpoint_id:POST /api/:version/jobs/request,db_config_name:ci,line:/app/models/ci/build.rb:443:in `retries_count'*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $1 AND "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($5)) /*application:test,correlation_id:99fd97f3f04c3389fb728d8c24513ce1,db_config_name:ci,line:/app/serializers/ci/pipeline_entity.rb:96:in `block in '*/
  • SELECT COUNT(*) FROM "p_ci_builds" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."status" IN ($6)) /*application:test,correlation_id:d193d5bc0e74d316033322922ebebc31,endpoint_id:Projects::Pipelines::StagesController#play_manual,db_config_name:ci,line:/spec/controllers/projects/pipelines/stages_controller_spec.rb:57:in `block (5 levels) in '*/
  • SELECT COUNT(*) FROM "taggings" WHERE "taggings"."taggable_type" = $1 AND "taggings"."taggable_id" IN (SELECT "p_ci_builds"."id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4) /*application:test,correlation_id:15f126d967ef6d5324616795f039740f,db_config_name:ci,line:/app/models/ci/pipeline.rb:597:in `tags_count'*/
  • SELECT COUNT(*) FROM (SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 LIMIT $4) subquery_for_count /*application:test,correlation_id:1273f4c6-e0d7-4ee6-82b9-af847d544347,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/graphql/types/limited_countable_connection_type.rb:20:in `count'*/
  • SELECT COUNT(*) FROM (SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."stage_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) LIMIT $5) subquery_for_count /*application:test,correlation_id:f801c732-abe2-4de3-911a-1dd366460223,endpoint_id:GraphqlController#execute,db_config_name:ci,line:/app/graphql/types/limited_countable_connection_type.rb:20:in `count'*/
  • SELECT COUNT(*) FROM (SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $6 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" = $7)) AND ("p_ci_builds"."status" IN ($8)) LIMIT $9) subquery_for_count /*application:test,correlation_id:123a3b9387c037638f257673e7d18242,db_config_name:ci,line:/spec/models/ci/pipeline_spec.rb:5234:in `block (3 levels) in '*/
  • SELECT COUNT(*) FROM (SELECT $1 AS one FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."stage_id" = $3 AND "p_ci_builds"."partition_id" = $4 LIMIT $5) subquery_for_count /*application:test,correlation_id:f05e7f15154c907b9e88e888fbede0a0,db_config_name:ci,line:/spec/models/ci/stage_spec.rb:26:in `block (4 levels) in '*/
  • SELECT COUNT(DISTINCT "p_ci_builds"."id") FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) AND ("p_ci_builds"."status" IN ($7)) /*application:test,correlation_id:a4c8ba639e59a6ffe5d451763409be88,db_config_name:ci,line:/spec/models/environment_spec.rb:887:in `block (6 levels) in '*/
  • SELECT COUNT(DISTINCT "p_ci_builds"."stage") FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 /*application:test,correlation_id:aa98483e7ed02fa07aabca530832c561,db_config_name:ci,line:/app/models/ci/pipeline.rb:589:in `stages_count'*/
  • SELECT COUNT(distinct(tag_id)) FROM "taggings" WHERE "taggings"."taggable_type" = $1 AND "taggings"."taggable_id" IN (SELECT "p_ci_builds"."id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4) /*application:test,correlation_id:ae617728c41bc4458bae7d4456e53ce2,db_config_name:ci,line:/app/models/ci/pipeline.rb:601:in `distinct_tags_count'*/
  • SELECT DISTINCT "expanded_environment_name" FROM "p_ci_builds" INNER JOIN "p_ci_builds_metadata" ON "p_ci_builds_metadata"."build_id" = "p_ci_builds"."id" AND "p_ci_builds_metadata"."partition_id" = "p_ci_builds"."partition_id" WHERE "p_ci_builds"."type" IN ($1, $2, $3) AND ("p_ci_builds"."retried" = $4 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."commit_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines" WHERE "ci_pipelines"."id" = $5) UNION (SELECT "ci_pipelines"."id", "ci_pipelines"."ref", "ci_pipelines"."sha", "ci_pipelines"."before_sha", "ci_pipelines"."created_at", "ci_pipelines"."updated_at", "ci_pipelines"."tag", "ci_pipelines"."yaml_errors", "ci_pipelines"."committed_at", "ci_pipelines"."project_id", "ci_pipelines"."status", "ci_pipelines"."started_at", "ci_pipelines"."finished_at", "ci_pipelines"."duration", "ci_pipelines"."user_id", "ci_pipelines"."lock_version", "ci_pipelines"."pipeline_schedule_id", "ci_pipelines"."source", "ci_pipelines"."config_source", "ci_pipelines"."protected", "ci_pipelines"."failure_reason", "ci_pipelines"."iid", "ci_pipelines"."merge_request_id", "ci_pipelines"."source_sha", "ci_pipelines"."target_sha", "ci_pipelines"."external_pull_request_id", "ci_pipelines"."ci_ref_id", "ci_pipelines"."locked", "ci_pipelines"."partition_id", "ci_pipelines"."auto_canceled_by_id" FROM "ci_pipelines", "base_and_descendants", "ci_sources_pipelines" WHERE "ci_sources_pipelines"."pipeline_id" = "ci_pipelines"."id" AND "ci_sources_pipelines"."source_pipeline_id" = "base_and_descendants"."id" AND "ci_sources_pipelines"."source_project_id" = "ci_sources_pipelines"."project_id")) SELECT id FROM "base_and_descendants" AS "ci_pipelines") AND "p_ci_builds_metadata"."expanded_environment_name" IS NOT NULL LIMIT $6 /*application:test,correlation_id:01HE5F7E37X0J60WMDT6X1XHBZ,endpoint_id:Projects::MergeRequestsController#ci_environments_status,db_config_name:ci,line:/app/models/ci/pipeline.rb:992:in `environments_in_self_and_project_descendants'*/
  • SELECT DISTINCT "p_ci_builds"."stage", "p_ci_builds"."stage_idx" FROM "p_ci_builds" WHERE "p_ci_builds"."commit_id" = $1 AND "p_ci_builds"."partition_id" = $2 ORDER BY "p_ci_builds"."stage_idx" ASC /*application:test,correlation_id:74b5d5668b73fb16d6f6e32a2574d238,db_config_name:ci,line:/app/models/ci/pipeline.rb:606:in `stages_names'*/
  • SELECT EXTRACT($1 FROM PERCENTILE_CONT($2) WITHIN GROUP (ORDER BY builds.duration)) AS p50, EXTRACT($3 FROM PERCENTILE_CONT($4) WITHIN GROUP (ORDER BY builds.duration)) AS p75, EXTRACT($5 FROM PERCENTILE_CONT($6) WITHIN GROUP (ORDER BY builds.duration)) AS p90, EXTRACT($7 FROM PERCENTILE_CONT($8) WITHIN GROUP (ORDER BY builds.duration)) AS p95, EXTRACT($9 FROM PERCENTILE_CONT($10) WITHIN GROUP (ORDER BY builds.duration)) AS p99 FROM (SELECT *, ("p_ci_builds"."started_at" - "p_ci_builds"."queued_at") AS duration FROM (WITH RECURSIVE "array_cte" AS MATERIALIZED (SELECT "ci_runners"."id" FROM "ci_runners" WHERE "ci_runners"."runner_type" = $12 ORDER BY "ci_runners"."id" DESC LIMIT $13), "recursive_keyset_cte" AS ((SELECT $14::p_ci_builds AS records, array_cte_id_array, p_ci_builds_id_array, $15::bigint AS count FROM (SELECT ARRAY_AGG("array_cte"."id") AS array_cte_id_array, ARRAY_AGG("p_ci_builds"."id") AS p_ci_builds_id_array FROM (SELECT "array_cte"."id" FROM array_cte) array_cte LEFT JOIN LATERAL (SELECT "p_ci_builds"."id" AS id FROM "p_ci_builds" WHERE "p_ci_builds"."runner_id" = "array_cte"."id" ORDER BY "p_ci_builds"."id" DESC LIMIT $16) p_ci_builds ON $17 WHERE "p_ci_builds"."id" IS NOT NULL) array_scope_lateral_query LIMIT $18) UNION ALL (SELECT (SELECT p_ci_builds FROM "p_ci_builds" WHERE "p_ci_builds"."id" = recursive_keyset_cte.p_ci_builds_id_array[position] LIMIT $19), array_cte_id_array, recursive_keyset_cte.p_ci_builds_id_array[:position_query.position-$20]||next_cursor_values.id||recursive_keyset_cte.p_ci_builds_id_array[position_query.position+$21:], recursive_keyset_cte.count + $22 FROM recursive_keyset_cte, LATERAL (SELECT id, position FROM UNNEST(p_ci_builds_id_array) WITH ORDINALITY AS u(id, position) WHERE id IS NOT NULL ORDER BY 1 DESC LIMIT $23) AS position_query, LATERAL (SELECT "record"."id" FROM (VALUES ($24)) AS nulls LEFT JOIN (SELECT "p_ci_builds"."id" AS id FROM "p_ci_builds" WHERE "p_ci_builds"."runner_id" = recursive_keyset_cte.array_cte_id_array[position] AND ("p_ci_builds"."id" < recursive_keyset_cte.p_ci_builds_id_array[position]) ORDER BY "p_ci_builds"."id" DESC LIMIT $25) record ON $26 LIMIT $27) AS next_cursor_values )) SELECT (records).status, (records).finished_at, (records).created_at, (records).updated_at, (records).started_at, (records).runner_id, (records).coverage, (records).commit_id, (records).name, (records).options, (records).allow_failure, (records).stage, (records).trigger_request_id, (records).stage_idx, (records).tag, (records).ref, (records).user_id, (records).type, (records).target_url, (records).description, (records).project_id, (records).erased_by_id, (records).erased_at, (records).artifacts_expire_at, (records).environment, (records).when, (records).yaml_variables, (records).queued_at, (records).lock_version, (records).coverage_regex, (records).auto_canceled_by_id, (records).retried, (records).protected, (records).failure_reason, (records).scheduled_at, (records).token_encrypted, (records).upstream_pipeline_id, (records).resource_group_id, (records).waiting_for_resource_at, (records).processed, (records).scheduling_type, (records).id, (records).stage_id, (records).partition_id, (records).auto_canceled_by_partition_id FROM "recursive_keyset_cte" AS "p_ci_builds" WHERE (count <> $11)) p_ci_builds WHERE "p_ci_builds"."started_at" IS NOT NULL AND "p_ci_builds"."runner_id" IS NOT NULL LIMIT $28) builds /*application:test,correlation_id:f93adb66-4545-4d9b-aa7c-c33270734df5,endpoint_id:graphql:unknown,db_config_name:ci,line:/ee/app/graphql/resolvers/ci/runners_jobs_statistics_resolver.rb:49:in `queued_durations'*/
  • SELECT array_agg(id), "p_ci_builds"."protected", (SELECT COALESCE(array_agg(tags.name ORDER BY name), ARRAY[]::text[]) FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (taggings.taggable_id="p_ci_builds".id) AND "taggings"."context" = $1 AND "taggings"."taggable_type" = $2) FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $3 AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 AND ("p_ci_builds"."retried" = $6 OR "p_ci_builds"."retried" IS NULL) GROUP BY "p_ci_builds"."protected", (SELECT COALESCE(array_agg(tags.name ORDER BY name), ARRAY[]::text[]) FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (taggings.taggable_id="p_ci_builds".id) AND "taggings"."context" = $7 AND "taggings"."taggable_type" = $8) /*application:test,correlation_id:9d4e297e6ba3bbeac39e3c8d771357a4,db_config_name:ci,line:/app/models/ci/build.rb:356:in `build_matchers'*/
  • SELECT array_agg(id), "p_ci_builds"."protected", (SELECT COALESCE(array_agg(tags.name ORDER BY name), ARRAY[]::text[]) FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (taggings.taggable_id="p_ci_builds".id) AND "taggings"."context" = $1 AND "taggings"."taggable_type" = $2) FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $3 AND "p_ci_builds"."commit_id" = $4 AND "p_ci_builds"."partition_id" = $5 GROUP BY "p_ci_builds"."protected", (SELECT COALESCE(array_agg(tags.name ORDER BY name), ARRAY[]::text[]) FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (taggings.taggable_id="p_ci_builds".id) AND "taggings"."context" = $6 AND "taggings"."taggable_type" = $7) /*application:test,correlation_id:9317e5b7c5fb5b50415e82e12c3a847c,db_config_name:ci,line:/app/models/ci/build.rb:356:in `build_matchers'*/
  • UPDATE "ci_job_artifacts" SET "expire_at" = $1 WHERE "ci_job_artifacts"."job_id" IN (SELECT "p_ci_builds"."id" FROM "p_ci_builds" WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $6 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" IN ($7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33)))) /*application:test,correlation_id:f2f88b3305ab44692dbe0e76ffd24416,db_config_name:ci,line:/app/models/ci/build.rb:762:in `keep_artifacts!'*/
  • UPDATE "ci_job_artifacts" SET "locked" = $1, "expire_at" = $2 WHERE "ci_job_artifacts"."id" IN (SELECT "ci_job_artifacts"."id" FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "p_ci_builds"."id" = "ci_job_artifacts"."job_id" AND "p_ci_builds"."type" = $3 INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "ci_pipelines"."locked" = $4 AND "ci_job_artifacts"."id" IN ($5, $6)) /*application:test,correlation_id:a6255f3bcdc3597b45c0776372c567bf,db_config_name:ci,line:/app/services/ci/job_artifacts/expire_project_build_artifacts_service.rb:25:in `block in execute'*/
  • UPDATE "ci_job_artifacts" SET "locked" = $1, "expire_at" = $2 WHERE "ci_job_artifacts"."id" IN (SELECT "ci_job_artifacts"."id" FROM "ci_job_artifacts" INNER JOIN "p_ci_builds" ON "p_ci_builds"."id" = "ci_job_artifacts"."job_id" AND "p_ci_builds"."type" = $3 INNER JOIN "ci_pipelines" ON "ci_pipelines"."id" = "p_ci_builds"."commit_id" AND "ci_pipelines"."partition_id" = "p_ci_builds"."partition_id" WHERE "ci_pipelines"."locked" = $4 AND $5=$6) /*application:test,correlation_id:0ae65989bfed4c6669f67dd68f663db6,db_config_name:ci,line:/app/services/ci/job_artifacts/expire_project_build_artifacts_service.rb:25:in `block in execute'*/
  • UPDATE "p_ci_builds" SET "artifacts_expire_at" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:7d93d3e1978d72ce7544ec9fff0463b6,db_config_name:ci,line:/app/services/ci/job_artifacts/create_service.rb:151:in `block in persist_artifact'*/
  • UPDATE "p_ci_builds" SET "artifacts_expire_at" = $1 WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND (EXISTS (SELECT $6 FROM "ci_job_artifacts" WHERE ("p_ci_builds".id = "ci_job_artifacts".job_id) AND "ci_job_artifacts"."file_type" IN ($7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33))) /*application:test,correlation_id:f2f88b3305ab44692dbe0e76ffd24416,db_config_name:ci,line:/app/models/ci/build.rb:761:in `keep_artifacts!'*/
  • UPDATE "p_ci_builds" SET "artifacts_expire_at" = $1, "updated_at" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:89906ce189107afc6638555faa062943,db_config_name:ci,line:/spec/controllers/projects/jobs_controller_spec.rb:270:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "created_at" = $1, "updated_at" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:6f62487bbc852ba301469e7840389148,db_config_name:ci,line:/spec/services/ci/stuck_builds/drop_pending_service_spec.rb:23:in `block (2 levels) in '*/
  • UPDATE "p_ci_builds" SET "created_at" = $1, "updated_at" = $2, "queued_at" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:d158c86c51dc975d8ac7f668287829e3,db_config_name:ci,line:/spec/services/ci/register_job_service_spec.rb:895:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET "erased_at" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/spec/models/ci/build_dependencies_spec.rb:390:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "finished_at" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:78e101445e4223aee3ba140246b829ee,db_config_name:ci,line:/spec/controllers/projects/pipelines/tests_controller_spec.rb:74:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "finished_at" = $1, "created_at" = $2, "updated_at" = $3, "started_at" = $4, "queued_at" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 /*application:test,correlation_id:d5b5b56e003b7525cf5e4d0220631b3c,db_config_name:ci,line:/spec/requests/api/graphql/ci/job_spec.rb:42:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET "lock_version" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:fcc521bbfa1204562d4c6ea2b9996ee4,db_config_name:ci,line:/spec/models/ci/build_spec.rb:476:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "options" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:d158c86c51dc975d8ac7f668287829e3,db_config_name:ci,line:/spec/services/ci/register_job_service_spec.rb:721:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "processed" = $1 WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."id" = $4 AND "p_ci_builds"."lock_version" = $5 /*application:test,correlation_id:0e449e925cd46c1b82f6a1dc3dd754c3,endpoint_id:PipelineProcessWorker,db_config_name:ci,line:/app/models/commit_status.rb:230:in `update_as_processed!'*/
  • UPDATE "p_ci_builds" SET "processed" = $1 WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND "p_ci_builds"."lock_version" = $4 AND ("p_ci_builds"."id" = $5 OR "p_ci_builds"."id" = $6) /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/commit_status.rb:230:in `update_as_processed!'*/
  • UPDATE "p_ci_builds" SET "processed" = $1 WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."id" = $4 AND "p_ci_builds"."lock_version" = $5 OR "p_ci_builds"."id" = $6 AND "p_ci_builds"."lock_version" = $7 OR "p_ci_builds"."id" = $8 AND "p_ci_builds"."lock_version" = $9) /*application:test,correlation_id:4f1b08f2c1c764c0e4a50e6bc7c346ed,db_config_name:ci,line:/app/models/commit_status.rb:230:in `update_as_processed!'*/
  • UPDATE "p_ci_builds" SET "processed" = $1 WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 AND ("p_ci_builds"."lock_version" = $4 AND ("p_ci_builds"."id" = $5 OR "p_ci_builds"."id" = $6) OR "p_ci_builds"."id" = $7 AND "p_ci_builds"."lock_version" = $8 OR "p_ci_builds"."id" = $9 AND "p_ci_builds"."lock_version" = $10 OR "p_ci_builds"."id" = $11 AND "p_ci_builds"."lock_version" = $12) /*application:test,correlation_id:4f1b08f2c1c764c0e4a50e6bc7c346ed,endpoint_id:Ci::InitialPipelineProcessWorker,db_config_name:ci,line:/app/models/commit_status.rb:230:in `update_as_processed!'*/
  • UPDATE "p_ci_builds" SET "processed" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:3a40c97d192c7707df5abc59dd0245fd,db_config_name:ci,line:/spec/models/ci/pipeline_spec.rb:2545:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "protected" = $1 WHERE "p_ci_builds"."type" = $2 AND "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:8e7a3e50fd86629ca95a0223abab37d4,db_config_name:ci,line:/spec/models/ci/build_spec.rb:5140:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "queued_at" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:d158c86c51dc975d8ac7f668287829e3,db_config_name:ci,line:/spec/services/ci/register_job_service_spec.rb:985:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "ref" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:135f9eed583f5d9d0b80d644cbff5f53,db_config_name:ci,line:/spec/models/ci/build_spec.rb:2864:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "retried" = $1, "processed" = $2 WHERE "p_ci_builds"."commit_id" = $3 AND "p_ci_builds"."partition_id" = $4 AND ("p_ci_builds"."retried" = $5 OR "p_ci_builds"."retried" IS NULL) AND "p_ci_builds"."name" = $6 AND "p_ci_builds"."id" != $7 /*application:test,correlation_id:2411ff51451c62009db9ee883500a8c5,db_config_name:ci,line:/app/models/commit_status.rb:323:in `update_older_statuses_retried!'*/
  • UPDATE "p_ci_builds" SET "scheduling_type" = $1 WHERE "p_ci_builds"."commit_id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/spec/services/ci/retry_pipeline_service_spec.rb:313:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "scheduling_type" = $1 WHERE "p_ci_builds"."type" IN ($2, $3, $4) AND "p_ci_builds"."commit_id" = $5 AND "p_ci_builds"."partition_id" = $6 /*application:test,correlation_id:082c3c9b180ad4cf8d6ac0b75a392d6e,db_config_name:ci,line:/spec/services/ci/retry_job_service_spec.rb:170:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:e4602cc2dd48e189dffae1785aaa170e,db_config_name:ci,line:/spec/models/ci/processable_spec.rb:463:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1, "created_at" = $2, "updated_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:ba769d8387636b9e6984742a142b24d9,db_config_name:ci,line:/spec/services/ci/stuck_builds/drop_pending_service_spec.rb:23:in `block (2 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1, "failure_reason" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:4f070ae6943a6122d3954863a043c14a,db_config_name:ci,line:/app/models/ci/build.rb:929:in `block in doom!'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "failure_reason" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:a8dc1462-bf72-4bd2-93aa-9b5fc426d583,endpoint_id:PUT /api/:version/jobs/:id,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "processed" = $3, "lock_version" = $4 WHERE "p_ci_builds"."id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."lock_version" = $7 /*application:test,correlation_id:ae68de59c76b7a5e6f834c46a201489f,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "allow_failure" = $4, "description" = $5, "failure_reason" = $6, "processed" = $7, "lock_version" = $8 WHERE "p_ci_builds"."id" = $9 AND "p_ci_builds"."partition_id" = $10 AND "p_ci_builds"."lock_version" = $11 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "allow_failure" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:f219db1c-81d5-48cb-873b-05026f3ad67f,endpoint_id:PUT /api/:version/jobs/:id,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "auto_canceled_by_id" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:0944eeef62f865b8140fe3505545d66d,endpoint_id:Ci::CancelRedundantPipelinesWorker,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "auto_canceled_by_id" = $4, "scheduled_at" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:5bec444384c32793172287716329c716,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "coverage" = $4, "description" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:72b0124f-e1c0-4add-a183-63574a8fb655,endpoint_id:POST /api/:version/projects/:id/statuses/:sha,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "description" = $4, "failure_reason" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "failure_reason" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:7f2d3325-ffb0-43f5-ad0e-323f8d446d9a,endpoint_id:POST /api/:version/projects/:id/deployments/:deployment_id/approval,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "failure_reason" = $4, "scheduled_at" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:f5b42ad0370dddbc90dbd6b6d3f1854f,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:895aad5e4131e7770f77d2a25ae852a0,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "queued_at" = $4, "failure_reason" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:a6255f3bcdc3597b45c0776372c567bf,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "runner_id" = $4, "failure_reason" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:0d4eb548-d9f6-4fd6-8a0c-329ae7a3ce18,endpoint_id:POST /api/:version/jobs/request,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "scheduled_at" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:01HE5EGM4B3NDMJBB15G55V5ZJ,endpoint_id:graphql:cancelPipeline,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "finished_at" = $2, "updated_at" = $3, "upstream_pipeline_id" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "queued_at" = $2, "processed" = $3, "lock_version" = $4 WHERE "p_ci_builds"."id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."lock_version" = $7 /*application:test,correlation_id:2d34ca81e1fca67bb52ea2e405c01627,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "queued_at" = $2, "token_encrypted" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:d158c86c51dc975d8ac7f668287829e3,endpoint_id:Ci::InitialPipelineProcessWorker,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "scheduled_at" = $2, "processed" = $3, "lock_version" = $4 WHERE "p_ci_builds"."id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."lock_version" = $7 /*application:test,correlation_id:8f7caadafeec52fc9e082509b9a54da8,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "started_at" = $2, "processed" = $3, "lock_version" = $4 WHERE "p_ci_builds"."id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."lock_version" = $7 /*application:test,correlation_id:dbc11d1adcb6afcba24127c9be47a4a0,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "started_at" = $2, "runner_id" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:1ce7d52e-3dda-45c0-a2e1-102ab563ae54,endpoint_id:POST /api/:version/jobs/request,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "processed" = $3, "lock_version" = $4 WHERE "p_ci_builds"."id" = $5 AND "p_ci_builds"."partition_id" = $6 AND "p_ci_builds"."lock_version" = $7 /*application:test,correlation_id:0ff412e05b713eb093ed3834e20077d0,db_config_name:ci,line:/ee/spec/lib/gitlab/ci/minutes/pipeline_consumption_spec.rb:31:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "project_id" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:447b6b97d7f53233eab9137d30277f7b,db_config_name:ci,line:/spec/requests/api/releases_spec.rb:1093:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "queued_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:06e2bf2b-06d8-4cb1-9393-41895060e410,endpoint_id:POST /api/:version/projects/:id/deployments/:deployment_id/approval,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "queued_at" = $3, "scheduled_at" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:a92ef3650ad6c8e3ecaad3560968717e,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "queued_at" = $3, "scheduled_at" = $4, "token_encrypted" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:12a5ce7a8d74c81b1ef347d3444b3134,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "queued_at" = $3, "token_encrypted" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:0944eeef62f865b8140fe3505545d66d,endpoint_id:Ci::InitialPipelineProcessWorker,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "retried" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:b45c06a61ba6773b365328c4ec8087a5,db_config_name:ci,line:/spec/services/ci/retry_job_service_spec.rb:64:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "scheduled_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:06ef22738f597e2f829ee88ef43b95df,endpoint_id:Projects::JobsController#unschedule,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "scheduled_at" = $3, "waiting_for_resource_at" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:2afe18d4a6cdd477c9e163da7d516a76,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "started_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:4f1b08f2c1c764c0e4a50e6bc7c346ed,endpoint_id:Ci::CreateDownstreamPipelineWorker,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "started_at" = $3, "runner_id" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:e7d13ed5-7c86-4226-b202-acec2ace2af3,endpoint_id:POST /api/:version/jobs/request,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "started_at" = $3, "upstream_pipeline_id" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "upstream_pipeline_id" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "user_id" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:c947800ee1811930bd66eb55974bd138,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "user_id" = $3, "queued_at" = $4, "processed" = $5, "lock_version" = $6 WHERE "p_ci_builds"."id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."lock_version" = $9 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "user_id" = $3, "queued_at" = $4, "scheduled_at" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:01HE5F7DS3KTQRFVVN48TNT0R3,endpoint_id:graphql:playJob,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "user_id" = $3, "queued_at" = $4, "scheduled_at" = $5, "token_encrypted" = $6, "processed" = $7, "lock_version" = $8 WHERE "p_ci_builds"."id" = $9 AND "p_ci_builds"."partition_id" = $10 AND "p_ci_builds"."lock_version" = $11 /*application:test,correlation_id:af6bf1a0a67452ad41e3783067e69556,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "user_id" = $3, "queued_at" = $4, "token_encrypted" = $5, "processed" = $6, "lock_version" = $7 WHERE "p_ci_builds"."id" = $8 AND "p_ci_builds"."partition_id" = $9 AND "p_ci_builds"."lock_version" = $10 /*application:test,correlation_id:da355b8e1e3207cc233936e68d9598f8,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "waiting_for_resource_at" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:41ae0640a8660dc895af634cae41c34f,endpoint_id:PipelineProcessWorker,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "status" = $1, "updated_at" = $2, "when" = $3, "processed" = $4, "lock_version" = $5 WHERE "p_ci_builds"."id" = $6 AND "p_ci_builds"."partition_id" = $7 AND "p_ci_builds"."lock_version" = $8 /*application:test,correlation_id:b2f8bfe90d3e4a50791c1e7bc0279c73,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "token_encrypted" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:058e6ddd0cfc121434e1a82c4be23f38,endpoint_id:Ci::BuildFinishedWorker,db_config_name:ci,line:/app/models/ci/build.rb:654:in `remove_token!'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:737ab520-d00c-45c5-9fcf-9bf5f4a953d5,endpoint_id:PATCH /api/:version/jobs/:id/trace,db_config_name:ci,line:/lib/gitlab/ci/trace.rb:185:in `block in unsafe_write!'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "auto_canceled_by_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:b828d129f753d7725a2656032d78f082,db_config_name:ci,line:/spec/models/commit_status_spec.rb:282:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "commit_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:0d74e710903b1cd27550b5dd7118e858,db_config_name:ci,line::90:in `tap'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "coverage" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:3a4ecdbdf1e91300da6e3f8691584795,db_config_name:ci,line:/app/models/ci/build.rb:575:in `update_coverage'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "coverage" = $2, "coverage_regex" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:064d5dde5363540688680dac685f0026,db_config_name:ci,line:/app/models/ci/build.rb:575:in `update_coverage'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "coverage_regex" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:edf14e0643bcbe867ad4d116d92484f1,db_config_name:ci,line:/spec/features/projects/jobs/user_browses_jobs_spec.rb:106:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "description" = $2, "lock_version" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:ab70091fa0c856a717e8efac8059461f,db_config_name:ci,line:/spec/models/commit_status_spec.rb:725:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "environment" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:af83ca35592b787627981f18ed44530d,db_config_name:ci,line:/ee/spec/models/ci/build_spec.rb:118:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "environment" = $2, "token_encrypted" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:bc7b109d45d6ca1cee3c20d9d1ade2a8,db_config_name:ci,line:/spec/models/ci/build_spec.rb:2506:in `block (8 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "erased_at" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:ff47f63208e2a2442353a59a21dc5b71,db_config_name:ci,line:/spec/models/ci/build_spec.rb:1583:in `block (7 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "erased_at" = $2, "artifacts_expire_at" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:0ae65989bfed4c6669f67dd68f663db6,db_config_name:ci,line:/app/services/ci/build_erase_service.rb:44:in `update_erased!'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "erased_by_id" = $2, "erased_at" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:681186318e2446f52cf8abb146985799,endpoint_id:Projects::JobsController#erase,db_config_name:ci,line:/app/services/ci/build_erase_service.rb:44:in `update_erased!'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "failure_reason" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:9c30ef5dadf25b6993f6b7ac402ec127,db_config_name:ci,line:/spec/models/commit_status_spec.rb:948:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "name" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:bb60a6924fa00b9db8a9b1c15a279aa6,db_config_name:ci,line:/spec/models/ci/group_spec.rb:104:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "project_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:5f8a3252557dda77bccae005441489c4,db_config_name:ci,line:/ee/spec/models/ci/build_spec.rb:727:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "protected" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:705545530c03dd3d3dce0cac11989e71,db_config_name:ci,line:/spec/models/ci/processable_spec.rb:148:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "ref" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/spec/services/projects/update_pages_service_spec.rb:273:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "resource_group_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:2afe18d4a6cdd477c9e163da7d516a76,db_config_name:ci,line:/spec/services/ci/run_scheduled_build_service_spec.rb:33:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "retried" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:bdf28b6ed927dff29a8a04b4494e8e05,db_config_name:ci,line:/ee/spec/services/security/store_scan_service_spec.rb:171:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "runner_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:1a36dc8cc6d8dfb5fb3734577c1f98a4,db_config_name:ci,line:/spec/models/ci/build_spec.rb:2957:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "runner_id" = $2, "user_id" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:d43c844b7ffd3de080cc10e5414b8586,db_config_name:ci,line:/spec/requests/api/ci/jobs_spec.rb:438:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "stage_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,db_config_name:ci,line::90:in `tap'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "started_at" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:639dd1e3ec058fd1ba82241451c767b6,db_config_name:ci,line:/ee/spec/lib/gitlab/ci/minutes/pipeline_consumption_spec.rb:53:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "tag" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:5f9f6bc87fc81d8f0709dc01e18e472f,db_config_name:ci,line:/spec/models/ci/build_spec.rb:2768:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "tag" = $2, "ref" = $3 WHERE "p_ci_builds"."id" = $4 AND "p_ci_builds"."partition_id" = $5 /*application:test,correlation_id:ea9741b794f7d639ccf3e5ba108b8103,db_config_name:ci,line:/spec/lib/gitlab/ci/variables/builder_spec.rb:388:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "token_encrypted" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:0e449e925cd46c1b82f6a1dc3dd754c3,endpoint_id:Ci::BuildFinishedWorker,db_config_name:ci,line:/app/models/ci/build.rb:654:in `remove_token!'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "trigger_request_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:cbde0b3ab0fed7ce69f605f1c48892b5,db_config_name:ci,line::90:in `tap'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "upstream_pipeline_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:3c7b81572361a3690aecb669cbe454df,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "user_id" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:f86ed9575166575d01ebb0e467d04f91,db_config_name:ci,line:/ee/spec/requests/api/ci/runner_spec.rb:202:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds" SET "updated_at" = $1, "when" = $2 WHERE "p_ci_builds"."id" = $3 AND "p_ci_builds"."partition_id" = $4 /*application:test,correlation_id:90b960195d5d169cd9e0e4295e685972,db_config_name:ci,line:/spec/models/ci/build_spec.rb:1644:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds" SET "yaml_variables" = $1 WHERE "p_ci_builds"."id" = $2 AND "p_ci_builds"."partition_id" = $3 /*application:test,correlation_id:3673f1b7a796fa4c4af84eada46a9571,db_config_name:ci,line:/spec/support/shared_examples/ci/stuck_builds_shared_examples.rb:14:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds" SET scheduling_type = CASE WHEN (EXISTS (SELECT $1 FROM "ci_build_needs" WHERE ("p_ci_builds".id = "ci_build_needs".build_id))) THEN $2 ELSE $3 END WHERE "p_ci_builds"."type" IN ($4, $5, $6) AND "p_ci_builds"."commit_id" = $7 AND "p_ci_builds"."partition_id" = $8 AND "p_ci_builds"."scheduling_type" IS NULL /*application:test,correlation_id:2411ff51451c62009db9ee883500a8c5,db_config_name:ci,line:/app/models/ci/processable.rb:93:in `populate_scheduling_type!'*/
  • UPDATE "p_ci_builds_metadata" SET "config_options" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/cross_database_modification.rb:92:in `block in transaction'*/
  • UPDATE "p_ci_builds_metadata" SET "config_options" = $1, "config_variables" = $2 WHERE "p_ci_builds_metadata"."id" = $3 AND "p_ci_builds_metadata"."partition_id" = $4 /*application:test,correlation_id:4aca9529c5dd63b2f90c29693f9a8193,db_config_name:ci,line:/app/models/concerns/ci/metadatable.rb:55:in `block in degenerate!'*/
  • UPDATE "p_ci_builds_metadata" SET "config_variables" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:f2f88b3305ab44692dbe0e76ffd24416,db_config_name:ci,line:/ee/spec/models/ee/ci/build_dependencies_spec.rb:344:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "config_variables" = $1, "id_tokens" = $2 WHERE "p_ci_builds_metadata"."id" = $3 AND "p_ci_builds_metadata"."partition_id" = $4 /*application:test,correlation_id:0f3f8078bcae97f9993909ff04c724a8,db_config_name:ci,line:/spec/models/ci/build_spec.rb:2541:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "debug_trace_enabled" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:ac71c3ea6a231ee1cf16a2ee19198abf,db_config_name:ci,line:/spec/requests/api/ci/jobs_spec.rb:763:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "expanded_environment_name" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,db_config_name:ci,line:/spec/models/ci/pipeline_spec.rb:3517:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "has_exposed_artifacts" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:6d84b7fd6feb0540c2c5e5b0938f8aec,db_config_name:ci,line:/spec/models/ci/build_spec.rb:336:in `block (4 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "id_tokens" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:94d8c05bac0a5301cdd779728037b3ac,db_config_name:ci,line:/ee/spec/services/ci/register_job_service_spec.rb:225:in `block (6 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "runtime_runner_features" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:d55218f331e5f124f5cdc40edab2318c,db_config_name:ci,line:/spec/models/ci/build_spec.rb:5292:in `block (3 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "secrets" = $1 WHERE "p_ci_builds_metadata"."id" = $2 AND "p_ci_builds_metadata"."partition_id" = $3 /*application:test,correlation_id:94d8c05bac0a5301cdd779728037b3ac,db_config_name:ci,line:/ee/spec/services/ci/register_job_service_spec.rb:194:in `block (5 levels) in '*/
  • UPDATE "p_ci_builds_metadata" SET "timeout" = $1, "timeout_source" = $2 WHERE "p_ci_builds_metadata"."id" = $3 AND "p_ci_builds_metadata"."partition_id" = $4 /*application:test,correlation_id:e7d13ed5-7c86-4226-b202-acec2ace2af3,endpoint_id:POST /api/:version/jobs/request,db_config_name:ci,line:/app/models/ci/build_metadata.rb:59:in `update_timeout_state'*/

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #423054 (closed)

Edited by Marius Bobin

Merge request reports