mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-17 23:29:01 +02:00
bf161f2f9c
Track actual claim-time delivery, support legacy daemons, and repair comment batches across claim, retry, edit, and delete races. MUL-4348 Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
18 lines
938 B
SQL
18 lines
938 B
SQL
-- Record the comment ids that were actually embedded in a daemon claim.
|
|
--
|
|
-- coalesced_comment_ids is the enqueue plan, not proof of delivery: daemons
|
|
-- predating coalesced-comments-v1 ignore the structured fields. Keeping a
|
|
-- separate delivered set lets completion reconciliation replay every comment
|
|
-- that the claiming daemon did not receive.
|
|
ALTER TABLE agent_task_queue
|
|
ADD COLUMN IF NOT EXISTS delivered_comment_ids UUID[] NOT NULL DEFAULT '{}';
|
|
|
|
-- Active tasks created before this migration always received their primary
|
|
-- trigger through trigger_comment_content. We deliberately do not backfill
|
|
-- coalesced ids: an older daemon may have ignored them, and a duplicate replay
|
|
-- is safer than silently losing a deliberate instruction.
|
|
UPDATE agent_task_queue
|
|
SET delivered_comment_ids = ARRAY[trigger_comment_id]
|
|
WHERE trigger_comment_id IS NOT NULL
|
|
AND status IN ('dispatched', 'running', 'waiting_local_directory');
|