Problem
Some escrow records contain negative values for timing metrics:
{
"id": 39,
"time_to_release": -14078,
"time_to_fund": 43,
"state": "released"
}
Negative `time_to_release` (-14078 seconds ≈ -4 hours) is logically impossible - you can't release before funding.
Observed in
Multiple released escrows have negative timing values. This suggests either:
- Clock skew between systems
- Calculation bug in the indexer
- Events processed out of order
- Timestamps recorded incorrectly
Impact
- Minor: Metrics/analytics would be incorrect
- Could indicate deeper indexer issues
- Erodes trust in platform data accuracy
Expected Behavior
All timing metrics should be:
- Non-negative (≥ 0)
- Logically consistent (fund → commit → release → claim order)
Suggested Fix
- Investigate root cause - Check indexer logic for timing calculations
- Add validation - Reject/flag negative values on write
- Clean up data - Set invalid values to null or recalculate from timestamps
Acceptance Criteria
Problem
Some escrow records contain negative values for timing metrics:
{ "id": 39, "time_to_release": -14078, "time_to_fund": 43, "state": "released" }Negative `time_to_release` (-14078 seconds ≈ -4 hours) is logically impossible - you can't release before funding.
Observed in
Multiple released escrows have negative timing values. This suggests either:
Impact
Expected Behavior
All timing metrics should be:
Suggested Fix
Acceptance Criteria