App is crashing on some devices

[ashishdimi09]

I am using SQLCipher for Android version:
implementation 'net.zetetic:android-database-sqlcipher:4.2.0@aar'

for some devices getting below error and its not reproducible

Google console device :
net.sqlcipher.database.SQLiteException:
at net.sqlcipher.database.SQLiteCompiledSql.native_compile (Native Method)
at net.sqlcipher.database.SQLiteCompiledSql.compile (SQLiteCompiledSql.java:91)
at net.sqlcipher.database.SQLiteCompiledSql. (SQLiteCompiledSql.java:64)
at net.sqlcipher.database.SQLiteProgram. (SQLiteProgram.java:89)
at net.sqlcipher.database.SQLiteQuery. (SQLiteQuery.java:48)
at net.sqlcipher.database.SQLiteDirectCursorDriver.query (SQLiteDirectCursorDriver.java:60)
at net.sqlcipher.database.SQLiteDatabase.rawQueryWithFactory (SQLiteDatabase.java:2012)
at net.sqlcipher.database.SQLiteDatabase.rawQuery (SQLiteDatabase.java:1898)
at net.sqlcipher.database.SQLiteDatabase.keyDatabase (SQLiteDatabase.java:2647)
at net.sqlcipher.database.SQLiteDatabase.openDatabaseInternal (SQLiteDatabase.java:2577)
at net.sqlcipher.database.SQLiteDatabase.openDatabase (SQLiteDatabase.java:1243)
at net.sqlcipher.database.SQLiteDatabase.openOrCreateDatabase (SQLiteDatabase.java:1318)
at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase (SQLiteOpenHelper.java:166)
at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase (SQLiteOpenHelper.java:135)
at net.sqlcipher.database.SQLiteOpenHelper.getWritableDatabase (SQLiteOpenHelper.java:131)
at com.XXXXXXX.XXXXXX.DataBase$13.run (:865)
at java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:641)
at java.lang.Thread.run (Thread.java:919)

It occurs over all android versions (Android 5.1 to 10)

[developernotes]

Hi @ashishdimi09

Thank you for your interest in SQLCipher and sharing your report. Unfortunately, there is not enough actionable information for us to investigate further.

• Did the SQLiteException contain a message? If so, what was it?
• What application code is executing when this occurs?
• What version(s) of the Android OS is this occurring on?
• Are you able to reproduce this issue consistently on any device or emulator?

Additionally, if you are able to reproduce this issue in a development environment, please extract the database from the device/emulator and attempt to open/inspect it manually. You can use the nightly build of DB Browser for SQLite if you don't have a tool.

Finally, you might also consider updating to the latest version of SQLCipher for Android, currently at 4.4.3 to see if you continue to observe this behavior. If you are trying to isolate the behavior for reproduction purposes, you might consider trying to compose a small test within the SQLCipher for Android test suite, we have instructions for creating a test here. Thanks!

[ashishdimi09]

Hi @developernotes
Thank you to respond Nick

Please find the below information as per you queries to investigate further

1. Did the SQLiteException contain a message? If so, what was it?
   I did't see the any message in Google crash log console.
2. What application code is executing when this occurs?
   on button click
3. What version(s) of the Android OS is this occurring on?
   It occurs over all android versions (Android 5.1 to 10). Have attached screenshot
4. Are you able to reproduce this issue consistently on any device or emulator?
   Unable to reproduce any device or emulator

I have tried to use test suite but did't find any issue. From next release will use the latest version of SQLCipher v4.4.3 but it will take time. We are curious about the crash issue right now and that only happing for few devices.

https://user-images.githubusercontent.com/17329771/110935273-3a63a600-8355-11eb-8fbb-f9d9e8f277d5.png

[developernotes]

Hi @ashishdimi09

Unfortunately, this is still not enough information to begin an analysis of the issue you're experiencing. It would be helpful if you were to inspect the application code that is executed within the button click, then try to replicate the database logic within a separate test within the SQL Android test suite to see if reproduction is possible.

[stale]

Hello, it looks like there has been no activity on this issue recently. Has the issue been fixed, or does it still require the community's attention? This issue may be closed if no further activity occurs. You may also label this issue as "bug", "enhancement", or "security" and I will leave it open. Thank you for your contributions.

[stale]

Closing this issue after a prolonged period of inactivity. If this issue is still present in the latest release, please feel free to reopen with up-to-date information.