android.database.sqlite.SQLiteException: file is not a database (code 26):

Please fill out the following details:

1. Version of Mobile SDK Used: 12.1.1
2. Issue found in Native App or Hybrid App: Native App
3. OS Version: Android 14
4. Device: Samsung A 52
5. Steps to reproduce: registerSoup const registerSoup = forceUtil?.promiser(smartstore.registerSoup);
6. Actual behavior:
7. Expected Behavior:
8. Error Log: android.database.sqlite.SQLiteException: file is not a database (code 26):

Fatal Exception: android.database.sqlite.SQLiteException: file is not a database (code 26): , while compiling: SELECT COUNT() FROM sqlite_schema;
#################################################################
Error Code : 26 (SQLITE_NOTADB)
Caused By : File opened that is not a database file or encrypted.
(file is not a database (code 26): , while compiling: SELECT COUNT() FROM sqlite_schema;)
#################################################################
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.executeForLong(SQLiteConnection.java:628)
at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:240)
at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:202)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:474)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:189)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:181)
at net.zetetic.database.sqlcipher.SQLiteDatabase.openInner(SQLiteDatabase.java:1028)
at net.zetetic.database.sqlcipher.SQLiteDatabase.open(SQLiteDatabase.java:1013)
at net.zetetic.database.sqlcipher.SQLiteDatabase.openDatabase(SQLiteDatabase.java:840)
at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:359)
at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:278)
at net.zetetic.database.sqlcipher.SupportHelper.getWritableDatabase(SupportHelper.java:60)
at androidx.room.RoomDatabase.inTransaction(RoomDatabase.kt:638)
at androidx.room.RoomDatabase.assertNotSuspendingTransaction(RoomDatabase.kt:457)
at androidx.room.RoomDatabase.query(RoomDatabase.kt:486)
at androidx.room.util.DBUtil.query(DBUtil.kt:75)

It's not happening for all users
It is happening only for specific devices

[wmathurin]

What devices (make / OS version) is it happening on?

• OS Version: Android 14
• Device: Samsung A52

[tcoolma]

We have encountered the same issue on two devices.
Samsung SM-A356E, Android 14
ZTE Blade A34, Android 13

The Mobile SDK Version is 12.0.1

Exception: android.database.sqlite.SQLiteException
Ex. Message: file is not a database (code 26): , while compiling: SELECT COUNT(*) FROM sqlite_schema;
Thread: Thread[mqt_native_modules,5,main]
Memory Usage: 10 / 1919 MB (0%)

Device Mfr.: ZTE
Device Model: ZTE Blade A34
OS Version: 13
Conn. Type: 4g
Carrier: Claro

Original stack trace:

android.database.sqlite.SQLiteException : file is not a database (code 26): , while compiling: SELECT COUNT(*) FROM sqlite_schema;
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.executeForLong(SQLiteConnection.java:628)
at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:240)
at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:202)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:475)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:189)
at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:181)
at net.zetetic.database.sqlcipher.SQLiteDatabase.openInner(SQLiteDatabase.java:1028)
at net.zetetic.database.sqlcipher.SQLiteDatabase.open(SQLiteDatabase.java:1013)
at net.zetetic.database.sqlcipher.SQLiteDatabase.openDatabase(SQLiteDatabase.java:840)
at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:359)
at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:278)
at com.salesforce.androidsdk.smartstore.store.SmartStore.getDatabase(SmartStore.java:207)
at com.salesforce.androidsdk.reactnative.bridge.SmartStoreReactBridge.upsertSoupEntries(SmartStoreReactBridge.java:280)
at java.lang.reflect.Method.invoke(Method.java)
at com.facebook.react.bridge.JavaMethodWrapper.invoke(JavaMethodWrapper.java:372)
at com.facebook.react.bridge.JavaModuleWrapper.invoke(JavaModuleWrapper.java:149)
at com.facebook.jni.NativeRunnable.run(NativeRunnable.java)
at android.os.Handler.handleCallback(Handler.java:942)
at android.os.Handler.dispatchMessage(Handler.java:99)
at com.facebook.react.bridge.queue.MessageQueueThreadHandler.dispatchMessage(MessageQueueThreadHandler.java:29)
at android.os.Looper.loopOnce(Looper.java:235)
at android.os.Looper.loop(Looper.java:350)
at com.facebook.react.bridge.queue.MessageQueueThreadImpl$4.run(MessageQueueThreadImpl.java:234)
at java.lang.Thread.run(Thread.java:1012)

