Last modified: 2014-04-21 18:45:57 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T62957, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 60957 - Timestamp in filename of hourly webstatscollector output refers to end of the covered period instead of its start
Timestamp in filename of hourly webstatscollector output refers to end of the...
Status: NEW
Product: Analytics
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Normal normal
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-02-06 12:45 UTC by christian
Modified: 2014-04-21 18:45 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description christian 2014-02-06 12:45:27 UTC
The timestamp in the filename of the hourly webstatscollector output
files refers to the end of the covered period instead of its start.

So for example:
  http://dumps.wikimedia.org/other/pagecounts-raw/2014/2014-02/pagecounts-20140206-110000.gz
covers from 2014-02-06 10:00 until 2014-02-06 11:00.

This is confusing for me, as I'd instead expect the above file to
cover
  2014-02-06 11:00 until 2014-02-06 12:00.
.

From time to time, I see other people tripping over this as well. For
example when trying to relate the above file to sampled-1000 tsvs,
they'd grep for 2014-02-06T11 in the timestamp field, although they'd
have to grep for 2014-02-06T10 instead.

Could we either document this clearly on
  http://dumps.wikimedia.org/other/pagecounts-raw/
or switch the filename to hold the start of the covered period?
Comment 1 Bingle 2014-02-06 12:50:25 UTC
Prioritization and scheduling of this bug is tracked on Mingle card https://wikimedia.mingle.thoughtworks.com/projects/analytics/cards/cards/1433

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links