@Marvin i have the prefect server running on a vm wnever i deploy a flow this error happens
sudo journalctl -xeu prefect-server.service
Dec 11 17
3423 container-apps prefect[162006]: await self.middleware_stack(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 186, in
call
Dec 11 17
3423 container-apps prefect[162006]: raise exc
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/errors.py", line 164, in
call
Dec 11 17
3423 container-apps prefect[162006]: await
self.app(scope, receive, _send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/gzip.py", line 29, in
call
Dec 11 17
3423 container-apps prefect[162006]: await responder(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/gzip.py", line 130, in
call
Dec 11 17
3423 container-apps prefect[162006]: await super().__call__(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/gzip.py", line 46, in
call
Dec 11 17
3423 container-apps prefect[162006]: await
self.app(scope, receive, self.send_with_compression)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 63, in
call
Dec 11 17
3423 container-apps prefect[162006]: await wrap_app_handling_exceptions(
self.app, conn)(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
Dec 11 17
3423 container-apps prefect[162006]: raise exc
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
Dec 11 17
3423 container-apps prefect[162006]: await app(scope, receive, sender)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in
call
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/routing.py", line 716, in
call
Dec 11 17
3423 container-apps prefect[162006]: await self.middleware_stack(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/routing.py", line 736, in app
Dec 11 17
3423 container-apps prefect[162006]: await route.handle(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/routing.py", line 290, in handle
Dec 11 17
3423 container-apps prefect[162006]: await
self.app(scope, receive, send)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/fastapi/routing.py", line 124, in app
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
Dec 11 17
3423 container-apps prefect[162006]: raise exc
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
Dec 11 17
3423 container-apps prefect[162006]: await app(scope, receive, sender)
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/fastapi/routing.py", line 110, in app
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/prefect/server/utilities/server.py", line 50, in handle_response_scoped_depends
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/fastapi/routing.py", line 390, in app
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/fastapi/routing.py", line 289, in run_endpoint_function
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/prefect/server/api/workers.py", line 403, in get_scheduled_flow_runs
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/prefect/server/models/workers.py", line 324, in get_scheduled_flow_runs
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/prefect/server/database/query_components.py", line 270, in get_scheduled_flow_runs_from_work_pool
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/jinja2/environment.py", line 1016, in get_template
Dec 11 17
3423 container-apps prefect[162006]: return self._load_template(name, globals)
Dec 11 17
3423 container-apps prefect[162006]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/jinja2/environment.py", line 975, in _load_template
Dec 11 17
3423 container-apps prefect[162006]: template = self.loader.load(self, name, self.make_globals(globals))
Dec 11 17
3423 container-apps prefect[162006]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/jinja2/loaders.py", line 126, in load
Dec 11 17
3423 container-apps prefect[162006]: source, filename, uptodate = self.get_source(environment, name)
Dec 11 17
3423 container-apps prefect[162006]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Dec 11 17
3423 container-apps prefect[162006]: File "/home/aspire/prefect-venv/lib/python3.11/site-packages/jinja2/loaders.py", line 380, in get_source
Dec 11 17
3423 container-apps prefect[162006]: raise TemplateNotFound(template)
Dec 11 17
3423 container-apps prefect[162006]: jinja2.exceptions.TemplateNotFound: postgres/get-runs-from-worker-queues.sql.jinja