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

Updater: Check if column exist only shortly before it is needed #16589

Merged
merged 1 commit into from Oct 19, 2020

Conversation

tsteur
Copy link
Member

@tsteur tsteur commented Oct 19, 2020

Just in case there are multiple updates running at the same time (eg when 2 users click on update in the UI or this might also happen in Matomo for WordPress). Then the update on log_visit...SET visitor_seconds_since_first = visitor_days_since_first * 86400, might take a while and meanwhile another concurrent job has removed that column already. Bit hard to explain but basically we want to get this information only shortly before it is needed

Just in case there are multiple updates running at the same time (eg when 2 users click on `update` in the UI or this might also happen in Matomo for WordPress). Then the update on `log_visit...SET visitor_seconds_since_first = visitor_days_since_first * 86400, ` might take a while and meanwhile another concurrent job has removed that column already. Bit hard to explain but basically we want to get this information only shortly before it is needed
@tsteur tsteur added not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. Needs Review PRs that need a code review labels Oct 19, 2020
@tsteur tsteur added this to the 4.0.0-RC milestone Oct 19, 2020
@tsteur tsteur changed the title Check if column exist only shortly before it is needed Updater: Check if column exist only shortly before it is needed Oct 19, 2020
@sgiehl sgiehl merged commit 8561803 into 4.x-dev Oct 19, 2020
@sgiehl sgiehl deleted the hasdayscolumninconv branch October 19, 2020 09:00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Needs Review PRs that need a code review not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

2 participants