{"record":{"id":"47a454add833a802","repo":"coleam00/Archon","slug":"failed-to-look-up-run-for-isolation-env-envid","errorCode":null,"errorMessage":"Failed to look up run for isolation env ${envId}: ${err.message}","messagePattern":"Failed to look up run for isolation env (.+?): (.+?)","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"packages/core/src/db/workflows.ts","lineNumber":483,"sourceCode":" */\nexport async function getRunByIsolationEnvId(envId: string): Promise<WorkflowRun | null> {\n  const extract =\n    getDatabaseType() === 'postgresql'\n      ? \"metadata->>'isolation_env_id'\"\n      : \"json_extract(metadata, '$.isolation_env_id')\";\n  try {\n    const result = await pool.query<WorkflowRun>(\n      `SELECT * FROM remote_agent_workflow_runs\n       WHERE ${extract} = $1\n       ORDER BY started_at DESC LIMIT 1`,\n      [envId]\n    );\n    const row = result.rows[0];\n    return row ? normalizeWorkflowRun(row) : null;\n  } catch (error) {\n    const err = error as Error;\n    getLog().error({ err, envId }, 'db.workflow_run_get_by_isolation_env_failed');\n    throw new Error(`Failed to look up run for isolation env ${envId}: ${err.message}`);\n  }\n}\n\n/**\n * Find runs in a codebase whose id starts with `idPrefix` (e.g. the 8-char\n * short id shown in listings). Returns up to two matches so callers can detect\n * an ambiguous prefix. Scoped to `codebaseId` in the query, so it never crosses\n * projects. Run ids are UUIDs, so `idPrefix` is rejected unless it's within the\n * UUID charset — that keeps it out of LIKE-wildcard territory (`%` / `_`).\n */\nexport async function findWorkflowRunsByIdPrefix(\n  idPrefix: string,\n  codebaseId: string\n): Promise<WorkflowRun[]> {\n  if (idPrefix.length === 0 || !/^[0-9a-fA-F-]+$/.test(idPrefix)) return [];\n  try {\n    const result = await pool.query<WorkflowRun>(\n      'SELECT * FROM remote_agent_workflow_runs WHERE codebase_id = $1 AND id LIKE $2 LIMIT 2',","sourceCodeStart":465,"sourceCodeEnd":501,"githubUrl":"https://github.com/coleam00/Archon/blob/0773b9745896ef0612e709c80845a0f7db315b19/packages/core/src/db/workflows.ts#L465-L501","documentation":"Error \"Failed to look up run for isolation env ${envId}: ${err.message}\" thrown in coleam00/Archon.","triggerScenarios":"Thrown at packages/core/src/db/workflows.ts:483 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"0773b9745896ef0612e709c80845a0f7db315b19","analyzedAt":"2026-09-01T02:28:07.064Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-08T05:18:18.240Z"}