br 0.1.20: DATABASE_ERROR 'no such column: source_system in table issues' on older databases

[w3dev33]

Description

br 0.1.20 fails with DATABASE_ERROR when running br list on databases created with older versions of br (e.g. 0.1.14). The error does not occur with br 0.1.14.

Error

{
  "error": {
    "code": "DATABASE_ERROR",
    "message": "Database error: internal error: no such column: source_system in table issues",
    "hint": null,
    "retryable": false,
    "context": null
  }
}

Reproduction

1. Create a workspace with br 0.1.14 and add some issues
2. Upgrade to br 0.1.20
3. Run br list in that workspace → DATABASE_ERROR

Investigation

• The source_system column does exist in the issues table (verified via PRAGMA table_info(issues) and direct SELECT source_system FROM issues LIMIT 1)
• br doctor passes all checks including schema.columns and sqlite.integrity_check
• The error is specific to br list (and likely other commands that read issues)
• The issue appears related to the fsqlite update in 0.1.20 — databases created with older br versions have a different column order in the issues table

Affected commands

• br list
• Likely any command that queries the issues table via fsqlite

Workaround

Downgrade to br 0.1.14:

curl -fsSL https://raw.githubusercontent.com/Dicklesworthstone/beads_rust/main/install.sh | bash -s -- --version v0.1.14

Environment

• macOS ARM64 (Apple Silicon)
• br 0.1.20 (darwin_arm64)
• Database created with br 0.1.14

[w3dev33]

Additional note: This issue appears to affect only existing databases created with older versions of br. A fresh database created by br 0.1.20 itself likely works fine, as the schema would be created in the column order that fsqlite expects. The regression is specifically triggered by the different column ordering in databases migrated from older br versions.

[KingMob]

I'm seeing something similar. I let Claude wipe out all the sqlite files and rebuild from JSONL, which fixed all the issues...except for, weirdly, br doctor itself. Like, ready, show, search, list, etc all work afaict, but br doctor complains:

br doctor
╭──────────────────────────────────────────────────────────────────────────────────────────── Doctor ─────────────────────────────────────────────────────────────────────────────────────────────╮
│ Diagnostics Report                                                                                                                                                                              │
│                                                                                                                                                                                                 │
│ Status: Issues found                                                                                                                                                                            │
│ Checks: 8 ok, 0 warn, 1 error                                                                                                                                                                   │
│                                                                                                                                                                                                 │
│ [OK] jsonl.merge_artifacts                                                                                                                                                                      │
│ [OK] sync_jsonl_path: JSONL path is within sync allowlist                                                                                                                                       │
│ [OK] sync_conflict_markers: No merge conflict markers found                                                                                                                                     │
│ [OK] jsonl.parse: Parsed 383 records                                                                                                                                                            │
│ [ERROR] schema.tables: Missing tables: issues, dependencies, labels, comments, events, config, metadata, dirty_issues, export_hashes, blocked_issues_cache, child_counters                      │
│     {                                                                                                                                                                                           │
│       "missing": [                                                                                                                                                                              │
│         "issues",                                                                                                                                                                               │
│         "dependencies",                                                                                                                                                                         │
│         "labels",                                                                                                                                                                               │
│         "comments",                                                                                                                                                                             │
│         "events",                                                                                                                                                                               │
│         "config",                                                                                                                                                                               │
│         "metadata",                                                                                                                                                                             │
│         "dirty_issues",                                                                                                                                                                         │
│         "export_hashes",                                                                                                                                                                        │
│         "blocked_issues_cache",                                                                                                                                                                 │
│         "child_counters"                                                                                                                                                                        │
│       ]                                                                                                                                                                                         │
│     }                                                                                                                                                                                           │
│ [OK] schema.columns                                                                                                                                                                             │
│ [OK] sqlite.integrity_check                                                                                                                                                                     │
│ [OK] counts.db_vs_jsonl: Both have 383 records                                                                                                                                                  │
│ [OK] sync.metadata: External changes pending import                                                                                                                                             │
│                                                                                                                                                                                                 │
╰─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╯

[KingMob]

I spoke too soon. Now I'm getting errors like:

Bash(br update fe-g0b.36.13 --status=in_progress)
  ⎿  Error: Exit code 2
     {
       "error": {
         "code": "DATABASE_ERROR",
         "message": "Database error: database disk image is malformed: interior table cell has no rowid",
         "hint": null,
         "retryable": false,
         "context": null
       }
     }

     {
       "error": {
         "code": "DATABASE_ERROR",
         "message": "Database error: database disk image is malformed: interior table cell has no rowid",
         "hint": null,
         "retryable": false,
         "context": null
       }
     }

It seems to be restricted to just old issues, though, even if the sqlite db was completely rebuilt. New issues created post-upgrade aren't showing any problems in my testing.

[Dicklesworthstone]

Fixed in c6529f4.

Bumped CURRENT_SCHEMA_VERSION from 1 to 2, forcing re-migration of databases at version 1 that were created before the source_system column was added to the issues table.