Files
multica/server/migrations/399_plugin_hook_schedule.down.sql
Jiayuan Zhangandmultica-agent 5bf10d485c MUL-6582: add durable scheduled Plugin hooks (#7448)
* MUL-6582 feat(plugins): add durable scheduled hooks

Co-authored-by: multica-agent <[email protected]>

* MUL-6582: add schedule-pulse example plugin

Ship a real scheduled plugin that records each unique delivery_id in
workspace storage, so a host retry does not look like a second pulse.
The cmd/server test installs this example manifest and drives two
scheduler replicas through a dropped first attempt.

Co-authored-by: multica-agent <[email protected]>

* MUL-6582 fix(migrations): make schedule indexes retry-safe

Co-authored-by: multica-agent <[email protected]>

---------

Co-authored-by: multica-agent <[email protected]>
2026-08-23 17:37:21 +08:00

10 lines
467 B
SQL

DELETE FROM plugin_invocation WHERE trigger = 'schedule';
ALTER TABLE plugin_invocation DROP CONSTRAINT IF EXISTS plugin_invocation_trigger_check;
ALTER TABLE plugin_invocation ADD CONSTRAINT plugin_invocation_trigger_check
CHECK (trigger IN ('ui', 'manual', 'event', 'agent')) NOT VALID;
ALTER TABLE plugin_invocation DROP COLUMN IF EXISTS planned_at;
ALTER TABLE plugin_invocation DROP COLUMN IF EXISTS delivery_id;
DROP TABLE IF EXISTS plugin_hook_schedule;