Outage in Census

Mirror Syncs Failing with SQL error

Resolved Minor

March 26, 2025 - Started about 1 year ago - Lasted 38 minutes
Official incident page

Incident Report

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.

Components affected

Census Sync Engine

Trusted by 1,000+ teams

Need to monitor Census outages?

Stop finding out about outages from your users. Monitor 6,320+ cloud services and get alerted the second something breaks.

Start Free Trial

No credit card
14-day trial
2-minute setup

Latest Updates ( sorted recent to last )

RESOLVED about 1 year ago - at 03/26/2025 04:25AM

This incident has been resolved.

MONITORING about 1 year ago - at 03/26/2025 04:15AM

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.

INVESTIGATING about 1 year ago - at 03/26/2025 04:03AM

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.

Latest Census outages

Census Web Outage - about 2 months ago

Degraded performance of Web & Sync Runs. - 3 months ago

Census Full Outage - 3 months ago

Census Web Outage and Sync Delays - 4 months ago

Subset of syncs are failing with, "Passed `nil` into T.must" - 5 months ago

The Status Page Aggregator with Early Outage Detection

With IsDown, you can monitor all your critical services' official status pages from one centralized dashboard and receive instant alerts the moment an outage is detected. Say goodbye to constantly checking multiple sites for updates and stay ahead of outages with IsDown.

Start free trial

No credit card required · Cancel anytime · 6320 services available

Integrations with Slack Microsoft Teams Google Chat Datadog PagerDuty Zapier Discord Webhook