Hi I up prefect server in docker locally with version core 0

Question

Hi I up prefect server in docker locally with version core 0 15 2 it starts normally but the when i try to up agent got error prefect exceptions ClientError Your Prefect Server instance has no tenants Create a tenant with `prefect server create tenant` Found that if I use folder with postgres data that was created with older version of server agent up as normal Сan anybody help what happens

Denis Rogovskiy · Answer

Agent also version prefect==0 15 2

Kevin Kho · Answer

Hi < Denis Rogovskiy> I m a bit unclear here Does your server already have a tenant from the old version Was this an attempt to upgrade

Denis Rogovskiy · Answer

i run server with core14 x with one folder for postgres data then i change version to newer core 0 15 2 everything works fine Then i needed to up server agent on new empty machine and there i faced with problem that agent cant start I made some experiments like change postgres folder on first server restart server and again cant start agent Change back to pg data folder made by core14 x and it works

Kevin Kho · Answer

When you check server do you see your tenant

Denis Rogovskiy · Answer

no it is empty

Zanie · Answer

It seems likely that you ll need to run the database migrations

Zanie · Answer

For example here in the Helm chart when the GraphQL service starts up we have an init container that runs the migration command <https github com PrefectHQ server blob master helm prefect server templates graphql deployment yaml L49>

Denis Rogovskiy · Answer

looks like it make this command graphql2 hostname graphql2 image prefecthq server $ PREFECT SERVER TAG latest ports $ PREFECT SERVER GRAPHQL HOST PORT 4201 4201 command bash c $ PREFECT SERVER DB CMD amp amp python src prefect server services graphql server py and PREFECT SERVER DB CMD= prefect server database upgrade y

Zanie · Answer

`prefect server database upgrade` is the key command here

Denis Rogovskiy · Answer

graphql2 1 | graphql2 1 | Running Alembic migrations postgres2 1 | postgres2 1 | PostgreSQL Database directory appears to contain a database Skipping initialization postgres2 1 | graphql2 1 | INFO alembic runtime migration Context impl PostgresqlImpl towel2 1 | severity INFO name prefect server Scheduler message Scheduled 0 flow runs postgres2 1 | 2021 10 06 15 34 34 923 UTC 1 LOG listening on IPv4 address 0 0 0 0 port 5432 postgres2 1 | 2021 10 06 15 34 34 923 UTC 1 LOG listening on IPv6 address port 5432 graphql2 1 | INFO alembic runtime migration Will assume transactional DDL graphql2 1 | Applied Hasura metadata from prefect server services hasura migrations metadata yaml graphql2 1 | graphql2 1 | Database upgraded

Denis Rogovskiy · Answer

seems i found some errorsgraphql2 1 | INFO alembic runtime migration Running upgrade 459a61bedc9e gt a666a3f4e422 Add unique index for idempotency key postgres2 1 | CREATE DATABASE ui2 1 | 2021 10 06 15 36 33 notice 10 10 start worker processes graphql2 1 | graphql2 1 | Could not upgrade the database graphql2 1 | Error HTTPConnectionPool host= hasura2 port=3000 Max retries exceeded with url v1 query Caused by NewConnectionError lt urllib3 connection HTTPConnection object at 0x7f3c14232610 gt Failed to establish a new connection Errno 111 Connection refused i will play with host names looks like it will help