omnibus-gitlab tracker no longer loading due to database statement timeout

https://gitlab.com/gitlab-org/omnibus-gitlab is reporting an Error 500 due to https://sentry.gitlap.com/gitlab/gitlabcom/issues/476053:

PG::QueryCanceled: ERROR: canceling statement due to statement timeout : SELECT "ci_pipelines".* FROM "ci_pipelines" INNER JOIN "ci_builds" ON "ci_builds"."commit_id" = "ci_pipelines"."id" AND "ci_builds"."type" IN ('Ci::Build') AND ("ci_builds"."retried" = 'f' OR "ci_builds"."retried" IS NULL) AND ((artifacts_file IS NOT NULL AND artifacts_file <> '') OR EXISTS (SELECT 1 FROM "ci_job_artifacts" WHERE (ci_builds.id = ci_job_artifacts.job_id) AND "ci_job_artifacts"."file_type" = 1)) AND (artifacts_expire_at IS NULL OR artifacts_expire_at > '2018-08-27 16:32:37.511623') WHERE "ci_pipelines"."project_id" = 20699 AND "ci_pipelines"."ref" = 'master' AND "ci_builds"."name" IN ('sast', 'dependency_scanning', 'sast:container', 'container_scanning', 'dast') ORDER BY "ci_pipelines"."id" DESC LIMIT 1
SELECT 
  "ci_pipelines".* 
FROM 
  "ci_pipelines" 
  INNER JOIN "ci_builds" ON "ci_builds"."commit_id" = "ci_pipelines"."id" 
  AND "ci_builds"."type" IN ('Ci::Build') 
  AND (
    "ci_builds"."retried" = 'f' 
    OR "ci_builds"."retried" IS NULL
  ) 
  AND (
    (
      artifacts_file IS NOT NULL 
      AND artifacts_file <> ''
    ) 
    OR EXISTS (
      SELECT 
        1 
      FROM 
        "ci_job_artifacts" 
      WHERE 
        (
          ci_builds.id = ci_job_artifacts.job_id
        ) 
        AND "ci_job_artifacts"."file_type" = 1
    )
  ) 
  AND (
    artifacts_expire_at IS NULL 
    OR artifacts_expire_at > '2018-08-27 16:32:37.511623'
  ) 
WHERE 
  "ci_pipelines"."project_id" = 20699 
  AND "ci_pipelines"."ref" = 'master' 
  AND "ci_builds"."name" IN (
    'sast', 'dependency_scanning', 'sast:container', 
    'container_scanning', 'dast'
  ) 
ORDER BY 
  "ci_pipelines"."id" DESC 
LIMIT 
  1
Edited Aug 27, 2018 by Stan Hu
Assignee Loading
Time tracking Loading