Fixing midnight data purges vs rolling 24‑hour windows
Summary The system was experiencing a logic error in data retention policies. Instead of purging stale user records at the boundary of the calendar day (midnight), the current implementation was performing a rolling 24-hour window purge. This resulted in inconsistent data states where records were being deleted based on their specific timestamp rather than the … Read more