Re: upload_history not updated (Was: UDD mirror not up to date)
Hi guys,
Today I noticed an issue in my report[1] at the end of the first
section (called "Sources in Debian Sid including orphan, by upload
dates"). Some packages don't have an upload date. This is very common
for packages uploaded a few hours ago. However, I can see some
packages not updated for a very long time, such as edb and pal.
[1] https://people.debian.org/~eriberto/udd/help_a_package.html
These packages don't have an upload date in bapase but it is not true
for upload_history. See below:
$ 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
upload_history ON bapase.source=upload_history.source WHERE
bapase.source IN (\'pal\',\'edb\');'
Source Name | Upload bapase | Upload upload_history
-------------+---------------+------------------------
edb | | 1999-05-26 03:19:50+00
edb | | 1999-07-30 18:53:01+00
edb | | 1999-08-16 18:52:33+00
edb | | 1999-09-20 18:56:18+00
edb | | 2000-02-16 10:54:55+00
edb | | 2002-02-07 20:00:07+00
edb | | 2002-04-03 04:17:13+00
edb | | 2004-03-23 09:47:05+00
edb | | 2006-11-02 23:32:56+00
edb | | 2006-11-18 12:17:08+00
edb | | 2006-11-19 22:03:05+00
edb | | 2007-09-14 21:32:04+00
edb | | 2009-08-30 06:32:08+00
edb | | 2009-12-20 12:50:53+00
pal | | 2004-03-31 21:14:16+00
pal | | 2004-05-01 15:32:28+00
pal | | 2004-05-08 18:17:03+00
pal | | 2004-06-09 20:32:11+00
pal | | 2005-11-14 17:47:08+00
pal | | 2008-06-02 10:17:04+00
pal | | 2008-06-03 06:47:06+00
pal | | 2008-06-19 16:47:04+00
pal | | 2008-07-05 19:32:24+00
pal | | 2008-07-22 17:50:19+00
pal | | 2008-08-03 18:03:08+00
pal | | 2008-09-07 21:04:28+00
pal | | 2008-09-29 11:02:03+00
pal | | 2009-05-17 16:32:07+00
pal | | 2009-09-24 07:32:17+00
pal | | 2010-12-01 20:48:12+00
pal | | 2011-08-27 21:48:09+00
pal | | 2011-12-13 23:33:45+00
(32 rows)
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.
Regards,
Eriberto
Reply to: