IssueTracker

Also occurs on 1.1.0-beta04

Also occurs on Bumblebee and Chipmunk

Since the Bumblebee made the nonTransitiveRClass true by default this error will now make a lot of people mad. I think this is really high priority to fix

We are fixing in a future Dolphin release and we backporting the fix to Bumblebee and Chipmunk.

Thank you for your patience while our engineering team worked to resolve this issue. A fix for this issue is now available in:

• Android Studio Dolphin Canary 2 (2021.3.1.2)
• Android Gradle Plugin 7.3.0-alpha02

We encourage you to try the latest update.

If you notice further issues or have questions, please file a new bug report.

Thank you for taking the time to submit feedback — we really appreciate it!

Is there a change for Bumblebee backport? This is P0 and S1 ticket, I'd think this is the kind of stuff that should be part of a patch release

Great, thanks!

Issue is still present for me in Bumblebee Patch 2

Also still seeing this issue in Chipmunk Patch 1, latest Eel Canary 4 in some cases.

In our multi-module project with nonTransitiveRClass enabled, previews in library modules can reference resources, but not the application modules

I'm using Chipmunk | 2021.2.1 Patch 1 and the result is same with Comment #12.

Same here

There was another related issue fixed in Dolphin RC 1 and the latest Electric Eel Canary. Could you try with either to see if you still have the issue?

I can't reproduce the error anymore following the original repro steps.
If you have reproducible steps, please create a new issue and explain how the problem arises.

Thanks

Same issue in Electric Eel

android.content.res.Resources$NotFoundException: Could not resolve resource value: 0x1CFE92.   
at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1161)   
at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1137)   
at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1141)

• Android Studio Electric Eel | 2022.1.1 Patch 1
• Build #AI-221.6008.13.2211.9514443, built on January 21, 2023
• Runtime version: 11.0.15+0-b2043.56-8887301 x86_64
• VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.

If you encounter this issue, please file a new bug with reproducible steps as I cannot reproduce anymore with the steps mentioned originally

android.content.res.Resources$NotFoundException: Could not resolve resource value: 0xAAE62.   at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1161)   at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1137)   at android.content.res.Resources_Delegate.throwException(Resources_Delegate.java:1141)   at android.content.res.Resources_Delegate.getResourceValue(Resources_Delegate.java:929)   at android.content.res.Resources_Delegate.getValue(Resources_Delegate.java:900)   at android.content.res.Resources.getValue(Resources.java:1437)   at androidx.compose.ui.res.PainterResources_androidKt.painterResource(PainterResources.android.kt:61)   at com.example.composetutor.MainActivityKt.MessageCard(MainActivity.kt:68)   at com.example.composetutor.ComposableSingletons$MainActivityKt$lambda-4$1.invoke(MainActivity.kt:47)   at com.example.composetutor.ComposableSingletons$MainActivityKt$lambda-4$1.invoke(MainActivity.kt:45)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.material.MaterialTheme_androidKt.PlatformMaterialTheme(MaterialTheme.android.kt:23)   at androidx.compose.material.MaterialThemeKt$MaterialTheme$1$1.invoke(MaterialTheme.kt:82)   at androidx.compose.material.MaterialThemeKt$MaterialTheme$1$1.invoke(MaterialTheme.kt:81)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.material.TextKt.ProvideTextStyle(Text.kt:363)   at androidx.compose.material.MaterialThemeKt$MaterialTheme$1.invoke(MaterialTheme.kt:81)   at androidx.compose.material.MaterialThemeKt$MaterialTheme$1.invoke(MaterialTheme.kt:80)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.material.MaterialThemeKt.MaterialTheme(MaterialTheme.kt:72)   at com.example.composetutor.ui.theme.ThemeKt.ComposeTutorTheme(Theme.kt:40)   at com.example.composetutor.ComposableSingletons$MainActivityKt$lambda-5$1.invoke(MainActivity.kt:45)   at com.example.composetutor.ComposableSingletons$MainActivityKt$lambda-5$1.invoke(MainActivity.kt:44)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.material.SurfaceKt$Surface$1.invoke(Surface.kt:137)   at androidx.compose.material.SurfaceKt$Surface$1.invoke(Surface.kt:118)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.material.SurfaceKt.Surface-F-jzlyU(Surface.kt:115)   at com.example.composetutor.MainActivityKt.DefaultPreview(MainActivity.kt:44)   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)   at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)   at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)   at java.lang.reflect.Method.invoke(Method.java:566)   at androidx.compose.ui.tooling.ComposableInvoker.invokeComposableMethod(ComposableInvoker.kt:163)   at androidx.compose.ui.tooling.ComposableInvoker.invokeComposable(ComposableInvoker.kt:203)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3$1$composable$1.invoke(ComposeViewAdapter.kt:509)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3$1$composable$1.invoke(ComposeViewAdapter.kt:507)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3$1.invoke(ComposeViewAdapter.kt:544)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3$1.invoke(ComposeViewAdapter.kt:502)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.ui.tooling.InspectableKt.Inspectable(Inspectable.kt:61)   at androidx.compose.ui.tooling.ComposeViewAdapter$WrapPreview$1.invoke(ComposeViewAdapter.kt:449)   at androidx.compose.ui.tooling.ComposeViewAdapter$WrapPreview$1.invoke(ComposeViewAdapter.kt:448)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.ui.tooling.ComposeViewAdapter.WrapPreview(ComposeViewAdapter.kt:443)   at androidx.compose.ui.tooling.ComposeViewAdapter.access$WrapPreview(ComposeViewAdapter.kt:127)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3.invoke(ComposeViewAdapter.kt:502)   at androidx.compose.ui.tooling.ComposeViewAdapter$init$3.invoke(ComposeViewAdapter.kt:499)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.ui.platform.ComposeView.Content(ComposeView.android.kt:428)   at androidx.compose.ui.platform.AbstractComposeView$ensureCompositionCreated$1.invoke(ComposeView.android.kt:252)   at androidx.compose.ui.platform.AbstractComposeView$ensureCompositionCreated$1.invoke(ComposeView.android.kt:251)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.ui.platform.CompositionLocalsKt.ProvideCommonCompositionLocals(CompositionLocals.kt:194)   at androidx.compose.ui.platform.AndroidCompositionLocals_androidKt$ProvideAndroidCompositionLocals$3.invoke(AndroidCompositionLocals.android.kt:123)   at androidx.compose.ui.platform.AndroidCompositionLocals_androidKt$ProvideAndroidCompositionLocals$3.invoke(AndroidCompositionLocals.android.kt:122)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.ui.platform.AndroidCompositionLocals_androidKt.ProvideAndroidCompositionLocals(AndroidCompositionLocals.android.kt:114)   at androidx.compose.ui.platform.WrappedComposition$setContent$1$1$2.invoke(Wrapper.android.kt:156)   at androidx.compose.ui.platform.WrappedComposition$setContent$1$1$2.invoke(Wrapper.android.kt:155)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.CompositionLocalKt.CompositionLocalProvider(CompositionLocal.kt:228)   at androidx.compose.ui.platform.WrappedComposition$setContent$1$1.invoke(Wrapper.android.kt:155)   at androidx.compose.ui.platform.WrappedComposition$setContent$1$1.invoke(Wrapper.android.kt:140)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:107)   at androidx.compose.runtime.internal.ComposableLambdaImpl.invoke(ComposableLambda.jvm.kt:34)   at androidx.compose.runtime.ActualJvm_jvmKt.invokeComposable(ActualJvm.jvm.kt:78)   at androidx.compose.runtime.ComposerImpl$doCompose$2$5.invoke(Composer.kt:3352)   at androidx.compose.runtime.ComposerImpl$doCompose$2$5.invoke(Composer.kt:3342)   at androidx.compose.runtime.SnapshotStateKt__DerivedStateKt.observeDerivedStateRecalculations(DerivedState.kt:341)   at androidx.compose.runtime.SnapshotStateKt.observeDerivedStateRecalculations  at androidx.compose.runtime.ComposerImpl.doCompose(Composer.kt:3342)   at androidx.compose.runtime.ComposerImpl.composeContent$runtime_release(Composer.kt:3277)   at androidx.compose.runtime.CompositionImpl.composeContent(Composition.kt:587)   at androidx.compose.runtime.Recomposer.composeInitial$runtime_release(Recomposer.kt:966)   at androidx.compose.runtime.CompositionImpl.setContent(Composition.kt:519)   at androidx.compose.ui.platform.WrappedComposition$setContent$1.invoke(Wrapper.android.kt:140)   at androidx.compose.ui.platform.WrappedComposition$setContent$1.invoke(Wrapper.android.kt:131)   at androidx.compose.ui.platform.AndroidComposeView.setOnViewTreeOwnersAvailable(AndroidComposeView.android.kt:1099)   at androidx.compose.ui.platform.WrappedComposition.setContent(Wrapper.android.kt:131)   at androidx.compose.ui.platform.WrappedComposition.onStateChanged(Wrapper.android.kt:181)   at androidx.lifecycle.LifecycleRegistry$ObserverWithState.dispatchEvent(LifecycleRegistry.kt:314)   at androidx.lifecycle.LifecycleRegistry.addObserver(LifecycleRegistry.kt:192)   at androidx.compose.ui.platform.WrappedComposition$setContent$1.invoke(Wrapper.android.kt:138)   at androidx.compose.ui.platform.WrappedComposition$setContent$1.invoke(Wrapper.android.kt:131)   at androidx.compose.ui.platform.AndroidComposeView.onAttachedToWindow(AndroidComposeView.android.kt:1174)   at android.view.View.dispatchAttachedToWindow(View.java:21291)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3491)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3498)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3498)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3498)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3498)   at android.view.ViewGroup.dispatchAttachedToWindow(ViewGroup.java:3498)   at android.view.AttachInfo_Accessor.setAttachInfo(AttachInfo_Accessor.java:58) Copy stack to clipboard Tip: Try to refresh the layout.

