Skip to content

Bio Bridge step bugs (Apr 2026): (1) UPSERT accumulation — Google returns dif...

Bio Bridge step bugs (Apr 2026): (1) UPSERT accumulation — Google returns different nanosecond timestamps per sync → UPSERT on (ts, metric_type, source) doesn't dedup → each sync adds ~16k duplicate step recs/day. FIX: DELETE existing activity records for day before re-inserting. (2) merge_step_deltas double-counts across PW2+Pixel8. Alternative: PW2-only derived:com.google.step_count.delta:com.google.android.fit:Google:Google Pixel Watch 2:e74c792b:top_level. Steps=metric_type='activity'. Repair: delete activity raw_metrics for range → re-sync → transform --rebuild.

Bio Bridge step bugs (Apr 2026): (1) UPSERT accumulation — Google returns different nanosecond timestamps per sync → UPSERT on (ts, metric_type, source) doesn't dedup → each sync adds ~16k duplicate step recs/day. FIX: DELETE existing activity records for day before re-inserting. (2) merge_step_deltas double-counts across PW2+Pixel8. Alternative: PW2-only derived:com.google.step_count.delta:com.google.android.fit:Google:Google Pixel Watch 2:e74c792b:top_level. Steps=metric_type='activity'. Repair: delete activity raw_metrics for range → re-sync → transform --rebuild.

  • [[Bio Bridge]]

Bio-Bridge-step-accumulation-bug-Apr-2026-Google-mergestepdeltas-returns

Bio Bridge step accumulation bug (Apr 2026): Google merge_step_deltas returns...

Bio Bridge step accumulation bug (Apr 2026): Google merge_step_deltas returns different nanosecond timestamps per sync → UPSERT on (timestamp, metric_type, source) doesn't dedup → each sync adds ~16k duplicate step records/day. FIX: DELETE existing activity records for day before re-inserting. Affected days Apr 9-15 (2-3x inflated). Pixel Watch 2 single-source alternative available. Repair: delete raw_metrics activity for range → re-sync → transform --rebuild.

Bio Bridge step accumulation bug (Apr 2026): Google merge_step_deltas returns different nanosecond timestamps per sync → UPSERT on (timestamp, metric_type, source) doesn't dedup → each sync adds ~16k duplicate step records/day. FIX: DELETE existing activity records for day before re-inserting. Affected days Apr 9-15 (2-3x inflated). Pixel Watch 2 single-source alternative available. Repair: delete raw_metrics activity for range → re-sync → transform --rebuild.

  • [[Bio Bridge]]