mass-removing packages that missed both jessie and stretch?
Hi,
It is becoming increasingly painful to do QA work due to the number of
packages in unstable that have been completely broken for a long time.
I've been pondering with ignoring packages not in testing when doing
archive rebuilds, but that's not really a good solution.
So, I propose that we remove from the archive all packages that:
were in unstable at the time of the jessie freeze
AND
were not in jessie at the time of the release
AND
where in unstable at the time of the stretch freeze
AND
where not in stretch at the time of the release
AND
are still not in testing
AND
were not uploaded over the last 6 months
I propose the following process:
- I would file a bug against each of those packages, asking whether it
should be removed, and stating that the bug should be closed if the
package should stay in Debian.
- after a month, I would reassign/retitle the bugs that are still open
to ftp.debian.org to request the package removal.
I don't plan to argue: if someone cares enough about the package to
close the bug, so be it.
Here is a list, with the popcon insts, and the last upload:
source | insts | last_upload
-----------------------------+-------+------------------------
hyde | 23 | 2016-12-25 05:33:25+00
zoneminder | 686 | 2016-12-10 03:05:33+00
php-ps | 654 | 2016-12-02 16:00:10+00
red5 | 57 | 2016-11-05 10:10:28+00
node-jsdom | 23 | 2016-10-25 11:30:42+00
netdde | 22 | 2016-10-24 01:08:38+00
trackballs | 201 | 2016-10-04 22:35:37+00
phoneui-apps | 3 | 2016-09-26 19:21:08+00
interchange | 2 | 2016-09-05 22:26:06+00
nipy | 199 | 2016-09-05 05:06:07+00
libjpeg9 | 11301 | 2016-08-01 22:40:11+00
trac-wikiprint | 45 | 2016-07-30 22:26:26+00
gpointing-device-settings | 827 | 2016-07-18 11:00:10+00
faumachine | 17 | 2016-06-16 11:00:53+00
pisa | 130 | 2016-06-09 22:46:19+00
jarisplayer | 19 | 2016-05-10 09:50:38+00
openmeeg | 115 | 2016-05-04 23:23:03+00
hurd-libfuse | 3 | 2016-05-03 00:19:54+00
python-django-feincms | 18 | 2016-04-28 11:00:26+00
jclicmoodle | 3 | 2016-04-23 19:20:15+00
calendarserver | 76 | 2016-03-06 12:34:07+00
creepy | 35 | 2016-03-03 15:20:04+00
udev-discover | 67 | 2016-02-22 22:30:30+00
janest-core | 6 | 2016-02-04 18:20:50+00
gnu-fdisk | 628 | 2016-01-27 12:22:08+00
openbve | 88 | 2016-01-03 16:37:30+00
controlaula | 6 | 2015-12-15 15:50:26+00
bashdb | 138 | 2015-10-10 09:19:33+00
python-lua | 10 | 2015-09-10 12:19:56+00
dsc-statistics | 4 | 2015-09-05 13:34:31+00
cipux-cat-web | 1 | 2015-07-23 21:34:52+00
mediatomb | 626 | 2015-07-13 18:04:36+00
jitsi | 588 | 2015-06-15 16:02:19+00
xnetcardconfig | 13 | 2015-01-28 00:19:25+00
django-conneg | 3 | 2014-12-30 01:33:27+00
android-permissions | | 2014-11-17 22:03:45+00
slmon | 18 | 2014-11-07 12:51:05+00
qpid-cpp | 143 | 2014-10-26 15:59:44+00
armory | 80 | 2014-10-25 13:00:07+00
unetbootin | 4138 | 2014-10-14 21:59:03+00
moonshot-trust-router | 2 | 2014-10-07 18:48:57+00
drgeo | 171 | 2014-09-07 18:33:38+00
emscripten | 8 | 2014-08-21 09:04:41+00
shush | 27 | 2014-07-04 01:48:35+00
qpid-tools | 5 | 2014-06-03 09:39:12+00
cutter-testing-framework | 129 | 2014-06-02 06:04:07+00
evernote-mode | 33 | 2014-05-01 16:21:18+00
moodle-debian-edu-theme | 7 | 2014-03-25 11:33:56+00
mtpfs | 989 | 2014-02-09 00:18:37+00
logkeys | 64 | 2014-02-04 18:48:33+00
planner-el | 50 | 2014-01-13 06:48:32+00
django-ldapdb | 2 | 2013-12-28 05:00:08+00
elmerfem | 62 | 2013-12-17 17:33:47+00
rt-extension-assettracker | 1 | 2013-10-17 01:18:17+00
xgraph | 76 | 2013-09-19 15:08:24+00
phoneuid | 3 | 2013-09-07 03:19:19+00
varnish-agent | 3 | 2013-09-02 01:00:05+00
twitter-recess | 5 | 2013-09-01 17:49:06+00
couchdb | 140 | 2013-08-31 09:18:19+00
mnemonicode | 19 | 2013-08-06 15:01:11+00
pearpc | 39 | 2013-07-25 21:33:29+00
sugar-poll-activity | 1 | 2013-07-16 16:20:57+00
sugar-jigsawpuzzle-activity | 1 | 2013-07-16 16:20:26+00
mod-spamhaus | 34 | 2013-07-13 10:19:19+00
gregorio | 4 | 2013-06-23 11:47:53+00
tmview | 27 | 2013-06-08 17:05:04+00
flickrfs | 53 | 2013-06-03 19:33:06+00
babel | 30 | 2013-06-02 22:48:19+00
djbdns | 137 | 2013-05-28 15:48:22+00
xburst-tools | 2 | 2013-02-22 04:32:58+00
openclipart2 | 372 | 2012-11-19 15:36:00+00
node-bones | 3 | 2012-09-20 09:17:56+00
z88dk | 32 | 2012-05-30 10:20:29+00
jwhois | 176 | 2012-05-14 12:04:18+00
tile | 88 | 2012-05-10 01:34:37+00
icewm-themes | 126 | 2012-04-30 21:49:04+00
rinputd | 4 | 2012-04-12 21:10:55+00
libsearch-estraier-perl | 5 | 2012-03-30 21:34:41+00
apt-spy | 597 | 2012-03-03 15:47:32+00
pyformex | 20 | 2012-01-19 20:51:13+00
diet | 5 | 2012-01-13 21:32:24+00
azureus | 326 | 2011-12-04 21:02:52+00
cutechess | 15 | 2011-11-14 22:17:43+00
pyfltk | 18 | 2011-11-09 23:33:00+00
ocamlduce | 9 | 2011-11-01 21:05:53+00
node-jquery | 11 | 2011-10-30 13:17:15+00
node-zlib | 2 | 2011-10-16 18:33:45+00
fso-common | | 2011-10-04 21:02:08+00
fusioninventory-for-glpi | 1 | 2011-09-20 09:03:17+00
sbackup | 50 | 2010-04-20 04:34:00+00
libtext-vimcolor-perl | 51 | 2010-02-13 16:06:04+00
libxml-validate-perl | 25 | 2009-10-14 04:47:04+00
cl-rlc | 9 | 2009-08-04 01:17:03+00
uif2iso | 88 | 2009-02-21 11:02:23+00
imview-doc | 13 | 2008-07-14 06:47:40+00
qemu-launcher | 328 | 2007-06-09 21:32:07+00
sawfish-merlin-ugliness | 51 | 2004-07-28 13:47:09+00
And the corresponding UDD query (the initial list of packages was generated by
parsing Sources files):
select distinct sources.source, insts, last_upload
from sources
left join popcon_src pc on sources.source = pc.source
left join (
select source, max(date) as last_upload from upload_history group by source
) uh on sources.source = uh.source
where sources.source in ('android-permissions', 'apt-spy', 'ardesia', 'armory',
'asterisk-chan-capi', 'autotrace', 'azureus', 'babel', 'bandwidthcalc',
'bashdb', 'bitcoin', 'calendarserver', 'cipux-cat-web', 'cl-rlc', 'clisp',
'controlaula', 'couchdb', 'creepy', 'cutechess', 'cutter-testing-framework',
'diet', 'django-conneg', 'django-ldapdb', 'djbdns', 'dogtag-pki', 'doxymacs',
'drgeo', 'drift', 'dsc-statistics', 'elmerfem', 'emscripten', 'evernote-mode',
'facturlinex2', 'faumachine', 'flickrfs', 'fontmatrix', 'freeipa',
'fso-common', 'fusioninventory-for-glpi', 'gcc-snapshot', 'get-iplayer',
'gnu-fdisk', 'gpointing-device-settings', 'gregorio', 'hurd', 'hurd-libfuse',
'hyde', 'icewm-themes', 'imview-doc', 'interchange', 'janest-core',
'jarisplayer', 'jclicmoodle', 'jitsi', 'jsonbot', 'jwhois',
'libapache2-mod-auth-memcookie', 'libjpeg8', 'libjpeg9', 'libmemcache',
'libnss-mysql-bg', 'libsearch-estraier-perl', 'libsyncml',
'libtext-vimcolor-perl', 'libxml-validate-perl', 'litecoin',
'llvm-toolchain-snapshot', 'logkeys', 'mediatomb', 'mnemonicode',
'mod-spamhaus', 'moodle', 'moodle-debian-edu-theme', 'moonshot-trust-router',
'mozart', 'mozart-stdlib', 'mtpfs', 'netdde', 'netgen', 'nipy', 'nipype',
'node-bones', 'node-jquery', 'node-jsdom', 'node-zlib', 'ocamlduce', 'openbve',
'openclipart2', 'openmeeg', 'pearpc', 'phoneui-apps', 'phoneuid', 'php-ps',
'pisa', 'planner-el', 'pyfltk', 'pyformex', 'pyg', 'python-django-feincms',
'python-glpk', 'python-lua', 'qemu-launcher', 'qpid-cpp', 'qpid-tools', 'red5',
'rggobi', 'rinputd', 'rt-extension-assettracker', 'sawfish-merlin-ugliness',
'sbackup', 'shush', 'slmon', 'sugar-jigsawpuzzle-activity',
'sugar-physics-activity', 'sugar-poll-activity', 'tcl8.4', 'tile', 'tk8.4',
'tmview', 'trac-wikiprint', 'trackballs', 'tt-rss', 'twitter-recess',
'udev-discover', 'uif2iso', 'underscore.logger', 'unetbootin', 'varnish-agent',
'xburst-tools', 'xdeb', 'xgraph', 'xindy', 'xnetcardconfig', 'z88dk',
'zoneminder')
and release='sid'
and extra_source_only is null
and last_upload < '2017-01-19'
order by last_upload desc;
- Lucas
Reply to: