initializeDatabase creates idx_message_history_index_orphan_sweep / idx_tags_pi_adopt / idx_tags_pi_fallback_tool_owner on legacy tables

[PeraSoluciones]

Title

initializeDatabase creates idx_message_history_index_orphan_sweep / idx_tags_pi_adopt / idx_tags_pi_fallback_tool_owner on legacy tables

Description

initializeDatabase creates idx_message_history_index_orphan_sweep / idx_tags_pi_adopt / idx_tags_pi_fallback_tool_owner on legacy tables

Environment

• Plugin: v0.40.0
• OS: linux x64
• Node: v24.13.1
• OpenCode: 1.18.22

Configuration

Config from ~/.config/cortexkit/magic-context.jsonc:

{
  "$schema": "https://raw.githubusercontent.com/cortexkit/opencode-magic-context/master/assets/magic-context.schema.json",
  "historian": {
    "opencode": {
      "model": "opencode-go/deepseek-v4-flash"
    },
    "pi": {
      "model": "opencode-go/deepseek-v4-flash"
    }
  },
  "dreamer": {
    "opencode": {
      "model": "opencode-go/deepseek-v4-flash"
    },
    "pi": {
      "model": "opencode-go/deepseek-v4-flash"
    }
  },
  "cache_ttl": {
    "default": "5m",
    "anthropic/claude-sonnet-4-6": "59m",
    "anthropic/claude-opus-4-6": "59m"
  },
  "sidekick": {
    "disable": true
  },
  "embedding": {
    "provider": "local",
    "model": "Xenova/all-MiniLM-L6-v2"
  }
}

Diagnostics

• Timestamp: 2026-08-24T18:46:49.555Z
• Plugin: v0.40.0
• OS: linux x64
• Node: v24.13.1
• OpenCode installed: true [cli] (1.18.22)
• Plugin registered in opencode config: true
• Plugin registered in tui config: true
• magic-context.jsonc parse error: none
• Conflicts detected: none
• MC compaction mode: on
• Native compaction: auto=false, prune=false

Config paths

{
  "configDir": "~/.config/opencode",
  "opencodeConfig": "~/.config/opencode/opencode.json",
  "opencodeConfigFormat": "json",
  "magicContextConfig": "~/.config/cortexkit/magic-context.jsonc",
  "tuiConfig": "~/.config/opencode/tui.jsonc",
  "tuiConfigFormat": "jsonc",
  "omoConfig": null
}

magic-context.jsonc flags

{
  "$schema": "https://raw.githubusercontent.com/cortexkit/opencode-magic-context/master/assets/magic-context.schema.json",
  "historian": {
    "opencode": {
      "model": "opencode-go/deepseek-v4-flash"
    },
    "pi": {
      "model": "opencode-go/deepseek-v4-flash"
    }
  },
  "dreamer": {
    "opencode": {
      "model": "opencode-go/deepseek-v4-flash"
    },
    "pi": {
      "model": "opencode-go/deepseek-v4-flash"
    }
  },
  "cache_ttl": {
    "default": "5m",
    "anthropic/claude-sonnet-4-6": "59m",
    "anthropic/claude-opus-4-6": "59m"
  },
  "sidekick": {
    "disable": true
  },
  "embedding": {
    "provider": "local",
    "model": "Xenova/all-MiniLM-L6-v2"
  }
}

Plugin cache

{
  "path": "~/.cache/opencode/packages/@cortexkit/opencode-magic-context@latest",
  "cached": "0.15.3",
  "latest": "0.40.0"
}

Storage

{
  "path": "~/.local/share/cortexkit/magic-context",
  "exists": true,
  "context_db_size": "18.4 MB"
}

Recent sessions

No recent OpenCode sessions found (or OpenCode DB unavailable on this runtime).

Historian dumps

(Metadata only — XML content is not included in this report.)
Dumps are stored per-project under <project>/.cortexkit/magic-context/historian/.

{
  "byProject": [],
  "legacyDumps": {
    "dir": "/tmp/opencode/magic-context/historian",
    "count": 0,
    "recent": []
  }
}

Historian failures (session_meta)

Note: this counter RESETS to 0 on every successful run — see 'Historian runs' below for the durable history.
No sessions with historian failures.

Historian runs (durable telemetry)

Per-session success/failure/no-op counts from historian_runs (never reset).
No historian runs recorded (or schema predates v24).

Log file

• Path: /tmp/opencode/magic-context/magic-context.log
• Exists: false
• Size: 0 KB

Historian failure signals (log, sanitized)

No historian failure log lines found in recent history.

Recent errors (last 20, sanitized)

No error-shaped log lines found in recent history.

Log (last 400 lines, sanitized)

<no log output>

[magic-alfonso]

Thanks for the report — confirmed and fixed on master. A legacy message_history_index without the harness column hit idx_message_history_index_orphan_sweep before the startup column heal ran, so SQLite raised no such column: harness at open and migrations never got the chance to run — a stable wedge, exactly as you found. The index is now created after the heal, we audited every other index in the initializer (the two tag indexes were already correctly sequenced), and a new regression fence opens the database from every historical schema version so this whole class stays dead. Fix rides the next release.