1459272 - remove raw_crashes_* tables and maintenance

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

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

There's a set of raw_crashes_* partition tables in postgres. The postgres crash store inserts data into these tables. There are some stored procedures that maintain the tables by adding new partitions and truncating old ones.

At one time, these tables were used for deriving other data. That time has passed and now they're just hanging out.

This bug covers removing the tables and all the code that maintains them.

Comment 1

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

Attachment: pr 4446: fix bug 1459272, 1459276, 1460990: remove postgres crashstorage db bits

Comment 2

[[github robot]]

Commit pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/dcf366c15cea99f19bd1217c266a1f2a4222c8b9
fix bug 1459272, 1459276, 1460990: remove postgres crashstorage db bits (#4446)

* fix bug 1459272: remove raw_crashes tables

* fix bug 1459276: remove reports* tables and procedures

* fix bug 1460990: remove report_partition_info and friends

* Remove unused stored procedures and tables

This removes the last tangled remnants of postgres crashstorage.

* Remove add_param_to_dict and parse_versions

The uses for these were removed a long time ago. We don't need them any
more.

Comment 3

[[github robot]]

Commit pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/47978b84cb7f273a30eef95cf7b1d7423644ee4c
Merge pull request #4449 from willkg/1459275-fix

bug 1459272: fix migration