529629 - prod socorro database work - drop unused tables

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Austin King [:ozten]]

Please drop the following tables in production:
branches_deprecated
legacy_priority_jobs
mtbfconfig_deprecated
mtbffacts_deprecated
productdims_prior
signaturedims_deprecated
tcbyurlconfig_deprecated
topcrashers_deprecated
topcrashurlfacts_deprecated
topcrashurlfactsreports_prior
urldims_prior

Comment 1

[Austin King [:ozten]]

@morgamic - please approve this request.

Comment 2

[Frank Griswold [:griswolf] [:fgriswold]]

We have been running for more than a month without needing the old tables: I think it is fine to drop them now.

Comment 3

[Michael Morgan [:morgamic]]

Have they been dropped in stage first?

Comment 4

[Austin King [:ozten]]

No, I asked for this and the feedback was that stage is a clone of prod and that it will get overwritten anyways.

@aravind - can we do this on stage first and give it some testing?

Comment 5

[Michael Morgan [:morgamic]]

Hmmm.  Seems like we'd be skipping an opportunity to spot regressions on stage, so I'm not so sure about that.

Comment 6

[Aravind Gottipati [:aravind]]

sure, dropping them on the stage db (not lars db).

Comment 7

[Aravind Gottipati [:aravind]]

None of those table even exist in the staging env.

Comment 8

[K Lars Lohn [:lars] [:klohn]]

that's because the staging database was created from scratch without the deprecated tables.  When they were deprecated, their names were changed.  If any process still depended on them, those processes would have broken right then and there.  Since we're not seeing problems, we're in the clear.

I say that they should be unceremoniously deleted from production without another thought.

Comment 9

[Aravind Gottipati [:aravind]]

All done.