All Apps and Add-ons

DBConnect randomly loses connection to MySql database, looking for troubleshooting ideas

briancronrath
Contributor

I'm on DBConnect version 2.4.1

Several other databases maintain connection through the app fine but one particular MySql database intermittently just seems to stop responding long enough that the 30 second timeout is hit. The queries I run normally do not take more than a second or two to finish, but several times throughout the day, dbconnect will hang when running a query and fail out with Exception(' java.sql.SQLTransientConnectionException: - Connection is not available, request timed out after 30000ms..',). "

When this starts to happen, I can't even validate the connection through the db app, if I open it in the explorer tab it will hang on validating and throw the same exact error message. I then have to come away for a while and come back when it randomly decides to start working again.

This database does not have any other reads or writes from any other sources occurring during the timeframe, the only other entity that uses this database is an app I have direct control over and I have it purposely not running any loads while I test out integrating the db with Splunk. I'm also running nothing scheduled through splunk in regards to this db, these are only single very simple ad hoc queries I am running, that take a second to return when things are "good".

In these times where splunk db connect has troubles, I have tested running the exact same queries through my own client, remotely from the searchheads, and they have no issue at all returning the queries within a second. Something specifically about the way dbconnect handles connection appears to be the issue but I cannot for the life of me figure out what. I've looked through https://docs.splunk.com/Documentation/Splunk/7.2.5/admin/Configureusertimeouts and this didn't really help me either.

I am kind of at the end of what I know to troubleshoot with this, I never have issues accessing this database through my app or through mysql clients, only through splunk do I ever seem to have issues. What else could I look into?

0 Karma

sryedudo
Loves-to-Learn Lots

briancronrath:

Did you find the root cause for this issue ? I am also running into same issue with one of the DB input. Appreciate your response on this.

0 Karma

gibranduatiga
New Member

not trying to upgrade app?

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 ...