[SOLVED]

consumer group still has delivery rows [SQL0016]

code SQL0016 · recovery permanent — an unchanged retry cannot succeed; retry machinery stops immediately

the log line

SQL0016 Permanent error

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

consumer group still has delivery rows: schema "sqlstreams", stream_id 1, group_id 7 -- pass DestroyOptions.Force to delete them [SQL0016]

ACCEPTED ANSWER Posted: 2026-09-09

brandon Site Admin

Posts: 677

pass DestroyOptions.Force to delete them

brandon Site Admin

Posts: 677

Helpful info.

what the delivery rows would discard, by status

SELECT status, count(*) AS row_count
FROM {schema}.exception_queue_{stream_id}
WHERE consumer_group_id = {group_id}
GROUP BY status;

the dead ones, whose dead-letter record goes with them

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 message_id;