Skip to content

Self-host Postgres: installations.app_id and orb_github_installations.account_id also overflow-risk (INTEGER) #5070

Description

@JSONbored

What happens

Follow-up to #5059/#5060 (merged): widenGithubIdColumnsToBigint's first pass grepped migrations/*.sql for CREATE TABLE column-list definitions only. Two GitHub-native-id columns were added later via single-line ALTER TABLE ... ADD COLUMN ... INTEGER statements (migrations 0071, 0077) and were missed by that grep pattern:

  • installations.app_id -- GitHub's own numeric App id.
  • orb_github_installations.account_id -- the installation owner's numeric GitHub account id.

Found via a direct information_schema.columns query against the live edge-nl-01 schema for every remaining integer id-shaped column, run as a final sanity check after the first fix merged.

Fix

Add both to GITHUB_ID_BIGINT_WIDENING_SQL in src/selfhost/pg-adapter.ts, same idempotent Postgres-only pattern as #5060. Both statements were dry-run validated then applied directly against edge-nl-01 (same urgency reasoning as #5059: the underlying overflow is a live risk class, not hypothetical).

Metadata

Metadata

Assignees

No one assigned

    Labels

    gittensor:bugGittensor-scored bug fix — scores a 0.05x multiplier.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions