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 <[email protected]> markdown Andreas Tille <[email protected]> critterding (U) Android Tools Maintainers <[email protected]> android-platform-external-doclava Antoine Beaupré <[email protected]> monkeysphere (U) Bernhard R. Link <[email protected]> gv Christopher Hoskin <[email protected]> subethasmtp Cédric Boutillier <[email protected]> ruby-nmatrix (U) Daniel Kahn Gillmor <[email protected]> monkeysphere (U) David Prévot <[email protected]> php-sabre-event (U) php-sabre-vobject (U) Debian Go Packaging Team <[email protected]> go-cpe-dictionary golang-github-golang-geo golang-golang-x-debug vuls Debian Go Packaging Team <[email protected]> vuls Debian Install System Team <[email protected]> partman-swapfile Debian Java Maintainers <[email protected]> openhft-chronicle-bytes openhft-chronicle-network openhft-chronicle-threads openhft-chronicle-wire Debian Javascript Maintainers <[email protected]> node-solid-jose node-trust-jwa Debian Libvirt Maintainers <[email protected]> libvirt-tck Debian Multimedia Maintainers <[email protected]> mediagoblin Debian PHP PEAR Maintainers <[email protected]> php-sabre-event php-sabre-vobject Debian Privacy Tools Maintainers <[email protected]> monkeysphere Debian QA Group <[email protected]> markdown Debian Ruby Extras Maintainers <[email protected]> ruby-devise-i18n ruby-nmatrix Debian Science Maintainers <[email protected]> critterding yorick-optimpack Debian Security Tools <[email protected]> libewf Debian Tcl/Tk Packagers <[email protected]> tcltk-defaults Emmanuel Bourg <[email protected]> openhft-chronicle-bytes (U) openhft-chronicle-network (U) openhft-chronicle-threads (U) openhft-chronicle-wire (U) Francesco Paolo Lovergine <[email protected]> tcltk-defaults (U) Gabriele Giacone <[email protected]> critterding (U) Geert Stappers <[email protected]> urjtag Giulio Paci <[email protected]> m2m-aligner mitlm phonetisaurus tinysvm yamcha Guido Günther <[email protected]> libvirt-tck (U) Jameson Rollins <[email protected]> monkeysphere (U) Jelmer Vernooij <[email protected]> quasselc Jochen Friedrich <[email protected]> darkice Jonas Smedegaard <[email protected]> imip-agent mediagoblin (U) node-solid-jose (U) node-trust-jwa (U) Jose M Calhariz <[email protected]> librep sawfish Kai-Chung Yan <[email protected]> android-platform-external-doclava (U) Kai-Chung Yan <[email protected]> android-platform-external-doclava (U) Lennart Weller <[email protected]> nvidia-texture-tools Marc Bigler <[email protected]> darkice Mathieu Parent <[email protected]> php-sabre-vobject (U) Matt Kraai <[email protected]> markdown Michael Stapelberg <[email protected]> golang-github-golang-geo (U) golang-golang-x-debug (U) Nobuhiro Iwamatsu <[email protected]> go-cpe-dictionary (U) vuls (U) ownCloud for Debian maintainers <[email protected]> php-sabre-event (U) Pierre Chifflier <[email protected]> libewf (U) Samyak Jain <[email protected]> ruby-devise-i18n (U) Sergei Golovan <[email protected]> tcltk-defaults (U) Steffen Moeller <[email protected]> libtaverna2-server-java pluto-sat-code sump-logicanalyzer (U) Thibaut Paumard <[email protected]> yorick-optimpack (U) Thomas Goirand <[email protected]> dtc Thorsten Glaser <[email protected]> musescore-snapshot Uwe Hermann <[email protected]> urjtag Vincent Danjean <[email protected]> poti Yannick Heinrich <[email protected]> sump-logicanalyzer
signature.asc
Description: PGP signature
