bError { info: “SqliteFailure(Error { code: CannotOpen, extended_code: 14 }, Some("unable to open database file"))”, kind: Other }
I am getting this message. The App still works great but on my PC it will not sync.
You can try running Tools > Check Database first, but likely you will need to restore from the most recent automatic backup before this happened. Restoring an Automatic Backup (Recovering from Data Loss) - Frequently Asked Questions
When I try to restore a backup I get the following messages:
“Automatic syncing and backups have been disabled while restoring. To enable them again, close the profile or restart Anki.”
Then
ProtoError { info: “failed to decode Protobuf message: buffer underflow” }
I’ve tried quitting and restarting several times
That’s normal.
That’s one I haven’t seen before.
- Are you trying the same backup each time? Try the next one back.
- Have you tried running Anki with add-ons disabled (holding down Shift while starting, until you see the confirmation message)?
- What version of Anki are you using?
1 Like
Running without add-ons worked! Thank you very much. I guess I’ll just delete the addons I have. Thanks again
Edit - It worked on one profile but not another… so the issue persists
I tried different backups and always get the buffer overflow message
Version 24.06.2 (33a92379)
If they are ones you don’t need, that’s the best way to get rid of outdated add-ons. If you need them, there might be forked/updated versions.
You have 2 different profiles that were both getting this database error? That’s especially concerning since those are entirely separate databases.
It probably was just one profile with the issue. When I started Anki holding shift I was in my other profile and it worked so I thought the issue was fixed but maybe that profile never had the issue at all.
My main profile still has the issue though…
Can you clear up for me which of the suggestions you’ve tried so far in the profile that actually has the problem?
- Are you trying the same backup each time? Try the next one back.
- Have you tried running Anki with add-ons disabled (holding down Shift while starting, until you see the confirmation message)?
I have tried both of these solutions and neither works. Every time I try to sync I get the “DbError { info: “SqliteFailure(Error { code: CannotOpen, extended_code: 14 }, Some("unable to open database file"))”, kind: Other }” error.
When I try to load a backup I get “ProtoError { info: “failed to decode Protobuf message: buffer underflow” }”
The phone and web version still work so I have been using that for now.
If you want to try to fix your database from the outside, there’s a procedure for doing that – Managing Files - Anki Manual . But honestly, if you have everythıng you need on your phone, then it might be time to just let go of your database on your PC.
Instead of just overwriting it, I would get rid of it entirely. You can go to your profile and rename your collection.anki2 database to something else (effectively deleting it as far as Anki can see). When you restart Anki in that profile, it will create a fresh database. You can setup syncing and download from AnkiWeb to get your whole collection. (When everything is up and running again, you can delete your old-renamed database.)
1 Like
Does Check Database report any problems? If not, you may find logging out of syncing in the preferences screen resolves the issue. If not, please try Danika’s suggestion.
1 Like
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.