\\\12
5122.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\\\