What Does This Error Message Mean ? - Sqlite3_exec - Failed To Set Synchronous Mode = 1(normal)

I am trying to open a SQLiteDatabase in a 'Service' which fails with the following exception: 10-21 19:33:23.547: E/SqliteDatabaseCpp(31208): sqlite3_exec - Failed to set synchrono

Solution 1:

I think it is an access conflict happened when the db was used (locked) by one thread (the activity?), the other thread (the service?) tried to use (lock) it but failed.

You can make your own SQLiteOpenHelper a singleton class, and then share it between the activity and service, and then the class will handle the conflict properly for you. See the discussion in this thread

Solution 2:

Check if the database is opened by other thread but not closed when you try to open it again. If yes, just try to close it after use.