Group page times out on staging.gitlab.com
As @victorwu mentioned, https://staging.gitlab.com/gitlab-org is getting a 502 error due to this SQL query:
SELECT
COUNT(*)
FROM
"issues"
INNER JOIN
"projects"
ON "projects"."id" = "issues"."project_id"
LEFT JOIN
project_features
ON projects.id = project_features.project_id
WHERE
(
"projects"."namespace_id" IN
(
WITH RECURSIVE "base_and_descendants" AS
(
SELECT
"namespaces".*
FROM
"namespaces"
WHERE
"namespaces"."type" IN
(
'Group'
)
AND "namespaces"."id" = 9970
UNION
SELECT
"namespaces".*
FROM
"namespaces",
"base_and_descendants"
WHERE
"namespaces"."type" IN
(
'Group'
)
AND "namespaces"."parent_id" = "base_and_descendants"."id"
)
SELECT
"id"
FROM
"base_and_descendants" AS "namespaces"
)
AND
(
projects.visibility_level IN
(
10,
20
)
)
OR "projects"."namespace_id" IN
(
WITH RECURSIVE "base_and_descendants" AS
(
SELECT
"namespaces".*
FROM
"namespaces"
WHERE
"namespaces"."type" IN
(
'Group'
)
AND "namespaces"."id" = 9970
UNION
SELECT
"namespaces".*
FROM
"namespaces",
"base_and_descendants"
WHERE
"namespaces"."type" IN
(
'Group'
)
AND "namespaces"."parent_id" = "base_and_descendants"."id"
)
SELECT
"id"
FROM
"base_and_descendants" AS "namespaces"
)
AND
(
EXISTS
(
SELECT
1
FROM
"project_authorizations"
WHERE
"project_authorizations"."user_id" = 64248
AND
(
project_authorizations.project_id = projects.id
)
)
)
)
AND
(
(projects.visibility_level > 0
AND
(
"project_features"."issues_access_level" IS NULL
OR "project_features"."issues_access_level" >=
(
20
)
OR
(
"project_features"."issues_access_level" = 10
AND EXISTS
(
SELECT
1
FROM
"project_authorizations"
WHERE
"project_authorizations"."user_id" = 64248
AND
(
project_authorizations.project_id = projects.id
)
AND
(
project_authorizations.access_level >= 10
)
)
)
)
)
OR
(
projects.visibility_level = 0
AND
(
"project_features"."issues_access_level" IS NULL
OR "project_features"."issues_access_level" >= 10
)
AND EXISTS
(
SELECT
1
FROM
"project_authorizations"
WHERE
"project_authorizations"."user_id" = 64248
AND
(
project_authorizations.project_id = projects.id
)
AND
(
project_authorizations.access_level >= 10
)
)
)
)
AND
(
"issues"."state" IN
(
'opened'
)
)
AND "projects"."archived" = 'f'D, [2019-04-10T00:40:40.101451 #9607] DEBUG -- : (79558.5ms) SELECT COUNT(*) FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT JOIN project_features ON projects.id = p
roject_features.project_id WHERE ("projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id
" = 9970
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS
"namespaces") AND (projects.visibility_level IN (10,20)) OR "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS (SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('G
roup') AND "namespaces"."id" = 9970
UNION
SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."parent_id" = "base_and_descendants"."id") SELECT "id" FROM "base_and_descendants" AS
"namespaces") AND (EXISTS (SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 64248 AND (project_authorizations.project_id = projects.id)))) AND ((projects.visibility_level
> 0 AND ("project_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" >= (20) OR ("project_features"."issues_access_level" = 10 AND EXISTS(SELECT 1 FROM "project_authorizati
ons" WHERE "project_authorizations"."user_id" = 64248 AND (project_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10))))) OR (projects.visibility_level = 0 AND ("proje
ct_features"."issues_access_level" IS NULL OR "project_features"."issues_access_level" >= 10) AND EXISTS(SELECT 1 FROM "project_authorizations" WHERE "project_authorizations"."user_id" = 64248 AND (project
_authorizations.project_id = projects.id) AND (project_authorizations.access_level >= 10)))) AND ("issues"."state" IN ('opened')) AND "projects"."archived" = 'f'
D, [2019-04-10T00:40:40.109354 #9607] DEBUG -- : ↳ app/helpers/groups_helper.rb:38:in `group_issues_count'
D, [2019-04-10T00:40:40.109532 #9607] DEBUG -- : ↳ app/views/layouts/nav/sidebar/_group.html.haml:1:in `_app_views_layouts_nav_sidebar__group_html_haml___3743724771602157734_70349104741120'
D, [2019-04-10T00:40:40.109575 #9607] DEBUG -- : ↳ app/views/layouts/_page.html.haml:3:in `_app_views_layouts__page_html_haml__2183305817196073134_70349156844080'
D, [2019-04-10T00:40:40.109659 #9607] DEBUG -- : ↳ app/views/layouts/application.html.haml:10:in `_app_views_layouts_application_html_haml__3482868329737528834_70349028996800'
D, [2019-04-10T00:40:40.109694 #9607] DEBUG -- : ↳ app/views/layouts/group.html.haml:13:in `_app_views_layouts_group_html_haml___1133997741850444897_70349091056000'
D, [2019-04-10T00:40:40.109730 #9607] DEBUG -- : ↳ app/controllers/application_controller.rb:116:in `render'
D, [2019-04-10T00:40:40.109808 #9607] DEBUG -- : ↳ app/controllers/groups_controller.rb:136:in `render_show_html'
D, [2019-04-10T00:40:40.109841 #9607] DEBUG -- : ↳ ee/app/controllers/ee/groups_controller.rb:13:in `render_show_html'
D, [2019-04-10T00:40:40.109874 #9607] DEBUG -- : ↳ app/controllers/groups_controller.rb:62:in `block (2 levels) in show'
D, [2019-04-10T00:40:40.109910 #9607] DEBUG -- : ↳ app/controllers/groups_controller.rb:60:in `show'
D, [2019-04-10T00:40:40.109945 #9607] DEBUG -- : ↳ app/controllers/application_controller.rb:434:in `set_locale'Attached is the full output.
Edited by Stan Hu