907838 - some user activity pages are timing out with a 504

Status: RESOLVED WONTFIX

(Marketplace Graveyard :: Admin Tools, defect, P4)

Description

[Andrew Williamson [:eviljeff]]

Try https://marketplace.firefox.com/lookup/user/631/activity (me) and after a long long wait it will time out, presuming because I haz dun too much activity.

Comment 1

[Wil Clouser [:clouserw]]

Do you use this page routinely?

Comment 2

[Andrew Williamson [:eviljeff]]

(In reply to Wil Clouser [:clouserw] from comment #1)
> Do you use this page routinely?

tbh, no.  And I'm obviously an edge case in terms of activity.

Comment 3

[Andrew Williamson [:eviljeff]]

for some context on what its choking on:

select count(*) from log_activity_mkt where user_id=631;
+----------+
| count(*) |
+----------+
|     3979 | 
+----------+

Comment 4

[Chuck Harmston [:chuck]]

Marking as a P4 due to the previously-noted infrequency of use of this page and edge case nature of this bug.