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.

Sign up for GitHub

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

Error opening database: Error executing SQL: duplicate column name: unknownFields #5464

Closed
bendk opened this issue Apr 4, 2023 · 2 comments
Closed

Error opening database: Error executing SQL: duplicate column name: unknownFields #5464

bendk opened this issue Apr 4, 2023 · 2 comments
Assignees
@bendk

Comments

@bendk
Copy link
Contributor

bendk commented Apr 4, 2023 •
edited by data-sync-user
Loading

Lots of error reports on this one today. It looks like we're trying to run the migration multiple times:

https://mozilla.sentry.io/issues/3728786877/?project=6295546&referrer=slack

┆Issue is synchronized with this Jira Task
┆Sprint End Date: 2023-04-07
@bendk
Copy link
Contributor Author

bendk commented Apr 4, 2023

I'm pretty sure this is what happened:

  • Some users installed yesterday's nightly, which incorrectly had the places DB schema version as 15.
  • dce0f34 fixed the code so the version was correctly listed as 16
  • However, those users still had their version as 15 and are still trying to do the upgrade, even though the unknownFields column is already present in their DB.

@bendk
Copy link
Contributor Author

bendk commented Apr 4, 2023

v97.4.1 should fix this one.

@bendk bendk closed this as completed Apr 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@bendk bendk

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bendk