Mirror Syncs Failing with SQL error

What to do

• Check whether you use Census Sync Engine. Check your stack

  Paste a package.json, lockfile, Terraform or a list of domains at down.guide/stack to see every provider you depend on.

• Confirm your retries, queues and scheduled jobs caught up after the 21m it lasted.

  Anything that failed between 2025-03-26 04:03 UTC and 2025-03-26 04:25 UTC may need a replay.

• Subscribe to Census's feed to hear about the next one first. RSS feed

  https://down.guide/feed?provider=census works in Slack (/feed subscribe), Discord feed bots and any RSS reader.

Updates from Census 3

1. investigatingMar 26, 2025, 4:03 AM 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.

   provider

2. monitoringMar 26, 2025, 4:15 AM 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.

   provider

3. resolvedMar 26, 2025, 4:25 AM UTC

   This incident has been resolved.

   provider

Corrections

None so far.

Something wrong on this page? Report an error or send us a note. Every fix is listed here.