Bug#694669: UDD: Missing data in the history.sources_count table

[Josue Abarca <jmaslibre@debian.org>]

Package: qa.debian.org
Severity: normal
User: qa.debian.org@packages.debian.org
Usertags: udd

I was checking the information in the table history.sources_count in
UDD, and I see that there is no data in the columns: total_sid_main,
total_sid_contrib, total_sid_nonfree.

Query:
udd=> select ts,total_sid_main, total_sid_contrib, total_sid_nonfree, vcstype_git from history.sources_count;

To reproduce:
$ ssh wagner.debian.org
$ psql service=udd
udd=> select ts,total_sid_main, total_sid_contrib, total_sid_nonfree, vcstype_git from history.sources_count;

Output:
 ts                         | total_sid_main | total_sid_contrib | total_sid_nonfree | vcstype_git 
----------------------------+----------------+-------------------+-------------------+-------------
 2008-12-25 00:00:00        |                |                   |                   |        1121
 2009-03-10 00:00:00        |                |                   |                   |        1369
....
 2012-11-26 00:00:02.110947 |                |                   |                   |        7122
 2012-11-27 00:00:02.472756 |                |                   |                   |        7123
 2012-11-28 00:00:01.879357 |                |                   |                   |        7122

Another test:
udd=> select distinct total_sid_main from history.sources_count;
 total_sid_main 
----------------
               
(1 row)


I expected to see something like:
 ts                         | total_sid_main | total_sid_contrib | total_sid_nonfree | vcstype_git 
----------------------------+----------------+-------------------+-------------------+-------------
 2008-12-25 00:00:00        | 19557          | 175               | 336               |        1121


Thanks for all your work in UDD.

Cheers,
Josué Abarca