worker tick backoff curve exhausted [SQL0036]

code SQL0036 · log event at error — sqlstreams's own machinery stopped doing its job; an operator must act

the log line

SQL0036 Log event at error

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

level=ERROR msg="worker tick backoff curve exhausted" code=SQL0036 schema=sqlstreams worker=stream_janitor

A worker’s tick failure streak passed its TickRetry cap; ticks continue at the cap’s delay, but the failure is no longer treated as self-healing. The error attribute carries the last failure and the line’s preceding group holds the narration leading up to it.

brandon Site Admin

Posts: 677

Helpful info.

this worker's rows and their failure streaks

SELECT
	worker_config.id,
	worker_config.target_instances,
	worker_instance.expires_at,
	worker_instance.attempts
FROM {schema}.worker_config
LEFT JOIN {schema}.worker_instance ON worker_instance.worker_id = worker_config.id
WHERE worker_config.name = '{worker}'
ORDER BY worker_instance.attempts DESC;

Landed here from a log? Paste the line — the queries above fill with your own values.

Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.

Jump to: