+shell

pdhanda wrote:

Bugmeister is the new Bugzilla maintainer and default assignee.

Removing "shell" keyword for things that aren't directly doable by shell users etc

Adding ops keyword

Removing shell keyword if exists

It looks like someone already ran the regeneration script since the charts are populated.

I have asked the ops to setup two cronjobs:
https://gerrit.wikimedia.org/r/#change,915

cron reviewed by Ryan Lane yesterday. Puppet must have deployed that cronjob by now :-)

Sunday has passed but the charts don't seem to have been regenerated: the first day is still the same (day of bugzilla update, 2010-01-20), but it should be the first day of bugzilla since there's no temporal limit.
Either the cronjob didn't run, or this note in https://gerrit.wikimedia.org/r/#change,915 is the reason: «Might need to verify the script collectstats.pl does exist in that directory». Could someone verify that it's there?

The collect script does not seem to work properly. Apergos gave me the cronjob output:

DBD::mysql::st execute failed: Duplicate entry '118-2011-11-24 00:00:00' for key 1 [for Statement "INSERT INTO series_data (series_id, series_date, series_value) VALUES (?, '2011-11-24', ?)" with ParamValues: 0='118', 1=244] at ./collectstats.pl line 526
main::CollectSeriesData() called at ./collectstats.pl line 162

Antoine can't finish this since he'd need root.

I don't know when, but the script has run in the end and the charts are populated at last. No idea what changed.

we ran into a problem with this one when testing on the new server

https://gerrit.wikimedia.org/r/#/c/109086/

we'll debug this soon before the switch-over of BZ (the change influences the new module, not the current/old kaulen server where it works and we won't touch it anymore)

it fails to execute: /bin/sh: 1: /srv/org/wikimedia/bugzilla/collectstats.pl: not found happens only on new server

06:58 < mutante> /bin/sh: 1: /srv/org/wikimedia/bugzilla/collectstats.pl: not found

06:58 < mutante> /bin/sh: symbolic link to `dash'

06:59 < mutante> /srv/org/wikimedia/bugzilla/collectstats.pl: a /usr/bin/perl -w script, ASCII text executable

Daniel: Did breaking it into two commands completely fix this?

https://gerrit.wikimedia.org/r/#/c/110170 and https://gerrit.wikimedia.org/r/#/c/110172 merged; closing as FIXED.

I would prefer we wait for the cron to kick in so we can confirm the report is properly generated at https://bugzilla.wikimedia.org/reports.cgi?product=Wikimedia&datasets=UNCONFIRMED&datasets=NEW&datasets=ASSIGNED&datasets=REOPENED&datasets=VERIFIED&datasets=LATER&datasets=REMIND

Data is definitely being collected, see e.g.:
https://bugzilla.wikimedia.org/chart.cgi?category=-All-&subcategory=-All-&name=1720&select0=1&label0=Tickets+changed+in+last+24+hours&line0=1720&datefrom=&dateto=&action-wrap=Chart+This+List

Closing as FIXED.