hasVisits - timezone problem - some sites not archived - no new tracking data for website id XY (between 2016-04-01 22:00:00 and 2015-04-02 01:36:19) #10031
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
duplicate
For issues that already existed in our issue tracker and were reported previously.
Major
Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Waiting for user feedback
Indicates the Matomo team is waiting for feedback from the author or other users.
Milestone
Since 2015-11 or around Piwik 2.15 i noticed, that some sites were not archived for days, sometimes for weeks. In the archiving reports i get my email, i can see the information from the hasVisits-check in core/CronArchive.php that sites have been skipped ... for example:
"no new tracking data for website id XY (between 2016-04-01 22:00:00 and 2015-04-02 01:36:19) - Skipped website id XY as archiving is not needed"
core/CronArchive.php
The hasVisits-check should test, if there were new visits for a specific site the day before; if yes do archiving, if not skip this site. Therefore it should check:
day before (2016-04-01) in the period from 00:00 to 23.59.
So the message aboves shows, that the actually used test period
2016-04-01 22:00:00 to 2015-04-02 01:36:19 (cronjob starts 01.30)
differs from the expected period, which would be
2016-04-01 00:00:00 to 2015-04-02 01:36:19 (cronjob starts 01.30)
This is on a server with Europe/Berlin timezone settings, so i have UTC+1h in winter and UTC+2h in summer, see here: http://www.timeanddate.com/time/zone/germany/berlin
With low traffic sites this goes on unitil the first visitor arrives someday between 22:00 and 23:59.
This made this behaviour quite erratic.
Possible solutions:
This behaviour could probably occur in any piwik instance with low traffic sites with deviant timezone settings.
Any hints how to fix this are welcome.
Best regards
Stephan
The text was updated successfully, but these errors were encountered: