--=-=-=
Content-Type: text/plain
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
--=-=-=
Content-Type: text/plain
Content-Disposition: inline; filename=trash-experimental.txt Content-Description: Removal candidates for experimental
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)
--=-=-=
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline; filename=trash-experimental-dd-list.txt Content-Transfer-Encoding: quoted-printable
Content-Description: Removal candidates for experimental (dd-list)
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
--=-=-=--
--==-=-Content-Type: application/pgp-signature; name="signature.asc"
-----BEGIN PGP SIGNATURE-----
iIgEARYKADAWIQR3hZU8YXPYylUJRxfDof4h+X+qzwUCZ3E73BIcYW5zZ2FyQGRl Ymlhbi5vcmcACgkQw6H+Ifl/qs8H7AD7BkS7pMwV0/w9Kt1KvvYXVvqWNxUQmdXX EBoL7WNZiWoA/0nzUxvTpP/mWDu2Bm9k7TZVjxxeNjnh5zwYHny6ZjIB
=klfg
-----END PGP SIGNATURE-----
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)