Your message dated Sun, 31 Mar 2013 16:29:17 +0200
with message-id <[email protected]>
and subject line Re: Bug#694669: UDD: Missing data in the history.sources_count
table
has caused the Debian Bug report #694669,
regarding UDD: Missing data in the history.sources_count table
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
694669: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=694669
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
On 28/11/12 at 15:21 -0600, Josue Abarca wrote:
> 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.
Indeed. Fixed now.
Thanks,
Lucas
--- End Message ---
