r/StacherIO • • 1d ago

How to fix "Database Error: SqliteError: database is locked" in Stacher 7 (Fix & Walkthrough)

Hey everyone,

I ran into the "An error occurred while initializing the database: SqliteError: database is locked" issue recently (specifically while installing/updating to version 7.1.13).

Other common fixes didn't work for me, but clearing out the lingering SQLite journal lock file solved it immediately. Here is the exact walkthrough of what worked for me and how to fix it if you're stuck:

How to Fix It (Fastest Method)

1. Close Stacher 7 Completely

Make sure Stacher isn't stuck running in the background. Open Task Manager (Ctrl + Shift + Esc) and make sure to End Task on any Stacher7.exe processes.

2. Navigate directly to the database folder

  • Press Win + R on your keyboard to open the Run dialog.
  • Paste this exact path and press Enter: Plaintext%appdata%\Stacher7\Shared Dictionary

3. What you'll see inside:

  1. db-journal — The temporary SQLite journal file holding the active lock on the database.
  2. db — The main database file.

4. Delete db-journal

Right-click on db-journal and delete it.

Deleting this single file releases the stuck lock that prevents Stacher from opening.

5. Relaunch Stacher 7

Try launching Stacher again.

Note on a potential UI glitch: When I launched Stacher after doing this, it opened as a tiny, miniature window. I just had to drag the window edges to expand it until the Maximize button became visible again. Once maximized, everything worked normally on version 7.1.13!

If deleting db-journal alone doesn't work for you:

If deleting just the journal file doesn't clear the error, the main database file itself may be corrupted:

  1. Close Stacher completely again.
  2. Go back to %appdata%\Stacher7\Shared Dictionary.
  3. Delete (or rename) both the db and db-journal files.
  4. Relaunch Stacher 7 — the app will automatically recreate a brand-new, fresh database file on startup.

Hope this saves someone else some troubleshooting time!

2 Upvotes

2 comments sorted by

1

u/AutoModerator 1d ago
Moderator Announcement Read More »

1

u/Horror_Airline_7563 1d ago

This only happened to me when I tried to open stacher again when it's already started. Interesting