SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then
View previous thread::View next thread

manager row suspended [SQL0035]

Edit this page
code SQL0035 · 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
SQL0035 Log event at warn

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

level=WARN msg="manager row suspended" code=SQL0035 schema=sqlstreams

The manager’s own row has target_instances 0, so its worker chain goes unreconciled until it is restored. Suspension is an operator action; restore target_instances to resume.

For the system’s manager row that means upkeep is off for the whole deployment — every process’s loop declines, and nothing drops partitions, advances cursors, or fires schedules until the column is restored to 1.

A process that is waiting rather than reconciling does not log this. The system’s row is declared target_instances = 1, so one process holds the claim and every other one is declined on a row that is working exactly as intended — that is a Debug line, not this warning. This event means the count is 0 and no process anywhere will run.

brandon Site Admin brandon profile Posts: 677

Helpful info.

  1. every suspended worker row -- target_instances 0

    SELECT
	id,
	name,
	system_id,
	stream_id,
	consumer_group_id
FROM {schema}.worker_config
WHERE target_instances = 0
ORDER BY name;
Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.

The team