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

Project: platform/frameworks/support
Branch: androidx-main

commit e81f3bda1116a1734ec397f54dd40f8472203294
Author: elifbilgin <elifbilgin@google.com>
Date: Mon Aug 08 12:22:30 2022

Converting `sqlite` related files in `sqlite` from Java to Kotlin (Part 1/3).

Test: Existing tests
Bug: 240707042
Relnote: Converting `sqlite` related files in `sqlite` from Java to Kotlin.
Change-Id: I7bc3574feaacb12bd4aa1c006579ddc52607a3a5

M room/room-runtime/api/restricted_current.txt
M room/room-runtime/src/test/java/androidx/room/RoomSQLiteQueryTest.java
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteProgram.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteCompat.kt
M sqlite/sqlite/src/test/java/androidx/sqlite/db/SimpleSQLiteQueryTest.kt
M sqlite/sqlite/api/current.txt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SimpleSQLiteQuery.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteQuery.kt
M room/room-compiler/build.gradle
M room/room-runtime/src/main/java/androidx/room/RoomSQLiteQuery.kt
M sqlite/sqlite-framework/build.gradle
M sqlite/sqlite/api/public_plus_experimental_current.txt
M sqlite/sqlite/build.gradle
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteStatement.kt
M room/room-runtime/api/restricted_current.ignore
M sqlite/sqlite/api/restricted_current.txt
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/QueryInterceptorTest.kt
M room/room-runtime/src/main/java/androidx/room/QueryInterceptorDatabase.kt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit 659c2cdeeb8a045b413da4763d1431497592e5cf
Author: elifbilgin <elifbilgin@google.com>
Date: Mon Aug 08 11:07:43 2022

Renaming `sqlite` related files in `sqlite` from Java to Kotlin (Part 1/3).

Test: Existing tests
Bug: 240707042
Relnote: Converting `sqlite` related files in `sqlite` from Java to Kotlin.
Change-Id: I60b041d58430c70c028b91ef8c86a0d64f89fc3a

M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteQuery.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteStatement.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteProgram.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteCompat.kt
M sqlite/sqlite/src/test/java/androidx/sqlite/db/SimpleSQLiteQueryTest.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SimpleSQLiteQuery.kt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit a55634970cd065189bf9055c9ec5cbbdeeb789fc
Author: elifbilgin <elifbilgin@google.com>
Date: Wed Aug 10 16:44:43 2022

Converting `sqlite-framework` related files in `sqlite-framework` from Java to Kotlin.

Test: Existing tests
Bug: 240707042
Relnote: Converting `sqlite-framework` related files in `sqlite-framework` from Java to Kotlin.
Change-Id: Iaa63a678596118d4d40da7b12a30839166d0bc11

D sqlite/sqlite-framework/src/main/java/androidx/sqlite/util/SneakyThrow.java
M room/room-runtime/src/androidTest/java/androidx/room/AutoClosingRoomOpenHelperTest.kt
M sqlite/sqlite-framework/api/current.txt
M sqlite/sqlite-framework/src/androidTest/java/androidx/sqlite/db/framework/OpenHelperRecoveryTest.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteDatabase.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteProgram.kt
M sqlite/sqlite-framework/api/public_plus_experimental_current.txt
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/InternalsTest.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/util/ProcessLock.kt
M sqlite/integration-tests/inspection-room-testapp/src/androidTest/java/androidx/sqlite/inspection/RoomInvalidationHookTest.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteOpenHelper.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteStatement.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteOpenHelperFactory.kt
M sqlite/sqlite-framework/api/restricted_current.txt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit d6fc345225a1546cdb00a8a2728dfb5adcddb762
Author: elifbilgin <elifbilgin@google.com>
Date: Wed Aug 10 12:55:32 2022

Initial code check-in for renaming `sqlite-framework` related files in `sqlite` from *.java to *.kt.

Test: N/A
Bug: 240707042
Relnote: Initial code check-in for renaming `sqlite-framework` related files in `sqlite` from *.java to *.kt.
Change-Id: I2ecd06a8122751ae46765a8a354a6c1e191e2149

M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteDatabase.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/util/ProcessLock.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteProgram.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteOpenHelper.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteStatement.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteOpenHelperFactory.kt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit 5e2fab48d7c66ec49ae8c1fff52bd0999c94fe05
Author: elifbilgin <elifbilgin@google.com>
Date: Thu Aug 18 10:27:53 2022

Converting `sqlite` related files in `sqlite` from Java to Kotlin (Part 2/3).

Test: Existing tests
Bug: 240707042
Relnote: Converting `sqlite` related files in `sqlite` from Java to Kotlin.
Change-Id: I1d635ae1b6e7ef76de9c626b2088266a6a094a4d

