SQLiteConstraintException

1,307 views
Skip to first unread message

Maarten Trompper

unread,
Sep 8, 2022, 2:27:31 AM9/8/22
to Google Mobile Ads SDK Developers
With `ads-lite:21.2.0`:

```
Error inserting flex_time=9000 job_id=-1 period=19000 source=16 requires_charging=0 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService user_id=0 target_package=com.google.android.gms tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG task_type=0 required_idleness_state=0 service_kind=0 source_version=223017000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1662618153658 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0 [CONTEXT service_id=218 ]
android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067 SQLITE_CONSTRAINT_UNIQUE)
at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:940)
at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:790)
at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:89)
at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1702)
at android.database.sqlite.SQLiteDatabase.insertOrThrow(SQLiteDatabase.java:1597)
at bgmg.g(:com.google.android.gms@223017044@22.30.17 (190400-470714279):52)
at bgkz.n(:com.google.android.gms@223017044@22.30.17 (190400-470714279):3)
at bgkz.u(:com.google.android.gms@223017044@22.30.17 (190400-470714279):20)
at bgkz.h(:com.google.android.gms@223017044@22.30.17 (190400-470714279):3)
at bggq.run(:com.google.android.gms@223017044@22.30.17 (190400-470714279):9)
at ypp.c(:com.google.android.gms@223017044@22.30.17 (190400-470714279):6)
at ypp.run(:com.google.android.gms@223017044@22.30.17 (190400-470714279):7)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1137)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
at yuu.run(:com.google.android.gms@223017044@22.30.17 (190400-470714279):0)
at java.lang.Thread.run(Thread.java:1012)
```

Mobile Ads SDK Forum Advisor

unread,
Sep 8, 2022, 10:35:11 AM9/8/22
to blackenvelop...@gmail.com, google-adm...@googlegroups.com
Hi Maarten,

Could you kindly provide the following details via Reply to author option, for us to investigate your concern further?
  • AdMob's App ID
  • Ad Unit IDs (and its ad format)
  • test project where the issue is reproducible
  • full stack trace of the crash logs

1. Navigate to

https://docs.google.com/forms/d/e/1FAIpQLSfkAiXMeYP-fw1W3Z-tT9uwmATEKO5X6S-th0gR2ezdKaaqfg/viewform?usp=pp_url&entry.400550049=Mobile+Ads+SDK&entry.460850823=5004Q00002dwdNmQAI&entry.80707362=00122312

2. Fill out all fields, and attach your file(s).

3. Please reply back on this thread when you have uploaded your file(s). Please do not share this link.


Regards,
Google Logo
Teejay Wennie
Mobile Ads SDK Team
 

 

ref:_00D1U1174p._5004Q2dwdNm:ref

Yanis Biziuk

unread,
Feb 7, 2023, 9:17:32 AM2/7/23
to Google Mobile Ads SDK Developers
Hi, we have the same problem

com.google.firebase:firebase-bom:31.2.0
com.google.firebase:firebase-analytics-ktx
com.google.firebase:firebase-crashlytics-ktx
com.google.android.gms:play-services-ads:21.3.0

any solutions to solve it?


Error inserting flex_time=0 job_id=-1 period=2000 source=16 requires_charging=0 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService user_id=0 target_package=com.google.android.gms tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG task_type=0 required_idleness_state=0 service_kind=0 source_version=230313000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1675765178459 retry_strategy=\{"maximum_backoff_seconds":\{"3600":0\},"initial_backoff_seconds":\{"30":0\},"retry_policy":\{"0":0\}\} last_runtime=0 [CONTEXT service_id=218 ]\
                                                                                                    android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067 SQLITE_CONSTRAINT_UNIQUE[2067])\
                                                                                                        at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)\
                                                                                                        at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:1127)\
                                                                                                        at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:790)\
                                                                                                        at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:88)\
                                                                                                        at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:2123)\
                                                                                                        at android.database.sqlite.SQLiteDatabase.insertOrThrow(SQLiteDatabase.java:2018)\
                                                                                                        at blvo.g(:com.google.android.gms@230313028@23.03.13 (100400-503260631):53)\
                                                                                                        at bluh.n(:com.google.android.gms@230313028@23.03.13 (100400-503260631):3)\
                                                                                                        at bluh.u(:com.google.android.gms@230313028@23.03.13 (100400-503260631):20)\
                                                                                                        at bluh.p(:com.google.android.gms@230313028@23.03.13 (100400-503260631):3)\
                                                                                                        at bluh.l(:com.google.android.gms@230313028@23.03.13 (100400-503260631):26)\
                                                                                                        at bltu.handleMessage(:com.google.android.gms@230313028@23.03.13 (100400-503260631):10)\
                                                                                                        at android.os.Handler.dispatchMessage(Handler.java:107)\
                                                                                                        at aufv.kX(:com.google.android.gms@230313028@23.03.13 (100400-503260631):0)\
                                                                                                        at aufv.dispatchMessage(:com.google.android.gms@230313028@23.03.13 (100400-503260631):13)\
                                                                                                        at android.os.Looper.loop(Looper.java:237)\
                                                                                                        at android.os.HandlerThread.run(HandlerThread.java:67)\

Mobile Ads SDK Forum Advisor

unread,
Feb 7, 2023, 1:14:51 PM2/7/23
to yanis....@veraxen.com, google-adm...@googlegroups.com

Hello Yanis,

 

Thank you for reaching out to us. Could you please share to us also the below information so we can further investigate on your concern?

  • AdMob's App ID
  • Ad Unit IDs (and its ad format)
  • test project where the issue is reproducible
  • full stack trace of the crash logs

 

Kindly provide the requested details privately via "Reply To Author" button or with the below process.

 

If you are having trouble attaching your file to this case or if your file(s) are larger than 25mb, you can share your files with me by performing the following steps:

 

1. Navigate to

https://docs.google.com/forms/d/e/1FAIpQLSfkAiXMeYP-fw1W3Z-tT9uwmATEKO5X6S-th0gR2ezdKaaqfg/viewform?usp=pp_url&entry.400550049=Mobile+Ads+SDK&entry.460850823=5004Q00002dwdNmQAI&entry.80707362=00122312

2. Fill out all fields, and attach your file(s).

3. Please reply back on this thread when you have uploaded your file(s). Please do not share this link.


Regards,

Google Logo
Michael Angelo
Mobile Ads SDK Team
 


ref:_00D1U1174p._5004Q2dwdNm:ref
Reply all
Reply to author
Forward
0 new messages