https://prefect.io logo
Title
m

Malinkin Sergey

02/10/2023, 7:37 AM
Hello, Today tryed update to 2.8.0 and got alembic error:
alembic.script.revision.MultipleHeads: Multiple heads are present for given argument 'head'; 898a4c563127, cfdfec5d7557
alembic.util.exc.CommandError: Multiple head revisions are present for given argument 'head'; please specify a specific target revision, '<branchname>@head' to narrow to a specific head, or 'heads' for all heads
Anyone have an idea how to fix it?
t

Tolga Karahan

02/10/2023, 8:26 AM
Hello Sergey. It seems there are two records in alembic_version table which should be one record pointing out to the head revision.
m

Malinkin Sergey

02/10/2023, 8:35 AM
Yeap, but i don't know how fix it, and why i have two value. We create fresh setup on 2.7.12 and after make this issue. And since it is fixed, we decided to update immediately
d

Dustin Ngo

02/10/2023, 4:07 PM
Hi @Malinkin Sergey the revision
898a4c563127
doesn't appear to exist in our repo. Is it possible you might have attempted to run a migration you found in a branch that never made it to
main
?
m

Malinkin Sergey

02/10/2023, 5:34 PM
Hello, @Dustin Ngo Maybe. Previously we had a problem with the DB just in the process of migration. As a result, we decided to recreate the base, but stay in the same environment. Can we fix it without reinstall/recreate db?
d

Dustin Ngo

02/10/2023, 5:36 PM
You'll probably need to find whatever code generated this revision number. You can then manually downgrade that specific revision, stamp your database with a "canonical" revision, then upgrade