No mapping file provided for the current version. De-obfuscation of stack trace not possible.

[tcoolma]

Could this be related to the Android OS version? Your attention to this issue would be greatly appreciated. Thanks!

Still facing in version 13.0.0

Any Update on this?

Facing in Hybrid react-native SDK as well
the above same issue

"android.database.sqlite.SQLiteException: file is not a database (code 26): , while compiling: SELECT COUNT(*) FROM sqlite_schema;" still facing the same

Any Update on this? @wmathurin

[wmathurin]

Are you accessing a smartstore while the user is logging out or a user switch is taking place?

Are you accessing a smartstore while the user is logging out or a user switch is taking place?

No, we are not calling the smartstore thing on logout, nor is any user Switch happening.
The thing is that
Whenever any application update is received by the user, and we try to registerSoup at that time, we face the issue.

[Danielturr]

We are also facing this issue. It is only happening on one device, but whenever they launch the app, it basically crashes with this error.

Fatal Exception: android.database.sqlite.SQLiteException: file is not a database (code 26): , while compiling: SELECT COUNT(*) FROM sqlite_schema; at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java) at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973) at net.zetetic.database.sqlcipher.SQLiteConnection.executeForLong(SQLiteConnection.java:628) at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:240) at net.zetetic.database.sqlcipher.SQLiteConnection.open(SQLiteConnection.java:202) at net.zetetic.database.sqlcipher.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:475) at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:189) at net.zetetic.database.sqlcipher.SQLiteConnectionPool.open(SQLiteConnectionPool.java:181) at net.zetetic.database.sqlcipher.SQLiteDatabase.openInner(SQLiteDatabase.java:1028) at net.zetetic.database.sqlcipher.SQLiteDatabase.open(SQLiteDatabase.java:1013) at net.zetetic.database.sqlcipher.SQLiteDatabase.openDatabase(SQLiteDatabase.java:840) at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:359) at net.zetetic.database.sqlcipher.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:278) at com.aho.androidsdk.smartstore.store.SmartStore.getDatabase(SmartStore.java:217) at com.aho.androidsdk.reactnative.bridge.SmartStoreReactBridge.upsertSoupEntries(SmartStoreReactBridge.java:280) at java.lang.reflect.Method.invoke(Method.java) at com.facebook.react.bridge.JavaMethodWrapper.invoke(JavaMethodWrapper.java:372) at com.facebook.react.bridge.JavaModuleWrapper.invoke(JavaModuleWrapper.java:149) at com.facebook.jni.NativeRunnable.run(NativeRunnable.java) at android.os.Handler.handleCallback(Handler.java:959) at android.os.Handler.dispatchMessage(Handler.java:100) at com.facebook.react.bridge.queue.MessageQueueThreadHandler.dispatchMessage(MessageQueueThreadHandler.java:29) at android.os.Looper.loopOnce(Looper.java:257) at android.os.Looper.loop(Looper.java:342) at com.facebook.react.bridge.queue.MessageQueueThreadImpl$4.run(MessageQueueThreadImpl.java:234) at java.lang.Thread.run(Thread.java:1012)

Device
Brand: Samsung
Model: Galaxy Z Fold6
Orientation: Portrait
RAM free: 5.07 GB
Disk free: 146.26 GB

Operating System
Version: Android 15
Orientation: Portrait
Rooted: No