Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UnixODBC connection pool does not release idle connections #204

Open
AlanChao2025 opened this issue Jan 21, 2025 · 2 comments
Open

UnixODBC connection pool does not release idle connections #204

AlanChao2025 opened this issue Jan 21, 2025 · 2 comments

Comments

@AlanChao2025
Copy link

I have set the connection pooling CPTimeout to 60 seconds in unixODBC, but after a connection has been idle for more than 60 seconds, it's not being released. Why is this happening?

I am using ODBC Driver 18 for SQL Server, unixODBC 2.3.11, and the operating system is AlmaLinux 9.4.

/etc/odbcinst.ini:
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.2.so.2.1
UsageCount=1
CPTimeout=60

[ODBC]
Pooling=Yes
PoolMaxSize=15
PoolWaitTimeout=30

@lurcher
Copy link
Owner

lurcher commented Jan 21, 2025

Can you see if 2.3.12 or even better 2.3.13pre (or the current code in git) does the same?

@AlanChao2025
Copy link
Author

AlanChao2025 commented Feb 5, 2025

Can you see if 2.3.12 or even better 2.3.13pre (or the current code in git) does the same?

How should I properly close idle connections in a connection pool?
I keep seeing idle connections appear in the file descriptors.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants