worker instance lost [SQL0034]

code SQL0034 · 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

SQL0034 Log event at warn

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

level=WARN msg="worker instance lost" code=SQL0034 schema=sqlstreams worker=stream_janitor

This instance’s worker_instance row expired or was claimed by a replacement while it was still running, so it stops and lets the replacement run alone. Expect it after pauses longer than the instance TTL — GC, machine sleep, a network partition.

brandon Site Admin

Posts: 677

Helpful info.

the instances holding this worker's rows now

SELECT
	worker_instance.id,
	worker_instance.token,
	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.name = '{worker}'
ORDER BY worker_instance.expires_at 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: