https://prefect.io logo
Title
r

Richard Alexander

12/16/2022, 3:13 PM
I upgraded Prefect from 2.6.5 to 2.7.2 this morning and now many (or maybe all) of our flows are failing. We have a local Prefect instance running flows locally, not connected to Prefect cloud. I logged an issue here which explains the details with error logs: https://github.com/PrefectHQ/prefect/issues/7922 This is our production server, so any clues on how to get us back online quickly would be much appreciated! Thanks for the great software and for the help!
āœ… 1
r

Ryan Peden

12/16/2022, 3:27 PM
Hi Richard - rolling the database back should be possible if you want to go back to 2.6.5 for now. Since it is your production database I advise making sure you have backups as a precaution, though I don't expect any issues. You should be able to roll back to 2.6.5 by running:
prefect orion database downgrade -r 3ced59d8806b
See this thread for additional details.
j

Jeff Hale

12/16/2022, 3:30 PM
Thank you for raising. The PR fix is open and we expect to release 2.7.3 soon.
r

Richard Alexander

12/16/2022, 4:04 PM
@Ryan Peden thanks so much! Downgrading the database workd perfectly... I just didn't know how to do it. You saved the day! šŸ˜„
šŸ™Œ 1
r

Ryan Peden

12/16/2022, 4:06 PM
Glad to hear it helped šŸ™‚
r

Richard Alexander

12/16/2022, 4:08 PM
@Jeff Hale so is my flow name the underlying issue? Is that why my issue is related to the refenced PR?
@Ryan Peden sorry to bother you again, but I'm trying to understand the downgrade process just in case I need to perform it again in the future. I'm unclear on how you found the proper revision to send me. I did the following: • Went to the reference thread • Went to the postgres revisions page on github: https://github.com/PrefectHQ/prefect/tree/2.6.4/src/prefect/orion/database/migrations/versions/postgresql • I see that the revision ID is listed both inside the files, and within the filename But I can't find the revision ID that you sent. How did you determine the correct revision for my specific case of downgrading to 2.6.5?
r

Ryan Peden

12/16/2022, 4:30 PM
and then went down to the bottom to find the newest migration
j

Jeff Hale

12/16/2022, 4:31 PM
re: flow name: yes, there was a bug with parsing function and flow names.
r

Richard Alexander

12/16/2022, 4:32 PM
Ah! Perfect, thank you. I didn't notice it was on the wrong branch. :-)