Thanks for posting this. I am also encountering this issue. Disabling the non-transitive R classes appears to have fixed the issue.

Android Studio Giraffe | 2022.3.1 Canary 11 Build #AI-223.8836.35.2231.9848316, built on March 29, 2023 Runtime version: 17.0.6+0-17.0.6b653.34-9746777 aarch64 VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o. macOS 13.3

Thanks for providing more data here for us to look into. I believe the team has submitted a fix, will update on the thread on which version the fix will be available in. Thank you!

The stacktrace from comment #35 looks different. Could you file a new bug with reproducible steps if you have them?

@comment #42: this looks like a different issue than the one in comment #1, but one that we've fixed in Iguana Patch 1, which will be released soon

Hi. Are there any updates on this?

Hey - 2.7.0-alpha13 has a change that should reduce the issue, but not guaranteed.

But I was not able to reproduce the issue with the project and data from comment#39. 🙁

Things got busy so I have to dedicate more time to this issue, but its sort of a wild goose chase without a reliable repro.

Starting with the latest version, 2.7.0-alpha13, we switched to BundledSQLiteDriver, which produces hundreds of database-locked exceptions.

   Non-fatal Exception: android.database.SQLException: Error code: 5, message: database is locked
       at androidx.sqlite.driver.bundled.BundledSQLiteStatementKt.nativeStep(BundledSQLiteStatement.jvmAndroid.kt)
       at androidx.sqlite.driver.bundled.BundledSQLiteStatementKt.access$nativeStep(BundledSQLiteStatement.jvmAndroid.kt)
       at androidx.sqlite.driver.bundled.BundledSQLiteStatement.step(BundledSQLiteStatement.jvmAndroid.kt:100)
       at app.resubs.core.database.dao.PendingNotificationDao_Impl.getAll$lambda$1(PendingNotificationDao_Impl.kt:94)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invokeSuspend(DBUtil.kt:68)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invoke(DBUtil.kt:8)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invoke(DBUtil.kt:4)
       at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invokeSuspend(ConnectionPoolImpl.kt:144)
       at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invoke(ConnectionPoolImpl.kt:8)
       at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invoke(ConnectionPoolImpl.kt:4)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:43)
       at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext(Builders.common.kt:166)
       at kotlinx.coroutines.BuildersKt.withContext(Builders.kt)
       at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:144)
       at androidx.room.coroutines.ConnectionPoolImpl$useConnection$1.invokeSuspend(ConnectionPoolImpl.kt:13)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
       at kotlinx.coroutines.internal.ScopeCoroutine.afterResume(Scopes.kt:35)

Hi ck...@gmail.com. If you have any ideas on how to reproduce the error, please help with this.

I did found that we were not configuring the busy_timeout in the initial connection which can lead to SQLITE_BUSY (error code 5). I've sent a cl to fix that.

I have another alternative / workaround for those with this issue which will also hint me to the root of the cause. In comment#10 I mentioned how increasing the timeout can help, but I realize my suggestion there was not great because it should be done on all connections and not just on the initial connection, to do this you will need to wrap your driver, here is an example code:

val actualDriver = BundledSQLiteDriver()
val driverWrapper =
  object : SQLiteDriver by actualDriver {
    override fun open(fileName: String): SQLiteConnection {
      return actualDriver.open(fileName).also { newConnection ->
        newConnection.execSQL("PRAGMA busy_timeout = $customBusyTimeout")
      }
    }
  }
roomDatabaseBuilder
  .setDriver(driverWrapper)

Let me know if this helps or not.

Hi ck...@gmail.com, ba...@gmail.com. Could you please test this solution on your side?

Project: platform/frameworks/support
Branch: androidx-main
Author: Daniel Santiago Rivera <danysantiago@google.com>
Link:      https://android-review.googlesource.com/3486790

Apply busy_timeout config for initial connection

Apply busy_timeout config for initial connection 
 
Fix an issue where busy_timeout was not being configured in the initial connection where schema validation is also done. The busy_timeout must be set on all connections to avoid SQLITE_BUSY. 
 
Bug: 380088809 
Test: BaseBuilderTest#setCustomBusyTimeout 
Change-Id: I9320856f64363b05bcf6407eed0efe36ef3312a3

Hi. I have applied this fix to my app and release for 10% of users. I got 4000 installs and for now I don't see this error. I am going to try with version 2.7.0-rc01.

I'm still seeing this or a similar issue on 2.7.0-rc01. I haven't tried using AndroidSQLiteDriver or any of the other workarounds listed here. Previously, I was using setQueryCoroutineContext(Dispatchers.IO.limitedParallelism(1)) which did solve the problem. I removed that after upgrading to 2.7.0-rc01.

I got this crash yesterday:

android.database.SQLException: Error code: 5, message: database is locked
    at androidx.sqlite.driver.bundled.BundledSQLiteStatementKt.nativeStep(SourceFile)
    at androidx.sqlite.driver.bundled.BundledSQLiteStatementKt.access$nativeStep(BundledSQLiteStatement.jvmAndroid.kt:0)
    at androidx.sqlite.driver.bundled.BundledSQLiteStatement.step(BundledSQLiteStatement.jvmAndroid.kt:0)
    at androidx.sqlite.driver.bundled.BundledSQLiteStatement.step(BundledSQLiteStatement.jvmAndroid.kt:100)
    at androidx.sqlite.SQLite.execSQL(com.google.android.gms:play-services-mlkit-barcode-scanning@@18.3.1:56)
    at androidx.room.coroutines.PooledConnectionImpl.endTransaction(ConnectionPoolImpl.kt:420)
    at androidx.room.coroutines.PooledConnectionImpl.transaction(ConnectionPoolImpl.kt:388)
    at androidx.room.coroutines.PooledConnectionImpl.isRecycled(ConnectionPoolImpl.kt:0)
    at androidx.room.coroutines.PooledConnectionImpl.access$isRecycled(ConnectionPoolImpl.kt:0)
    at androidx.room.coroutines.PooledConnectionImpl.withTransaction(ConnectionPoolImpl.kt:0)
    at androidx.room.coroutines.PooledConnectionImpl.withTransaction(ConnectionPoolImpl.kt:344)
    at kotlin.coroutines.intrinsics.IntrinsicsKt__IntrinsicsKt.getCOROUTINE_SUSPENDED
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3$invokeSuspend$$inlined$internalPerform$1.invokeSuspend(DBUtil.kt:0)
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3$invokeSuspend$$inlined$internalPerform$1.invokeSuspend(DBUtil.kt:59)
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3$invokeSuspend$$inlined$internalPerform$1.invoke(DBUtil.kt:0)
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3$invokeSuspend$$inlined$internalPerform$1.invoke(DBUtil.kt:0)
    at kotlin.coroutines.intrinsics.IntrinsicsKt__IntrinsicsKt.getCOROUTINE_SUSPENDED
    at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invokeSuspend(ConnectionPoolImpl.kt:0)
    at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invokeSuspend(ConnectionPoolImpl.kt:144)
    at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invoke(ConnectionPoolImpl.kt:0)
    at androidx.room.coroutines.ConnectionPoolImpl$useConnection$4.invoke(ConnectionPoolImpl.kt:0)
    at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(ChildStackFactory.kt:43)
    at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext
    at kotlinx.coroutines.BuildersKt.withContext(DebugStrings.kt:0)
    at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext
    at kotlinx.coroutines.BuildersKt.withContext(DebugStrings.kt:1)
    at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:144)
    at androidx.room.RoomDatabase.useConnection$room_runtime_release(RoomDatabase.android.kt:0)
    at androidx.room.RoomConnectionManager.useConnection
    at androidx.room.RoomDatabase.useConnection$room_runtime_release(RoomDatabase.android.kt:587)
    at kotlin.coroutines.intrinsics.IntrinsicsKt__IntrinsicsKt.getCOROUTINE_SUSPENDED
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3.invokeSuspend(DBUtil.android.kt:0)
    at androidx.room.util.DBUtil__DBUtil_androidKt$performInTransactionSuspending$3.invokeSuspend(DBUtil.android.kt:243)
    at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
    at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:0)
    at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:100)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644)
    at java.lang.Thread.run(Thread.java:1012)

Hi. I got a new error: Fatal Exception: android.database.SQLException: Error code: 5, message: Timed out attempting to acquire a reader connection.

Writer pool:
	Xu1@d088033 (capacity=1)
		[1] - ow@e204ff0
		Status: Free connection
Reader pool:
	Xu1@6c0ec8f (capacity=4)
		[1] - ow@dd27b1c
		Status: Acquired connection
		Coroutine: [go2@7c92325, eo2{Active}@cf76cfa, Dispatchers.IO]
		Acquired:
			at lR.C(Unknown Source:310)
			at iR.invokeSuspend(Unknown Source:13)
			at dq.resumeWith(Unknown Source:8)
			at TR1.o(Unknown Source:6)
			at W.resumeWith(Unknown Source:22)
			at dq.resumeWith(Unknown Source:31)
			at xc0.run(Unknown Source:109)
			at K2.run(Unknown Source:1024)
			at qc2.run(Unknown Source:2)
			at SV.run(Unknown Source:93)
		
		[2] - ow@71a2d08
		Status: Free connection
		[3] - ow@c0dcca1
		Status: Free connection
		[4] - ow@bbf5ec6
		Status: Free connection

"Timed out attempting to acquire a reader connection" is a better error than "database is locked", hehe

It seems you have 3 zombie connections in your pool. I suspect this is because currently don't refill the pool when a connection dies. I'll work on a change to make sure the pool is always of the correct size. Thanks again for your patience on helping us make the library better.

Project: platform/frameworks/support
Branch: androidx-main
Author: Daniel Santiago Rivera <danysantiago@google.com>
Link:      https://android-review.googlesource.com/3546974

Reimplement suspending pool with Semaphore

Reimplement suspending pool with Semaphore 
 
This changes the implementation of Room's connection pool to use a Semaphore instead of a Channel. It makes the implementation simpler and removes the possibility of connections getting 'lost' due the the various branches needed to handle when a channel send / receive fails. 
 
The Channel was also used as a 'queue' instead a circular array is used to push and pop connections acquired and released into the pool. The semaphore still controls the amount of connections being locked and unlocked and is the suspending API that waits for a connection to be free. 
 
Bug: 322386871 
Bug: 380088809 
Test: BaseConnectionPoolTest 
Change-Id: I9b7f2d44b511eb3e3d8cdaf8cb8905bb6203f8c5

The next release (2.7.0-rc03) will have a change that should alleviate the 'Timed out attempting to acquire a reader connection' issue, I'll continue to keep this issue open so others can report if they are still experiencing it or not.

Hi. Thank you for your fixes. I have released 2.7.0-rc01 for 100% of users. For now it have about 22000 installs and I don't see the error SQLException: Error code: 5, message: database is locked anymore.

Hi. Got 1 android.database.SQLException: Error code: 5, message: database is locked

RoomDB: 2.7.0-rc03. Device: Oppo, Android 11

Note: before this was at native step, now I got it at nativePrepare.

Fatal Exception: android.database.SQLException: Error code: 5, message: database is locked
       at androidx.sqlite.driver.bundled.BundledSQLiteConnectionKt.nativePrepare(BundledSQLiteConnection.jvmAndroid.kt)
       at androidx.sqlite.driver.bundled.BundledSQLiteConnectionKt.access$nativePrepare(BundledSQLiteConnection.jvmAndroid.kt)
       at androidx.sqlite.driver.bundled.BundledSQLiteConnection.prepare(BundledSQLiteConnection.jvmAndroid.kt:36)
       at androidx.sqlite.SQLite.execSQL(SQLite.java:56)
       at androidx.room.BaseRoomConnectionManager.configureSynchronousFlag(BaseRoomConnectionManager.java:156)
       at androidx.room.BaseRoomConnectionManager.configurationConnection(BaseRoomConnectionManager.java:135)
       at androidx.room.BaseRoomConnectionManager.access$configurationConnection(BaseRoomConnectionManager.java:36)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.openLocked$lambda$1(BaseRoomConnectionManager.java:83)
       at androidx.room.concurrent.ExclusiveLock.withLock(ExclusiveLock.java:50)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.openLocked(BaseRoomConnectionManager.java:65)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.open(BaseRoomConnectionManager.java:57)
       at androidx.room.coroutines.ConnectionPoolImpl._init_$lambda$4(ConnectionPoolImpl.java:85)
       at androidx.room.coroutines.Pool.tryOpenNewConnectionLocked(ConnectionPoolImpl.kt:234)
       at androidx.room.coroutines.Pool.acquire(ConnectionPoolImpl.kt:219)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invokeSuspend(ConnectionPoolImpl.kt:171)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invoke(ConnectionPoolImpl.kt:12)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invoke(ConnectionPoolImpl.kt:12)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturnIgnoreTimeout(Undispatched.kt:54)
       at kotlinx.coroutines.TimeoutKt.setupTimeout(Timeout.kt:149)
       at kotlinx.coroutines.TimeoutKt.withTimeout(Timeout.kt:44)
       at kotlinx.coroutines.TimeoutKt.withTimeout-KLykuaI(Timeout.kt:72)
       at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:542)
       at androidx.room.RoomConnectionManager.useConnection(RoomConnectionManager.java:126)
       at androidx.room.RoomDatabase.useConnection$room_runtime_release(RoomDatabase.android.kt:588)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$$inlined$compatCoroutineExecute$DBUtil__DBUtil_androidKt$1.invokeSuspend(DBUtil.android.kt:109)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$$inlined$compatCoroutineExecute$DBUtil__DBUtil_androidKt$1.invoke(DBUtil.android.kt:12)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$$inlined$compatCoroutineExecute$DBUtil__DBUtil_androidKt$1.invoke(DBUtil.android.kt:12)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:43)
       at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext(BuildersKt__Builders_common.kt:166)
       at kotlinx.coroutines.BuildersKt.withContext(Builders.kt:1)
       at androidx.room.util.DBUtil__DBUtil_androidKt.performSuspending(DBUtil__DBUtil_android.kt:247)
       at androidx.room.util.DBUtil.performSuspending(DBUtil.java:1)
       at androidx.room.coroutines.FlowUtil$createFlow$$inlined$map$1$2.emit(Emitters.kt:224)
       at kotlinx.coroutines.flow.FlowKt__ChannelsKt.emitAllImpl$FlowKt__ChannelsKt(FlowKt__Channels.kt:33)
       at kotlinx.coroutines.flow.FlowKt__ChannelsKt.access$emitAllImpl$FlowKt__ChannelsKt(FlowKt__Channels.kt:1)
       at kotlinx.coroutines.flow.FlowKt__ChannelsKt$emitAllImpl$1.invokeSuspend(Channels.kt:11)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
       at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:100)
       at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.java:113)
       at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
       at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.java:586)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:820)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:717)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:704)

I also got 1 exception: android.database.SQLException: Error code: 5, message: Timed out attempting to acquire a writer connection.

Fatal Exception: android.database.SQLException: Error code: 5, message: Timed out attempting to acquire a writer connection.

Writer pool:
	fv1@6e0810d (capacity=1, permits=0, queue=(size=0)[], )
		[1] - Aw@1f718c2
		Status: Acquired connection
		Coroutine: [Ac0{Active}@7ccd6d3, Dispatchers.IO]
		Acquired:
			at xR.C(Unknown Source:328)
			at iK1.w(Unknown Source:6)
			at il2.h(Unknown Source:77)
			at Wk2.invokeSuspend(Unknown Source:28)
			at pq.resumeWith(Unknown Source:8)
			at Bc0.run(Unknown Source:109)
			at K2.run(Unknown Source:1024)
			at wc2.run(Unknown Source:2)
			at fW.run(Unknown Source:93)
		
Reader pool:
	fv1@7a12109 (capacity=4, permits=4, queue=(size=0)[], )
		[1] - null
		[2] - null
		[3] - null
		[4] - null

       at androidx.sqlite.SQLite.throwSQLiteException(SQLite.java:67)
       at androidx.room.coroutines.ConnectionPoolImpl.throwTimeoutException(ConnectionPoolImpl.kt:191)
       at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:142)
       at androidx.room.coroutines.ConnectionPoolImpl$useConnection$1.invokeSuspend(ConnectionPoolImpl.kt:13)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
       at kotlinx.coroutines.internal.ScopeCoroutine.afterResume(Scopes.kt:35)
       at kotlinx.coroutines.AbstractCoroutine.resumeWith(AbstractCoroutine.kt:101)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:46)
       at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:98)
       at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.java:113)
       at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
       at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.java:586)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:820)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:717)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:704)
        

And also I got 10 java.lang.UnsatisfiedLinkError: dlopen failed: library "libsqliteJni.so" not found

Maybe it may be linked with nativePrepare error?

