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

Jump to bottom

Two hours missing from stats on 13th March 2016, daylight savings day #9949

Open
jlazic opened this issue Mar 18, 2016 · 6 comments
Open

Two hours missing from stats on 13th March 2016, daylight savings day #9949

jlazic opened this issue Mar 18, 2016 · 6 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
Backlog (Help wan...

Comments

@jlazic
Copy link

jlazic commented Mar 18, 2016

Hi,

I have just noticed that 2h and 23h stats are missing on "Visits by Server Time" graph in Piwik 2.16.0 for date 2016-03-13. This was daylight savings day for USA. If one hour of stats was missing I would attribute that to DST, but why would two hours of stats be gone?
Both server and PHP (5.6.17) have timezone set to UTC, while tracked sites have America/Detroit set as timezone. I have already invalidated reports for 2016-03-13 and recreated them, but that did not help.
All of web servers and database server have system same timezone settings (UTC), while MySQL has global.time_zone set to SYSTEM.

Missing visits

If you need more info let me know and I will try provide it.
@tsteur
Copy link
Member

tsteur commented Mar 29, 2016

Can you see visits for 23h in visitor log? It looks like the 23h is related to another issue.

@jlazic
Copy link
Author

jlazic commented Mar 30, 2016

Yes, there are logged visits for 23h. Also, I just noticed that in Visits per local time graph there is no data missing. Hope this helps.
Visits per local time

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Mar 31, 2016
@mattab mattab added this to the 2.16.x (LTS) milestone Mar 31, 2016
@tsteur
Copy link
Member

tsteur commented Mar 31, 2016

For piwik.org tracking we have similar issue on 2016-03-27 and 23h. We correctly get data for 2h though. So can you maybe check whether there is any data for 2am in the visitor log (server time)?

@jlazic
Copy link
Author

jlazic commented Mar 31, 2016

Field 'visit_first_action_time' in 'piwik_log_visit' table is what we call server time? If so then - yes, there are logged visits for 2h.

@tsteur
Copy link
Member

tsteur commented Mar 31, 2016

I think in this case we need to look for visit_last_action_time

@jlazic
Copy link
Author

jlazic commented Apr 1, 2016

Answer is still - yes, there are logged visits for both visit_first_action_time and visit_last_action_time during the 2h.

@mattab mattab mentioned this issue Aug 23, 2016
Closed
@mattab mattab modified the milestones: 2.16.x (LTS), Mid term Aug 25, 2016
@pardvm pardvm mentioned this issue Mar 30, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
Backlog (Help wanted)
Development

No branches or pull requests
3 participants
@tsteur @mattab @jlazic