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 by Stan Hu