sqlalchemy / sqlalchemy

The Database Toolkit for Python
https://www.sqlalchemy.org
MIT License
8.97k stars 1.35k forks source link

Unable to close a connection #11282

Closed rshunim closed 1 month ago

rshunim commented 1 month ago

Describe the bug

when using the method .close() in my code (on sqlalchemy.engine.base.Connection object), and then checking the connections in the container, I still see the connection.

image

Is there a problem with this method?

Optional link from https://docs.sqlalchemy.org which documents the behavior that is expected

No response

SQLAlchemy Version in Use

20.0.29

DBAPI (i.e. the database driver)

pyodbc

Database Vendor and Major Version

Teradata

Python Version

3.10

Operating system

Linux

To Reproduce

# sqlalchemy.engine.base.Connection - Object
client.connection.close()
# after closing still see the connection in the container

Error

There is no error

Additional context

No response