Using async CRUD service (Prisma) doesn't work with other async hosted service

[MateoSaezMata]

Question

Hi everyone

I'm facing some issues while making CRUD operations.

I'm using prisma python client to perform the CRUD operations

Prisma provides some client API to perform this operations which implements the connect and disconnect awaitable methods.

Before starting the service (ui.run) I'm registering the connect method at app.on_startup and the disconnect method at app.on_shutdown.

Everything is fine until the hot reload comes into place.
I'm not succeeding finding information about on_startup and on_shutdown behavior when the hot reload resets the service.

Minimal example:

This would be one entity at the database

erDiagram
sometable {
        id int PK
        info varchar
    }

Loading

And code:

from prisma import Prisma
from nicegui import ui

db = Prisma()

@ui.page('/')
async def root():
    response = await db.sometable.find_many()
    for r in response:
        ui.label(r.info)

if __name__ in {'__main__', '__mp_main__'}:
    app.on_startup(db.connect)
    app.on_shutdown(db.disconnect)
    ui.run()

The logs:

# First start
NiceGUI ready to go on http://localhost:8080, http://172.17.0.1:8080, http://172.18.0.1:8080, and http://172.26.243.32:8080
# Adding blank space
WARNING:  WatchFiles detected changes in 'webapp/webapp/__main__.py'. Reloading...
NiceGUI ready to go on http://localhost:8080, http://172.17.0.1:8080, http://172.18.0.1:8080, and http://172.26.243.32:8080
# Errors
All connection attempts failed
.
.
.
httpcore.ConnectError: All connection attempts failed
The above exception was the direct cause of the following exception:
.
.
.
httpx.ConnectError: All connection attempts failed
ERROR:    Exception in ASGI application

So apart from this errors the connection is performed well so I can retrieve the data with no problem
I think the disconnect method isn't triggered due the idle connections at the PostgresSQL server.

Problably I shouldn't implement the connectand disconnect methods at on_startup and on_shutdown although it comes very handy to perform queries at top level.

Any help would be apreciated

[MateoSaezMata]

I think this is not NiceGUI hot reload related issue
I found this (prisma/httpx related) RobertCraigie/prisma-client-py#872