Fixed

Bug

Status Update

No update yet.

Description

ya...@gmail.com

created issue #1

May 20, 2024 09:45AM

Component used: androidx.room, androidx.sqlite:sqlite-bundled
Version used: androidx.room 2.7.0-alpha02, androidx.sqlite:sqlite-bundled 2.5.0-alpha02
Devices/Android versions reproduced on: Nexus 5X/8.1.0

I created an Android app using Room (Kotlin Multiplatform) and distributed it on the Play Store. Crashlytics reported that some Android devices were failing to instantiate the BundledSQLiteDriver.

Here is the stack trace.

      Fatal Exception: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" referenced by "/data/app/com.example.myapp.androidApp-eZAPwaCuftjM0oTWOtQSJQ==/split_config.armeabi_v7a.apk!/lib/armeabi-v7a/libsqliteJni.so"...
       at java.lang.Runtime.loadLibrary0(Runtime.java:1071)
       at java.lang.Runtime.loadLibrary0(Runtime.java:1007)
       at java.lang.System.loadLibrary(System.java:1667)
       at androidx.sqlite.driver.bundled.NativeLibraryLoader.loadLibrary(NativeLibraryLoader.java:24)
       at androidx.sqlite.driver.bundled.BundledSQLiteDriver.<clinit>(BundledSQLiteDriver.androidJvmCommon.kt:36)
       at com.example.myapp.shared.DataRepository.<init>(DataRepository.kt:39)
       at com.example.myapp.androidApp.MainApplication$appModule$1$3.invoke(MainApplication.java:144)
       at com.example.myapp.androidApp.MainApplication$appModule$1$3.invoke(MainApplication.java:143)
       at org.koin.core.instance.InstanceFactory.create(InstanceFactory.java:50)
       at org.koin.core.instance.SingleInstanceFactory.create(SingleInstanceFactory.java:46)
       at org.koin.core.instance.SingleInstanceFactory$get$1.invoke(SingleInstanceFactory.java:55)
       at org.koin.core.instance.SingleInstanceFactory$get$1.invoke(SingleInstanceFactory.java:53)
       at org.koin.mp.KoinPlatformTools.synchronized(KoinPlatformTools.java:36)
       at org.koin.core.instance.SingleInstanceFactory.get(SingleInstanceFactory.java:53)
       at org.koin.core.registry.InstanceRegistry.resolveInstance$koin_core(InstanceRegistry.java:109)
       at org.koin.core.scope.Scope.resolveValue(Scope.kt:247)
       at org.koin.core.scope.Scope.resolveInstance(Scope.kt:233)
       at org.koin.core.scope.Scope.get(Scope.kt:212)
       at com.example.myapp.shared.core.NovelPageReducer$special$$inlined$inject$default$6.invoke(NovelPageReducer.java:67)
       at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74)
       at com.example.myapp.shared.core.NovelPageReducer.getDataRepository(NovelPageCore.kt:153)
       at com.example.myapp.shared.core.NovelPageReducer.fetchIsBookmarked(NovelPageCore.kt:431)
       at com.example.myapp.shared.core.NovelPageReducer.access$fetchIsBookmarked(NovelPageCore.kt:143)
       at com.example.myapp.shared.core.NovelPageReducer$reduce$2.invokeSuspend(NovelPageCore.kt:176)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
       at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104)
       at android.os.Handler.handleCallback(Handler.java:883)
       at android.os.Handler.dispatchMessage(Handler.java:100)
       at android.os.Looper.loop(Looper.java:214)
       at android.app.ActivityThread.main(ActivityThread.java:7388)
       at java.lang.reflect.Method.invoke(Method.java)
       at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:492)
       at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:980)

I did not reproduce the above error on my Pixel 4a/Android 13.

Sample project to trigger the issue.

I created a sample project with a configuration similar to the production application where the error occurred.

https://github.com/k-yamada/ReproduceBundledSQLiteDriverError

Line where the error occurred.

https://github.com/k-yamada/ReproduceBundledSQLiteDriverError/blob/main/shared/src/commonMain/kotlin/com/example/reproduce/DataRepository.kt#L13

Devices with error reported by Crashlytics

V10/Android 10
Galaxy Feel/Android 8.0.0
Kfonwi/Android 9
Nexus 5X/Android 8.1.0
Tab M7 3rd Gen/Android 11
Pixel 3 XL/Android 9
Pixel 6 Pro/Android 12
K10C/Android 13
FFFTAB8/Android 12

Comments

da...@google.com <da...@google.com> #2May 21, 2024 07:45AM

+1, but Deferred does not solve the Observer problem that Rx and LiveData do, so I guess Google should implement Channels instead of LiveData which is actually a Kotlin Coroutine counterpart. Looking forward to this as I've decided not to use RxJava in most of future projects due to Kotlin Coroutines..

da...@google.com <da...@google.com> #3May 21, 2024 09:50AM

Project: platform/frameworks/support
Branch: androidx-master-dev

commit e78cceffeac28f0028342990c1391c640edf453c
Author: Daniel Santiago Rivera <danysantiago@google.com>
Date: Wed Nov 28 12:40:24 2018

Room Support for Coroutines

This change allows users to define suspend functions in DAOs with
@Query, @Insert, @Update and @Delete. The new artifact room-coroutine
defines a helper classes for supporting the feature.

Bug: 69474692
Test: ./gradlew room:integration-tests:kotlintestapp:cC
Change-Id: Id73a6b845df3f21f99d14cb6980130dcf3885c81

M buildSrc/src/main/kotlin/androidx/build/PublishDocsRules.kt
A room/compiler/src/main/kotlin/androidx/room/ext/KotlinMetadataElement.kt
D room/compiler/src/main/kotlin/androidx/room/ext/KotlinMetadataProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/ext/element_ext.kt
M room/compiler/src/main/kotlin/androidx/room/ext/javapoet_ext.kt
M room/compiler/src/main/kotlin/androidx/room/processor/DeletionMethodProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/processor/InsertionMethodProcessor.kt
A room/compiler/src/main/kotlin/androidx/room/processor/MethodProcessorDelegate.kt
M room/compiler/src/main/kotlin/androidx/room/processor/PojoProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/processor/ProcessorErrors.kt
M room/compiler/src/main/kotlin/androidx/room/processor/QueryMethodProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/processor/RawQueryMethodProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/processor/ShortcutMethodProcessor.kt
M room/compiler/src/main/kotlin/androidx/room/processor/UpdateMethodProcessor.kt
A room/compiler/src/main/kotlin/androidx/room/solver/query/result/CoroutineResultBinder.kt
M room/compiler/src/main/kotlin/androidx/room/solver/query/result/PojoRowAdapter.kt
A room/compiler/src/main/kotlin/androidx/room/solver/shortcut/binder/CoroutineDeleteOrUpdateMethodBinder.kt
A room/compiler/src/main/kotlin/androidx/room/solver/shortcut/binder/CoroutineInsertMethodBinder.kt
M room/compiler/src/main/kotlin/androidx/room/solver/shortcut/result/DeleteOrUpdateMethodAdapter.kt
M room/compiler/src/main/kotlin/androidx/room/solver/shortcut/result/InsertMethodAdapter.kt
M room/compiler/src/main/kotlin/androidx/room/vo/RelationCollector.kt
M room/compiler/src/test/kotlin/androidx/room/processor/QueryMethodProcessorTest.kt
A room/coroutines/build.gradle
A room/coroutines/src/main/AndroidManifest.xml
A room/coroutines/src/main/java/androidx/room/CoroutinesRoom.kt
M room/integration-tests/kotlintestapp/build.gradle
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/dao/BooksDao.kt
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/BooksDaoTest.kt
A room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/SuspendRoomDispatcherTest.kt
M settings.gradle

https://android-review.googlesource.com/833705

https://goto.google.com/android-sha1/e78cceffeac28f0028342990c1391c640edf453c

ad...@ally.rapido.bike <ad...@ally.rapido.bike> #4May 29, 2024 08:42AM

So do you support any Coroutine "observables" like channels? Or these are just one-off suspending calls?

ap...@google.com <ap...@google.com> #5May 30, 2024 01:07AM

