Dave Meyer asked us to file the following suggestion regarding a new feature that was added to JIRA 7 EAP:
When our add-on (Dataplane) is running reports, JIRA regularly generates log warnings of the following format:
This new code appears to be issuing log statements whenever a single thread has more than a single database connection open. By its very nature, Dataplane needs to do this.
Is there any way to make the warning threshold adjustable by us? We recognize that the warnings are there to alert the JIRA administrator that something may be going wrong and to prevent deadlocks, but in our case, we are using multiple connections deliberately.
For example, Dataplane takes great pains to be a careful user of JIRA database connections. Although a single Dataplane thread can certainly use multiple database connections, we never query the same tables that are used in other connections, and we also maintain our own “sub-pool” of database connections to ensure that we never starve JIRA core of needed resources. (For example, Dataplane has its own internal high-water limit that prevents it from trying to use more than 1/3rd of the total JIRA dB connection pool at any time.)
Could we get some sort of plugin-wide (or even ThreadLocal) setting that allows us to configure the warning threshold to a higher value to eliminate these warnings for our deliberate use? Although I see a way to increase the connection limit by +1 through some sort of strict-mode setting, one will not always be sufficient, and we also don’t want to have to ask the user to make a JIRA properties change to make it work.