Hello. I'm upgrading to 0.15.4 and it seems that we're receiving an error message from Alembic when...

Henry

08/27/2021, 2:10 AM

Hello. I'm upgrading to 0.15.4 and it seems that we're receiving an error message from Alembic when graphql tries to run migrations

Copy code

Could not upgrade the database!
Error: Can't load plugin: sqlalchemy.dialects:postgres

Kevin Kho

08/27/2021, 2:12 AM

Hi @Henry, haven’t seen it before but do you think this what you’re running into ?

Henry

08/27/2021, 2:15 AM

hmmm, i'm running the dockerhub image for 0.15.4 tho?

Henry

08/27/2021, 2:16 AM

Copy code

respository: "prefecthq/server"
    tag: core-0.15.4

Kevin Kho

08/27/2021, 2:16 AM

Ok i’ll have to ask some more team members tomorrow

Zanie

08/27/2021, 3:28 PM

Hey Henry, are you setting any custom environment variables / config or connection urls?

Henry

08/27/2021, 3:32 PM

i don't believe so?

Henry

08/27/2021, 3:35 PM

my mistake it looks like this stackoverflow issue was correct

Henry

08/27/2021, 3:35 PM

the

sqlalchemy.dialects:postgres

is referenced by the

postgres://

URI

Henry

08/27/2021, 3:35 PM

so using

postgresql:?/

fixes it

Zanie

08/27/2021, 3:35 PM

Yeah that is my suspicion as well

Zanie

08/27/2021, 3:36 PM

We should be setting that correctly in our images though..

Henry

08/27/2021, 3:36 PM

mind if i put in a PR to make this a little more headache free?

Henry

08/27/2021, 3:36 PM

also i noticed that the kubernetes pip package wasn't being installed for us in the image

Henry

08/27/2021, 3:36 PM

not sure if something changed?

Zanie

08/27/2021, 3:36 PM

PRs are definitely welcome

Zanie

08/27/2021, 3:37 PM

How are you starting your server? Helm? Prefect CLI?

Henry

08/27/2021, 3:39 PM

using helm

Henry

08/27/2021, 3:40 PM

we have our stuff living in k8s so we just kick it off with a chart we wrote up

Zanie

08/27/2021, 3:42 PM

In our helm chart we have

postgresql

in the connection string https://github.com/PrefectHQ/server/blob/80a960bedfa50195289895a4760cb54445a5cc9e/helm/prefect-server/templates/_helpers.tpl#L116

Henry

08/27/2021, 7:56 PM

that's great. i didn't know you guys had a helm chart now. is it more-or-less out of beta?

Henry

08/27/2021, 7:57 PM

we'll def switch over if it's stablized

Zanie

08/27/2021, 8:03 PM

It's pretty stable, I haven't had to touch it in a while.

Zanie

08/27/2021, 8:04 PM

I took the experimental tag off a bit ago. https://github.com/PrefectHQ/server/tree/master/helm/prefect-server

Open in Slack

Previous Next

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.