Transactions and threads in SQLite on Android
Transaction Isolation in SQLite
So you have a long running service (a separate thread) that is synchronising your database with a server or doing some periodic work on it. This task can potentially take a…