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 <andrea@pappacoda.it> markdown Andreas Tille <tille@debian.org> critterding (U) Android Tools Maintainers <android-tools-devel@lists.alioth.debian.org> android-platform-external-doclava Antoine Beaupré <anarcat@debian.org> monkeysphere (U) Bernhard R. Link <brlink@debian.org> gv Christopher Hoskin <mans0954@debian.org> subethasmtp Cédric Boutillier <boutil@debian.org> ruby-nmatrix (U) Daniel Kahn Gillmor <dkg@fifthhorseman.net> monkeysphere (U) David Prévot <taffit@debian.org> php-sabre-event (U) php-sabre-vobject (U) Debian Go Packaging Team <pkg-go-maintainers@lists.alioth.debian.org> go-cpe-dictionary golang-github-golang-geo golang-golang-x-debug vuls Debian Go Packaging Team <team+pkg-go@tracker.debian.org> vuls Debian Install System Team <debian-boot@lists.debian.org> partman-swapfile Debian Java Maintainers <pkg-java-maintainers@lists.alioth.debian.org> openhft-chronicle-bytes openhft-chronicle-network openhft-chronicle-threads openhft-chronicle-wire Debian Javascript Maintainers <pkg-javascript-devel@lists.alioth.debian.org> node-solid-jose node-trust-jwa Debian Libvirt Maintainers <pkg-libvirt-maintainers@lists.alioth.debian.org> libvirt-tck Debian Multimedia Maintainers <pkg-multimedia-maintainers@lists.alioth.debian.org> mediagoblin Debian PHP PEAR Maintainers <pkg-php-pear@lists.alioth.debian.org> php-sabre-event php-sabre-vobject Debian Privacy Tools Maintainers <pkg-privacy-maintainers@lists.alioth.debian.org> monkeysphere Debian QA Group <packages@qa.debian.org> markdown Debian Ruby Extras Maintainers <pkg-ruby-extras-maintainers@lists.alioth.debian.org> ruby-devise-i18n ruby-nmatrix Debian Science Maintainers <debian-science-maintainers@lists.alioth.debian.org> critterding yorick-optimpack Debian Security Tools <team+pkg-security@tracker.debian.org> libewf Debian Tcl/Tk Packagers <pkg-tcltk-devel@lists.alioth.debian.org> tcltk-defaults Emmanuel Bourg <ebourg@apache.org> openhft-chronicle-bytes (U) openhft-chronicle-network (U) openhft-chronicle-threads (U) openhft-chronicle-wire (U) Francesco Paolo Lovergine <frankie@debian.org> tcltk-defaults (U) Gabriele Giacone <1o5g4r8o@gmail.com> critterding (U) Geert Stappers <stappers@debian.org> urjtag Giulio Paci <giuliopaci@gmail.com> m2m-aligner mitlm phonetisaurus tinysvm yamcha Guido Günther <agx@sigxcpu.org> libvirt-tck (U) Jameson Rollins <jrollins@finestructure.net> monkeysphere (U) Jelmer Vernooij <jelmer@debian.org> quasselc Jochen Friedrich <jochen@scram.de> darkice Jonas Smedegaard <dr@jones.dk> imip-agent mediagoblin (U) node-solid-jose (U) node-trust-jwa (U) Jose M Calhariz <jose@calhariz.com> librep sawfish Kai-Chung Yan <seamlik@debian.org> android-platform-external-doclava (U) Kai-Chung Yan <seamlikok@gmail.com> android-platform-external-doclava (U) Lennart Weller <lhw@ring0.de> nvidia-texture-tools Marc Bigler <marc@towards.ch> darkice Mathieu Parent <sathieu@debian.org> php-sabre-vobject (U) Matt Kraai <kraai@debian.org> markdown Michael Stapelberg <stapelberg@debian.org> golang-github-golang-geo (U) golang-golang-x-debug (U) Nobuhiro Iwamatsu <iwamatsu@debian.org> go-cpe-dictionary (U) vuls (U) ownCloud for Debian maintainers <pkg-owncloud-maintainers@lists.alioth.debian.org> php-sabre-event (U) Pierre Chifflier <pollux@debian.org> libewf (U) Samyak Jain <samyak.jn11@gmail.com> ruby-devise-i18n (U) Sergei Golovan <sgolovan@debian.org> tcltk-defaults (U) Steffen Moeller <moeller@debian.org> libtaverna2-server-java pluto-sat-code sump-logicanalyzer (U) Thibaut Paumard <thibaut@debian.org> yorick-optimpack (U) Thomas Goirand <zigo@debian.org> dtc Thorsten Glaser <tg@mirbsd.de> musescore-snapshot Uwe Hermann <uwe@debian.org> urjtag Vincent Danjean <vdanjean@debian.org> poti Yannick Heinrich <yannick.heinrich@gmail.com> sump-logicanalyzer
Attachment:
signature.asc
Description: PGP signature