Hi, I'm wondering how we can clean up suites like experimental and unstable. They tend to slowly accumulate cruft that nobody cleans up, including no longer installable packages.
As a very simple start, I would like to remove packages from experimental that haven't seen an upload for a long time (arbitrarily chosen as before 2020-01-01 for the list below). What do people think about this? I would also like to do something similar to unstable; maybe start with packages uploaded before some arbitrary date that are also not included in any of oldstable/stable/testing. These can cause problems like wasting time to investigate cruft removals, build failures, ... Does that seem reasonable as well? Ansgar
projectb=> select s.source, s.created from source s
where exists (
select 1 from src_associations sa
where s.id = sa.source and
sa.suite = (select id from suite where suite_name = 'experimental')
)
and s.created < '2020-01-01' order by source;
source | created
-----------------------------------+-------------------------------
android-platform-external-doclava | 2019-07-24 21:08:04.691192+00
critterding | 2014-11-03 01:19:08.643578+00
darkice | 2019-03-24 11:18:56.087124+00
dtc | 2012-06-08 09:17:11.189323+00
go-cpe-dictionary | 2018-12-26 05:34:06.439036+00
golang-github-golang-geo | 2017-03-09 15:19:27.388525+00
golang-golang-x-debug | 2017-03-23 09:03:43.615567+00
gv | 2019-03-09 20:41:24.058607+00
imip-agent | 2019-01-06 13:34:33.740546+00
libewf | 2018-12-28 20:47:47.223343+00
librep | 2018-08-25 05:34:08.814689+00
libtaverna2-server-java | 2013-11-24 21:20:33.311726+00
libvirt-tck | 2011-11-13 15:07:12.072289+00
m2m-aligner | 2016-04-12 10:38:28.348764+00
markdown | 2019-12-28 20:57:03.304098+00
mediagoblin | 2017-08-28 13:19:49.32023+00
mitlm | 2016-04-24 16:23:21.734803+00
monkeysphere | 2019-05-19 23:33:52.925219+00
musescore-snapshot | 2019-07-05 00:19:11.735843+00
node-solid-jose | 2019-09-27 10:05:56.642068+00
node-trust-jwa | 2019-02-04 04:36:38.354632+00
nvidia-texture-tools | 2016-05-18 10:32:37.829021+00
openhft-chronicle-bytes | 2018-09-14 06:04:31.457889+00
openhft-chronicle-network | 2018-09-17 03:51:04.998927+00
openhft-chronicle-threads | 2018-09-15 20:35:37.601005+00
openhft-chronicle-wire | 2018-09-16 17:50:13.421894+00
partman-swapfile | 2019-03-12 04:54:30.304068+00
phonetisaurus | 2016-05-05 16:29:26.102649+00
php-sabre-event | 2015-11-06 01:20:46.165676+00
php-sabre-vobject | 2016-04-07 01:48:57.375779+00
pluto-sat-code | 2018-03-01 22:06:10.485772+00
poti | 2013-01-14 14:47:46.613882+00
quasselc | 2017-01-14 21:36:32.548429+00
ruby-devise-i18n | 2019-06-03 15:34:25.854689+00
ruby-nmatrix | 2016-03-03 15:26:31.250004+00
sawfish | 2019-07-19 15:35:40.94432+00
subethasmtp | 2017-12-21 12:43:37.751214+00
sump-logicanalyzer | 2011-07-27 07:17:07.488676+00
tcltk-defaults | 2019-02-24 20:54:53.737672+00
tinysvm | 2013-02-16 13:48:04.758297+00
urjtag | 2016-12-14 21:36:28.988139+00
vuls | 2019-06-18 23:16:21.087982+00
yamcha | 2017-09-25 21:34:17.955363+00
yorick-optimpack | 2017-01-08 07:03:14.977687+00
(44 rows)
Andrea Pappacoda <and...@pappacoda.it> markdown Andreas Tille <ti...@debian.org> critterding (U) Android Tools Maintainers <android-tools-de...@lists.alioth.debian.org> android-platform-external-doclava Antoine Beaupré <anar...@debian.org> monkeysphere (U) Bernhard R. Link <brl...@debian.org> gv Christopher Hoskin <mans0...@debian.org> subethasmtp Cédric Boutillier <bou...@debian.org> ruby-nmatrix (U) Daniel Kahn Gillmor <d...@fifthhorseman.net> monkeysphere (U) David Prévot <taf...@debian.org> php-sabre-event (U) php-sabre-vobject (U) Debian Go Packaging Team <pkg-go-maintain...@lists.alioth.debian.org> go-cpe-dictionary golang-github-golang-geo golang-golang-x-debug vuls Debian Go Packaging Team <team+pkg...@tracker.debian.org> vuls Debian Install System Team <debian-b...@lists.debian.org> partman-swapfile Debian Java Maintainers <pkg-java-maintain...@lists.alioth.debian.org> openhft-chronicle-bytes openhft-chronicle-network openhft-chronicle-threads openhft-chronicle-wire Debian Javascript Maintainers <pkg-javascript-de...@lists.alioth.debian.org> node-solid-jose node-trust-jwa Debian Libvirt Maintainers <pkg-libvirt-maintain...@lists.alioth.debian.org> libvirt-tck Debian Multimedia Maintainers <pkg-multimedia-maintain...@lists.alioth.debian.org> mediagoblin Debian PHP PEAR Maintainers <pkg-php-p...@lists.alioth.debian.org> php-sabre-event php-sabre-vobject Debian Privacy Tools Maintainers <pkg-privacy-maintain...@lists.alioth.debian.org> monkeysphere Debian QA Group <packa...@qa.debian.org> markdown Debian Ruby Extras Maintainers <pkg-ruby-extras-maintain...@lists.alioth.debian.org> ruby-devise-i18n ruby-nmatrix Debian Science Maintainers <debian-science-maintain...@lists.alioth.debian.org> critterding yorick-optimpack Debian Security Tools <team+pkg-secur...@tracker.debian.org> libewf Debian Tcl/Tk Packagers <pkg-tcltk-de...@lists.alioth.debian.org> tcltk-defaults Emmanuel Bourg <ebo...@apache.org> openhft-chronicle-bytes (U) openhft-chronicle-network (U) openhft-chronicle-threads (U) openhft-chronicle-wire (U) Francesco Paolo Lovergine <fran...@debian.org> tcltk-defaults (U) Gabriele Giacone <1o5g4...@gmail.com> critterding (U) Geert Stappers <stapp...@debian.org> urjtag Giulio Paci <giuliop...@gmail.com> m2m-aligner mitlm phonetisaurus tinysvm yamcha Guido Günther <a...@sigxcpu.org> libvirt-tck (U) Jameson Rollins <jroll...@finestructure.net> monkeysphere (U) Jelmer Vernooij <jel...@debian.org> quasselc Jochen Friedrich <joc...@scram.de> darkice Jonas Smedegaard <d...@jones.dk> imip-agent mediagoblin (U) node-solid-jose (U) node-trust-jwa (U) Jose M Calhariz <j...@calhariz.com> librep sawfish Kai-Chung Yan <seam...@debian.org> android-platform-external-doclava (U) Kai-Chung Yan <seamli...@gmail.com> android-platform-external-doclava (U) Lennart Weller <l...@ring0.de> nvidia-texture-tools Marc Bigler <m...@towards.ch> darkice Mathieu Parent <sath...@debian.org> php-sabre-vobject (U) Matt Kraai <kr...@debian.org> markdown Michael Stapelberg <stapelb...@debian.org> golang-github-golang-geo (U) golang-golang-x-debug (U) Nobuhiro Iwamatsu <iwama...@debian.org> go-cpe-dictionary (U) vuls (U) ownCloud for Debian maintainers <pkg-owncloud-maintain...@lists.alioth.debian.org> php-sabre-event (U) Pierre Chifflier <pol...@debian.org> libewf (U) Samyak Jain <samyak.j...@gmail.com> ruby-devise-i18n (U) Sergei Golovan <sgolo...@debian.org> tcltk-defaults (U) Steffen Moeller <moel...@debian.org> libtaverna2-server-java pluto-sat-code sump-logicanalyzer (U) Thibaut Paumard <thib...@debian.org> yorick-optimpack (U) Thomas Goirand <z...@debian.org> dtc Thorsten Glaser <t...@mirbsd.de> musescore-snapshot Uwe Hermann <u...@debian.org> urjtag Vincent Danjean <vdanj...@debian.org> poti Yannick Heinrich <yannick.heinr...@gmail.com> sump-logicanalyzer
signature.asc
Description: PGP signature
