https://prefect.io logo
i

iñigo

07/18/2023, 10:30 AM
Hello Prefect Community, I've done an upgrade to my prefect server and when I am trying to start the server I am having an alembic issue. Prefect is installed over linux and the db is in a docker postgres. I've installed the latest version of prefect 2.10.21. the issue when i start the server:
Copy code
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
1
b

Bianca Hoch

07/18/2023, 4:32 PM
Hi Inigo, This looks like an alembic issue. What version did you upgrade from?
i

iñigo

07/18/2023, 4:33 PM
from 2.8.3
b

Bianca Hoch

07/18/2023, 4:38 PM
Gotcha. Is that the full stack trace of the error?
i

iñigo

07/18/2023, 4:38 PM
no, that's the last part of the error...
b

Bianca Hoch

07/18/2023, 4:39 PM
Would you mind sharing the rest? Curious to see if there's any other info that may help with troubleshooting.
i

iñigo

07/18/2023, 5:18 PM
in fact I'm not able to retreive it because I have restarted all... as I could not wait.. It wasn't so hard to restart all as I have for every object (deployment, secret, string) in python scripts
b

Bianca Hoch

07/18/2023, 5:19 PM
When you say you've restarted, is it that you've done a fresh instillation and setup a new db?
Did the problem resolve itself?
i

iñigo

07/18/2023, 5:19 PM
yes, I've recreated the postgres volume and docker
but I had to remove a py file inside of prefect/migrations or something like that
"/.local/lib/python3.9/site-packages/prefect/server/database/migrations/versions/postgresql/2023_02_27_094322_b34d8de0721a_.py I had to remove this file
b

Bianca Hoch

07/18/2023, 5:21 PM
Interesting! Thanks for sharing the details here. It'll be helpful in case someone else runs into a similar issue.
i

iñigo

07/18/2023, 5:21 PM
yes, in fact after that I think that could have solved the problem.
🚀 1
1
As I tried to update the DB and I couldn.t