\\\125122.172 | ERROR | prefect.server - Encountered exception in request: Traceback (most recent call last): File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute cursor.execute(statement, parameters) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 113, in execute self._adapt_connection._handle_exception(error) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 263, in _handle_exception raise error File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 95, in execute self.await_(_cursor.execute(operation, parameters)) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 125, in await_only return current.driver.switch(awaitable) # type: ignore[no-any-return] File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 185, in greenlet_spawn value = await result File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\cursor.py", line 48, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute return await self._conn._execute(fn, *args, **kwargs) File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\core.py", line 133, in _execute return await future File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\core.py", line 106, in run result = function() sqlite3.OperationalError: no such table: json_each The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\middleware\errors.py", line 162, in call await self.app(scope, receive, _send) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\middleware\gzip.py", line 24, in call await responder(scope, receive, send) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\middleware\gzip.py", line 44, in call await self.app(scope, receive, self.send_with_gzip) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\middleware\exceptions.py", line 79, in call raise exc File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\middleware\exceptions.py", line 68, in call await self.app(scope, receive, sender) File "C:\GitHub\PACC\prefect_env\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 20, in call raise e File "C:\GitHub\PACC\prefect_env\lib\site-packages\fastapi\middleware\asyncexitstack.py", line 17, in call await self.app(scope, receive, send) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\routing.py", line 718, in call await route.handle(scope, receive, send) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\routing.py", line 276, in handle await self.app(scope, receive, send) File "C:\GitHub\PACC\prefect_env\lib\site-packages\starlette\routing.py", line 66, in app response = await func(request) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\utilities\server.py", line 103, in handle_response_scoped_depends response = await default_handler(request) File "C:\GitHub\PACC\prefect_env\lib\site-packages\fastapi\routing.py", line 273, in app raw_response = await run_endpoint_function( File "C:\GitHub\PACC\prefect_env\lib\site-packages\fastapi\routing.py", line 190, in run_endpoint_function return await dependant.call(**values) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\api\flow_runs.py", line 62, in create_flow_run model = await models.flow_runs.create_flow_run( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\database\dependencies.py", line 119, in async_wrapper return await fn(*args, **kwargs) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\models\flow_runs.py", line 105, in create_flow_run await models.flow_runs.set_flow_run_state( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\models\flow_runs.py", line 517, in set_flow_run_state await models.flow_run_notification_policies.queue_flow_run_notifications( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\database\dependencies.py", line 119, in async_wrapper return await fn(*args, **kwargs) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\models\flow_run_notification_policies.py", line 172, in queue_flow_run_notifications await db.queries.queue_flow_run_notifications( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\server\database\query_components.py", line 146, in queue_flow_run_notifications await session.execute(stmt) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\ext\asyncio\session.py", line 454, in execute result = await greenlet_spawn( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 190, in greenlet_spawn result = context.throw(*sys.exc_info()) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\orm\session.py", line 2262, in execute return self._execute_internal( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\orm\session.py", line 2144, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\orm\bulk_persistence.py", line 1276, in orm_execute_statement result = conn.execute( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1412, in execute return meth( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\sql\elements.py", line 515, in _execute_on_connection return connection._execute_clauseelement( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1635, in _execute_clauseelement ret = self._execute_context( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1844, in _execute_context return self._exec_single_context( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1984, in _exec_single_context self._handle_dbapi_exception( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 2339, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\engine\default.py", line 921, in do_execute cursor.execute(statement, parameters) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 113, in execute self._adapt_connection._handle_exception(error) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 263, in _handle_exception raise error File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\dialects\sqlite\aiosqlite.py", line 95, in execute self.await_(_cursor.execute(operation, parameters)) File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 125, in await_only return current.driver.switch(awaitable) # type: ignore[no-any-return] File "C:\GitHub\PACC\prefect_env\lib\site-packages\sqlalchemy\util\_concurrency_py3k.py", line 185, in greenlet_spawn value = await result File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\cursor.py", line 48, in execute await self._execute(self._cursor.execute, sql, parameters) File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute return await self._conn._execute(fn, *args, **kwargs) File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\core.py", line 133, in _execute return await future File "C:\GitHub\PACC\prefect_env\lib\site-packages\aiosqlite\core.py", line 106, in run result = function() sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: json_each [SQL: INSERT INTO flow_run_notification_queue (flow_run_notification_policy_id, flow_run_state_id) SELECT flow_run_notification_policy.id, CAST(:param_1 AS CHAR(36)) AS anon_1 FROM flow_run_notification_policy WHERE flow_run_notification_policy.is_active IS 1 AND (flow_run_notification_policy.state_names = :state_names_1 OR EXISTS (SELECT 1 FROM json_each(flow_run_notification_policy.state_names) AS json_each WHERE json_each.value IN (:json_each_values_1_1))) AND (flow_run_notification_policy.tags = :tags_1 OR EXISTS (SELECT 1 FROM json_each(flow_run_notification_policy.tags) AS json_each WHERE json_each.value IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1)))] [parameters: {'param_1': 'a66a3fba-36b8-4898-8fc8-09e8f55d381e', 'state_names_1': '[]', 'tags_1': '[]', 'json_each_values_1_1': 'Pending'}] (Background on this error at: https://sqlalche.me/e/20/e3q8) Traceback (most recent call last): File "flowtest.py", line 10, in <module> test_flow() File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\flows.py", line 540, in call return enter_flow_run_engine_from_flow_call( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\engine.py", line 272, in enter_flow_run_engine_from_flow_call retval = from_sync.wait_for_call_in_loop_thread( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\_internal\concurrency\api.py", line 243, in wait_for_call_in_loop_thread return call.result() File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\_internal\concurrency\calls.py", line 283, in result return self.future.result(timeout=timeout) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\_internal\concurrency\calls.py", line 169, in result return self.__get_result() File "C:\Python38\lib\concurrent\futures\_base.py", line 389, in __get_result raise self._exception File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\_internal\concurrency\calls.py", line 346, in _run_async result = await coro File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\client\utilities.py", line 51, in with_injected_client return await fn(*args, **kwargs) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\engine.py", line 338, in create_then_begin_flow_run flow_run = await client.create_flow_run( File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\client\orchestration.py", line 596, in create_flow_run response = await self._client.post("/flow_runs/", json=flow_run_create_json) File "C:\GitHub\PACC\prefect_env\lib\site-packages\httpx\_client.py", line 1848, in post return await self.request( File "C:\GitHub\PACC\prefect_env\lib\site-packages\httpx\_client.py", line 1530, in request return await self.send(request, auth=auth, follow_redirects=follow_redirects) File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\client\base.py", line 280, in send response.raise_for_status() File "C:\GitHub\PACC\prefect_env\lib\site-packages\prefect\client\base.py", line 138, in raise_for_status raise PrefectHTTPStatusError.from_httpx_error(exc) from exc.cause prefect.exceptions.PrefectHTTPStatusError: Server error '500 Internal Server Error' for url 'http://ephemeral-prefect/api/flow_runs/' Response: {'exception_message': 'Internal Server Error'} For more information check: https://httpstatuses.com/500\\\

just like old times haha