Fresh install fails: Alembic migration 1 error "relation contributor_repo does not exist" when dropping cntrb_id column

[ANJAN672]

Hey everyone
I’m Anjan, an engineering student and developer from India. I’ve been exploring CHAOSS and recently started digging into Augur, trying to understand how the data pipelines work.

While setting up Augur locally, I ran into an issue during the Alembic migrations:
INFO [alembic.runtime.migration] Running upgrade 0 -> 1, Augur New Changes
psycopg2.errors.UndefinedTable: relation "contributor_repo" does not exist
LINE 1: ALTER TABLE contributor_repo DROP COLUMN cntrb_id

From what I can see, the migration file
augur/application/schema/alembic/versions/1_augur_new_changes.py
tries to run:
op.drop_column('contributor_repo', 'cntrb_id')

Docker way works but local doesn't coz
Docker uses
AUGUR_DB_SCHEMA_BUILD=1environment variable which triggers adifferent code paththat either:Uses a pre-built database image with schema already applied
OR handles the schema creation in a special way that avoids this ordering issue < ----

Anyone Installs freshly hit this issue

Before opening a GitHub issue, I wanted to check here:

Is this a known issue?
Am I missing a required migration step or setup?
Happy to debug further or open a PR if this is genuinely a bug.
Would appreciate any guidance 🙏

[MoralCode]

This should now be fixed on current main and will be part of the upcoming 0.93 release