Hi all! I have a pretty basic prefect install, whe...
# ask-community
a
Hi all! I have a pretty basic prefect install, where I’ve installed via poetry, run
prefect server start --port 4201
and run
prefect config set PREFECT_API_URL=<http://127.0.0.1/4201/api>
. I then have run
prefect agent start --pool default-agent-pool
. Then I’ve built a scheduled deployment with
build_from_flow
and applied that. When I go to the UI, I can see the deployment, and it runs successfully and I can see flow run history from scheduled runs. It’s been running every 4 hours successfully for the last several days. However, when I go to
~/.prefect
and open up prefect.db with sqlite3, almost all of the tables seem to be empty. Alembic_version returns the 2nd latest revision. But,
select *
from flow, deployment, flow_run, etc all return nothing. When I do
prefect deployment ls
I get a table with the header row but 0 actual rows. So, I’m a bit confused as to why things seem to working in the UI but the db is empty (as I would have thought the UI was pulling from that db). I want to make sure everything is set up correctly before I go any further!
For the CLI commands I just needed to specify the env var in local commands since my local session doesn’t have them, whereas the API server process does (e.g.
PREFECT_API_URL=.. prefect deployment ls
returns the results I expected). This doesn’t help me with the empty DB problem, although could be related..