For now we'll be just supporting one-off suspend functions in Room 2.1.0-alpha03. Coroutines stream functionality with channels is still a work in progress.

da...@google.com <da...@google.com> May 30, 2024 01:09AM

Marked as fixed.

bo...@gmail.com <bo...@gmail.com> #6Jun 25, 2024 12:42PM

Relating to the original request, how about allowing a return type of Deferred<LiveData<T>> which suspends until LiveData<T>'s value has been set the first time?

da...@google.com <da...@google.com> #7Jun 25, 2024 12:45PM

I just tested out Room 2.1.0-alpha03 and added suspend to all of my functions.... there appears to be an issue with functions that use @Query() and UPDATE and DELETE queries. Examples:

Code Example 1:
@Query("DELETE FROM individual")
suspend fun deleteAll()
Error:
Deletion methods must either return void or return int (the number of deleted rows).

Code Example 2:
@Query("UPDATE individual SET firstName = :firstName WHERE id = :id")
suspend fun updateFirstName(id: Long, firstName: String)
Error:
Not sure how to convert a Cursor to this method's return type (kotlin.Unit).

bo...@gmail.com <bo...@gmail.com> #8Jun 25, 2024 01:10PM

Async return types with @Query that perform UPDATE, DELETE or INSERT are not yet supported. This also applies to coroutines. We are actively working on adding this for the next alpha of 2.1.0. Subscribe to the bug for updates:

https://issuetracker.google.com/issues/120227284

da...@google.com <da...@google.com> #9Jun 25, 2024 01:17PM

Hello.
Any updates on returning Channel<T> from DAO?
Will contributions be accepted for that feature?

ro...@gmail.com <ro...@gmail.com> #10Aug 16, 2024 02:09PM

Channels are experimental right now so we probably want to wait until it is stable.

ev...@due.network <ev...@due.network> #11Oct 31, 2024 12:19PM

Channels +1

f2...@gmail.com <f2...@gmail.com> #12Nov 9, 2024 03:14AM

Marking as fix since core coroutines are supported in 2.1, in the mean time we'll keep an eye on the Channels API to potentially support it once its upgraded out of experimental.

https://issuetracker.google.com/issues/127328278

ke...@level.co <ke...@level.co> #13Nov 14, 2024 04:30PM

Is it expected that we still have to ensure that suspended functions aren't dispatched from the main thread?
The first call (eg `final SupportSQLiteStatement _stmt = __preparedStmtOfDeleteAll.acquire();`) is not wrapped in a callable and can't be done on the ui thread, so we still have to wrap suspensions with our own context.

da...@google.com <da...@google.com> #14Nov 14, 2024 11:11PM

Kotlinx.coroutines 1.2 released with cold stream abstraction Flow:

https://kotlin.github.io/kotlinx.coroutines/kotlinx-coroutines-core/kotlinx.coroutines.flow/-flow/index.html

It's in "preview" status, but maybe we also could expect some experimental version of Room with Flow support for observable requests

ki...@protonmail.com <ki...@protonmail.com> #15Dec 8, 2024 10:12PM

Same crash on Pixel 6 pro

androidx-room = "2.7.0-alpha11"

androidx-sqlite = "2.5.0-alpha11"

Attached a stack trace

Message last modified on Dec 8, 2024 10:13PM

0a349c077202524f96de843fde217909_crash_session_675378B4004800010C938EC151423BF4_DNE_0_v2_stacktrace.txt

34 KB

View

Download

da...@nutrium.com <da...@nutrium.com> #16Dec 11, 2024 10:04AM

Hi, we released a app yesterday and we are facing the same issue with the same stack trace of

https://issuetracker.google.com/issues/341639198#comment15

Does anyone knows if it's safe to use AndroidSQLiteDriver for android as a backup plan?

We also released the iOS app some weeks ago and until know we didn't catch any issue related to this.

da...@google.com <da...@google.com> #17Dec 11, 2024 04:32PM

For the stacktrace in comment#15 its as if the JNI lib was not packaged with the APK, can you confirm if the APK has the native libraries? They should be located in jni/<abi>/libsqliteJni.so

da...@nutrium.com <da...@nutrium.com> #18Dec 18, 2024 03:28PM

Hi, thanks for the reply we don't have the JNI lib jni/<abi>/libsqliteJni.so
We have the structure like in the screenshoot

Screenshot 2024-12-18 at 15.23.44.png

54 KB

View

Download

al...@gmail.com <al...@gmail.com> #19Dec 28, 2024 01:47PM

Facing the same

issue 2

.7.0-alpha12

IssueTracker

BundledSQLiteDriver: couldn't find "libsqliteJni.so"

Status Update

Description

Sample project to trigger the issue.

Devices with error reported by Crashlytics

Comments

da...@google.com <da...@google.com> #2May 21, 2024 07:45AM

da...@google.com <da...@google.com> #3May 21, 2024 09:50AM

ad...@ally.rapido.bike <ad...@ally.rapido.bike> #4May 29, 2024 08:42AM

ap...@google.com <ap...@google.com> #5May 30, 2024 01:07AM

da...@google.com <da...@google.com> May 30, 2024 01:09AM

bo...@gmail.com <bo...@gmail.com> #6Jun 25, 2024 12:42PM

da...@google.com <da...@google.com> #7Jun 25, 2024 12:45PM

bo...@gmail.com <bo...@gmail.com> #8Jun 25, 2024 01:10PM

da...@google.com <da...@google.com> #9Jun 25, 2024 01:17PM

ro...@gmail.com <ro...@gmail.com> #10Aug 16, 2024 02:09PM

ev...@due.network <ev...@due.network> #11Oct 31, 2024 12:19PM

f2...@gmail.com <f2...@gmail.com> #12Nov 9, 2024 03:14AM

ke...@level.co <ke...@level.co> #13Nov 14, 2024 04:30PM

da...@google.com <da...@google.com> #14Nov 14, 2024 11:11PM

ki...@protonmail.com <ki...@protonmail.com> #15Dec 8, 2024 10:12PM

da...@nutrium.com <da...@nutrium.com> #16Dec 11, 2024 10:04AM

da...@google.com <da...@google.com> #17Dec 11, 2024 04:32PM

da...@nutrium.com <da...@nutrium.com> #18Dec 18, 2024 03:28PM

al...@gmail.com <al...@gmail.com> #19Dec 28, 2024 01:47PM

Issue 341639198

Description

Sample project to trigger the issue.

Devices with error reported by Crashlytics

Issue summary

Comments

da...@google.com <da...@google.com> #2May 21, 2024 07:45AM

da...@google.com <da...@google.com> #3May 21, 2024 09:50AM

ad...@ally.rapido.bike <ad...@ally.rapido.bike> #4May 29, 2024 08:42AM

ap...@google.com <ap...@google.com> #5May 30, 2024 01:07AM

da...@google.com <da...@google.com> May 30, 2024 01:09AM

bo...@gmail.com <bo...@gmail.com> #6Jun 25, 2024 12:42PM

da...@google.com <da...@google.com> #7Jun 25, 2024 12:45PM

bo...@gmail.com <bo...@gmail.com> #8Jun 25, 2024 01:10PM

da...@google.com <da...@google.com> #9Jun 25, 2024 01:17PM

ro...@gmail.com <ro...@gmail.com> #10Aug 16, 2024 02:09PM

ev...@due.network <ev...@due.network> #11Oct 31, 2024 12:19PM

f2...@gmail.com <f2...@gmail.com> #12Nov 9, 2024 03:14AM

ke...@level.co <ke...@level.co> #13Nov 14, 2024 04:30PM

da...@google.com <da...@google.com> #14Nov 14, 2024 11:11PM

ki...@protonmail.com <ki...@protonmail.com> #15Dec 8, 2024 10:12PM

da...@nutrium.com <da...@nutrium.com> #16Dec 11, 2024 10:04AM

da...@google.com <da...@google.com> #17Dec 11, 2024 04:32PM

da...@nutrium.com <da...@nutrium.com> #18Dec 18, 2024 03:28PM

al...@gmail.com <al...@gmail.com> #19Dec 28, 2024 01:47PM

Add comment

Issue metadata