On 23/08/21 at 19:29 -0300, Eriberto wrote: > Em seg., 23 de ago. de 2021 às 15:53, Lucas Nussbaum > <lu...@debian.org> escreveu: > > > > 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 > > Is possible/viable to insert the dates manually? I think it can fix > this inconsistency.
If the emails are available, it would be better to fix the code so that they can be imported, and then re-import from scratch (or just re-import the months with problems) Note that it's not a problem with missing dates: it's a problem with missing records in upload_history. Lucas
