Fatal Exception: android.database.sqlite.SQLiteConstraintException FOREIGN KEY constraint failed (code 787) [114705286]

Fixed

Bug

Status Update

No update yet.

Description

[Deleted User]

created issue #1

Sep 10, 2018 07:08PM

Component used:WorkManager
Version used:1.0.0-alpha08
Devices reproduced on:Xiaomi, Motorola, Samsung, Oppo, etc
Android versions reproduced on:6,7,8,9

We are facing this crash with 2 stack traces :

android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId (SQLiteConnection.java)
android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId (SQLiteConnection.java:812)
android.database.sqlite.SQLiteSession.executeForLastInsertedRowId (SQLiteSession.java:788)
android.database.sqlite.SQLiteStatement.executeInsert (SQLiteStatement.java:86)
android.arch.persistence.db.framework.FrameworkSQLiteStatement.executeInsert (SourceFile:50)
android.arch.persistence.room.EntityInsertionAdapter.bind (SourceFile:64)
androidx.work.impl.model.SystemIdInfoDao_Impl.insertSystemIdInfo (SourceFile:52)
androidx.work.impl.background.systemjob.SystemJobScheduler.schedule (SourceFile:92)
androidx.work.impl.Schedulers.schedule (SourceFile:99)
androidx.work.impl.utils.EnqueueRunnable.scheduleWorkInBackground (SourceFile:114)
androidx.work.impl.utils.EnqueueRunnable.run (SourceFile:86)
java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1113)
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:588)
java.lang.Thread.run (Thread.java:818)

android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId (SQLiteConnection.java)
android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId (SQLiteConnection.java:812)
android.database.sqlite.SQLiteSession.executeForLastInsertedRowId (SQLiteSession.java:788)
android.database.sqlite.SQLiteStatement.executeInsert (SQLiteStatement.java:86)
android.arch.persistence.db.framework.FrameworkSQLiteStatement.executeInsert (SourceFile:50)
android.arch.persistence.room.EntityInsertionAdapter.bind (SourceFile:64)
androidx.work.impl.model.SystemIdInfoDao_Impl.insertSystemIdInfo (SourceFile:52)
androidx.work.impl.background.systemjob.SystemJobScheduler.schedule (SourceFile:92)
androidx.work.impl.Schedulers.schedule (SourceFile:99)
androidx.work.impl.WorkManagerImpl.rescheduleEligibleWork (SourceFile:555)
androidx.work.impl.utils.ForceStopRunnable.run (SourceFile:74)
java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1113)
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:588)
java.lang.Thread.run (Thread.java:818)

Here is the fabrics link for this crash:

http://crashes.to/s/50397ac3f50

Comments

su...@google.com <su...@google.com> #2Sep 17, 2018 06:17PM

Hello everyone. Is this bug going to be fixed? I have to install 3rd party app to emulate the location. I really need this feature. Please, fix it.

[Deleted User] <[Deleted User]> #3Sep 17, 2018 06:30PM

Issue happens also on ubuntu 22.04

ap...@google.com <ap...@google.com> #4Sep 17, 2018 09:29PM

Issue happens also on POP_OS 22.04

su...@google.com <su...@google.com> #5Sep 17, 2018 09:29PM

I have the same issue on Ubuntu 22.04. There is for a quick moment a white square where the map should be, but it is gone in a blink. Not sure if it is related, but when selecting a saved route, a grey overlay with the text "Loading Saved Route.." appears. This remain in place forever until the emulator is closed. (screenshot attached)

ap...@google.com <ap...@google.com> #6Sep 18, 2018 09:28PM

Same, blank map, white square at first but then nothing.
Also keeps loading when uploading saved route.

SDK does not change anything, I'll try changing API 33 to another one maybe that's the issue.

Ubuntu 22.04

su...@google.com <su...@google.com> #7Sep 25, 2018 08:02PM

Marked as fixed, reassigned to su...@google.com.

Same happening to me on Ubuntu 22.04.
I tried several API emulators (23 to 33).
Also tried deleting and creating emulators again.
Also tried rolling back the emulator version a couple of versions prior.
Calling the emulator in the command line instead of in the IDE, does not solve it either.
Nothing worked and I have both problems: map does not appear and when clicking the routes, it gets stuck on Loading.

ak...@gmail.com <ak...@gmail.com> #8Dec 1, 2022 06:41PM

I also opened an issue in stackoveflow,

https://stackoverflow.com/questions/71316605/google-maps-missing-in-extended-controls-android-emulator a while back, but issue is still ongoing this seems like it is a Linux related issue, I can confirm it works on Windows and Mac, this issue needs to get fixed at this point.

For now as a workaround you can you the flatpak version as suggested by @Torben

https://stackoverflow.com/questions/71316605/google-maps-missing-in-extended-controls-android-emulator#comment126431100_71316605.

mw...@gmail.com <mw...@gmail.com> #9Apr 21, 2023 09:31AM

Same problem on Ubuntu 22.04. It's been broken for 3 months, is there any way to get someone at Google to take notice of this problem? Android Studio cannot be used for location based development on Linux.

Note that the Flatpak version is not an official distribution. Page says "NOTE: This wrapper is not verified by, affiliated with, or supported by Google."

Emulator is https://dl.google.com/android/repository/emulator-linux_x64-8420304.zip

Fri Apr 21 2023 14:59:31 GMT+0530 (India Standard Time).png

198 KB

View

Download

xu...@gmail.com <xu...@gmail.com> #10Jul 10, 2023 03:23AM

Same problem on the latest Fedora 36 with kernel 5.18! I have to install 2 or more Android Studio on my PC to debug the app with Location. There isn't flatpak of Canary build :(