Hi,
On 22/08/21 at 23:15 +0200, Mattia Rizzolo wrote:
> On Sun, Aug 22, 2021 at 05:43:19PM -0300, Eriberto Mota wrote:
> > Hi guys,
> >
> > Today I noticed an issue
>
> You reported true things, but I doubt this is in any way related to the
> current issue.
>
> Are you saying these inconsistencies appeared just now? I'd suspect
> those things have been broken for a decade already.
>
> > $ LANG=C psql -P pager=off service=udd -c $'SELECT bapase.source as
> > "Source Name", bapase.upload_date as "Upload bapase",
> > upload_history.date as "Upload upload_history" FROM bapase JOIN
>
> Incidentally, I know nothing of bapase.
bapase is just a view (see '\d+ bapase' in psql)
> > As I said, no dates in bapase. However, there is another problem here:
> > the last date for edb in upload_history is 2009-12-20 but 2013-07-03
> > in tracker.debian.org. The same for pal: 2011-12-13 in upload_history
> > and 2014-04-26 in tracker.
>
> For these kind of bugs, remember that the upload_history is feeded via
> the debian-devel-changes mails, parsed one by one. the implementation
> of it has changed a couple of times over the many years (though it has
> been the same for at least the last 7). So it's realistic to think that
> a few uploads might be missing here and there.
Indeed, the upload_history implementation is fragile (or more correctly:
its data source is fragile). There are a few uploads whose emails to
debian-devel-changes could not be parsed for some reason.
You can get the list of packages currently in unstable with no
corresponding upload in upload_history:
udd=> select s.source, s.version from sources s left join upload_history uh using (source, version) where s.release='sid' and uh.version is null order by source asc;
source | version
------------------------------+-----------------------------
binutils-z80 | 4
dvhtool | 1.0.1-5
edb | 1.31-3
kerneltop | 0.91-2
libmime-explode-perl | 0.39-3
libnet-jabber-loudmouth-perl | 0.07-3
libparse-exuberantctags-perl | 1.02-1
libsgml-parser-opensp-perl | 0.994-3
libshairport | 1.2.1~git20120510.cbed0c1-3
libsocket-linux-perl | 0.01-2
libtext-levenshteinxs-perl | 0.03-4
libxml-grddl-perl | 0.004-2
pal | 0.4.3-8.1
scheme2c | 2012.10.14-1
vowpal-wabbit | 7.3-1.1
(15 rows)
Lucas
Attachment:
signature.asc
Description: PGP signature