messages dead-lettered [SQL0028]

Edit this page

code SQL0028 · log event at warn — degraded but self-healing, or a durable data consequence; an operator should learn of it eventually

the log line

· Report this thread

SQL0028 Log event at warn

As it arrives in your log — example values stand where yours will:

level=WARN msg="messages dead-lettered" code=SQL0028 schema=sqlstreams stream_id=1 group_id=7

A commit wrote terminal outcomes for a batch of messages — retries exhausted or the consumer classified them unrecoverable; dead_count carries how many. The rows stay in the delivery log as dead and will not be retried.

brandon Site Admin

Posts: 677

Helpful info.

every dead row this group holds, newest first

SELECT
	message_id,
	attempts,
	last_error,
	updated_at
FROM {schema}.exception_queue_{stream_id}
WHERE consumer_group_id = {group_id}
	AND status = 'dead'
ORDER BY updated_at DESC;

which errors account for them

SELECT last_error, count(*) AS dead_count
FROM {schema}.exception_queue_{stream_id}
WHERE consumer_group_id = {group_id}
	AND status = 'dead'
GROUP BY last_error
ORDER BY dead_count DESC;