[BUG] FastAPI + Great Expectations + MSSQL (requests accumulate in sleeping status)

[IgorShcherbakov]

If you run GE in a container (Kubernetes), then after performing checks in the database you can see requests in the “suspended” status. Is it possible to forcefully close all connections to the database after performing the checks?

Example query:
SELECT sum(CASE WHEN ([PK_ID] IS NOT NULL) THEN 1 ELSE 0 END) AS [column_values.null.unexpected_count]
FROM [#gx_temp_d56615b6]

Great Expectations Version: 0.18.8

[IgorShcherbakov]

The problem is in the "run" method of the "Checkpoint" class. Resources are not released.

[IgorShcherbakov]

There is no way to terminate the GE without ending the program completely. For example, context.engine.dispose() and context.connection.close().