agent_nomination_processor.py exists in economics_drivers/artifact_nominations rows with status='proposed'contribution_settlements row (idempotent)agent_contributions (idempotent)governance_decisions entriesPass 1 — Process proposed nominations
Scan artifact_nominations WHERE status = 'proposed'. For each row:
agent_contributions entry (if contribution_id present, idempotent by reference_id)contribution_settlements entry (idempotent by nomination_id + downstream_task_id)Pass 2 — Finalize settled downstream
Find contribution_settlements with status='settled' but downstream_status='queued' → mark 'completed'.
UNIQUE(nomination_id, downstream_task_id) constraint(agent_id, contribution_type, reference_id)artifact_nominations table (source of nominations)contribution_settlements table (downstream settlements)agent_contributions table (credit ledger)governance_decisions table (for governance-type nominations)token_accounts table (agent wallets)economics_drivers/agent_nomination_processor.py with two-pass pipeline_process_settled_nominations: AND cs.token_reward > 0 filter incorrectly excluded zero-reward settlements; removed the condition_process_governance_nomination uses wrong column names:decision_id, artifact_type, artifact_id, metadataid, content_type, content_id, evidence_jsondecision NOT NULL column
(id, content_type, content_id, decision_type, decision, rationale, evidence_json, status, proposed_by, created_at) with decision='pending_review'task-6273e427-nomination-fix at commit 0a6cb0c8174a42d3 in origin/main ancestry causes all orchestra/task/* branches to fail the "no merge commits" rule_process_settled_nominations only handled downstream_status='queued', missing 'done' and other terminal states{
"_stall_skip_providers": [],
"_stall_requeued_by": "codex",
"_stall_requeued_at": "2026-04-11 03:14:20",
"completion_shas": [
"e4820cfadf3c0ce4f45a52d691ed801f07e39c0f",
"727ccdcfa48e464014e520fa10897033960669ff",
"152c38d889df6fa4e9c83f96232b71e1f8527b84",
"d911c251be8837452821ce92eff9c1531d583d62",
"1a0e7cd70104b5e8a68e4a0cad7ec2dc152ed2d1",
"58adcee5f863fce8209071a827795e8e5db980d3",
"306ea79b845ab2c1041a32dde3a5a597bb6c468a",
"3e6e2b2d2e2aa1e759dd4319a0ea0e19d1afdfa0",
"0891ceec01b09e2152e49035b10dc8abe2a2ae9c",
"57604f68c6fffeace96bbb047d968305e6f11ac8",
"d609ac00af8155165db6d811cf600d75daaeedec",
"ca9e81afc8e637c9eacb1f65c0e39059ccf5f8a6",
"ec22b5b92ee8e63d668609ed98df88167220283a"
],
"completion_shas_checked_at": "2026-04-13T00:15:49.369588+00:00",
"completion_shas_missing": [
"c2b85b15e76e7fc81a9b3704a3759997dd34bc85",
"53cf4426ffffb55fa47ec3a1b340d18a84a8396b",
"adb500acd979108621f63443e1053185c19b6d20",
"8101020a6cf5cd7e451e6fa13af91b760ff6b6ca",
"1a378cdd9d0e4639dc2ad34032a701abbac5598f",
"fc384b9f02f5f14cbca80e55e028dd0529ced7a4",
"0a6cb0c8cc6a42f9b99edd7077352e8b4e102d6a",
"463d4e532c6a711f7438084d65fd29452fe34dcf",
"0decbb923683406aec40321bb5fc2007c8957426",
"d2bc34822ab6036cdc1b7938bda3bfca0126571b",
"32769222414f253940eee6445cb9878abb6cfd06",
"9dbb31cefb521fbebed47e15c2c743521682ce74",
"47674f5a2fd8fa292ba5cd35336b78297ba3cb43",
"39e48c2647f1a2d983b97303d7ca234ac50e2eed",
"e25b2e0e3f23b0c1cd514a4c1f32fa984af53ea9"
],
"requirements": {
"coding": 5,
"safety": 9
},
"_stall_skip_at": {},
"_stall_skip_pruned_at": "2026-04-14T10:37:14.022390+00:00"
}