All Apps and Add-ons

Splunk DB Connect 2: Why am I getting error "Cannot get a connection, pool error Timeout waiting for idle object"?

guimilare
Communicator

Hello Splunkers.

I have 2 connections with a Microsoft DB using Splunk DB Connect 2.
For some time, everything was OK, but all of sudden Splunk stopped indexing new data.
Looking at _internal, I saw these following errors:

01/04/2016 17:19:44 [ERROR] [websocket.py] ERROR: java.sql.SQLException: java.sql.SQLException:java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object.

01/04/2016 17:19:44 [ERROR] [ws.py] [DBInput Service] Exception encountered from server on_message for entity-name = mi_input://Input_PT and type = input with error = ERROR: java.sql.SQLException: java.sql.SQLException:java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object.

I've read that maybe DB Connect 1 could solve this issue.
Have anyone seen this before?

Thanks in advance

1 Solution

heath
Path Finder

I had the same issue. Increasing maxTotalConn from 16 to 100 seems to have fixed it so far.

In splunk_app_db_connect/local/db_connection_types.conf:
[default]
maxTotalConn = 100

View solution in original post

heath
Path Finder

I had the same issue. Increasing maxTotalConn from 16 to 100 seems to have fixed it so far.

In splunk_app_db_connect/local/db_connection_types.conf:
[default]
maxTotalConn = 100

jsilverbears
Path Finder

I had the same issue but I did not have that file path mentioned. Mine was called db_connections.conf in that directory. That setting was not in there either. So I placed the setting in there but just doing that did not work. I had to restart Splunk after that; not sure if they had to but they didn't mention it.

Anyway, after putting that setting in and restarting Splunk, my connection started working again.

0 Karma

briancronrath
Contributor

jsilverbears you might wanna check under the default instead of local directory, that's where I found mine in order to resolve the issue.

0 Karma

guimilare
Communicator

Hi Heath,

Increasing maxTotalConn from 16 to 100 worked here as well!
Thanks!

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...