Error registering DbHealthProvider using SQLAlchemy AsyncEngine

[angelgonzalbez]

I'm trying to register a DbHealthProvider using an async connection, but I'm getting status DOWN with the following message:

"db": { "status": "DOWN", "details": { "engine": "postgresql", "failure": "'AsyncConnection' object does not support the context manager protocol" } }

I tried passing my_engine.sync_engine, but I'm encountering this error:

"db": { "status": "DOWN", "details": { "engine": "postgresql", "failure": "greenlet_spawn has not been called; can't call await_only() here. Was IO attempted in an unexpected place? (Background on this error at: https://sqlalche.me/e/20/xd2s)" } }