Re: Lintian latest-debian-changelog-entry-reuses-existing-version report for (old-)stable?
Hi Chris,
On 2019-05-27 14:24, Chris Lamb wrote:
>>>> Are there Lintian reports available for (old-)stable and testing [..]
> […]
>>> Unless someone else can correct me, I don't believe so… We have
>>> enough trouble keeping up with unstable as it is sometimes.
> […]
>> Are logs from all the lintian runs archived somewhere? Then I could try
>> to grep them for packages having emitted this tag in the past ...
>
> Hm, try /srv/lintian.debian.org/logs on lindsay.debian.org, otherwise
> not.
nothing interesting :-(
> (I wonder if there is a more direct way of getting what you want here
> though... UDD?)
You ask nasty questions :-)
select distinct a.source, regexp_replace(a.version, '\d*:', '') as noepoch, a.version, a.date, a.distribution, b.version, b.date, b.distribution from upload_history as a, upload_history as b where a.source = b.source and a.version < b.version and regexp_replace(a.version, '\d*:', '') = regexp_replace(b.version, '\d*:', '') order by b.date desc;
(I'm sure that could be done more elegant)
(108 rows)
lets see which of these are still in service:
select distinct p.source, p.source_version, p.release, a.date, a.version, b.date, b.version from packages as p, upload_history as a, upload_history as b where a.source = b.source and a.version < b.version and regexp_replace(a.version, '\d*:', '') = regexp_replace(b.version, '\d*:', '') and p.source = a.source and (p.source_version = a.version or p.source_version = b.version) and (p.release = 'sid' or p.release = 'buster' or p.release = 'stretch' or p.release = 'jessie') order by p.release,p.source;
source | source_version | release | date | version | date | version
-----------------------+----------------+---------+------------------------+---------+------------------------+-----------
d3-format | 1:1.0.2-1 | buster | 2016-12-05 14:00:10+00 | 1.0.2-1 | 2017-10-09 20:49:36+00 | 1:1.0.2-1
dot-forward | 1:0.71-3 | buster | 2000-07-23 18:52:21+00 | 0.71-3 | 2019-01-11 21:05:52+00 | 1:0.71-3
fastforward | 1:0.51-4 | buster | 2000-07-23 18:52:28+00 | 0.51-4 | 2019-01-12 23:49:18+00 | 1:0.51-4
libconvert-units-perl | 1:0.43-2 | buster | 2001-12-18 20:09:31+00 | 0.43-2 | 2015-07-21 21:37:58+00 | 1:0.43-2
t-digest | 1:3.0-1 | buster | 2014-11-05 13:00:10+00 | 3.0-1 | 2015-05-12 07:04:51+00 | 1:3.0-1
dot-forward | 1:0.71-2 | jessie | 1999-11-03 19:55:06+00 | 0.71-2 | 2012-04-12 11:47:25+00 | 1:0.71-2
fastforward | 1:0.51-3 | jessie | 1999-09-21 18:53:54+00 | 0.51-3 | 2011-04-01 12:32:20+00 | 1:0.51-3
libconvert-units-perl | 1:0.43-1 | jessie | 2001-12-16 20:11:47+00 | 0.43-1 | 2006-02-22 22:32:07+00 | 1:0.43-1
naist-jdic | 1:0.4.3-4 | jessie | 2008-09-30 00:32:09+00 | 0.4.3-4 | 2013-06-11 10:33:40+00 | 1:0.4.3-4
ucspi-tcp | 1:0.88-3 | jessie | 2001-04-05 21:36:48+00 | 0.88-3 | 2009-10-15 19:00:32+00 | 1:0.88-3
zope-quotafolder | 1:0.1.1-1 | jessie | 2005-03-24 22:03:14+00 | 0.1.1-1 | 2011-11-01 01:48:16+00 | 1:0.1.1-1
d3-format | 1:1.0.2-1 | sid | 2016-12-05 14:00:10+00 | 1.0.2-1 | 2017-10-09 20:49:36+00 | 1:1.0.2-1
dot-forward | 1:0.71-3 | sid | 2000-07-23 18:52:21+00 | 0.71-3 | 2019-01-11 21:05:52+00 | 1:0.71-3
fastforward | 1:0.51-4 | sid | 2000-07-23 18:52:28+00 | 0.51-4 | 2019-01-12 23:49:18+00 | 1:0.51-4
libconvert-units-perl | 1:0.43-2 | sid | 2001-12-18 20:09:31+00 | 0.43-2 | 2015-07-21 21:37:58+00 | 1:0.43-2
t-digest | 1:3.0-1 | sid | 2014-11-05 13:00:10+00 | 3.0-1 | 2015-05-12 07:04:51+00 | 1:3.0-1
libconvert-units-perl | 1:0.43-2 | stretch | 2001-12-18 20:09:31+00 | 0.43-2 | 2015-07-21 21:37:58+00 | 1:0.43-2
naist-jdic | 1:0.4.3-7 | stretch | 2009-06-29 15:34:09+00 | 0.4.3-7 | 2015-12-13 07:19:49+00 | 1:0.4.3-7
t-digest | 1:3.0-1 | stretch | 2014-11-05 13:00:10+00 | 3.0-1 | 2015-05-12 07:04:51+00 | 1:3.0-1
xfonts-kappa20 | 1:0.396-2 | stretch | 2005-03-13 03:02:30+00 | 0.396-2 | 2015-12-21 16:34:45+00 | 1:0.396-2
(20 rows)
OK, two more bugs needed in sid for packages not caught by lintian
Andreas
Reply to: