commit confirmation was lost [SQL0019]

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

the log line

SQL0019 Permanent error

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

commit confirmation was lost: schema "sqlstreams", stream_id 1, group_id 7 [SQL0019]

brandon Site Admin

Posts: 677

Helpful info.

whether the outcomes landed -- rows updated at the commit

SELECT
	message_id,
	status,
	attempts,
	updated_at
FROM {schema}.exception_queue_{stream_id}
WHERE consumer_group_id = {group_id}
ORDER BY updated_at DESC
LIMIT 20;

the range lease whose expiry settles it either way

SELECT
	token,
	low,
	high,
	expires_at,
	reclaims
FROM {schema}.claim_lease_{stream_id}
WHERE consumer_group_id = {group_id};

Landed here from a log? Paste the line — the queries above fill with your own values.

Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.

Jump to: