Can't migrate or upgrade database with Flask-Migrate (Alembic)
Alembic stores the db version in a table it creates called alembic_version
. This table contains a single field and row alembic_version.version_num
. Make sure the value for this matches the filename of the most recent file in migrations/version
. This version number is also contained inside the revision file in the revision
variable that generally shows up on line 26 of the file. Make sure it matches the db version.
Another option is to simply drop the db and recreate it using alembic. If this is a development environment, where the data is not important, that would be my recommendation.
I feel like the accepted answer is a little over-complicated. I had this same issue and the way that I solved it was to simply delete the migration that contained the coding errors. You don't need it anyways since, again, it was coded incorrectly. Find the latest migration in the migrations/versions
folder, delete it, then run your migration again and upgrade. You don't need to delete the data in your database just to migrate it.
alembic.util.CommandError: Target database is not up to date.
Could you try following steps?
python manage.py db stamp head
python manage.py db migrate
python manage.py db upgrade
'stamp' the revision table with the given revision; don't run any migrations