The “Sleep‑Is‑Fixed” report is a key metric for the Wellness product line, used by:
A data integrity issue directly impacts user trust and contractual reporting obligations with partners. The bug surfaced after the March 2026 DST change in the United States and Europe, prompting an urgent investigation. missax180220krissylynntabootriangleepis fixed
// Faulty logic (v2.4.1)
if (isDstTransition(date))
utcMillis = localMillis + offset; // <-- should be minus
The string could also be a username or handle used on online platforms (e.g., gaming, forums, or social media). The “Sleep‑Is‑Fixed” report is a key metric for
If you provide a topic, I can use the following structure: A data integrity issue directly impacts user trust
| Lesson | Action Item |
|--------|-------------|
| Test Time‑Zone Edge Cases | Extend the test matrix to cover all DST transitions for every supported region. |
| Library Upgrade Gatekeeping | Enforce a mandatory integration test for any third‑party library that handles date/time before merge to main. |
| Monitoring Gaps | Deploy real‑time anomaly alerts on aggregated metric drift (e.g., > 5 % deviation from 7‑day moving average). |
| Documentation | Update the Data Ingestion Design Doc with a clear diagram of timezone handling and the new validation step. |
| Rollback Preparedness | Keep the previous stable library version pre‑packaged and a feature flag (tz‑conversion‑legacy) ready for instant toggle. |
| Component | Change Summary |
|-----------|----------------|
| date‑utils library | Rolled back to v2.3.9 (stable) and patched the DST conversion logic in v2.4.2 to correctly subtract the offset. |
| ingest‑sleep‑service | Added defensive guard: if the resulting UTC epoch is > 24 h before/after the original event window, log a warning and reject. |
| report‑engine | Updated aggregation query to re‑validate timestamps against device_timezone metadata, ensuring any stray offsets are caught early. |
| Test Suite | Added DST‑fallback unit tests for every supported timezone, and a property‑based test that generates random epoch values around DST transition dates. |
| CI/CD Pipeline | Integrated a time‑zone matrix job (12 time‑zones × 2 DST directions) into nightly builds. |