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)"
}
}