# Mirror Syncs Failing with SQL error

- Provider: [Census](https://down.guide/providers/census)
- Confidence: 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.

From the builder: does your app depend on Census? [Sazabi](https://www.sazabi.com/?utm_source=down-guide&utm_medium=markdown&utm_content=census) detects problems in your own logs without hand-written monitors, and you can ask it in plain language which errors mention Census.

---
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://www.sazabi.com/?utm_source=down-guide&utm_medium=markdown&utm_content=DWN-64d21d736f), AI-native observability and security: automatic issue detection, plain-language log search and live dashboards.