SQLiteConstraintException

[Maarten Trompper]

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]

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,

Teejay Wennie Mobile Ads SDK Team

 

ref:_00D1U1174p._5004Q2dwdNm:ref

[Yanis Biziuk]

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]

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,

Michael Angelo Mobile Ads SDK Team

ref:_00D1U1174p._5004Q2dwdNm:ref