IntegrityError: (psycopg2.IntegrityError) insert or update on table "councilmatic_core_eventagendaitem" violates foreign key constraint "councilmatic__bill_id_dfc1212c_fk_councilmatic_core_bill_ocd_id"

datamade / nyc-council-councilmatic

NYC Council version of Councilmatic

MIT License

7 stars 3 forks source link

IntegrityError: (psycopg2.IntegrityError) insert or update on table "councilmatic_core_eventagendaitem" violates foreign key constraint "councilmatic__bill_id_dfc1212c_fk_councilmatic_core_bill_ocd_id" #146

Closed hancush closed 5 years ago

hancush commented 5 years ago

there are about a thousand instances of an error that occurs when the downloads/ directory contains obsolete information from the api. https://sentry.io/datamade/nyc-council-councilmatic/issues/751135399/events/36923225234/

we've since cleared that directory. we have not seen this exception since, however i am going to monitor for regression and log this for posterity.

hancush commented 5 years ago

actually, this seems to be happening because we're missing bill data as a result of other, unrepaired integrity errors, namely https://github.com/datamade/nyc-council-councilmatic/issues/147 (note that the first instance of this error, occurred the day after the first instance of the other integrity error)