Petter Reinholdtsen: Brushing up on old packages in Xiph and Debian
Since my motivation boost in the beginning of the month caused me
to wrap up a new release of
liboggz, I have used the
same boost to wrap up new editions of
libfishsound,
liboggplay
and
libkate
too. These have been tagged in upstream git, but not yet published on
the Xiph download location. I am waiting for someone with access to
have time to move the tarballs there, I hope it will happen in a few
days. The same is the case for a minor update of liboggz too.
As I was looking at Xiph packages lacking updates, it occurred to
me that there are packages in Debian that have not received a new
upload in a long time. Looking for a way to identify them, I came
across the ltnu script from the
devscripts
package. It can sort by last update, packages maintained by a single
user/group, and is useful to figure out which packages a single
maintainer should have a look at. But I wanted a archive wide
summary. Based on the UDD SQL
query used by ltnu, I ended up with the following command:
#!/bin/sh env PGPASSWORD=udd-mirror psql --host=udd-mirror.debian.net --user=udd-mirror udd --command=" select source, max(version) as ver, max(date) as uploaded from upload_history where distribution='unstable' and source in (select source from sources where release='sid') group by source order by max(date) asc limit 50;"This will sort all source packages in Debian by upload date, and list the 50 oldest ones. The end result is a list of packages I suspect could use some attention:
source ver uploaded -----------------------------+-------------------------+------------------------ xserver-xorg-video-ivtvdev 1.1.2-1 2011-02-09 22:26:27+00 dynamite 0.1.1-2 2011-04-30 16:47:20+00 xkbind 2010.05.20-1 2011-05-02 22:48:05+00 libspctag 0.2-1 2011-09-22 18:47:07+00 gromit 20041213-9 2011-11-13 21:02:56+00 s3switch 0.1-1 2011-11-22 15:47:40+00 cd5 0.1-3 2011-12-07 21:19:05+00 xserver-xorg-video-glide 1.2.0-1 2011-12-30 16:50:48+00 blahtexml 0.9-1.1 2012-04-25 11:32:11+00 aggregate 1.6-7 2012-05-01 00:47:11+00 rtfilter 1.1-4 2012-05-11 12:50:00+00 sic 1.1-5 2012-05-11 19:10:31+00 kbdd 0.6-4 2012-05-12 07:33:32+00 logtop 0.4.3-1 2012-06-05 23:04:20+00 gbemol 0.3.2-2 2012-06-26 17:03:11+00 pidgin-mra 20100304-1 2012-06-29 23:07:41+00 mumudvb 1.7.1-1 2012-06-30 09:12:14+00 libdr-sundown-perl 0.02-1 2012-08-18 10:00:07+00 ztex-bmp 20120314-2 2012-08-18 19:47:55+00 display-dhammapada 1.0-0.1 2012-12-19 12:02:32+00 eot-utils 1.1-1 2013-02-19 17:02:28+00 multiwatch 1.0.0-rc1+really1.0.0-1 2013-02-19 17:02:35+00 pidgin-latex 1.5.0-1 2013-04-04 15:03:43+00 libkeepalive 0.2-1 2013-04-08 22:00:07+00 dfu-programmer 0.6.1-1 2013-04-23 13:32:32+00 libb64 1.2-3 2013-05-05 21:04:51+00 i810switch 0.6.5-7.1 2013-05-10 13:03:18+00 premake4 4.3+repack1-2 2013-05-31 12:48:51+00 unagi 0.3.4-1 2013-06-05 11:19:32+00 mod-vhost-ldap 2.4.0-1 2013-07-12 07:19:00+00 libapache2-mod-ldap-userdir 1.1.19-2.1 2013-07-12 21:22:48+00 w9wm 0.4.2-8 2013-07-18 11:49:10+00 vish 0.0.20130812-1 2013-08-12 21:10:37+00 xfishtank 2.5-1 2013-08-20 17:34:06+00 wap-wml-tools 0.0.4-7 2013-08-21 16:19:10+00 ttysnoop 0.12d-6 2013-08-24 17:33:09+00 libkaz 1.21-2 2013-09-02 16:00:10+00 rarpd 0.981107-9 2013-09-02 19:48:24+00 libimager-qrcode-perl 0.033-1.2 2013-09-04 21:06:31+00 dov4l 0.9+repack-1 2013-09-22 19:33:25+00 textdraw 0.2+ds-0+nmu1 2013-10-07 21:25:03+00 gzrt 0.8-1 2013-10-08 06:33:13+00 away 0.9.5+ds-0+nmu2 2013-10-25 01:18:18+00 jshon 20131010-1 2013-11-30 00:00:11+00 libstar-parser-perl 0.59-4 2013-12-23 21:50:43+00 gcal 3.6.3-3 2013-12-29 18:33:29+00 fonts-larabie 1:20011216-5 2014-01-02 21:20:49+00 ccd2iso 0.3-4 2014-01-28 06:33:35+00 kerneltop 0.91-1 2014-02-04 12:03:30+00 vera++ 1.2.1-2 2014-02-04 21:21:37+00 (50 rows)So there are 8 packages last uploaded to unstable in 2011, 12 packages in 2012 and 26 packages in 2013. I suspect their maintainers need help and we should all offer our assistance. I already contacted two of them and hope the rest of the Debian community will chip in to help too. We should ensure any Debian specific patches are passed upstream if they still exist, that the package is brought up to speed with the latest Debian policy, as well as ensure the source can built with the current compiler set in Debian. As usual, if you use Bitcoin and want to show your support of my activities, please send Bitcoin donations to my address 15oWEoG9dUPovwmUL9KWAnYRtNJEkP1u1b.