Page 1 of 1

Vienna 3.8.8 won't launch:"DB Error: 11 "database disk image is malformed""

Posted: Mon Jul 31, 2023 5:11 pm
by scrutinizer
The failure cropped up out of the blue. It even didn't generate a crash report. The only way to figure out what happened behind the curtain was to run the binary in Terminal. I got the following:

Code: Select all

/Applications/*/Vienna.app/Contents/MacOS/Vienna ; exit;
2023-07-31 19:55:36.773 Vienna[2347:26212] DB Error: 11 "database disk image is malformed"
2023-07-31 19:55:36.773 Vienna[2347:26212] DB Query: SELECT version FROM info
2023-07-31 19:55:36.773 Vienna[2347:26212] DB Path: /Users/home/Library/Application Support/Vienna/messages.db
2023-07-31 19:55:36.773 Vienna[2347:26212] Unknown error calling sqlite3_step (11: database disk image is malformed) rs
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Error: 11 "database disk image is malformed"
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Query: PRAGMA auto_vacuum = 1
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Path: /Users/home/Library/Application Support/Vienna/messages.db
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Error: 11 "database disk image is malformed"
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Query: CREATE TABLE info (version, last_opened, first_folder, folder_sort)
2023-07-31 19:55:36.774 Vienna[2347:26212] DB Path: /Users/home/Library/Application Support/Vienna/messages.db
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.
Deleting expired sessions...1014 completed.
I moved the messages.db to the Trash but that had me losing all my RSS feeds. Is there a less crude solution?

Re: Vienna 3.8.8 won't launch:"DB Error: 11 "database disk image is malformed""

Posted: Sat Aug 12, 2023 1:03 pm
by scrutinizer
This situation happened twice: both times, the computer was abruptly powered off. I learned that the said error is characteristic of SQLite databases corrupting their structure when the system loses power amid operation. However, I think that in macOS it's on the app to apply safeguards when such an accident occurs. None of the apps relying on SQLite, that's on my Mac, has ever displayed this misbehaviour. This leads me to think something's wrong with how Vienna handles an emergency.

Is the developer reading this forum? A nimble acknowledgment as a sign of awarenesses would be reassuring to know the fix is on its way.

Re: Vienna 3.8.8 won't launch:"DB Error: 11 "database disk image is malformed""

Posted: Thu Aug 17, 2023 2:35 pm
by scrutinizer
A bit late but here's a crash report I found by opening the Console today.

Vienna_2023-08-09-221106.txt
The coinciding crash report
(80.91 KiB) Downloaded 311 times