SQLStreams

the messaging platform that is just Postgres

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

schedule config replaced [SQL0062]

Edit this page
code SQL0062 · log event at warn — the newest declaration wins; if this is unexpected or repeats on every restart, two services declare this schedule with different configs and overwrite each other
the log line · Report this thread
SQL0062 Log event at warn

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

level=WARN msg="schedule config replaced" code=SQL0062 schema=sqlstreams schedule_id=3

Client.Scheduler(name).Register found the schedule already registered and the declared config differed from the stored row. The row keeps the newest declaration, and each changed config field rides the line as its own attribute carrying old -> new. The payload and Metadata documents are never logged: a changed one rides as payload_changed or metadata_changed and nothing of what it holds. A changed cron expression also moves next_scheduled_at: a run already due under the old expression is dropped, not produced late, and the line carries the new next_scheduled_at.

One line is a config change landing. The same line on every deploy means two services both declare the schedule with different configs and overwrite each other on restart - a schedule’s config wants exactly one declaring service, and nothing in the library enforces that beyond this line. schedule_config keeps no declaration trail the way stream_config_log and worker_config_log do, so the diagnose query shows the row as stored now; the earlier config values are only in the log lines, and an earlier payload is nowhere:

sqlstreams explain SQL0062
brandon Site Admin brandon profile Posts: 677

Helpful info.

  1. the schedule row as stored now (schedule_config keeps no declaration trail)

    SELECT
    	name,
    	expression,
    	concurrency,
    	timeout_ns,
    	suspended
    FROM {schema}.schedule_config
    WHERE id = {schedule_id};
Nothing pasted yet — the queries above show their blanks.

Looking for a different code? Search every thread.