[SOLVED]

consumer group not found [SQL0014]

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

the log line

SQL0014 Permanent error

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

consumer group not found: schema "sqlstreams", stream "orders.created", group_id 7 -- register a consumer with this group name to create it [SQL0014]

ACCEPTED ANSWER Posted: 2026-09-09

brandon Site Admin

Posts: 677

brandon Site Admin

Posts: 677

Helpful info.

every group registered on this stream

SELECT
	consumer_group_config.id,
	consumer_group_config.name,
	consumer_group_config.created_at
FROM {schema}.consumer_group_config
JOIN {schema}.stream_config ON stream_config.id = consumer_group_config.stream_id
WHERE stream_config.name = '{stream}'
ORDER BY consumer_group_config.name;

the group row behind an id, if that is what the line carried

SELECT
	id,
	stream_id,
	name,
	created_at
FROM {schema}.consumer_group_config
WHERE id = {group_id};