# Census: Mirror Syncs Failing with SQL error

> Census status incident “Mirror Syncs Failing with SQL error” on 2025-03-26: impact minor (vendor’s label), 21 min, 3 update(s). Archived by Rewindex.

Canonical: https://rewindex.com/company/census/incidents/kg95l020xpbz
Last updated: 2025-03-26T04:25:01Z

- Impact (vendor’s label): minor
- Status: resolved
- Started: 2025-03-26 04:03 UTC · Resolved: 2025-03-26 04:25 UTC · Duration: 21 min
- Updates: 3 · Affected components: Sync Engine
- [Vendor status page: https://stspg.io/l9xgl9k2x9g7](https://stspg.io/l9xgl9k2x9g7)
- [Company: Census](https://rewindex.com/company/census.md)

## Timeline of updates

- **investigating** 2025-03-26 04:03 UTC: 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.
- **monitoring** 2025-03-26 04:15 UTC: 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.
- **resolved** 2025-03-26 04:25 UTC: This incident has been resolved.

## Cite this

Status incident (vendor impact label: minor) posted by Census, started 2025-03-26 04:03 UTC, resolved after 21 min, 3 update(s).

- Canonical URL: https://rewindex.com/company/census/incidents/kg95l020xpbz
- Citation: Census, “Mirror Syncs Failing with SQL error” (2025-03-26 04:03 UTC). Archived by Rewindex: https://rewindex.com/company/census/incidents/kg95l020xpbz (CC BY 4.0).
- Markdown link: `[Census: Mirror Syncs Failing with SQL error (2025-03-26)](https://rewindex.com/company/census/incidents/kg95l020xpbz)`


---
Canonical: https://rewindex.com/company/census/incidents/kg95l020xpbz · Markdown: https://rewindex.com/company/census/incidents/kg95l020xpbz.md · JSON: https://rewindex.com/api/v1/companies/census/incidents/kg95l020xpbz · Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/) · Generated 2026-11-04T18:03:43.998Z