Hi I'm Trying to connect my postgress on Azure but after deploying i am getting this error
eventhough i have already installed the requirements over there
# Database clients
psycopg2-binary==2.9.10
asyncpg==0.30.0
requests
SQLAlchemy==2.0.41
pydantic==1.10.13
Exception while executing function: Functions.DbHealthCheck Result: Failure
Exception: ModuleNotFoundError: No module named 'asyncpg.protocol.protocol'
Stack: File "/azure-functions-host/workers/python/3.11/LINUX/X64/azure_functions_worker/dispatcher.py", line 674, in _handle__invocation_request
await self._run_async_func(fi_context, fi.func, args)
File "/azure-functions-host/workers/python/3.11/LINUX/X64/azure_functions_worker/dispatcher.py", line 1012, in _run_async_func
return await ExtensionManager.get_async_invocation_wrapper(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/azure-functions-host/workers/python/3.11/LINUX/X64/azure_functions_worker/extension.py", line 143, in get_async_invocation_wrapper
result = await function(**args)
^^^^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/function_app.py", line 115, in db_health
engine = get_async_engine()
^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/function_app.py", line 94, in get_async_engine
return create_async_engine(connection_string, echo=True)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/.python_packages/lib/site-packages/sqlalchemy/ext/asyncio/engine.py", line 120, in create_async_engine
sync_engine = _create_engine(url, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in create_engine
File "/home/site/wwwroot/.python_packages/lib/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
return fn(*args, **kwargs) # type: ignore[no-any-return]
^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/.python_packages/lib/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
dbapi = dbapi_meth(**dbapi_args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/.python_packages/lib/site-packages/sqlalchemy/dialects/postgresql/asyncpg.py", line 1100, in import_dbapi
return AsyncAdapt_asyncpg_dbapi(__import__("asyncpg"))
^^^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/.python_packages/lib/site-packages/asyncpg/__init__.py", line 9, in <module>
from .connection import connect, Connection # NOQA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/site/wwwroot/.python_packages/lib/site-packages/asyncpg/connection.py", line 25, in <module>
from . import connect_utils
File "/home/site/wwwroot/.python_packages/lib/site-packages/asyncpg/connect_utils.py", line 30, in <module>
from . import protocol
File "/home/site/wwwroot/.python_packages/lib/site-packages/asyncpg/protocol/__init__.py", line 11, in <module>
from .protocol import Protocol, Record, NO_TIMEOUT, BUILTIN_TYPE_NAME_MAP