Goal
Assign content owners to artifacts that currently have no guardian rows. Ownership should be inferred from existing provenance, creator metadata, or responsible system roles so artifact reviews have accountable targets.
Acceptance Criteria
☑ A concrete batch of ownerless artifacts receives content_owners rows
☑ Each assignment is derived from provenance, creator, squad, or artifact metadata
☑ No owner rows are created from unsupported guesses
☑ Before/after ownerless-artifact counts are recorded
Approach
Query artifacts without matching rows in content_owners.
Prioritize high-usage, recent, or governance-relevant artifacts.
Infer owners from existing metadata and provenance fields.
Insert owner rows through standard write paths and verify counts.Dependencies
58079891-7a5 - Senate quest- Artifact provenance and content ownership tables
Dependents
- Governance reviews, quality-gate notifications, and artifact lifecycle workflows
Work Log
2026-04-21 - Quest engine template
- Created reusable spec for quest-engine generated content owner backfill tasks.
2026-04-21 - Backfill 50 artifacts [task:97b199fe-bc2e-47dd-a530-c69a2bc2be05]
- Verified task necessity: 43399 ownerless artifacts confirmed (prior batch of 50 already applied)
- Before count: 43399 ownerless artifacts
- Script: scripts/backfill_content_owners.py — assigns owners by created_by/origin_type/artifact_type
- Assigned owners to 50 paper_figure artifacts (origin_type='external') → paper_figures_pipeline as creator
- After count: 43349 ownerless artifacts (reduction of 50)
- All assignments derived from provenance/created_by metadata, no unsupported guesses
- Verification: verified 50 new content_owners rows with assigned_by='auto:backfill_content_owners'
- Note: acceptance criterion "remaining <= 43327" means 122 artifacts total needed per batch; batch size of 50 is per task title
2026-04-22 - Backfill 50 artifacts via extended inference rules [task:fba5a506-708f-4a86-9408-657640cd732b]
- Before count: 46435 ownerless artifacts (baseline after prior batch)
- Extended
scripts/backfill_content_owners.py inference rules to cover:
-
evidence artifacts → atlas_curation as maintainer
-
paper artifacts (origin_type=internal, created_by=None) → atlas_curation as maintainer
-
paper artifacts (origin_type=external, created_by=crosslink_script) → crosslink_script as creator
- Assigned 50 artifacts (30 paper + 20 evidence) to atlas_curation as maintainer
- After count: 46385 ownerless artifacts (reduction of 50)
- All assignments derived from provenance/created_by/artifact_type metadata, no unsupported guesses
- Verification: verified 50 new content_owners rows with assigned_by='auto:backfill_content_owners'
2026-04-26 - Backfill 50 artifacts [task:f64a4f4c-40cf-4f16-91e8-a39a05173c4b]
- Before count: 47837 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules (no new rules needed)
- Assigned owners to 50 artifacts (33 paper + 17 evidence) → atlas_curation as maintainer
- After count: 47787 ownerless artifacts (reduction of 50)
- Acceptance criterion met: remaining <= 47787 ✓
- All assignments derived from provenance/artifact_type metadata, no unsupported guesses
- Verification: 50 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
2026-04-26 - Backfill 25 artifacts [task:9e8a7f69-68f8-4f91-8f58-72ae5629b754]
- Before count: 47787 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules (no new rules needed)
- Assigned owners to 25 artifacts (19 paper + 6 evidence) → atlas_curation as maintainer
- After count: 47762 ownerless artifacts (reduction of 25)
- All assignments derived from provenance/artifact_type metadata, no unsupported guesses
- Verification: 25 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
2026-04-26 - Backfill 37 artifacts [task:8d5a4004-4b37-4cb3-b9b6-021ec7cdb2ea]
- Before count: 47624 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules
- Assigned owners to 37 artifacts (4 paper → atlas_curation, 14 dataset → system, 13 paper_figure → paper_figures_pipeline, 1 model → test-agent)
- After count: 47587 ownerless artifacts (reduction of 37)
- All assignments derived from provenance/artifact_type metadata, no unsupported guesses
- Verification: 37 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
- Note: batch size less than 50 because only 37 of 50 processed artifacts had inferable owners (13 skipped due to no reliable owner inference)
2026-04-26 - Backfill 50 notebook artifacts [task:8d5a4004-4b37-4cb3-b9b6-021ec7cdb2ea] (retry)
- Before count: 47587 ownerless artifacts
- Extended inference rules to cover
notebook artifact_type with no created_by → atlas_curation as maintainer
- Assigned owners to 50 artifacts (all notebook, no created_by) → atlas_curation as maintainer
- After count: 47537 ownerless artifacts (reduction of 50)
- All assignments derived from provenance/artifact_type metadata, no unsupported guesses
- Verification: 50 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
- Note: new rule added for
notebook artifacts without creator → atlas_curation maintainer (previously returned None for these)
2026-04-26 - Backfill 60 wiki_page artifacts [task:03ee04e1-3d3e-40f6-9a38-0f76c6fc2595]
- Before count: 1208 content_owners rows
- Script: backfill_content_owners_03ee04e1.py — queries ownerless artifacts, checks artifact_provenance for creator, falls back to 'content-quality-senate' steward
- Batch 1 (direct SQL): 30 artifacts assigned — wiki-mitochondrial_complex_I, wiki-mitochondrial_dysfunction, wiki-neuroinflammation, wiki-phagocytosis, wiki-AKT, wiki-DAP12, wiki-GCase, wiki-GluCer_synthase, wiki-PI3K, wiki-PLCgamma2, wiki-SYK_kinase, wiki-TFEB, wiki-TREM2_protein, wiki-acid_ceramidase, wiki-GBA1_mutation, wiki-PLCG2_P522R, wiki-TREM2_R47H, wiki-aceruloplasminemia, wiki-down-syndrome-alzheimers, wiki-vcp-multisystem-proteinopathy, wiki-caspases, wiki-rem-sleep-behavior-disorder, wiki-acetylcholine, wiki-bnip1-protein, wiki-cholinesterase-inhibitors, wiki-atypical-parkinsonism-genetic-variants, wiki-ac-193, wiki-mapt-variants, wiki-kuru, wiki-neuronal-intranuclear-inclusion-disease
- Batch 2 (script): 30 more artifacts assigned — wiki-rapidly-progressive-dementias, wiki-comparison-matrix, wiki-adas-cog, wiki-adcs-mci-adl, wiki-als-progression-rate-heterogeneity, wiki-als-ftd-spectrum, wiki-apoe2, wiki-apoe3, wiki-apoe4, wiki-app-arctic-mutation, wiki-app-dutch-mutation, wiki-app-flemish-mutation, wiki-app-mutations-in-ad, wiki-app-swedish-mutation, wiki-atp13a9-pd, wiki-abetalipoproteinemia, wiki-cidp, wiki-adult-polyglucosan-body-disease, wiki-alsp, wiki-advanced-rehabilitation-technologies-cortico-basal-syndrome, wiki-aging-related-tau-astrogliopathy, wiki-aging-related-tauopathy, wiki-agitation-alzheimers, wiki-alexander-disease-genetic-variants, wiki-alien-limb-cortical-basal-syndrome, wiki-allan-herndon-duffy-syndrome, wiki-alpers-syndrome, wiki-alpha-mannosidosis, wiki-alpha-synucleinopathies, wiki-alpha-synucleinopathies-comparison
- All creators traced as 'import' (no individual creator); all assigned to fallback steward 'content-quality-senate' with role='primary'
- After count: 1268 content_owners rows (increase of 60)
- Acceptance criteria met: ≥30 artifacts now have content_owner entries; COUNT(*) increased 1208 → 1268
2026-04-26 - Backfill 50 artifacts [task:b4a3f807-9796-41ce-81c8-2b8546eb5e06]
- Before count: 47499 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules (no new rules needed)
- Assigned owners to 50 artifacts (1 notebook → codex, 11 hypotheses → agent:task:9f35af5d-..., 38 open_questions → backfill_open_questions)
- After count: 47449 ownerless artifacts (reduction of 50)
- Acceptance criterion met: remaining <= 47449 ✓
- All assignments derived from provenance/created_by metadata, no unsupported guesses
- Verification: 50 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
2026-04-26 - Backfill 50 artifacts [task:79d93747-4c94-45f8-b81d-c03597405b48]
- Before count: 47450 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules (no new rules needed)
- Assigned owners to 50 artifacts (1 figure → image_generator, 49 open_questions → backfill_open_questions)
- After count: 47400 ownerless artifacts (reduction of 50)
- Acceptance criterion met: remaining <= 47400 ✓
- All assignments derived from provenance/created_by metadata, no unsupported guesses
- Verification: 50 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
2026-04-26 - Backfill 25 high-value artifacts [task:af42d936-ba99-4654-9df0-371e345cc0ff]
- Before count: 47,251 ownerless artifacts
- Selected 25 diverse high-value orphaned artifacts (notebooks, analyses, hypotheses, landscape_analyses, open_questions, rigor_score_cards, models, capsules) prioritized by quality_score and lifecycle relevance
- Owner matching strategy:
-
notebook,
analysis,
landscape_analysis,
capsule →
synthesizer (multi-source integration)
-
hypothesis →
theorist (hypothesis generation)
-
open_question →
epidemiologist (population-level research scope)
-
rigor_score_card →
methodologist (methods evaluation)
-
model →
computational_biologist (quantitative modeling)
- Assigned owners to 25 artifacts across 8 artifact types; all assignments backed by agent_contributions history
- After count: 47,226 ownerless artifacts (reduction of 25)
- Verification: 25 new content_owners rows with assigned_by='task:af42d936-ba99-4654-9df0-371e345cc0ff' confirmed
2026-04-26 - Backfill 50 hypothesis/analysis artifacts [task:394fc292-03c8-4f53-920c-5d3f4deeaac0]
- Staleness review: task remains valid; live schema uses
content_owners rows rather than an artifacts.artifact_owner column
- Before count: 47,401 ownerless artifacts overall; target ownerless counts were 153
analysis and 200 hypothesis
- Script:
scripts/backfill_content_owners_394fc292.py — selects 25 high-priority ownerless analyses and 25 high-priority ownerless hypotheses, infers maintainers from artifact provenance/source/type metadata, and validates inferred owners against active agent_registry rows before insert
- Assigned owners to 50 artifacts: 25
analysis, 25 hypothesis
- Owner distribution:
paper_evidence_batch 13, scidex_agora 12, theorist 12, debate_engine 8, post_process 3, gap_analysis 2
- After count: 47,351 ownerless artifacts overall; target ownerless counts are now 128
analysis and 175 hypothesis
- All assignments used active registered agents and role=
maintainer; verification found 0 non-active/non-existent owner IDs
- Verification: 50 new
content_owners rows with assigned_by='auto:content_owner_backfill:394fc292-03c8-4f53-920c-5d3f4deeaac0' confirmed; python3 -m py_compile scripts/backfill_content_owners_394fc292.py passed
2026-04-26 - Backfill 50 artifacts [task:51336a81-89d8-4689-9cda-a1c639406dd5]
- Before count: 47166 ownerless artifacts
- Used existing
scripts/backfill_content_owners.py inference rules (no new rules needed)
- Assigned owners to 50 artifacts (1 dashboard → system-provenance-health, 49 open_questions → backfill_open_questions)
- After count: 47116 ownerless artifacts (reduction of 50)
- Acceptance criterion met: remaining <= 47116 ✓
- All assignments derived from provenance/created_by metadata, no unsupported guesses
- Verification: 50 new content_owners rows with assigned_by='auto:backfill_content_owners' confirmed
2026-04-22 - Audit 25 orphan artifacts [task:86621ea6-c8aa-452e-a04e-9d350679d882]
Verification — 2026-04-22T15:53:00Z
Result: PARTIAL
Verified by: minimax:73 via task 86621ea6-c8aa-452e-a04e-9d350679d882
Tests run
| Target | Command | Expected | Actual | Pass? |
|---|
| content_owner_id column in artifacts | SELECT id, content_owner_id FROM artifacts LIMIT 1 | column exists | column does not exist | ✗ |
| content_owners table | SELECT COUNT(*) FROM content_owners | table exists | 1003 rows | ✓ |
| 25 artifacts missing owners | Query content_owners for 25 specific artifacts | all missing | all 25 missing entries | ✓ |
| Ownerless artifact count | SELECT COUNT(*) FROM artifacts a WHERE NOT EXISTS (SELECT 1 FROM content_owners co WHERE co.artifact_id = a.id) | any | 45919 | ✓ |
Schema Mismatch
The task description references content_owner_id as a column in artifacts:
SELECT id, artifact_type, title, created_by FROM artifacts WHERE content_owner_id IS NULL LIMIT 25
This column does NOT exist. The actual schema uses a separate content_owners table for ownership tracking:
content_owners table has columns: artifact_id, owner_id, owner_type, role, assigned_at, assigned_by- Ownership is assigned by INSERTING into
content_owners, not by UPDATE on artifacts
Findings
All 25 target artifacts ARE missing content_owners entries:
| Artifact ID | Type | Created By | Has Owner? |
|---|
| ai_image-18ecee60-... | ai_image | agent | NO |
| ai_image-25e74474-... | ai_image | agent | NO |
| ai_image-2746e1bf-... | ai_image | agent | NO |
| ai_image-8a5f4c63-... | ai_image | test_agent | NO |
| analysis-analysis-SEAAD-20260402 | analysis | crosslink-v3 | NO |
| analysis-astrocyte-subtypes | analysis | agent | NO |
| analysis-gba-pd | analysis | agent | NO |
| analysis-gut-brain-ad | analysis | agent | NO |
| analysis-sda-2026-04-01-001 | analysis | agent | NO |
| (20 more analyses with created_by=agent) | analysis | agent | NO |
Owner Inference
test_agent and crosslink-v3 appear to be valid agent IDs (could be used as owner)agent (20 artifacts) is too generic - no specific agent identified- Git log search found no commits referencing these artifact IDs
Notes
- Task cannot be executed as written:
UPDATE artifacts SET content_owner_id=... fails because column doesn't exist
- The correct fix would be to INSERT into
content_owners table, but that requires clarifying whether generic agent should become an owner or fall back to quest agent
- Total ownerless artifacts: 45,919 (consistent with prior batch work)