1427143 - drop all crash reports from postgres

Status: RESOLVED FIXED

(Socorro :: Data request, task)

Description

[Lonnen :lonnen]

Per bug 1427117, we need to delete all crash reports collected before 2017-12-24. This bug covers removing the subset of information we copy into postgres. This means the reports table, and reports-clean.


stage first, then prod

Comment 1

[Will Kahn-Greene [:willkg] ET needinfo? me]

I'm going to drop all the tables older than 20171225 for any tables of the form tablename_YYYYMMDD.

For 20171225 tables, we need those since that's this week, so I'll truncate them.

I'll leave the 2018 tables since those are in the future and have no data in them.

I didn't realize the scope of this (900+ tables on -stage), so I'm going to do psql \d -> .sql file, vim it a bit to remove the tables we don't want to truncate/drop, add the SQL commands, then run it in psql.

Comment 2

[Will Kahn-Greene [:willkg] ET needinfo? me]

Attachment: 1427143_stage.sql

File with all the DROP and TRUNCATE statements.

Comment 3

[Lonnen :lonnen]

Comment on attachment 8938908 [details]
1427143_stage.sql

It's a long, machine generated list. The output has a consistency, but I didn't check line-by-line to ensure all the dates match. Truncate at the end checks out too.

Comment 4

[Will Kahn-Greene [:willkg] ET needinfo? me]

Attachment: 1427143_prod.sql

DROP and TRUNCATE statements to run against -prod.

Comment 5

[Will Kahn-Greene [:willkg] ET needinfo? me]

I've run both scripts in their respective environments. I think we're good here.

Comment 6

[Lonnen :lonnen]

no need for this to remain confidential