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