SQLStreams

the messaging platform that is just Postgres

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

schedule target stream keeps no success rows [SQL0058]

Edit this page
code SQL0058 · log event at warn — Client.Scheduler(name).Status counts no successes for it; set DeliveryLogMode all on the stream to count them
the log line · Report this thread
SQL0058 Log event at warn

As it arrives in your log:

level=WARN msg="schedule target stream keeps no success rows" code=SQL0058

Client.Scheduler(name).Register found the target stream’s DeliveryLogMode set to failures (the default) or off. Client.Scheduler(name).Status and .Messages read the target stream’s delivery_log by the schedule’s message key, so a success that writes no row is a success the status never sees: succeeded stays 0 and every run reads as pending or failed.

The schedule registers and produces regardless - the mode only decides what the status verbs can report.

To count successes, register the target stream with DeliveryLogMode: sqlstreams.DeliveryLogModeAll. That writes one row per success on that stream, for every message on it, not only the schedule’s.

Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.