Migration failed upgrading to latest from ~3 weeks ago

Yes, be sure to run a db reindex

Try:

REINDEX DATABASE VERBOSE

Critical that you do so to ensure your indexes are all in good shape.