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

Project: platform/frameworks/support
Branch: androidx-master-dev

commit 84cb8085e76a849cfd139a2d47a55adb916fdd1a
Author: Sumir Kataria <sumir@google.com>
Date: Mon Feb 04 10:39:25 2019

Fix potential NPE in checkWakeLocks.

Test: N/A
Bug: 123835104
Change-Id: I961d1809d8adc7c53ab86863931e9d274794923e

M work/workmanager/src/main/java/androidx/work/impl/utils/WakeLocks.java

https://android-review.googlesource.com/894733

https://goto.google.com/android-sha1/84cb8085e76a849cfd139a2d47a55adb916fdd1a

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

Thanks for fixing it quickly again :)

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

Seems like this didn't get the chance to be released on the latest beta-04 :/
Can we expect a new release next week?

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

Yes. Thanks.

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

Project: platform/frameworks/support
Branch: androidx-master-dev

commit fd35a469cabd33509e1d90c57561e33be03a0dd8
Author: Sumir Kataria <sumir@google.com>
Date: Tue Sep 18 13:11:51 2018

Prevent potential foreign key constraints in AlarmMgr.

This change is an addition to the one for JobScheduler:

https://android-review.googlesource.com/c/platform/frameworks/support/+/758783

Also, this change fixes a potential issue where handleScheduleWorkIntent
was not being executed inside a transaction as it should.

Bug: 114705286
Test: Added and ran tests.
Change-Id: Ica1e54e3e9d43d52e11731f3a5727433aac0f622

M work/workmanager/src/androidTest/java/androidx/work/impl/background/systemalarm/SystemAlarmDispatcherTest.java
M work/workmanager/src/main/java/androidx/work/impl/background/systemalarm/CommandHandler.java

https://android-review.googlesource.com/760504

https://goto.google.com/android-sha1/fd35a469cabd33509e1d90c57561e33be03a0dd8

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

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

Fixed in alpha09.

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

It is happening again on 2.7.1 version

`implementation 'androidx.work:work-runtime-ktx:2.7.1'

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

We have following gradle version, it is impacted heavily

Gradle: androidx.work:work-runtime:2.7.0@aar
Gradle: androidx.work:work-runtime-ktx:2.7.0@aar
Gradle: androidx.work:work-rxjava2:2.7.0@aar

Attachment: Impacted Users and session in a week
This issue has 16,025,903 crash events affecting 55,770 users

Stack Trace:

Fatal Exception: android.database.sqlite.SQLiteConstraintException: FOREIGN KEY constraint failed (code 787 SQLITE_CONSTRAINT_FOREIGNKEY)
at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(SQLiteConnection.java)
at android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:890)
at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:756)
at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:66)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1920)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1841)
at androidx.sqlite.db.framework.FrameworkSQLiteDatabase.execSQL(FrameworkSQLiteDatabase.java:265)
at androidx.work.impl.WorkDatabase$2.onOpen(WorkDatabase.java:167)
at androidx.work.impl.WorkDatabase_Impl$1.onOpen(WorkDatabase_Impl.java:113)
at androidx.room.RoomOpenHelper.onOpen(RoomOpenHelper.java:136)
at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.onOpen(FrameworkSQLiteOpenHelper.java:201)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:427)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:316)
at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.getWritableSupportDatabase(FrameworkSQLiteOpenHelper.java:151)
at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper.getWritableDatabase(FrameworkSQLiteOpenHelper.java:112)
at androidx.room.RoomDatabase.inTransaction(RoomDatabase.java:706)
at androidx.room.RoomDatabase.assertNotSuspendingTransaction(RoomDatabase.java:483)
at androidx.work.impl.model.WorkTagDao_Impl.getTagsForWorkSpecId(WorkTagDao_Impl.java:93)
at androidx.work.impl.WorkerWrapper.run(WorkerWrapper.java:135)
at androidx.work.impl.utils.SerialExecutor$Task.run(SerialExecutor.java:91)
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:923)

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

i met issue too: FOREIGN KEY constraint failed (code 787 SQLITE_CONSTRAINT_FOREIGNKEY)