More likely: SQLite is built to be small, simple and lightweight, not to be super highly concurrent.

If this situation happens rarely, just make sure you have a retry on the query. If it happens often, switch to postgres.