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
