Failed to look up run for isolation env ${envId}: ${err.mess

Error message

Failed to look up run for isolation env ${envId}: ${err.message}

What it means

Error "Failed to look up run for isolation env ${envId}: ${err.message}" thrown in coleam00/Archon.

Source

Thrown at packages/core/src/db/workflows.ts:483

 */
export async function getRunByIsolationEnvId(envId: string): Promise<WorkflowRun | null> {
  const extract =
    getDatabaseType() === 'postgresql'
      ? "metadata->>'isolation_env_id'"
      : "json_extract(metadata, '$.isolation_env_id')";
  try {
    const result = await pool.query<WorkflowRun>(
      `SELECT * FROM remote_agent_workflow_runs
       WHERE ${extract} = $1
       ORDER BY started_at DESC LIMIT 1`,
      [envId]
    );
    const row = result.rows[0];
    return row ? normalizeWorkflowRun(row) : null;
  } catch (error) {
    const err = error as Error;
    getLog().error({ err, envId }, 'db.workflow_run_get_by_isolation_env_failed');
    throw new Error(`Failed to look up run for isolation env ${envId}: ${err.message}`);
  }
}

/**
 * Find runs in a codebase whose id starts with `idPrefix` (e.g. the 8-char
 * short id shown in listings). Returns up to two matches so callers can detect
 * an ambiguous prefix. Scoped to `codebaseId` in the query, so it never crosses
 * projects. Run ids are UUIDs, so `idPrefix` is rejected unless it's within the
 * UUID charset — that keeps it out of LIKE-wildcard territory (`%` / `_`).
 */
export async function findWorkflowRunsByIdPrefix(
  idPrefix: string,
  codebaseId: string
): Promise<WorkflowRun[]> {
  if (idPrefix.length === 0 || !/^[0-9a-fA-F-]+$/.test(idPrefix)) return [];
  try {
    const result = await pool.query<WorkflowRun>(
      'SELECT * FROM remote_agent_workflow_runs WHERE codebase_id = $1 AND id LIKE $2 LIMIT 2',

View on GitHub (pinned to 0773b97458)

When it happens

Trigger: Thrown at packages/core/src/db/workflows.ts:483 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of coleam00/Archon@0773b97458 (2026-09-01). Data as JSON: /api/errors/47a454add833a802. Report an issue: GitHub.