Skip to main content
← Back to list
01Issue
BugOpenSwamp ClubPublic
AssigneesNone

Relationships

#3208 Activity projector fails with ZooKeeper "Bad version" error on swamp.score_grants during keeper instability

Opened by swamp_lord · 10/9/2026

Description

The activity projector job on swamp-club fails intermittently with a ClickHouse Keeper / ZooKeeper error when writing to the replicated swamp.score_grants table:

Code: 244. UNEXPECTED_ZOOKEEPER_ERROR: Bad version for swamp.score_grants replica clickhouse-production-01

It happens during Keeper leader elections or periods of high Keeper latency. The cluster self-heals quickly on another node, but the projector run fails. Until the projector recovers or is restarted, activity feed data can be delayed or end up inconsistent.

Detection

  • Alert: [P3] "Activity projector erroring (new signal) on swamp-club" (category: application-reliability)
  • Signal: [REDACTED-SECRET-1]
  • First seen: 2026-10-07T10:13:34Z (1 occurrence at time of alert)

Steps to reproduce

  1. The projector writes to swamp.score_grants on clickhouse-production-01.
  2. A Keeper leader election happens or Keeper latency spikes during the write.
  3. The insert fails with UNEXPECTED_ZOOKEEPER_ERROR: Bad version, and the projector run errors out.

Expected

The projector handles transient Keeper errors during writes to swamp.score_grants, so feed data is neither lost nor delayed.

Environment

  • swamp-club production, ClickHouse replica clickhouse-production-01
  • Related: the Keeper instability itself is still under investigation
02Bog Flow
◉OPEN○TRIAGED○IN PROGRESS○SHIPPED

Open

10/9/2026, 2:40:55 PM

No activity in this phase yet.

03Sludge Pulse
Editable. Press Enter to edit.

system commented 10/9/2026, 2:40:55 PM

Classified automatically when this issue was filed.

  • Source: Swamp Club

If you feel this classification is incorrect, add a ripple to tell us so.

Sign in to post a ripple.