code SQL0006 · recovery permanent — an unchanged retry cannot succeed; retry machinery stops immediately
the log line
As it arrives in your log or error chain — example values stand where yours will:
stream still holds messages: schema "sqlstreams", stream_id 1 -- pass DestroyOptions.Force to destroy them with the stream [SQL0006]
ACCEPTED ANSWER Posted: 2026-09-09
pass DestroyOptions.Force to destroy them with the stream
Helpful info.
how many messages the destroy would discard
SELECT count(*) AS message_count FROM {schema}.message_log_{stream_id};
the newest of them, to judge whether the stream is still in use
SELECT id, routing_key, created_at FROM {schema}.message_log_{stream_id} ORDER BY id DESC LIMIT 20;
Nothing pasted yet — the queries above show their blanks.
Looking for a different code? Search every thread.