thiagowfx's avatar

¬ just serendipity 🍀 (not just serendipity)

Anki: corrupted database

• 204 words • 1 min • updated

Life is hard. Today, when opening Anki on macOS:

DbError { info: "SqliteFailure(Error { code: DatabaseCorrupt, extended_code: 11 }, Some(\"database disk image is malformed\"))", kind: Other }

Database corrupt? What is this, are we in the 2000s? Goodness.

I have automatic backups enabled. For 4 years I haven’t needed them. Today is the day. Never say never!

shell
% ls -lt "$HOME/Library/Application Support/Anki2/Thiago/backups/"
total 234496
-rw-r--r--@ 1 tperrotta  staff  3911921 Apr  8 00:12 backup-2026-04-08-00.12.17.colpkg
-rw-r--r--@ 1 tperrotta  staff  3911921 Apr  7 00:16 backup-2026-04-07-00.16.26.colpkg

I try:

shell
open "$HOME/Library/Application Support/Anki2/Thiago/backups/backup-2026-04-07-00.16.26.colpkg"

…but apparently that file is corrupt as well.

I am not particularly worried because I sync my notes to AnkiWeb. Even if the entire local collection were corrupt, my flashcards are in the cloud.

So I decided to simply start from scratch1.

shell
mv ~/Library/Application\ Support/Anki2/Thiago/collection.anki2 ~/Library/Application\ Support/Anki2/Thiago/collection.anki2.corrupt
rm -f ~/Library/Application\ Support/Anki2/Thiago/collection.anki2-shm ~/Library/Application\ Support/Anki2/Thiago/collection.anki2-wal

Then I open Anki.

It prompts me to download my decks from AnkiWeb.

And now everything works as usual! Last cleanup:

shell
trash ~/Library/Application\ Support/Anki2/Thiago/collection.anki2.corrupt

No idea why this has happened. First time. Life goes on.

!next

Previously. ∎


  1. The idea was mine. The decision was mine. The LLM suggested the command on how to do so. I can still self-troubleshoot, mmmkay? ↩︎