search

firebase / firebase-android-sdk

Firebase Android SDK
https://firebase.google.com
Apache License 2.0
2.26k stars 573 forks source link

Firebase Internal Foreign key constraint error #361

Open stephanenicolas opened 5 years ago

stephanenicolas commented 5 years ago

When enable foreign key constraint in our app using : 

//https://stackoverflow.com/a/12531927/693752
db.setForeignKeyConstraintsEnabled(true);

we see an internal error in the logcat coming from an internal database schema definition from firebase: 

04-16 21:34:57.852  6738  8269 E SQLiteDatabase: Error inserting period=0 target_class=com.firebase.jobdispatcher.GooglePlayReceiver required_network_type=0 runtime=1555450497848 extras={"com.firebase.jobdispatcher.tag":{"com.company.REGISTER":4},"com.firebase.jobdispatcher.trigger_type":{"1":0},"com.firebase.jobdispatcher.replace_current":{"true":3},"com.firebase.jobdispatcher.persistent":{"2":0},"registration_id":{"dIu14E5WNzw:APA91bEheSYPxZM5T_wHaiFcP_EZTHqEuVU0GWT58D-1wlrjUhMzmbrmyeWTjUfLy3zBCqJrf7mwASZlBFqkqdlNMs7hsRh2WPJwa4I4eLrJeAkzZMYZGIZ-fccj4C8zLRbSEDbuMlvu":4},"com.firebase.jobdispatcher.maximum_backoff_seconds":{"3600":0},"com.firebase.jobdispatcher.initial_backoff_seconds":{"30":0},"com.firebase.jobdispatcher.retry_policy":{"1":0},"com.firebase.jobdispatcher.window_end":{"0":0},"com.firebase.jobdispatcher.service":{"com.company.SomeService":4},"com.firebase.jobdispatcher.recurring":{"false":3},"com.firebase.jobdispatcher.constraints":{"2":0},"com.firebase.jobdispatcher.window_start":{"0":0}} source=8 target_package=com.company.dev source_version=1 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=com.company.REGISTER flex_time=0 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}}
04-16 21:34:57.852  6738  8269 E SQLiteDatabase: android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1474)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1343)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at zxx.a(:com.google.android.gms@16089022@16.0.89 (040700-239467275):148)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at aaat.a(:com.google.android.gms@16089022@16.0.89 (040700-239467275):166)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at aaat.a(:com.google.android.gms@16089022@16.0.89 (040700-239467275):8)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at aaat.a(:com.google.android.gms@16089022@16.0.89 (040700-239467275):157)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at zxu.run(:com.google.android.gms@16089022@16.0.89 (040700-239467275):2)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at rrt.b(:com.google.android.gms@16089022@16.0.89 (040700-239467275):32)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at rrt.run(:com.google.android.gms@16089022@16.0.89 (040700-239467275):21)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at rxx.run(Unknown Source:7)
04-16 21:34:57.852  6738  8269 E SQLiteDatabase:    at java.lang.Thread.run(Thread.java:764)
google-oss-bot commented 5 years ago

I couldn't figure out how to label this issue, so I've labeled it for a human to triage. Hang tight.

schmidt-sebastian commented 5 years ago

@stephanenicolas Thanks for filing this issue. To help you further, can you let us know what Firebase SDKs you are using? Thank you!

stephanenicolas commented 5 years ago

FIREBASE_APPINDEXING_VERSION=16.0.2 FIREBASE_MESSAGING_VERSION=17.3.3 FIREBASE_CORE_VERSION=16.0.4 FIREBASE_IID_VERSION=17.0.3

Le mar. 16 avr. 2019 à 15:11, Sebastian Schmidt notifications@github.com a écrit :

@stephanenicolas https://github.com/stephanenicolas Thanks for filing this issue. To help you further, can you let us know what Firebase SDKs you are using? Thank you!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/firebase/firebase-android-sdk/issues/361#issuecomment-483863164, or mute the thread https://github.com/notifications/unsubscribe-auth/ABv33dSOMT70CpNkuhoGpvPShEOrgSdTks5vhkqCgaJpZM4czxRL .

stephanenicolas commented 5 years ago

@schmidt-sebastian Can you confirm that this issue is not a blocker ? We want to enable foreign key constraints in our app but we are wondering if this error would break firebase.

stephanenicolas commented 5 years ago

A co-worker told me that the bug might come from firebase job dispatcher: FIREBASE_JOB_DISPATCHER_VERSION=0.8.5

Le mar. 16 avr. 2019 à 16:45, Stéphane NICOLAS steff.nicolas@gmail.com a écrit :

FIREBASE_APPINDEXING_VERSION=16.0.2 FIREBASE_MESSAGING_VERSION=17.3.3 FIREBASE_CORE_VERSION=16.0.4 FIREBASE_IID_VERSION=17.0.3

Le mar. 16 avr. 2019 à 15:11, Sebastian Schmidt notifications@github.com a écrit :

