A Debezium connector against a Postgres logical replication slot has filled the source database disk
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
Interview Prompt
A Debezium connector against a Postgres logical replication slot has filled the source database disk twice in the last six months. Each time the connector restarted and never reattached cleanly, and the WAL grew until on-call manually intervened. The section's mechanics: log-based CDC requires an initial snapshot, the slot retains WAL until the consumer confirms read, and stuck consumers cause WAL growth on the source. Place the slot by replacing the Debezium transform with one whose name states the initial snapshot phase, the slot lag monitor (with a budget and an alert threshold), and the schema-evolution policy (additive flows; destructive blocks).
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision