Every now and then I'll get this issue ```android.database.sqlite.SQLiteDatabaseLockedException: dat...

# squarelibraries

[Colton Idle]

Every now and then I'll get this issue

android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5 SQLITE_BUSY): , while compiling: PRAGMA journal_mode

the stacktrace has some mentions of Sentry (the crash reporting tool) and it also points me to this block of code.

1. Does it seem like sentry could be the culprit?

at io.sentry.android.sqlite.SentrySupportSQLiteOpenHelper$sentryWritableDatabase$2.invoke(SentrySupportSQLiteOpenHelper.kt:40)

2. or is my code here somehow bad?

suspend fun itemExists(id: String): Boolean {
    var result = false
    withContext(myIoDispatcher) {
      val foo = myQueries.selectById(id).executeAsOneOrNull()
      if (foo != null) {
        result = true
      }
    }
    return result
  }

[Colton Idle]

According to the only google search result hit. This could be from reading and writing to the database at one time. That seems weird though.

My other method (that adds like 100k records at one time) is written like this

suspend fun deleteAllThenInsertAll(bufferedReader: BufferedReader) =
      withContext(myIoDispatcher) {
        myQueries.transaction {
          myQueries.deleteAll()
// read bufferedReader line by line and insert in the transaction

[Colton Idle]

Could it be... my provider was missing Singleton annotation?

@Provides
fun provideDelight(@ApplicationContext context: Context): DbService {
  val driver = AndroidSqliteDriver(The.Schema, context, "the.db")
  return DbService(driver)
}

[Daniel Perez]

That's what I was thinking. I'm under the impression your DB should be a singleton in your app.

[Colton Idle]

I thought it was already. so definitely a "me" problem. lol

[Paul Woitaschek]

We have this on iOS, and it's definitely a singleton

[Matt Nelson]

Don't think I'll ever go back to using the AndroidSqliteDriver and all that android glue being used under the hood (and needing Context). sqlite-jdbc is where it's at, and loads the latest version of SQLite instead of using whatever version of SQLite is on that device.

Checkout https://github.com/toxicity-io/sqlite-mc

Can simply pass Key.Empty and not even use the encryption if you don't want to.