Merge autopkgtest-cloud:remove-eol-series into autopkgtest-cloud:master

[Brian Murray]

The steps from removing end of life releases from the autopkgtst.db were not documented so I added the process I followed to remove hirsute and impish.

[Paride Legovini (paride)]

LGTM, thanks!

review: Approve

diff --git a/docs/administration.rst b/docs/administration.rst
index 47b4e02..101affa 100644
--- a/docs/administration.rst
+++ b/docs/administration.rst
@@ -175,6 +175,25 @@ being copied forward (``seed-new-release``) or devel results existing
 * Check `/running <https://autopkgtest.ubuntu.com/running/>`_ lists the new
   release, and check some package pages too.
 
+Removing an End of Life series
+------------------------------
+
+You’ll first want to stop the apache2 service so that browsing results will not
+fail while the database is being modified. Then there are two jobs which use
+the autopkgtest.db which will also need disabling. The ``download-results``
+service is constantly using the ``~/autopkgtest.db`` and will need to be
+stopped. The ``publish-db`` service which updates ``~/public/autopkgtest.db``
+is run minutely and will either need to be changed to hourly or ``chmod -x
+/home/ubuntu/webcontrol/publish-db`` to stop it from running.
+
+Once those steps are done then the rows can be deleted from the database.
+
+* ``sqlite3 -header -column autopkgtest.db "DELETE FROM current_version WHERE release='impish';"``
+* ``sqlite3 -header -column autopkgtest.db "DELETE FROM result WHERE result.test_id IN (SELECT test.id FROM test WHERE test.release='impish');"``
+* ``sqlite3 -header -column autopkgtest.db "DELETE FROM test WHERE test.release='impish';"``
+* ``sqlite3 -header -column autopkgtest.db "vacuum;"``
+
+
 Integration with GitHub and GitLab pull/merge requests
 ------------------------------------------------------