usaspending-api icon indicating copy to clipboard operation
usaspending-api copied to clipboard

Error Running Migrations

Open mvryan opened this issue 1 year ago • 1 comments

When Applying the Django migrations on a clean database (the docker based solution) I get an error when running search.0014_additional_transaction_search_cols

It complains that psycopg2.errors.UndefinedTable: relation "transaction_search" does not exist

Looking at the tables that do get created it seems transaction_search isn't there

Screen Shot 2023-05-22 at 2 08 45 PM

I reviewed the migrations and it looks like nothing is being skipped

  Applying search.0001_initial... OK
  Applying search.0002_auto_20210121_2235... OK
  Applying search.0003_auto_20210629_1550... OK
  Applying search.0004_transactionsearch_award_date_signed... OK
  Applying search.0005_transactionsearch_recipient_uei... OK
  Applying search.0006_auto_20220113_1658... OK
  Applying search.0007_transactionsearch_parent_uei... OK
  Applying search.0008_awardsearch_table... OK
  Applying search.0009_awardsearch_view_drop... OK
  Applying search.0010_subaward_search... OK
  Applying search.0011_alter_summarystateview_options... OK
  Applying search.0012_removing_subaward_models... OK
  Applying search.0013_subaward_search_schema... OK
  Applying search.0014_additional_transaction_search_cols...Traceback (most recent call last):

Any advice would be great. Thanks.

(EDIT: It looks like it should be in this migrations search.0002_auto_20210121_2235 https://github.com/fedspendingtransparency/usaspending-api/blob/82d162ce2d9aa3a73f77f9f16d92e6e5d233f0ce/usaspending_api/search/migrations/0002_auto_20210121_2235.py#L18 )

mvryan avatar May 22 '23 18:05 mvryan