M work/work-runtime/build.gradle
M room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/SuspendingQueryTest.kt
M room/room-runtime/src/main/java/androidx/room/AutoClosingRoomOpenHelper.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteQueryBuilder.kt
M work/work-gcm/build.gradle
M sqlite/sqlite/api/current.txt
M work/work-testing/build.gradle
M work/work-runtime/src/androidTest/java/androidx/work/impl/utils/ForceStopRunnableTest.java
M room/room-runtime/src/main/java/androidx/room/SQLiteCopyOpenHelper.kt
M sqlite/sqlite/api/public_plus_experimental_current.txt
M work/work-runtime-ktx/build.gradle
M work/work-inspection/build.gradle
M room/room-runtime/src/main/java/androidx/room/QueryInterceptorOpenHelper.kt
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteOpenHelper.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteOpenHelper.kt
M work/work-multiprocess/build.gradle
M sqlite/sqlite/api/restricted_current.txt
M work/work-benchmark/build.gradle
M work/integration-tests/testapp/build.gradle

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit 751e9ba511b3263cab58bd877afe2dd7dc77b891
Author: elifbilgin <elifbilgin@google.com>
Date: Wed Aug 17 16:31:25 2022

Renaming `sqlite` related files in `sqlite` from Java to Kotlin (Part 2/3).

Test: Existing tests
Bug: 240707042
Relnote: Renaming `sqlite` related files in `sqlite` from Java to Kotlin.
Change-Id: I0c0558046191bd05621ae39988b4b7cd5b9459c5

M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteQueryBuilder.kt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteOpenHelper.kt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit 684e629ec17072ea31aae485492b4fd2b10043f6
Author: elifbilgin <elifbilgin@google.com>
Date: Tue Aug 30 18:47:45 2022

Converting SupportSQLiteDatabase from *.java to *.kt.

Test: N/A
Bug: 240707042
Relnote: Converting SupportSQLiteDatabase from *.java to *.kt.
Change-Id: I251619c5d7a0869b89fe23217abd768c295f5e1f

M room/room-runtime/src/androidTest/java/androidx/room/AutoClosingRoomOpenHelperFactoryTest.kt
M sqlite/sqlite-ktx/build.gradle
M sqlite/sqlite-framework/src/main/java/androidx/sqlite/db/framework/FrameworkSQLiteDatabase.kt
M sqlite/sqlite-ktx/src/main/java/androidx/sqlite/db/SupportSQLiteDatabaseExt.kt
A sqlite/sqlite/api/current.ignore
A sqlite/sqlite/api/restricted_current.ignore
M room/room-runtime/src/main/java/androidx/room/AutoClosingRoomOpenHelper.kt
M sqlite/integration-tests/inspection-sqldelight-testapp/build.gradle
M sqlite/sqlite-inspection/build.gradle
M sqlite/sqlite/api/current.txt
M sqlite/integration-tests/inspection-room-testapp/build.gradle
M room/room-ktx/src/test/java/androidx/room/MigrationTest.kt
M room/room-runtime/src/test/java/androidx/room/InvalidationTrackerTest.kt
M sqlite/sqlite-framework/build.gradle
M sqlite/sqlite/api/public_plus_experimental_current.txt
M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteDatabase.kt
M work/work-runtime/src/main/java/androidx/work/impl/WorkDatabaseMigrations.kt
M sqlite/sqlite/build.gradle
M sqlite/sqlite/api/restricted_current.txt
M room/room-runtime/src/main/java/androidx/room/QueryInterceptorDatabase.kt

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

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

Project: platform/frameworks/support
Branch: androidx-main

commit 89bfc918a0bfe3237470262b75fd4a71c4048a1e
Author: elifbilgin <elifbilgin@google.com>
Date: Tue Aug 30 18:07:34 2022

Initial code check-in for renaming SupportSQLiteDatabase from *.java to *.kt.

Test: N/A
Bug: 240707042
Relnote: Initial code check-in for renaming SupportSQLiteDatabase from *.java to *.kt.
Change-Id: I5627dba94bad99b1110778cd3e770c1f2a996294

M sqlite/sqlite/src/main/java/androidx/sqlite/db/SupportSQLiteDatabase.kt

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

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

This bug was linked in a change in the following release(s):

androidx.room:room-ktx:2.5.0-beta01
androidx.room:room-runtime:2.5.0-beta01
androidx.sqlite:sqlite:2.3.0-beta01
androidx.sqlite:sqlite-framework:2.3.0-beta01
androidx.sqlite:sqlite-ktx:2.3.0-beta01
androidx.work:work-gcm:2.8.0-beta01
androidx.work:work-multiprocess:2.8.0-beta01
androidx.work:work-runtime:2.8.0-beta01
androidx.work:work-runtime-ktx:2.8.0-beta01
androidx.work:work-testing:2.8.0-beta01

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

Same crash on Nexus 5X running Android 8.1.0 on androidx.sqlite:sqlite-bundled version 2.5.0-alpha10 with room version 2.7.0-alpha10.

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

Same crash on Pixel 6 Pro(android12),Nexus 5X(android8.1) on androidx.sqlite:sqlite-bundled version 2.5.0-alpha11 with room version 2.7.0-alpha11.

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

Same crash on Android 12, Pixel 6 Pro.
androidx.sqlite:sqlite-bundled version 2.5.0-alpha11 with room version 2.7.0-alpha11

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

For those experiencing this issue, can you provide any more detail: stacktrace, bug report, trends (specific API versions, specific manufacturer)?

Usually with UnsatisfiedLinkError there is more in the logs / error mentioning why the native library couldn't be used, specifically the missing symbol. I have so far validated we are linking against the right atomic library in the NDK, so I suspect it must be another symbol.

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