Auto upgrade failing with - Error: file is not a database in "PRAGMA journal_mode = WAL"...

[just-my-opinion]

• [ X] I have searched open and closed issues for duplicates

• [X ] I am using Signal-Desktop as provided by the Signal team, not a 3rd-party package.

---

Bug Description

When allowing Signal (win) to upgrade to latest release, install failed with the following message:
Error: file is not a database in "PRAGMA journal_mode = WAL"
statement aborts at 1: [PRAGMA user_version;] file is not a database
at Worker. ([REDACTED]\ts\sql\main.js:44:34)
at Worker.emit (events.js:315:20)
at MessagePort. (internal/worker.js:207:53)
at MessagePort.[nodejs.internal.kHybridDispatch] (internal/event_target.js:354:41)
at MessagePort.exports.emitMessage (internal/per_context/messageport.js:18:26)

Steps to Reproduce

1. uninstalled Signal completely
2. downloaded the most recent version of Signal (win) from https://signal.org/download/ signal-desktop-win-5.23.1.exe
3. attempted to install that release
4. It failed with the identical error and error message

Actual Result:

Expected Result:

Screenshots

Platform Info

Signal Version:

Operating System:

Linked Device Version:

Link to Debug Log

[just-my-opinion]

Hey, is no one else experiencing this issue? I really could use some assistance...

[hiqua]

Try to delete your data: https://support.signal.org/hc/en-us/articles/360007059752-Backup-and-Restore-Messages#desktop_restore

[indutny-signal]

Sorry for a delay on our end. We are aware of db corruption issues happening to some users and are looking into the root cause of this, but unfortunately we don't have any suggestions other than what @hiqua brought up above.

[indutny-signal]

Duplicate of #5467

[indutny-signal]

@just-my-opinion could you confirm that Signal offered you to erase your database when you saw that error message, please?

[just-my-opinion]

No, signal did not direct me to uninstall. I did it in an effort to successfully get signal back up and running.

…

On Wed, Nov 17, 2021 at 7:10 AM Fedor Indutny ***@***.***> wrote: @just-my-opinion <https://github.com/just-my-opinion> could you confirm that Signal offered you to erase your database when you saw that error message, please? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5643 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALUUNHVHAVK2NKLOB6YDOMTUMPAXTANCNFSM5IARUYQA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[indutny-signal]

Oh, this sounds bad! I think I understand why this has happened. We'll see if we can improve here!

[just-my-opinion]

Are you suggesting I follow the advice and delete my data manually? I am quite certain the uninstall and new install of the old release eliminated all data since I was required to link to my phone again, after which no previous data (conversations) were present on desktop.

…

On Wed, Nov 17, 2021 at 10:52 AM Fedor Indutny ***@***.***> wrote: Oh, this sounds bad! I think I understand why this has happened. We'll see if we can improve here! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#5643 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALUUNHR35Y6JZF3M5FCKL3TUMP2YHANCNFSM5IARUYQA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[indutny-signal]

Sorry for the confusion, I meant that it is bad that it didn't offer you to erase the faulty data and relink and you had to do it yourself!