Closed Bug 1176130 Opened 9 years ago Closed 9 years ago

Delete old buildapi_complete and buildapi_pending artifacts

Categories

(Tree Management :: Treeherder: Infrastructure, defect, P3)

defect

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: emorley, Assigned: emorley)

References

Details

Bug 1169264 means we no longer store the buildapi_complete and buildapi_pending artifacts for buildbot jobs, and the size of buildapi_running is halved. We can delete the old artifacts to save having to wait 4 months for them to expire.
Stage... Did multiple iterations of: [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py run_sql -s "DELETE FROM job_artifact WHERE name = 'buildapi_complete' LIMIT 80000;" [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py run_sql -s "DELETE FROM job_artifact WHERE name = 'buildapi_pending' LIMIT 80000;" Zero records remaining: [emorley@treeherder-rabbitmq1.stage.private.scl3 treeherder-service]$ ../venv/bin/python ./manage.py run_sql -s "SELECT COUNT(*) FROM job_artifact WHERE name in ('buildapi_pending', 'buildapi_complete');" SQL command: SELECT COUNT(*) FROM job_artifact WHERE name in ('buildapi_pending', 'buildapi_complete'); https://emorley.pastebin.mozilla.org/8837369
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.