Fatal Exception: java.lang.UnsatisfiedLinkError: dlopen failed: library "libsqliteJni.so" not found
       at java.lang.Runtime.loadLibrary0(Runtime.java:1131)
       at java.lang.Runtime.loadLibrary0(Runtime.java:1051)
       at java.lang.System.loadLibrary(System.java:1664)
       at androidx.sqlite.driver.bundled.NativeLibraryLoader.loadLibrary(NativeLibraryLoader.java:21)
       at androidx.sqlite.driver.bundled.BundledSQLiteDriver$NativeLibraryObject.<clinit>(BundledSQLiteDriver.jvmAndroid.kt:62)
       at androidx.sqlite.driver.bundled.BundledSQLiteDriver.open(BundledSQLiteDriver.java:55)
       at androidx.sqlite.driver.bundled.BundledSQLiteDriver.open(BundledSQLiteDriver.java:42)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.openLocked$lambda$1(BaseRoomConnectionManager.java:72)
       at androidx.room.concurrent.ExclusiveLock.withLock(ExclusiveLock.java:50)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.openLocked(BaseRoomConnectionManager.java:65)
       at androidx.room.BaseRoomConnectionManager$DriverWrapper.open(BaseRoomConnectionManager.java:57)
       at androidx.room.coroutines.ConnectionPoolImpl._init_$lambda$5(ConnectionPoolImpl.java:92)
       at androidx.room.coroutines.Pool.tryOpenNewConnectionLocked(ConnectionPoolImpl.kt:234)
       at androidx.room.coroutines.Pool.acquire(ConnectionPoolImpl.kt:219)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invokeSuspend(ConnectionPoolImpl.kt:171)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invoke(ConnectionPoolImpl.kt:12)
       at androidx.room.coroutines.ConnectionPoolImpl$acquireWithTimeout$2.invoke(ConnectionPoolImpl.kt:12)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturnIgnoreTimeout(Undispatched.kt:54)
       at kotlinx.coroutines.TimeoutKt.setupTimeout(Timeout.kt:149)
       at kotlinx.coroutines.TimeoutKt.withTimeout(Timeout.kt:44)
       at kotlinx.coroutines.TimeoutKt.withTimeout-KLykuaI(Timeout.kt:72)
       at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:542)
       at androidx.room.RoomConnectionManager.useConnection(RoomConnectionManager.java:126)
       at androidx.room.RoomDatabase.useConnection$room_runtime_release(RoomDatabase.android.kt:588)
       at androidx.room.TriggerBasedInvalidationTracker.syncTriggers$room_runtime_release(InvalidationTracker.kt:300)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1$1.invokeSuspend(InvalidationTracker.kt:233)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1$1.invoke(InvalidationTracker.kt:12)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1$1.invoke(InvalidationTracker.kt:12)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:43)
       at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext(BuildersKt__Builders_common.kt:166)
       at kotlinx.coroutines.BuildersKt.withContext(Builders.kt:1)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1.invokeSuspend(InvalidationTracker.kt:233)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1.invoke(InvalidationTracker.kt:12)
       at androidx.room.TriggerBasedInvalidationTracker$createFlow$1.invoke(InvalidationTracker.kt:12)
       at kotlinx.coroutines.flow.SafeFlow.collectSafely(SafeFlow.java:57)
       at kotlinx.coroutines.flow.AbstractFlow.collect(AbstractFlow.java:226)
       at kotlinx.coroutines.flow.internal.ChannelFlowOperatorImpl.flowCollect(ChannelFlow.kt:191)
       at kotlinx.coroutines.flow.internal.ChannelFlowOperator.collectTo$suspendImpl(ChannelFlow.kt:153)
       at kotlinx.coroutines.flow.internal.ChannelFlowOperator.collectTo(ChannelFlow.kt:5)
       at kotlinx.coroutines.flow.internal.ChannelFlow$collectToFun$1.invokeSuspend(ChannelFlow.kt:56)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
       at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:100)
       at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.java:113)
       at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
       at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.java:586)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:820)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:717)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:704)