crash-loop kill backstop fired [SQL0031]

Edit this page

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

SQL0031 Log event at warn

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

level=WARN msg="crash-loop kill backstop fired" code=SQL0031 schema=sqlstreams stream_id=1 group_id=7

Repeated consumer crashes on the same exception rows tripped the backstop, which marked them dead (dead_count carries how many) to break the crash loop. Inspect the dead rows for the input that crashes the consumer.

brandon Site Admin

Posts: 677

Helpful info.

the rows the backstop marked dead

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;

the attempts that crashed without recording an outcome

SELECT
	message_id,
	attempt,
	status,
	attempted_at
FROM {schema}.delivery_log_{stream_id}
WHERE consumer_group_id = {group_id}
	AND status = 'expired'
ORDER BY attempted_at DESC
LIMIT 50;