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

messages.db corrupted after system hang #587

Closed
phik opened this issue Mar 17, 2016 · 2 comments
Closed

messages.db corrupted after system hang #587

phik opened this issue Mar 17, 2016 · 2 comments

Comments

@phik
Copy link

phik commented Mar 17, 2016

Mac OS hung this morning, while I was reading an article in Vienna.

After restart, Vienna 3.0.9 won't even launch:

$ /Applications/Vienna.app/Contents/MacOS/Vienna
2016-03-17 14:49:03.956 Vienna[890:96830] DB Error: 11 "database disk image is malformed"
2016-03-17 14:49:03.956 Vienna[890:96830] DB Query: select version from info
2016-03-17 14:49:03.957 Vienna[890:96830] DB Path: /Users/phil/Library/Application Support/Vienna/messages.db
2016-03-17 14:49:03.957 Vienna[890:96830] DB Error: 11 "database disk image is malformed"
2016-03-17 14:49:03.957 Vienna[890:96830] DB Query: create table info (version, last_opened, first_folder, folder_sort)
2016-03-17 14:49:03.957 Vienna[890:96830] DB Path: /Users/phil/Library/Application Support/Vienna/messages.db

3.1 launches, but with a blank sidebar (at least it didn't delete the messages.db, which is what I feared)

Indeed it is corrupt:

$ sqlite3 messages.db
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> pragma integrity_check;
Error: database disk image is malformed

...although not in an obvious way. It looks like a halfway-sensible file, and I can retrieve all of my subscriptions from it by extracting the strings, though I'll lose all past flagged articles.

My experience with sqlite doesn't include DB corruption unless one goes out of one's way to disable its journaling safeties.

Is Vienna using sqlite in a way that's unsafe in the face of an ungraceful shutdown?

@josh64x2
Copy link
Member

@phik which version of Mac OS X did this happen on?
Thanks

@phik
Copy link
Author

phik commented Mar 17, 2016

10.11.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants