# Mirror Syncs Failing with SQL error

- Provider: [Census](https://down.guide/census)
- Level: confirmed
- Impact: Degraded
- lasted 21m
- started 2025-03-26 04:03 UTC
- Sync Engine
- id: DWN-64d21d736f
- Official page: https://stspg.io/l9xgl9k2x9g7

## Updates from Census
### 2025-03-26 04:03 UTC: investigating
We have identified a bug that is causing "mirror" syncs to fail with an error in the SQL generated by Census; the error message varies by data warehouse, but relates to a missing column. We are rolling back the incorrect deployment.
Note that this is unrelated to the scheduled maintenance for Census Store, which has not yet started and will be postponed until this issue is resolved.

### 2025-03-26 04:15 UTC: monitoring
We have reverted to the previous working version of the system and sync success rates have returned to normal levels. We are investigating why our integration tests were insufficient to prevent this issue.

### 2025-03-26 04:25 UTC: resolved
This incident has been resolved.

---
down.guide reads providers' official status pages every minute and adds its own evidence, always labeled. Free, no account. Agents: MCP at https://down.guide/mcp, REST at https://down.guide/api/v1, feeds at https://down.guide/feed. Built by Sazabi (https://sazabi.com/?utm_source=down-guide&utm_medium=markdown).