79652103

Date: 2025-06-04 03:52:37
Score: 0.5
Natty:
Report link

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
 
Reasons:
  • RegEx Blacklisted phrase (1): i am getting this error
  • Long answer (-1):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Kishore Kumar