Contribution Analytics fails with 502 error

Summary

The Contribution Analytics page (not to be confused with Cycle Analytics) is not available on GitLab.com

Steps to reproduce

1. Open https://gitlab.com/groups/gitlab-org/analytics
2. Wait a while.
3. You will see 502 error page.

Expected behavior

The page should open.

Actual behavior

The page fails with 502 error.

Results of GitLab environment info

GitLab Enterprise Edition 8.12.3-ee 54ec1a6e

@blackst0ne Another good spot! Thank you.

Other groups "Contribution Analytics" pages are working OK. This must be due to the activity on the individual projects within this group

@rspeicher Any ideas who to mention for this issue?

@markglenfletcher, should it be labeled by bug ?

Added ~12980 label

I think it's a ~Performance issue. This page runs a ton of queries and is likely to time out.

Added ~18308 label

Milestone changed to %8.14

Added ~307491 label

Added ~123454 label

Removed ~307491 label

Is this still a problem?

@yorickpeterse Yep. Just hit a 502.

Reassigned to @timothyandrew

@timothyandrew I'm assigning this to you since you're the main person for cycle analytics as far as I'm aware.

Milestone changed to %8.15

@yorickpeterse: @jameslopez has been working on cycle analytics since the second iteration. I'll re-assign to him.

Reassigned to @jameslopez

thanks for pinging @timothyandrew!

This should get resolved once https://gitlab.com/gitlab-org/gitlab-ce/issues/24800 gets fixed too. We are returning hundreds of rows only for gitlab-ce, so the group gitlab-org will be in the thousands. Should be resolved with pagination or limiting the number of events returned.

Mentioned in issue #24800 (moved)

Mentioned in merge request !7743 (merged)

@jameslopez What is the status here?

changed milestone to %8.16

@DouweM already commented here: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/7743#note_20804685

removed ~123454 label

mentioned in issue #27549 (closed)

What's the status of this bug?
It is 8.16.4, this issue has 8.16 milestone, but the problem still exists.

mentioned in issue #27622 (closed)

@jameslopez Can you comment?

added ~480950 label

changed milestone to %9.0

added Stretch label

@DouweM actually, I was pinged here but I don't think this is Cycle Analytics! I think people (including myself) got confused since we have contribution analytics and cycle analytics. This is a different page. I'm unassigning myself from here for now as I thought this was related to a CA bug I was working on, but it certainly isn't

removed assignee

changed milestone to %9.1

added Deliverable and removed Stretch labels

removed Deliverable label

The problem is still reproducible on GitLab.com

See https://gitlab.com/gitlab-org/gitlab-ee/issues/1886#note_25095591.

closed via merge request gitlab-ee!1514

mentioned in merge request !14785