SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then
[SOLVED]

consumer group still has a live consumer [SQL0015]

Edit this page
code SQL0015 · recovery permanent — an unchanged retry cannot succeed; retry machinery stops immediately
the log line · Report this thread
SQL0015 Permanent error

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

consumer group still has a live consumer: schema "sqlstreams", group_id 7 -- stop the group's consumers, or pass DestroyOptions.Force [SQL0015]
ACCEPTED ANSWER Posted: 2026-09-09
brandon Site Admin brandon profile Posts: 677

stop the group's consumers, or pass DestroyOptions.Force

brandon Site Admin brandon profile Posts: 677

Helpful info.

  1. the instances still heartbeating on this group

    SELECT
    	worker_config.name AS worker,
    	worker_instance.id,
    	worker_instance.expires_at,
    	worker_instance.attempts
    FROM {schema}.worker_instance
    JOIN {schema}.worker_config ON worker_config.id = worker_instance.worker_id
    WHERE worker_config.consumer_group_id = {group_id}
    	AND worker_instance.expires_at > now()
    ORDER BY worker_instance.expires_at;
Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.