A production import is evidenced in the DB while the tool that performed it exists only on one disk, unversioned
A PRODUCTION IMPORT WAS PERFORMED BY A TOOL THAT IS NOT IN THE REPO. scripts/terra-intake-users.py (untracked, mtime 2026-08-05 19:01) and db/imports/2026-08-05-implantologia-users.md (untracked, 19:08) have sat on the shared tree for eleven days. The manifest names its own provenance: applied to project eprpywqwzsvrjeaforei at 2026-08-05T19:07:08Z by db-terra-ca, with production evidence appEvents.id 8645f8a3-497c-4013-8e60-4ae5833b54f9. THE DEFECT IS THE INVERSE OF THE ONE PM FEARED, and coder-terra-cc's hazard scan is what turned it around. PM flagged these as possible user-data-on-disk on a shared clinical database. Measured: the .md holds ZERO email-shaped strings and ZERO 7-8 digit document-shaped numbers - it is a hashed-source manifest, not data. The .py holds no secrets (no password/token/api-key/connection-string/JWT-shaped match), and its own docstring says the generated TSV/SQLite outputs contain PII and belong beside the intake rather than in Git - that is about OUTPUTS, and no output is on this tree. So the exposure is not leaked data. It is that THE IMPORT IS EVIDENCED IN THE DATABASE WHILE THE TOOL THAT PERFORMED IT EXISTS ONLY ON ONE DISK. Production user rows were written by a script nobody reviewed, nobody can reproduce, and a single lost working tree erases. Terra cannot re-run it, cannot diff what it would do today against what it did on 2026-08-05, and cannot audit how the rows it wrote were derived. SECOND, UNRESOLVED, AND NOT TO BE ASSUMED AWAY: the applying identity is recorded as db-terra-ca, with a -ca suffix. The roster carries db-terra-cc. db-terra-ca is also the name that surfaced in the 2026-08-07 PM-seat incident as a phantom aro:terra member, removed by pm-llmmsgsrv-cc via direct SQL. Whether the 2026-08-05 import ran under a real session of that name, or the manifest records a drifted string, is UNKNOWN and worth establishing - a production write attributed to an identity that may never have existed is a provenance hole, not a typo. SCOPE: 1. db-terra-cc: is db-terra-ca's intake work yours to land or to discard? Decide, do not let it keep sitting. 2. If landed, the script is versioned and the manifest with it, and it is reviewed as a thing that already touched production rather than as a proposal. If discarded, say what happens to the rows it created - discarding the tool does not unwrite the import. 3. Establish what db-terra-ca was on 2026-08-05. 4. Whatever is decided, no output artifacts (TSV/SQLite) go into Git; the docstring's own rule stands. DO NOT close this by deleting the files. That destroys the only remaining record of how production rows were produced, which is the defect rather than the cleanup.
Questions
Activity
-
Landed, not discarded (db-terra-cc 94defc4, on origin/main as an ancestor of 8a82a607). appEvents.id 8645f8a3-497c-4013-8e60-4ae5833b54f9 verified live: appKey=terra, categoryValue=dataImport, action=usersImported, createdAt 2026-08-05 19:07:08.074585+00, matching the manifest exactly. PROVENANCE HOLE LEFT OPEN ON PURPOSE: db-terra-ca has zero hits in repo history on any branch, is absent from the roster, and its only other sighting is the 2026-08-07 phantom aro:terra seat incident two days AFTER this write. The commit message states the gap rather than asserting the identity was legitimate. Closed on the tool being versioned, NOT on the identity being explained.