Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

archive log mixing UTC and local timezone #9653

Closed
valmiRe opened this issue Jan 28, 2016 · 1 comment
Closed

archive log mixing UTC and local timezone #9653

valmiRe opened this issue Jan 28, 2016 · 1 comment
Assignees
Labels
answered For when a question was asked and we referred to forum or answered it.
Milestone

Comments

@valmiRe
Copy link

valmiRe commented Jan 28, 2016

Hi all, I was wondering if there is a problem with the archive process mixing UTC and local timezone.
My timezone is UTC+1, the process logs in UTC, but the last line below is confusing, it mixes UTC (16:05:19) and local timezone (17:20:01)

logs extract of 2 last core:archive runs :

INFO [2016-01-28 16:05:19] done
INFO [2016-01-28 16:05:19] ---------------------------
INFO [2016-01-28 16:20:01] ---------------------------
INFO [2016-01-28 16:20:01] INIT
INFO [2016-01-28 16:20:01] Running Piwik 2.15.0 as Super User
INFO [2016-01-28 16:20:01] ---------------------------
INFO [2016-01-28 16:20:01] NOTES
INFO [2016-01-28 16:20:01] - Reports for today will be processed at most every 500 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO [2016-01-28 16:20:01] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO [2016-01-28 16:20:01] - Archiving was last executed without error 14 min 42s ago
INFO [2016-01-28 16:20:01] ---------------------------
INFO [2016-01-28 16:20:01] START
INFO [2016-01-28 16:20:01] Starting Piwik reports archiving...
INFO [2016-01-28 16:20:01] - tracking data found for website id 1 (between 2016-01-28 16:05:19 and 2016-01-28 17:20:01)
@tsteur
Copy link
Member

tsteur commented Jan 28, 2016

tracking data found for website id 1 (between 2016-01-28 16:05:19 and 2016-01-28 17:20:01)

Here it is supposed to check whether there were visits since midnight or since the last archive.

I presume your last archive was at 16:05:19 and the cron executed again at 16:20:01. The query always to detect if there were visits always adds one hour and makes it 17:20:01. I believe I added the + 1 hour or refactored it but to be honest I don't remember why. There might be eg a feature allowing you to import visitors up to one hour in the "future" and this way it covers it. Anyway, the +1 hour shouldn't "hurt" nor should it cause any problems re performance and data should be still correct.

@tsteur tsteur closed this as completed Jan 28, 2016
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Jan 28, 2016
@tsteur tsteur added this to the 2.16.0 milestone Jan 28, 2016
@tsteur tsteur self-assigned this Jan 28, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

2 participants