Bug#1073562: qa.debian.org: (Some?) popcon statistic graphs not updated since May
On Mon, Jun 17, 2024 at 04:04:59PM +0200, Bastian Venthur wrote:
> Package: qa.debian.org
> Severity: normal
> X-Debbugs-Cc: venthur@debian.org
>
> Dear Maintainer,
>
> Hi,
>
> browsing to:
>
> https://qa.debian.org/popcon-graph.php?packages=python3-debianbts+python3-pysimplesoap&show_installed=on&want_legend=on&want_ticks=on&from_date=2024-05-15&to_date=&hlght_date=&date_fmt=%25m-%25d&beenhere=1
>
> I've noticed that this graph hasn't been updated for almost a month. Not sure
> how often the graphs are supposed to be updated, but maybe some cron job is
> broken?
>
>
> Cheers,
>
> Bastian
>
I think this is the same bug that was reported here [4]. I did an
investigation based on the code, but I don't have access to any of the
logs. Could someone with access take a look please?
This appears to be broken for all packages.
I suspect that there is a cronjob or something that is running to update
the database. Looking at the code for this page [1], if the to_date is not
set explicitly then it will try to find the latest date for a given
package.
```
$to_date = $dbh->selectrow_array('SELECT max(p.day) FROM popcon_package pp JOIN popcon p ON
(pp.id = p.package_id) JOIN popcon_day pd ON (pd.day = p.day) WHERE package = ANY(?) AND
in_debian AND (p.vote > 0 OR p.old > 0 OR p.recent > 0 or p.no_files > 0)', undef,
\@packages) if !$to_date;
```
There is a perl script called popcon-import [2] that runs somewhere, can
someone who has access to these logs [3] take a look?
[1] https://salsa.debian.org/qa/qa/-/blob/master/cgi-bin/popcon-data?ref_type=heads#L45
[2]
https://salsa.debian.org/qa/qa/-/blob/master/popcon-graphs/popcon-import?ref_type=heads#L55
[3] my $logfile = "/srv/qa.debian.org/log/popcon.log";
[4] https://lists.debian.org/debian-qa/2024/06/msg00012.html
Reply to: