prod homepage timeouts due to long TCBS query

RESOLVED FIXED

Status

RESOLVED FIXED
9 years ago
7 years ago

People

(Reporter: ozten, Unassigned)

Tracking

Trunk
x86
Mac OS X
Dependency tree / graph

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

9 years ago
production is timing out due to slow TCBS queries.

Workaround - Continue to use the query page directly.
http://crash-stats.mozilla.com/query/query
We should modify the front page to eliminate the problem query.  Working on patching front page so the dashboard widgets aren't there until we can get the RAM upgraded, etc.
(Reporter)

Comment 2

9 years ago
Short term fix: Bug#544944

We are also upgrading Postgres RAM

We are evaluating removing data older than 28 days. This is how the system used to work.

We should evaluate how we are using the branchs admin config. TCBS reports are very expensive in terms the numer of rows created in the db. Originally this report was run very selectively and now is run by default for several months.
(Reporter)

Comment 3

9 years ago
Short term fix: Bug#544944

We are also upgrading Postgres RAM

We are evaluating removing data older than 28 days. This is how the system used
to work.

We should evaluate how we are using the branchs admin config. TCBS reports are
very expensive in terms the numer of rows created in the db. Originally this
report was run very selectively and now is run by default for several months
(Reporter)

Updated

9 years ago
Depends on: 545000, 545004, 545006
Is this bug still an issue?
Seems like no, also the 1.6 push will get rid of older data and prevent this from happening again.
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.