@stephanenicolas https://github.com/stephanenicolas Thanks for filing this issue. To help you further, can you let us know what Firebase SDKs you are using? Thank you!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/firebase/firebase-android-sdk/issues/361#issuecomment-483863164, or mute the thread https://github.com/notifications/unsubscribe-auth/ABv33dSOMT70CpNkuhoGpvPShEOrgSdTks5vhkqCgaJpZM4czxRL .

schmidt-sebastian commented 5 years ago

We believe that this may actually be an issue internal to the GMSCore Scheduler API. Since this code is not available publicly, I will file an internal issue to get this resolved. I can't promise a timeline for this fix, and unfortunately I do not know if this issue should block your change. We also believe that this issue might be unrelated to calling setForeignKeyConstraintsEnabled.

If there are any other customers affected by this issue, I would appreciate that you let us know here.

philn5d-ar commented 4 years ago

I have the same issue:

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)

not calling any db methods or even using SqlLite ourselves. Probably another package enabling constraints...which kind of points to poor DB design IMPO.

which, after searching led me here because of "pending_ops" schema hit on this search result.

relevant stack line: at sob.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):7)

other info:

implementation 'com.google.android.gms:play-services-ads:19.0.1'
implementation 'com.google.android.gms:play-services-analytics:17.0.0'
implementation 'com.crashlytics.sdk.android:crashlytics:2.10.1'
implementation 'com.google.firebase:firebase-analytics:17.4.0'
implementation 'com.google.firebase:firebase-crashlytics:17.0.0'

is it firebase? /shrug

UPDATE:

here's the whole stack trace

2020-05-08 14:41:21.082 5299-24447/? E/SQLiteDatabase: Error inserting flex_time=738000 job_id=-1 period=1478000 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=201516000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1588966881034 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0
    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:879)
        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:1599)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
        at aplm.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):76)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):173)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):21)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):167)
        at aphk.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):8)
        at sob.b(:com.google.android.gms@201516037@20.15.16 (120400-309763488):12)
        at sob.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at sub.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):0)
        at java.lang.Thread.run(Thread.java:919)
schmidt-sebastian commented 4 years ago

The Firebase Database SDK doesn't access SQLite through GMSCore. I believe the stacktrace above is for an unrelated issue. Unfortunately, the trace is obfuscated so it is hard to trace this back to the original product.

philn5d-ar commented 4 years ago

Thanks @schmidt-sebastian! Any pointers on how to track it down to the root? I'm only working with a contract dev to get some Android app work done, not well-versed in the inner workings of Android code. I'm building and running (in AVMs) via Android studio and these logs are coming through logcat if knowing that helps. Much appreciated!

schmidt-sebastian commented 4 years ago

I haven't had do deal with obfuscated stacktraces since we moved to GitHub. Unfortunately, that means that I can't provide assistance here.

Maybe @samtstern has some pointers on how to de-obfuscate GMSCore stacktraces.

angelolloqui commented 4 years ago

I am having the same error, and it does not allow me to start the app.

 E/SQLiteDatabase: Error inserting period=6605000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1589376728778 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms source_version=201516000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3302000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}}
    android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067)
    #################################################################
    Error Code : 2067 (SQLITE_CONSTRAINT_UNIQUE)
    Caused By : Abort due to constraint violation.
        (UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067))
    #################################################################
        at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
        at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:987)
        at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
        at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
        at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:2007)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1874)
        at apnp.a(:com.google.android.gms@201516017@20.15.16 (040306-309763488):76)
        at apne.a(:com.google.android.gms@201516017@20.15.16 (040306-309763488):173)
        at apne.a(:com.google.android.gms@201516017@20.15.16 (040306-309763488):21)
        at apne.a(:com.google.android.gms@201516017@20.15.16 (040306-309763488):167)
        at apjn.run(:com.google.android.gms@201516017@20.15.16 (040306-309763488):8)
        at ssd.b(:com.google.android.gms@201516017@20.15.16 (040306-309763488):12)
        at ssd.run(:com.google.android.gms@201516017@20.15.16 (040306-309763488):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1162)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:636)
        at sye.run(:com.google.android.gms@201516017@20.15.16 (040306-309763488):0)
        at java.lang.Thread.run(Thread.java:764)

If I remove the Crashlytics depedency, then it stops crashing and everything seems to work as normal, but of course I will not get crash reporting.

My dependencies:

    ext.google_play_services_version = '17.0.+'
...
  // Play Services
    implementation "com.google.android.gms:play-services-maps:${google_play_services_version}"
    implementation "com.google.android.gms:play-services-analytics:${google_play_services_version}"
    implementation "com.google.android.gms:play-services-ads:${google_play_services_version}"
    implementation "com.google.android.gms:play-services-auth:${google_play_services_version}"
    implementation "com.google.android.gms:play-services-auth-api-phone:17.4.0"

    // Firebase push notifications
    implementation "com.google.firebase:firebase-messaging:20.1.+"
    implementation 'com.google.firebase:firebase-core:17.2.+'

    // Crash and analytics
    implementation "com.google.firebase:firebase-crashlytics:17.0.0"
...

UPDATE: If I remove crashlytics, the log error is still there, but the application does not crash. So, somehow I think the error itself is not triggered by crashlytics, but the crash is. Maybe incorrectly handling the exception?

samtstern commented 4 years ago

Ok there's some crash going on that looks similar to some old GitHub issues I've found: https://github.com/googlearchive/firebase-jobdispatcher-android/issues/94 https://github.com/evernote/android-job/issues/87

Some internal bugs which may be related (for Googlers); https://b.corp.google.com/issues/156170585 https://b.corp.google.com/issues/149327697 https://b.corp.google.com/issues/146422649

I can't find the pattern here except that is has something to do with concurrency and job scheduling. Here's a random guess: I assume Crashlytics uses a second process to report crashes (otherwise it would be taken down by them) and maybe that process is not acquiring the right locks before trying to schedule the upload jobs?

Would need someone from the Crashlytics team to comment on what sort of Job scheduling it uses.

samtstern commented 4 years ago

Looks like Crashlytics uses DataTransport: https://cs.opensource.google/firebase-sdk/firebase-android-sdk/+/master:firebase-crashlytics/src/main/java/com/google/firebase/crashlytics/internal/send/DataTransportCrashlyticsReportSender.java

And DataTransport uses JobScheduler: https://cs.opensource.google/search?q=JobScheduler&ss=firebase-sdk

vkryachko commented 4 years ago

It is correct that DataTransport uses JobScheduler, however unlike in the case of https://github.com/googlearchive/firebase-jobdispatcher-android/issues/94, JobScheduler does not use Play Services to fulfill its job.

I am not sure how using JobScheduler would manifest in the above stacktrace as they seem entirely unrelated.

Additionally, does the stacktrace actually originate in your app? or is it just part of unfiltered logcat output?

@angelolloqui when the crash does occur, are there any other stacktraces present in your logcat?

angelolloqui commented 4 years ago

Additionally, does the stacktrace actually originate in your app? or is it just part of unfiltered logcat output? Not sure if it originates inside or outside the app as a response of the app opening, but it is only triggered when I open the app.

@angelolloqui when the crash does occur, are there any other stacktraces present in your logcat?

Nothing that I was able to capture. If you have any hint I can try to reproduce and pause somewhere, but I wasn't able to find any other info so far. All I can tell is that the stack trace happens with or without Crashlytics, but when Crashlytics dependency is added it also results in a crash when opening. One additional tip is that I am only able to reproduce so far in a real device and not in emulators.

One extra detail, maybe not related, but since it happens during startup just in case, is that the app is a multidex one and it uses a largeHeap.

angelolloqui commented 4 years ago

One more thing I just reminded is that the app used to have Crashlytics active through Fabric without any issue. It has been since we moved to Firebase for it that it started crashing.

MegaMaddin commented 4 years ago

One more thing I just reminded is that the app used to have Crashlytics active through Fabric without any issue. It has been since we moved to Firebase for it that it started crashing.

Same issue here, moved to firebase-crashlytics via react-native-firebase/crashlytics and since the update I also see the UNIQ constraint stacktrace during app start. Interestingly, crash reporting still works and crashes show up in Firebase.

vkryachko commented 4 years ago

@MegaMaddin does the stacktrace come from your app or some other app(e.g. play services) on the device? Also, do your crash reports contain this UNIQ constraint stacktrace?

acuntex commented 4 years ago

In my case it's not a "real crash". App still works, but I can see the same stack trace in the adb logs.

vkryachko commented 4 years ago

@mrwillis21 does crashlytics talk to play services in any way?

MegaMaddin commented 4 years ago

@MegaMaddin does the stacktrace come from your app or some other app(e.g. play services) on the device? Also, do your crash reports contain this UNIQ constraint stacktrace?

@vkryachko that's the stacktrace immediately after app start-up:

E/SQLiteDatabase: Error inserting flex_time=3595000 job_id=-1 period=7192000 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=201516000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1590052357409 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0
    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:879)
        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:1599)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
        at aplm.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):76)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):173)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):21)
        at aplb.a(:com.google.android.gms@201516037@20.15.16 (120400-309763488):167)
        at aphk.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):8)
        at sob.b(:com.google.android.gms@201516037@20.15.16 (120400-309763488):12)
        at sob.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at sub.run(:com.google.android.gms@201516037@20.15.16 (120400-309763488):0)
        at java.lang.Thread.run(Thread.java:919)

And no, the reported stacktrace in Firebase (I used crashlytics().crash() just includes the CrashTest.java stacktrace.

pangia commented 4 years ago

Same issue here after updating Firebase dependencies. Crashlytics also installed. Also use to be Fabric. App runs, but this stack trace shows in log at pretty much every navigation in the app. Worried this will cause issues if we release.

vkryachko commented 4 years ago

@pangia what are your other firebase dependencies besides crashlytics(if any)?

this stack trace shows in log at pretty much every navigation in the app

It's interesting that the library in question(datatransport) only ever executes upon app crashes to upload crashes to crashlytics(unless you use other firebase products like In App Messaging), so unless that is the case, this stacktrace is unlikely related to datatransport at all.

mrwillis21 commented 4 years ago

@mrwillis21 does crashlytics talk to play services in any way?

@vkryachko It does not.

pangia commented 4 years ago

@pangia what are your other firebase dependencies besides crashlytics(if any)?

this stack trace shows in log at pretty much every navigation in the app

It's interesting that the library in question(datatransport) only ever executes upon app crashes to upload crashes to crashlytics(unless you use other firebase products like In App Messaging), so unless that is the case, this stacktrace is unlikely related to datatransport at all.

Our dependencies: implementation 'com.google.firebase:firebase-core:17.4.1' implementation 'com.google.firebase:firebase-analytics:17.4.2' implementation 'com.google.firebase:firebase-database:19.3.0' implementation 'com.google.firebase:firebase-auth:19.3.1' implementation 'com.google.firebase:firebase-messaging:20.2.0' implementation 'com.google.firebase:firebase-config:19.1.4' implementation 'com.google.firebase:firebase-crashlytics:17.0.0' implementation 'com.google.android.gms:play-services-ads:19.1.0' implementation 'com.google.android.gms:play-services-games:19.0.0' implementation 'com.google.android.gms:play-services-base:17.2.1' implementation 'com.google.android.gms:play-services-analytics:17.0.0'

MegaMaddin commented 4 years ago

Same here, I'm using several other Firebase services via RNFirebase:

    "@react-native-firebase/admob"
    "@react-native-firebase/analytics"
    "@react-native-firebase/app"
    "@react-native-firebase/crashlytics"
    "@react-native-firebase/dynamic-links"
    "@react-native-firebase/iid"
    "@react-native-firebase/in-app-messaging"
    "@react-native-firebase/remote-config"
Discovery-Prachi commented 4 years ago

I am also facing this crash issue:

E/SQLiteDatabase: Error inserting flex_time=3340000 job_id=-1 period=6682000 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=201817000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1590520619376 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0 from {P:25120;U:10021} 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:879) 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:1639) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1494) at apiz.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):78) at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):196) at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):20) at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):190) at apex.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):8) at sfd.b(:com.google.android.gms@201817037@20.18.17 (120400-311416286):12) at sfd.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):7) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at sld.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):0) at java.lang.Thread.run(Thread.java:919)

Also getting this crash multiple times : https://github.com/firebase/firebase-android-sdk/issues/1593

TKBurner commented 4 years ago

I suspect this is related to which version of SQL lite you are importing. Analytics and a few other Firebase tools depend on SQLite to cache data on device prior to batch upload. If you are using an old SQLite version in your app somewhere else this can cause the behavior you are seeing. Can be hard to track down, could be in a submodule.

Moving to triage as this isn't Crashlytics related.

angelolloqui commented 4 years ago

The origin might not be related to crashlytics directly, but it is the fact that crashlytics is added to the project what makes it crash, so there is some wrong handling within the lib. If I get rid of Crashlytics dependency, then the crash disappear.

pangia commented 4 years ago

Confirmed that the SQLIte version being used is from API 29. Only get this error on a device, not in emulators. Also, it happens on every transition to a new intent/activity.

The error "Package unavailable for task: com.google.android.apps.plus/com.firebase.jobdispatcher.GooglePlayReceiver..." also appears right before the crash. JobDispatcher is deprecated, and not used by anything in our code or dependencies from what I can find. All of our dependencies are the latest version, but something is still puling it in.

Any ideas are appreciated, I'm not sure what else to try.

Mecze commented 4 years ago

We are seeing this error too. Here's our logs:

7440 E SQLiteDatabase: Error inserting period=1000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1591011452784 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms source_version=201516000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=0 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: 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) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:796) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apne.a(:com.google.android.gms@201516028@20.15.16 (100400-309763488):76) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apmt.a(:com.google.android.gms@201516028@20.15.16 (100400-309763488):173) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apmt.a(:com.google.android.gms@201516028@20.15.16 (100400-309763488):21) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apmt.c(:com.google.android.gms@201516028@20.15.16 (100400-309763488):9) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apmt.a(:com.google.android.gms@201516028@20.15.16 (100400-309763488):75) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at apmo.handleMessage(:com.google.android.gms@201516028@20.15.16 (100400-309763488):8) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.os.Handler.dispatchMessage(Handler.java:106) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at aebc.a(:com.google.android.gms@201516028@20.15.16 (100400-309763488):2) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at aebc.dispatchMessage(:com.google.android.gms@201516028@20.15.16 (100400-309763488):14) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.os.Looper.loop(Looper.java:201) 06-01 13:37:32.814 5358 7440 E SQLiteDatabase: at android.os.HandlerThread.run(HandlerThread.java:65)

It happens everytime our app sends an Analytic or Crashlytics (through Firebase Analytics or Crashlytics). The app does not crash, however. Analytics dashboard works fine (every thing seems work fine) but we get an Exception everytime we send an Analytic.

I tried deleting our old SQL dependencies on our project, and didn't care, error stills there. We are using Unity and these are our dependencies:

implementation 'com.android.support:appcompat-v7:25.3.1' implementation 'com.android.support:cardview-v7:25.3.1' implementation 'com.android.support:customtabs:25.3.1' implementation 'com.android.support:support-v4:25.3.1' implementation 'com.crashlytics.sdk.android:crashlytics:2.9.9' implementation 'com.facebook.android:facebook-applinks:[5,6)' implementation 'com.facebook.android:facebook-core:[5,6)' implementation 'com.facebook.android:facebook-login:[5,6)' implementation 'com.facebook.android:facebook-share:[5,6)' implementation 'com.google.ads.mediation:applovin:9.9.1.0' implementation 'com.google.ads.mediation:facebook:5.6.0.0' implementation 'com.google.ads.mediation:ironsource:6.10.0.0' implementation 'com.google.ads.mediation:unity:3.3.0.0' implementation 'com.google.android.gms:play-services-ads:18.3.0' implementation 'com.google.firebase:firebase-analytics:17.2.1' implementation 'com.google.firebase:firebase-analytics-unity:6.8.1' implementation 'com.google.firebase:firebase-app-unity:6.8.1' implementation 'com.google.firebase:firebase-common:19.3.0' implementation 'com.google.firebase:firebase-config:19.0.3' implementation 'com.google.firebase:firebase-config-unity:6.8.1' implementation 'com.google.firebase:firebase-crashlytics-unity:6.8.1' implementation 'com.parse.bolts:bolts-android:1.4.0'

vkryachko commented 4 years ago

The last stacktrace looks related to analytics, @g-charbel any ideas what could be causing this exception?

rafagcamargo commented 4 years ago

I am seeing the reported problem using Emulator, the app doesn't crash but I do see ADB logs. In my case, I have Crashlytics integrated and added Firebase Performance later.

com.crashlytics.sdk.android:crashlytics:2.10.1
com.google.firebase:firebase-perf:19.0.7
com.google.firebase:firebase-analytics:17.4.2
com.google.firebase:firebase-config:19.1.3
com.google.firebase:firebase-messaging:20.1.5
derrickrc commented 4 years ago

I also started experiencing the same starting a few weeks ago, app does not crash, but I see the below in Logcat. I updated my firebase dependencies, Performance Monitoring plugin version, and GMS google services plugin to the latest and am still seeing it. I also commented out perf monitoring and no change.

06-03 11:03:29.653 31959-19192/? E/SQLiteLog: (2067) abort at 36 in [INSERT INTO pending_ops(service_kind,source,tag,requires_charging,target_package,source_version,required_network_type,flex_time,persistence_level,target_class,runtime,retry_strategy,preferred_n 06-03 11:03:29.669 31959-19192/? E/SQLiteDatabase: Error inserting service_kind=0 source=16 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG requires_charging=0 target_package=com.google.android.gms source_version=201817000 required_network_type=0 flex_time=2896000 persistence_level=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService runtime=1591207409620 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} preferred_network_type=1 required_idleness_state=0 preferred_charging_state=1 last_runtime=0 period=5794000 task_type=0 job_id=-1 user_id=0 android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067) at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782) at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1471) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341) at aose.a(:com.google.android.gms@201817008@20.18.17 (020306-311416286):78) at aort.b(:com.google.android.gms@201817008@20.18.17 (020306-311416286):11) at aort.a(:com.google.android.gms@201817008@20.18.17 (020306-311416286):100) at aooq.run(:com.google.android.gms@201817008@20.18.17 (020306-311416286):11) at rxf.b(:com.google.android.gms@201817008@20.18.17 (020306-311416286):12) at rxf.run(:com.google.android.gms@201817008@20.18.17 (020306-311416286):7) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587) at scz.run(:com.google.android.gms@201817008@20.18.17 (020306-311416286):0) at java.lang.Thread.run(Thread.java:818)

vkryachko commented 4 years ago

Labeling it at api:analytics as it's to most likely cause of the issue, tracked internally in b/144327685.

vkryachko commented 4 years ago

Similar reported issue: https://github.com/firebase/quickstart-unity/issues/676

philn5d-ar commented 4 years ago

Thank you @vkryachko for following up on this!

ashwinraghav commented 4 years ago

Extending https://github.com/firebase/firebase-android-sdk/issues/361#issuecomment-628028362 The problem seems a bit systemic and possible unrelated to Firebase itself.

b/158100898 b/146422649

Nyceane commented 4 years ago

I am seeing this too, any fixes?

2020-06-16 19:40:59.863 4787-20244/? E/SQLiteDatabase: Error inserting service_kind=0 source=16 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG target_package=com.google.android.gms requires_charging=0 source_version=201817000 required_network_type=0 flex_time=9000 persistence_level=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService runtime=1592361659861 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} preferred_network_type=1 required_idleness_state=0 preferred_charging_state=1 period=20000 last_runtime=0 task_type=0 job_id=-1 user_id=0 android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067) at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782) at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1474) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1343) at apla.a(:com.google.android.gms@201817022@20.18.17 (040700-311416286):78) at apkp.a(:com.google.android.gms@201817022@20.18.17 (040700-311416286):196) at apkp.a(:com.google.android.gms@201817022@20.18.17 (040700-311416286):20) at apkp.a(:com.google.android.gms@201817022@20.18.17 (040700-311416286):190) at apgy.run(:com.google.android.gms@201817022@20.18.17 (040700-311416286):8) at sji.b(:com.google.android.gms@201817022@20.18.17 (040700-311416286):12) at sji.run(:com.google.android.gms@201817022@20.18.17 (040700-311416286):7) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607) at spj.run(:com.google.android.gms@201817022@20.18.17 (040700-311416286):0) at java.lang.Thread.run(Thread.java:761)

bigyanthapa commented 4 years ago 

    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:879)
        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:1599)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
        at apiz.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):78)
        at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):196)
        at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):20)
        at apio.a(:com.google.android.gms@201817037@20.18.17 (120400-311416286):190)
        at apex.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):8)
        at sfd.b(:com.google.android.gms@201817037@20.18.17 (120400-311416286):12)
        at sfd.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at sld.run(:com.google.android.gms@201817037@20.18.17 (120400-311416286):0)
        at java.lang.Thread.run(Thread.java:919)```

I believe this is similar issue as well. I do have crashlytics dependency in app. Also, in Android Studio, if  I filter the logs for my app only, I don't see this error. But if I do `NoFilters`, then this error appears. And it appears quite often. Doesn't crash the app, but definitely distracting and annoying. Any help/ directions would be great.
m00nlight commented 4 years ago

I have the same problem, but after adding the following setting to AndroidManifest.xml to prevent firebase-analytics and cloud-message for auto initialization, it seems to resolve the problem

        <meta-data
            android:name="firebase_messaging_auto_init_enabled"
            android:value="false" />
        <meta-data
            android:name="firebase_analytics_collection_enabled"
            android:value="false" />

It seems the problem is related with the firebase-analytics automatically generate the instance ID things. Although I am not 100% sure for the root cause.

Firebase Prevent auto initialization

bigyanthapa commented 4 years ago

Thanks @m00nlight, I will try that.

ItzGuuh commented 4 years ago

Also getting the same error:

2020-07-01 13:13:10.150 1725-442/? E/SQLiteDatabase: Error inserting period=4615000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1593619990143 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202117000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=2307000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 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:1015) at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:2021) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1890) at aqfz.a(:com.google.android.gms@202117024@20.21.17 (100300-316502805):146) at aqfj.a(:com.google.android.gms@202117024@20.21.17 (100300-316502805):190) at aqfj.a(:com.google.android.gms@202117024@20.21.17 (100300-316502805):23) at aqfj.a(:com.google.android.gms@202117024@20.21.17 (100300-316502805):185) at aqbt.run(:com.google.android.gms@202117024@20.21.17 (100300-316502805):9) at skp.b(:com.google.android.gms@202117024@20.21.17 (100300-316502805):12) at skp.run(:com.google.android.gms@202117024@20.21.17 (100300-316502805):7) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at sql.run(:com.google.android.gms@202117024@20.21.17 (100300-316502805):0) at java.lang.Thread.run(Thread.java:764)

The error crashes my app at any moment

My dependencies:

implementation 'com.google.firebase:firebase-core:17.4.3'´ implementation 'com.google.firebase:firebase-messaging:20.2.1'

keithchad commented 4 years ago 
E/SQLiteDatabase: Error inserting period=5115000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1593733672193 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202117000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=2557000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}}
    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:796)
        at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
        at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
        at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433)
        at aqfz.a(:com.google.android.gms@202117029@20.21.17 (100406-316502805):146)
        at aqfj.a(:com.google.android.gms@202117029@20.21.17 (100406-316502805):190)
        at aqfj.a(:com.google.android.gms@202117029@20.21.17 (100406-316502805):23)
        at aqfj.a(:com.google.android.gms@202117029@20.21.17 (100406-316502805):185)
        at aqbt.run(:com.google.android.gms@202117029@20.21.17 (100406-316502805):9)
        at skp.b(:com.google.android.gms@202117029@20.21.17 (100406-316502805):12)
        at skp.run(:com.google.android.gms@202117029@20.21.17 (100406-316502805):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at sql.run(:com.google.android.gms@202117029@20.21.17 (100406-316502805):0)
        at java.lang.Thread.run(Thread.java:764)
soshial commented 4 years ago

In recent week I keep having this all the time. Sometimes app freezes, sometimes crashes: 

E/SQLiteDatabase: Error inserting flex_time=9000 job_id=-1 period=20000 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=202414000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1593753430458 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0
    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:879)
        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:1599)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
        at aqun.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):175)
        at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):182)
        at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):23)
        at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):177)
        at aqpz.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):9)
        at smo.b(:com.google.android.gms@202414037@20.24.14 (120400-319035315):12)
        at smo.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at ssm.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):0)
        at java.lang.Thread.run(Thread.java:919)
E/SQLiteLog: (3850) disk I/O error
W/SQLiteLog: (28) cannot fstat db file /data/user/0/<MY_PACKAGE>/databases/google_app_measurement_local.db
E/SQLiteLog: (4106) os_unix.c:32730: (9) close(/data/user/0/<MY_PACKAGE>/databases/google_app_measurement_local.db) - 
E/SQLiteDatabase: Failed to open database '/data/user/0/<MY_PACKAGE>/databases/google_app_measurement_local.db'.
    android.database.sqlite.SQLiteDiskIOException: disk I/O error (code 3850 SQLITE_IOERR_LOCK): , while compiling: PRAGMA journal_mode
        at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
        at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986)
        at android.database.sqlite.SQLiteConnection.executeForString(SQLiteConnection.java:729)
        at android.database.sqlite.SQLiteConnection.setJournalMode(SQLiteConnection.java:376)
        at android.database.sqlite.SQLiteConnection.setWalModeFromConfiguration(SQLiteConnection.java:316)
        at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:224)
        at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:197)
        at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:505)
        at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:206)
        at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:198)
        at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:915)
        at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:895)
        at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:759)
        at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:748)
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:374)
        at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:317)
        at com.google.android.gms.measurement.internal.zzet.getWritableDatabase(com.google.android.gms:play-services-measurement-impl@@17.4.3:4)
        at com.google.android.gms.measurement.internal.zzeq.zzae(com.google.android.gms:play-services-measurement-impl@@17.4.3:316)
        at com.google.android.gms.measurement.internal.zzeq.zza(com.google.android.gms:play-services-measurement-impl@@17.4.3:28)
        at com.google.android.gms.measurement.internal.zzeq.zza(com.google.android.gms:play-services-measurement-impl@@17.4.3:100)
        at com.google.android.gms.measurement.internal.zzir.zza(com.google.android.gms:play-services-measurement-impl@@17.4.3:62)
        at com.google.android.gms.measurement.internal.zzhc.zza(com.google.android.gms:play-services-measurement-impl@@17.4.3:313)
        at com.google.android.gms.measurement.internal.zzhj.run(com.google.android.gms:play-services-measurement-impl@@17.4.3:2)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:462)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at com.google.android.gms.measurement.internal.zzfz.run(com.google.android.gms:play-services-measurement-impl@@17.4.3:21)
E/FA: Opening the local database failed, dropping and recreating it
denlig commented 4 years ago

Not sure if related, by we see this also:

2020-07-03 14:59:00.342 21010-9563/? E/SQLiteDatabase: Error inserting flex_time=2950000 job_id=-1 period=5902000 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=202117000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1593781140330 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0
    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:879)
        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:1599)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
        at aqew.a(:com.google.android.gms@202117037@20.21.17 (120400-316502805):146)
        at aqeg.a(:com.google.android.gms@202117037@20.21.17 (120400-316502805):190)
        at aqeg.a(:com.google.android.gms@202117037@20.21.17 (120400-316502805):23)
        at aqeg.a(:com.google.android.gms@202117037@20.21.17 (120400-316502805):185)
        at aqaq.run(:com.google.android.gms@202117037@20.21.17 (120400-316502805):9)
        at sjk.b(:com.google.android.gms@202117037@20.21.17 (120400-316502805):12)
        at sjk.run(:com.google.android.gms@202117037@20.21.17 (120400-316502805):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
        at spg.run(:com.google.android.gms@202117037@20.21.17 (120400-316502805):0)
        at java.lang.Thread.run(Thread.java:919)
uktshukg commented 4 years ago

Facing the same error

E/SQLiteDatabase: Error inserting service_kind=0 source=16 
tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG target_package=com.google.android.gms requires_charging=0 source_version=202414000 required_network_type=0 flex_time=74000 persistence_level=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService runtime=1594652794171 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} preferred_network_type=1 required_idleness_state=0 preferred_charging_state=1 period=149000 last_runtime=0 task_type=0 job_id=-1 user_id=0
    android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: pending_ops.tag, pending_ops.target_class, pending_ops.target_package, pending_ops.user_id (code 2067)
        at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
        at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:798)
        at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
        at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
        at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1509)
        at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1378)
        at aqui.a(:com.google.android.gms@202414017@20.24.14 (040306-319035315):175)
        at aqtk.a(:com.google.android.gms@202414017@20.24.14 (040306-319035315):182)
        at aqtk.a(:com.google.android.gms@202414017@20.24.14 (040306-319035315):23)
        at aqtk.a(:com.google.android.gms@202414017@20.24.14 (040306-319035315):177)
        at aqpu.run(:com.google.android.gms@202414017@20.24.14 (040306-319035315):9)
        at soy.b(:com.google.android.gms@202414017@20.24.14 (040306-319035315):12)
        at soy.run(:com.google.android.gms@202414017@20.24.14 (040306-319035315):7)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)
        at sux.run(:com.google.android.gms@202414017@20.24.14 (040306-319035315):0)
        at java.lang.Thread.run(Thread.java:761)
marchbold commented 4 years ago

We were having a similar error:

E SQLiteDatabase: 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=202414000 persistence_level=1 preferred_charging_state=1 required_network_type=0 runtime=1594705970894 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} last_runtime=0
E SQLiteDatabase: 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)
E SQLiteDatabase:   at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
E SQLiteDatabase:   at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:879)
E SQLiteDatabase:   at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:790)
E SQLiteDatabase:   at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:88)
E SQLiteDatabase:   at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1599)
E SQLiteDatabase:   at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468)
E SQLiteDatabase:   at aqun.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):175)
E SQLiteDatabase:   at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):182)
E SQLiteDatabase:   at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):23)
E SQLiteDatabase:   at aqtp.a(:com.google.android.gms@202414037@20.24.14 (120400-319035315):177)
E SQLiteDatabase:   at aqpz.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):9)
E SQLiteDatabase:   at smo.b(:com.google.android.gms@202414037@20.24.14 (120400-319035315):12)
E SQLiteDatabase:   at smo.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):7)
E SQLiteDatabase:   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
E SQLiteDatabase:   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
E SQLiteDatabase:   at ssm.run(:com.google.android.gms@202414037@20.24.14 (120400-319035315):0)
E SQLiteDatabase:   at java.lang.Thread.run(Thread.java:919)

But realised the play-services-ads-identifier lib wasn't being packaged, when we ensured that dependency was included the errors have disappeared.

jamessolo12 commented 4 years ago

This is a live issue raised in April, why is it not being looked at already?

msdrigg commented 4 years ago

07-17 09:29:56.884 719 922 I ActivityManager: Process com.android.bluetooth (pid 836) has died: fore SVC 07-17 09:29:57.074 971 2295 E SQLiteDatabase: Error inserting period=6146000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992596967 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3072000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:29:57.074 971 2295 E SQLiteDatabase: 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) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:29:57.074 971 2295 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: Error inserting period=6146000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992597020 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3072000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:29:57.090 971 2295 E SQLiteDatabase: 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) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):8) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:29:57.090 971 2295 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: Error inserting period=6145000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992597157 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3072000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:29:57.180 971 2295 E SQLiteDatabase: 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) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:29:57.180 971 2295 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: Error inserting period=6145000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992597344 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3072000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:29:57.362 971 2124 E SQLiteDatabase: 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) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:29:57.362 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: Error inserting period=6145000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992597537 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3072000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:29:57.544 971 2295 E SQLiteDatabase: 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) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:29:57.544 971 2295 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:30:39.853 719 920 W ActivityManager: Unable to start service Intent { act=com.google.android.gms.ads.identifier.service.START pkg=com.google.android.gms } U=0: not found 07-17 09:30:39.911 971 2124 E SQLiteDatabase: Error inserting period=6060000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992639903 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3029000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:30:39.911 971 2124 E SQLiteDatabase: 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) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:30:39.911 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:30:52.218 719 1962 W ActivityManager: Unable to start service Intent { act=com.google.android.gms.ads.identifier.service.START pkg=com.google.android.gms } U=0: not found 07-17 09:30:52.553 971 2295 E SQLiteDatabase: Error inserting period=6035000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992652498 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3017000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:30:52.553 971 2295 E SQLiteDatabase: 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) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:30:52.553 971 2295 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: Error inserting period=6032000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992653631 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=3015000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:30:53.637 971 2124 E SQLiteDatabase: 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) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:30:53.637 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:31:40.429 719 1962 W ActivityManager: Unable to start service Intent { act=com.google.android.gms.ads.identifier.service.START pkg=com.google.android.gms } U=0: not found 07-17 09:32:42.142 719 1962 W ActivityManager: Unable to start service Intent { act=com.google.android.gms.ads.identifier.service.START pkg=com.google.android.gms } U=0: not found 07-17 09:32:42.223 971 2124 E SQLiteDatabase: Error inserting period=5815000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992762208 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=2907000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:32:42.223 971 2124 E SQLiteDatabase: 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) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:32:42.223 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: Error inserting period=5815000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992762394 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=2907000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:32:42.421 971 2124 E SQLiteDatabase: 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) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:32:42.421 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: Error inserting period=5814000 preferred_charging_state=1 preferred_network_type=1 target_class=com.google.android.gms.measurement.PackageMeasurementTaskService required_network_type=0 runtime=1594992762658 required_idleness_state=0 source=16 service_kind=0 target_package=com.google.android.gms persistence_level=1 source_version=202414000 last_runtime=0 user_id=0 job_id=-1 requires_charging=0 tag=Measurement.PackageMeasurementTaskService.UPLOAD_TASK_TAG flex_time=2906000 task_type=0 retry_strategy={"maximum_backoff_seconds":{"3600":0},"initial_backoff_seconds":{"30":0},"retry_policy":{"0":0}} 07-17 09:32:42.682 971 2124 E SQLiteDatabase: 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) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:832) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1564) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1433) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at qbq.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):175) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):192) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):23) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at qas.a(:com.google.android.gms@202414070@20.24.14 (050300-319035315):187) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at pxc.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):9) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at hnh.b(:com.google.android.gms@202414070@20.24.14 (050300-319035315):12) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at hnh.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):7) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at hsu.run(:com.google.android.gms@202414070@20.24.14 (050300-319035315):0) 07-17 09:32:42.682 971 2124 E SQLiteDatabase: at java.lang.Thread.run(Thread.java:764)