<@ULVA73B9P> Your message was too long by 652 toke...
# marvin-in-the-wilds
seto
09/05/2024, 5:21 PM@Marvin Your message was too long by 652 tokens - please shorten it and try again.
For reference, here's your message at the allowed limit: i got error when migrate from sqlite postgres, the error is below.. What happened
Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 677, in lifespan async with self.lifespan_context(app) as maybe_state: File "/usr/local/lib/python3.11/contextlib.py", line 204, in aenter return await anext(self.gen) ^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 519, in lifespan await run_migrations() File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 442, in run_migrations await db.create_db() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 56, in create_db await self.run_migrations_upgrade() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 64, in run_migrations_upgrade await run_sync_in_worker_thread(alembic_upgrade) File "/usr/local/lib/python3.11/site-packages/prefect/utilities/asyncutils.py", line 91, in run_sync_in_worker_thread return await anyio.to_thread.run_sync( ^^^^^^^^^^^^^^^^^
m
Marvin
09/05/2024, 5:21 PMYour message was too long by 33 tokens - please shorten it and try again.
For reference, here's your message at the allowed limit:
Your message was too long by 652 tokens - please shorten it and try again.
For reference, here's your message at the allowed limit: i got error when migrate from sqlite postgres, the error is below.. What happened
Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 677, in lifespan async with self.lifespan_context(app) as maybe_state: File "/usr/local/lib/python3.11/contextlib.py", line 204, in aenter return await anext(self.gen) ^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 519, in lifespan await run_migrations() File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 442, in run_migrations await db.create_db() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 56, in create_db await self.run_migrations_upgrade() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 64, in run_migrations_upgrade await run_sync_in_worker_thread(alembic_upgrade) File "/usr/local/lib/python3.11/site-packages/pref
s
seto
09/05/2024, 5:22 PM@Marvin Your message was too long by 652 tokens - please shorten it and try again.
For reference, here's your message at the allowed limit: i got error when migrate from sqlite postgres, the error is below.. What happened
Traceback (most recent call last): File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 677, in lifespan async with self.lifespan_context(app) as maybe_state: File "/usr/local/lib/python3.11/contextlib.py", line 204, in aenter return await anext(self.gen) ^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 519, in lifespan await run_migrations() File "/usr/local/lib/python3.11/site-packages/prefect/server/api/server.py", line 442, in run_migrations await db.create_db() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 56, in create_db await self.run_migrations_upgrade() File "/usr/local/lib/python3.11/site-packages/prefect/server/database/interface.py", line 64, in run_migrations_upgrade await run_sync_in_worker_thread(alembic_upgrade)
m
Marvin
09/05/2024, 5:22 PMOh joy, another migration issue. You tried moving from SQLite to Postgres and received a cascade of errors involving
run_migrationss
seto
09/05/2024, 5:22 PMVersion 3
seto
09/05/2024, 5:23 PM@Marvin version 3 ya
m
Marvin
09/05/2024, 5:23 PMGot it. What version of Prefect are you using?
Marvin
09/05/2024, 5:23 PMWell, this looks like a real joy. Here are the crucial points for your migration woes:
1. Connection URL: Ensure you're setting
PREFECT_API_DATABASE_CONNECTION_URLprefect server startprefect server database upgrade -yprefect server database downgrade -yprefect server database revision --autogenerate -m "<migration name>"