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

Tracking can cause requests to option table #14298

Closed
tsteur opened this issue Apr 1, 2019 · 0 comments · Fixed by #14318
Closed

Tracking can cause requests to option table #14298

tsteur opened this issue Apr 1, 2019 · 0 comments · Fixed by #14318
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@tsteur
Copy link
Member

tsteur commented Apr 1, 2019

Noticed this query is execute some times within a day as part of a tracking request: SELECT option_name, option_value FROM option WHERE option_name LIKE ?.

image
Output:

'2019-03-31'
'UTC'
1554066533'
2019-04-01'
1554076800  
1554076800

Stacktrace:

#0 Piwik\Option->getNameLike(report_to_invalidate_1_2019-03-31%) called at [/var/www/html/core/Option.php:58] #1 Piwik\Option::getLike(report_to_invalidate_1_2019-03-31%) called at [/var/www/html/core/Archive/ArchiveInvalidator.php:70] #2 Piwik\Archive\ArchiveInvalidator->rememberToInvalidateArchivedReportsLater(1, Piwik\Date Object ([*timestamp] => 1554066319,[*timezone] => UTC)) called at [/var/www/html/core/Tracker/Visit.php:561] #3 Piwik\Tracker\Visit->markArchivedReportsAsInvalidIfArchiveAlreadyFinished() called at [/var/www/html/core/Tracker/Visit.php:193] #4 Piwik\Tracker\Visit->handle() called at [/var/www/html/core/Tracker.php:138] #5

Seems isToday is not quite correctly detected here.

timezone of the website is New York:
image

@tsteur tsteur added the Bug For errors / faults / flaws / inconsistencies etc. label Apr 1, 2019
@tsteur tsteur added this to the 3.10.0 milestone Apr 1, 2019
@katebutler katebutler self-assigned this Apr 1, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants