(Android) no such table: media_store_extension

[j3k0]

Since the upgrade to AIR SDK 33.1.1.674, I get this report from Android pre-launch report:

FATAL EXCEPTION: latency_sensitive_executor-thread-0
Process: com.google.android.apps.photos, PID: 28680
java.lang.RuntimeException: android.database.sqlite.SQLiteException: no such table: media_store_extension (code 1): , while compiling: SELECT id FROM media_store_extension WHERE POPULATED_COLUMNS != 134217726 OR DATE_MODIFIED = -1 OR FINGERPRINT IS NULL
	at nqo.a(PG:3)
	at aleu.run(PG:6)
	at krv.a(PG:17)
	at krw.run(Unknown Source:6)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636)
	at java.lang.Thread.run(Thread.java:764)
	at ksa.run(PG:5)
Caused by: android.database.sqlite.SQLiteException: no such table: media_store_extension (code 1): , while compiling: SELECT id FROM media_store_extension WHERE POPULATED_COLUMNS != 134217726 OR DATE_MODIFIED = -1 OR FINGERPRINT IS NULL
	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:890)
	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:501)
	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
	at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1392)
	at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1239)
	at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1110)
	at agcm.a(PG:8)
	at nog.a(PG:12)
	at nqf.a(PG:5)
	at _381.a(PG:248)
	at npu.run(PG:61)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:457)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)

It happens to only one device: Xiamod Redmi 6A.

I found this thread describing the exact same issue, with a possible fix (involving a change the gradle config):
https://forum.unity.com/threads/error-when-submitting-app-to-google-play.1098139/

[ajwfrost]

Thanks -> sounds like we are missing the mapping between the configuration file setting - e.g:

UncompressedExtensions=emd,tfl,tflite,pb

when using the App Bundle format. So based on that stack overflow post we should be injecting:

    aaptOptions {
        noCompress 'emd,tfl,tflite,pb'
    }

(or whatever other file extensions are listed, such as db, as not being compressed...)

We can make this change for the next release: in the meantime, if you set the configuration file so that you have:

KeepAndroidStudioOutput=true

you can then open up the resulting AndroidStudioProject folder within Android Studio itself and edit the app\build.gradle file for this, and then build the apk/aab from Android Studio itself..

thanks

[ajwfrost]

FYI there's a patch version of ADT available for this now, which should be generating those aaptOptions block:
https://transfer.harman.com/message/2ze0uhJ86Cg30FS8GeBqOr

thanks

[j3k0]

The patched ADT fixes the crash on Xiaomi Redmi 6A devices.

[MrCsabaToth]

I think this is a problem with the particular Xiaomi Redmi 6A device the pre-launch report uses on Google's end. Flutter developers get the same thing, only from that device. https://stackoverflow.com/questions/69919198/java-lang-runtimeexception-android-database-sqlite-sqliteexception-no-such-tab