812536 - Purge browser hang reports

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Benjamin Smedberg]

The browser hang reports aren't useful to us. I understand that we're facing database disk issues, and this would probably be a significant win.

The query for these in SQL is

select uuid, hangid, process_type from reports AND hangid IS NOT NULL and process_type IS NULL;

I'm not sure how this would affect secondary tables and such.

I think we should probably remove these from hbase as well.

Comment 1

[Robert Helmer [:rhelmer]]

The "hang_report" table (which is a matview) could also go.

Comment 2

[Robert Kaiser]

(In reply to Robert Helmer [:rhelmer] from comment #1)
> The "hang_report" table (which is a matview) could also go.

I saw that as probably part of bug 812511 (I guess removal of code can possibly be done across DB schema, mware and UI as needed in a single bug - but if not, feel free to file bugs for any parts of that).

Comment 3

[Robert Helmer [:rhelmer]]

(In reply to Robert Kaiser (:[e-mail]) from comment #2)
> (In reply to Robert Helmer [:rhelmer] from comment #1)
> > The "hang_report" table (which is a matview) could also go.
> 
> I saw that as probably part of bug 812511 (I guess removal of code can
> possibly be done across DB schema, mware and UI as needed in a single bug -
> but if not, feel free to file bugs for any parts of that).

I'd like to leave this as separate bugs - bug 812511 will stop populating this via cron and exposing it via socorro, but removing it and updating the schema needs to be done with DB upgrade scripts and Selena should own that bit (also needs special handling at release time)

Comment 4

[Selena Deckelmann :selenamarie :selena]

We no longer have disk space issues. Closing.

Comment 5

[Selena Deckelmann :selenamarie :selena]

Oops! This was to actually drop the hang_report :D

This is a bit more involved than just dropping the schema parts.. I imagine we want the processor to stop populating the data. I'll make a separate ticket for that.

Comment 6

[Selena Deckelmann :selenamarie :selena]

https://github.com/mozilla/socorro/pull/1480

Comment 7

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/0effa6b2a73956b79543374fb38a0b24dd70b0ec
Fixes bug 812536 Eliminate hang report and daily_hangs

https://github.com/mozilla/socorro/commit/07f0988f3a8e9c61245884f373ea5a6d8a6fc108
Fixes bug 812536: remove numbering in tests r=peterbe

https://github.com/mozilla/socorro/commit/5a318a1a8f40a004cf53926093b399080eed1fb7
Merge pull request #1480 from selenamarie/bug812536-purge-hang-report

Fixes bug 812536 Eliminate hang report and daily_hangs