What happens when a database crashes while consuming data from Kafka, and how do you handle it?

Tests whether you know the offset must only be committed after the DB write succeeds -- if you commit before writing, a crash loses the message; if you never commit, the consumer reprocesses it on restart, which is why idempotent writes matter more than the commit timing alone.