Error when submitting app to Google Play

Unity Engine
, ,
1

Sometimes when I upload an AAB file to the Google play store I get the following Error:

unity java.lang.RuntimeException: android.database.sqlite.SQLiteException: no such table: media_store_extension (code 1)

I can still submit the app, but it’s more than a warning. Google tells me that the app actually crashed with that error on some devices. What is odd is that I can resubmit and sometimes get the same error and sometimes none at all.

In Unity build settings I request permission for WRITE_EXTERNAL_STORAGE to save screenshots. Not sure if that is related.

Full Error

FATAL EXCEPTION: latency_sensitive_executor-thread-0
Process: com.google.android.apps.photos, PID: 25936
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)
    ... 4 more

It happens on a Xiaomi Redmi 6A device.

2

I got the same thing on the exact same device. Mine is a Crash Error and not a Warning. Keep me posted on any solutions!

3

Did you by chance add Google Play Game Services when this happened to you? I started getting these when I added GPGS plugin to my project.

4

Hi there, also getting the same error via the console after adding ‘take a screenshot and share’ functionality via store asset plugin - did you find any solution? Also happening on Xiaomi Redmi 6A.

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

Full Details

FATAL EXCEPTION: latency_sensitive_executor-thread-0
Process: com.google.android.apps.photos, PID: 30260
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)
   ... 4 more
FATAL EXCEPTION: latency_sensitive_executor-thread-1
Process: com.google.android.apps.photos, PID: 30260
java.lang.RuntimeException: android.database.sqlite.SQLiteException: no such table: media_store_extension (code 1): , while compiling: SELECT id FROM media_store_extension ORDER BY id DESC LIMIT 100 OFFSET 0
   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 ORDER BY id DESC LIMIT 100 OFFSET 0
   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 nnw.run(PG:17)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:457)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   ... 4 more
5

I am also experiencing this issue. I have not personally enabled any take a screenshot and share settings, but have added GPGS plugin to my project. I have not experienced this issue until today.

6

After reading a StackOverflow post which said:

I updated the aaptOptions of mainTemplate.gradle (Assets/Plugins/Android/mainTemplate.gradle) with noCompress 'db', so it looked like:

    aaptOptions {
        ignoreAssetsPattern = "!.svn:!.git:!.ds_store:!*.scc:.*:!CVS:!thumbs.db:!picasa.ini:!*~"
        noCompress 'db'
    }**PACKAGING_OPTIONS**

I also updated the External Dependency Manager for Unity from 1.2.164 to 1.2.165: GitHub - googlesamples/unity-jar-resolver: Unity plugin which resolves Android & iOS dependencies and performs version management

I can’t say for 100% certain which change fixed it, but it was likely the gradle build change - but I thought I’d list both things I did here just in case. No errors now after uploading (as shown below in Screenshot):

1483×190 10.6 KB

Hope that’s helpful to someone.

7

Thanks, Vixxd I’ll be sure to try it out. In case anyone else wants to try this solution but has not enabled a custom main gradle template, go to Edit->Project Settings->Player->Publishing Settings->Check the box “Custom Main Gradle Template”. Once done, the file will appear in the directory mentioned.

8

Just to confirm I edited my gradle template by adding the noCompress 'db and it appears to have worked. I will update my comment in case the issue comes back. Thanks!

7116958--849484--Screen Shot 2021-05-07 at 1.22.41 AM.png

9

I am also not seeing the error after doing the changes, will report back if it happens again.
Thank you @Vixxd !

10

i am having the same issue with the same phone , i am now following the instructions listed here , to clarify,
editing the main template.gradle , i am to replace this line:
noCompress = [‘.ress’, ‘.resource’, ‘.obb’] + unityStreamingAssets.tokenize(', ')
with this line:
noCompress ‘db’

really really clueless, thank you

11

Seems the fix is not permanent as I have not changed the template after adding noCompress 'db'.

7458851--915548--Screen Shot 2021-08-29 at 5.28.54 PM.png
7458851--915548--Screen Shot 2021-08-29 at 5.28.54 PM.png1768×488 40.4 KB

What is rather odd is the crash only appears to happen occasionally. I have had multiple builds with no issues with this error, then randomly one will pop up with it again. The only phone to have this issue is the Xiaomi Redmi 6A. What is odd is without changing anything, I made an identical build except for incrementing build number and it passed. Does anyone else have the error pop up again? Or is no one else experiencing it again with the change to the main gradle?

12

Same error with my application, same device. But I havn’t tried the main gradle fix yet

13

just confirming I’m seeing the same too, every other device is fine but the Redmi 6a device randomly shows these crashes randomly, what’s strange is in the video it appears to play fine and I don’t even see these crashes/errors in my firebase crashlytics, it would be nice to know what’s up and how to fix it without having to mess with manual gradle stuff though imo

14

Same here in multiple projects. Always with Redmi 6A device.

As mentioned in every stacktrace (at least for us), the crashed process is “com.google.android.apps.photos” which I presumed is the Android Photo app.

Not an Android expert but I’m wondering if our projects are really the cause of the crash.
Any thoughts about that? please

15

I forgot to post here again. After release the crash should not happen. As you mentioned it is an error on Googles part and has nothing to do with your app.

16

Thank for your reply !

17

I have same problem here. I discovered something that might be related;
I always use Nox for testing my games. I opened my app when Nox was trying to update Google Play Games app. Game got a crash.
Update finished and after I opened the game 4 times more and I kept getting crashes everytime.
I did not change anything but 5th try was fine.
I got crashes all the time when app trying to connect Google Play Services.
This case might be related with our problem. I hope this helps.