exception dead-lettered [SQL0030]

Edit this page

code SQL0030 · 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

SQL0030 Log event at warn

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

level=WARN msg="exception dead-lettered" code=SQL0030 schema=sqlstreams stream_id=1 group_id=7 message_id=214

An exception row exhausted its retries and was written terminal; attempts carries the final count. The row will not be retried.

brandon Site Admin

Posts: 677

Helpful info.

the exception row now recorded dead

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

the attempts that exhausted its budget

SELECT
	attempt,
	status,
	error,
	attempted_at
FROM {schema}.delivery_log_{stream_id}
WHERE consumer_group_id = {group_id}
	AND message_id = {message_id}
ORDER BY attempt;