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

Errors in archiving when Sequence wasn't initialized properly #6815

Closed
mgazdzik opened this issue Dec 5, 2014 · 1 comment
Closed

Errors in archiving when Sequence wasn't initialized properly #6815

mgazdzik opened this issue Dec 5, 2014 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@mgazdzik
Copy link
Contributor

mgazdzik commented Dec 5, 2014

In case of big instances when migration takes long enough, Sequence might not get initialized properly. In current state this will completely disable Piwik archiving process.
Since Sequence is quite small class, that could possibly self-patch, I think it should be fallback behaviour instead of throwing exception.

There are some other use cases I can think of, that could lead to this situation. For ex:

  • move existing archive tables from old instance to new one (with skipping migration part maybe)
  • or when schema update is performed on auxiliary database, where only raw data was imported,
  • basically any other more advanced/custom use case where core:update will not be able to take care of proper sequence initialization
@mgazdzik mgazdzik mentioned this issue Dec 5, 2014
Closed
@mattab
Copy link
Member

mattab commented Dec 9, 2014

Unfortunately we cannot fix it ina proper way. Here we shall recommend to always run Piwik on the latest DB schema using the latest codebase.

  • Running old schema with new codebase -> you get update screen
  • Running old codebase with new schema -> can mess up state of the DB in some other yet un-dicovered ways and we shall simply avoid all those issues at once by having the new codebase run with new schema 🎱

@mattab mattab closed this as completed Dec 9, 2014
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Dec 9, 2014
@mattab mattab mentioned this issue Dec 9, 2014
Closed
@mattab mattab mentioned this issue Jan 6, 2015
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @mgazdzik