epic_issues/list_service_spec.rb N+1 Job Failed #160834181

Job #160834181 failed for 6e8126c0:

Failures:

  1) EpicIssues::ListService#execute when epics feature is enabled does not have N+1 queries
     Failure/Error: expect { list_service.execute }.not_to exceed_query_limit(control_count)

       Expected a maximum of 36 queries, got 40:

       SELECT issues.*, epic_issues.id as epic_issue_id, epic_issues.relative_position FROM "issues" INNER JOIN "epic_issues" ON "epic_issues"."issue_id" = "issues"."id" WHERE (epic_issues.epic_id = 191) ORDER BY epic_issues.relative_position, epic_issues.id

       SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (762, 763, 764)

       SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (2035, 2042)

       SELECT "issue_assignees".* FROM "issue_assignees" WHERE "issue_assignees"."issue_id" IN (334, 333, 335, 336, 337, 338)

       SELECT "users".* FROM "users" WHERE "users"."id" = 1566

       SELECT  "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 762 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 2035 AND "namespaces"."type" IN ('Group') AND "namespaces"."type" = 'Group' LIMIT 1

       SELECT  "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 763 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 2035 AND "namespaces"."type" IN ('Group') AND "namespaces"."type" = 'Group' LIMIT 1

       SELECT  "project_features".* FROM "project_features" WHERE "project_features"."project_id" = 764 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."type" IN ('Group') AND "namespaces"."id" = 2042 AND "namespaces"."type" IN ('Group') AND "namespaces"."type" = 'Group' LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 2035 AND "routes"."source_type" = 'Namespace' LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 762 AND "routes"."source_type" = 'Project' LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 763 AND "routes"."source_type" = 'Project' LIMIT 1

       SELECT  "milestones".* FROM "milestones" WHERE "milestones"."id" = 37 LIMIT 1

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 762 LIMIT 1

       SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" WHERE (issues.confidential IS NOT TRUE) AND "issues"."project_id" IS NULL AND "issues"."milestone_id" = 37 GROUP BY "issues"."state"

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 37 AND ("merge_requests"."state" IN ('closed','merged'))

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 37

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 762 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 2035 LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 2035 AND "routes"."source_type" = 'Namespace' LIMIT 1

       SELECT  "milestones".* FROM "milestones" WHERE "milestones"."id" = 38 LIMIT 1

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 764 LIMIT 1

       SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" WHERE (issues.confidential IS NOT TRUE) AND "issues"."project_id" IS NULL AND "issues"."milestone_id" = 38 GROUP BY "issues"."state"

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 38 AND ("merge_requests"."state" IN ('closed','merged'))

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 38

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 764 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 2042 LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 2042 AND "routes"."source_type" = 'Namespace' LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 2042 AND "routes"."source_type" = 'Namespace' LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 764 AND "routes"."source_type" = 'Project' LIMIT 1

       SELECT  "milestones".* FROM "milestones" WHERE "milestones"."id" = 39 LIMIT 1

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 765 LIMIT 1

       SELECT COUNT(*) AS count_all, "issues"."state" AS issues_state FROM "issues" WHERE (issues.confidential IS NOT TRUE) AND "issues"."project_id" IS NULL AND "issues"."milestone_id" = 39 GROUP BY "issues"."state"

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 39 AND ("merge_requests"."state" IN ('closed','merged'))

       SELECT COUNT(*) FROM "merge_requests" WHERE "merge_requests"."milestone_id" = 39

       SELECT  "projects".* FROM "projects" WHERE "projects"."id" = 765 LIMIT 1

       SELECT  "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 2044 LIMIT 1

       SELECT  "routes".* FROM "routes" WHERE "routes"."source_id" = 2044 AND "routes"."source_type" = 'Namespace' LIMIT 1
     # ./ee/spec/services/epic_issues/list_service_spec.rb:64:in `block (4 levels) in <top (required)>'
     # ./spec/spec_helper.rb:169:in `block (2 levels) in <top (required)>'

Finished in 22 minutes 32 seconds (files took 15.42 seconds to load)
1444 examples, 1 failure, 2 pending

Failed examples:

rspec ./ee/spec/services/epic_issues/list_service_spec.rb:37 # EpicIssues::ListService#execute when epics feature is enabled does not have N+1 queries
! Generating reports is disabled. To enable it, please set the `FLAKY_RSPEC_GENERATE_REPORT=1` !
! Generating reports is disabled. To enable it, please set the `FLAKY_RSPEC_GENERATE_REPORT=1` !