[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#694669: marked as done (UDD: Missing data in the history.sources_count table)

Your message dated Sun, 31 Mar 2013 16:29:17 +0200
with message-id <20130331142917.GA3304@xanadu.blop.info>
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 owner@bugs.debian.org
immediately.)


-- 
694669: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=694669
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
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

--- End Message ---
--- Begin Message --- 
On 28/11/12 at 15:21 -0600, Josue Abarca wrote:
> 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.

Indeed. Fixed now.

Thanks,

Lucas

--- End Message ---
Reply to: