Set a busy timeout

sql

PRAGMA busy_timeout = 5000;

Explanation

A practical first-line defense against transient `database is locked` failures.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing WAL mode and lock handling

Switch the database to write-ahead logging mode.

Open In sheetsqlsame section

Merge WAL contents back into the main database file.

Open In sheetsqlsame section

See or set the database locking mode.

Open In sheetsqlsame section

Bundle multiple statements atomically.

Open In sheetsql1 tag match

Reserve the write lock up front.

Open In sheetsql1 tag match

Undo uncommitted changes.

Open In sheetsql1 tag match