Census incident

Sync Runs Failing with Undefined Column Error

Notice Resolved View vendor source →

Census experienced a notice incident on June 6, 2025 affecting Sync Engine, lasting 26m. The incident has been resolved; the full update timeline is below.

Started
Jun 06, 2025, 05:52 PM UTC
Resolved
Jun 06, 2025, 06:18 PM UTC
Duration
26m
Detected by Pingoru
Jun 06, 2025, 05:52 PM UTC

Affected components

Sync Engine

Update timeline

  1. monitoring Jun 06, 2025, 05:52 PM UTC

    Some syncs started failing with the following error at 12:18pm (EST) "ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column sync_configurations.new_diff_timestamp_expression_id does not exist" This was due to a brief issue during a schema update. The problem has been resolved, and we are monitoring.

  2. resolved Jun 06, 2025, 06:18 PM UTC

    This incident has been resolved.