I am in an upgrade process for a Neos site from 2.2 to 3.0. The step 2.2 -> 2.3 went fine, all migrations succeeded. I am currently stuck in ./flow doctrine:migrate and am facing errors as such, all were errors of being unable to drop foreign keys or indexes:
An exception occurred while executing 'ALTER TABLE neos_media_domain_model_adjustment_abstractimageadjustment DROP FOREIGN KEY FK_84416FDCA76D06E6':
SQLSTATE: Syntax error or access violation: 1091 Can't DROP 'FK_84416FDCA76D06E6'; check that column/key exists
I already tried fiddling arround with adding the missing indexes and keys manually by hand but that seems not the right approach. Also fiddling with the packages migration files is definitely not the right way.
Is there any best practice of how to resolve inconsistencies of the DB?