Re: upload_history not updated (Was: UDD mirror not up to date)

[Lucas Nussbaum <lucas@debian.org>]

On 23/08/21 at 19:29 -0300, Eriberto wrote:
> Em seg., 23 de ago. de 2021 às 15:53, Lucas Nussbaum
> <lucas@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