822304 - unused priorty_jobs tables in DB ought to be expunged

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

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

each processor in Socorro has its own 'priority_jobs_XXXX' table.  The XXXX is the 'processor_id' from the 'processors' table.  If XXXX doesn't exist in the 'processors' table, then that priority jobs table is moribund and can be dropped.  

Each processor is responsible for creating and dropping it's own priority jobs table.  If the table doesn't get dropped, that means the associated processor was SIGKILL'd and didn't get the opportunity to act.

Comment 1

[Selena Deckelmann :selenamarie :selena]

This is a programming issue, not for DBAs.

Comment 2

[[github robot]]

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

https://github.com/mozilla/socorro/commit/1aa9b5412f1620e9e049c2cca62188afe140509d
Fixes bug 822304 Removes priority_jobs table
* Removes table from models.py
* Updates a couple docs showing those tables are deprecated

https://github.com/mozilla/socorro/commit/cb49a27b0e6a393ff962652e58f6a46eb200c318
Merge pull request #1719 from selenamarie/bug822304-remove-priority-jobs

Fixes bug 822304 Removes priority_jobs table

Comment 3

[[github robot]]

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

https://github.com/mozilla/socorro/commit/c26a17e5c6ac10c8b41730dba832f96a2f39d31b
Fixes bug 822304 - migration for removal of priority jobs tables

https://github.com/mozilla/socorro/commit/17f9ff755897101dc08dd90acbc0cb71da26f098
Merge pull request #1733 from selenamarie/bug822304-migration-for-priority-jobs

Fixes bug 822304 - migration for removal of priority jobs tables