Package: qa.debian.org
Severity: normal
User: [email protected]
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
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
Archive:
http://lists.debian.org/[email protected]
