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)
Tree Management
Treeherder: Infrastructure
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.
Assignee | ||
Comment 1•9 years ago
|
||
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
Assignee | ||
Comment 2•9 years ago
|
||
And prod now complete:
https://emorley.pastebin.mozilla.org/8837383
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.
Description
•