Hello Prefect Community,
I've done an upgrade to m...
# ask-communityi
iñigo
07/18/2023, 10:30 AMHello 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 PMHi Inigo, This looks like an alembic issue. What version did you upgrade from?
i
iñigo
07/18/2023, 4:33 PMfrom 2.8.3
b
Bianca Hoch
07/18/2023, 4:38 PMGotcha. Is that the full stack trace of the error?
i
iñigo
07/18/2023, 4:38 PMno, that's the last part of the error...
b
Bianca Hoch
07/18/2023, 4:39 PMWould 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 PMin 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 PMWhen you say you've restarted, is it that you've done a fresh instillation and setup a new db?
Bianca Hoch
07/18/2023, 5:19 PMDid the problem resolve itself?
i
iñigo
07/18/2023, 5:19 PMyes, I've recreated the postgres volume and docker
iñigo
07/18/2023, 5:20 PMbut I had to remove a py file inside of prefect/migrations or something like that
iñigo
07/18/2023, 5:20 PM"/.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 PMInteresting! 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 PMyes, in fact after that I think that could have solved the problem.
🚀 1
✨ 1
iñigo
07/18/2023, 5:22 PMAs I tried to update the DB and I couldn.t
2 Views