Dangerous use of multiple connections error on local database

Problem

As Git Integration for Jira Server app uses the Jira database increasingly, it is to be expected that this error will be seen or encountered more often:

2020-09-24 08:38:47,769+0200 Caesium-1-3 WARN   [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=2; marks=[1-0]; pool=18/20
java.lang.AssertionError: Explicit stack trace requested

Diagnosis

All database connections are handled internally by the Jira Active Objects (AO) library. While the Git Integration app accesses the database progressively more, the AO library will use more database connections proportional to the volume of database requests.

Solution

The default value of 20 for database connections is sufficient for small Jira instances. For larger Jira instances, this value should be tuned based on Jira load, number of users, hardware performance and other factors.

More details may be found in the following articles:

• Tuning Database Connections

• Monitoring Database Connection Usage

More articles about troubleshooting, workarounds and solutions

Why I am getting the error, “git-upload-pack not permitted”?

Avoid OutOfMemory exceptions by configuring or memory allocation with Jira to accommodate large repositories

Cannot auto-deploy some tracked repositories: Specified origin is incorrect or not supported

Connection Reset when Accessing the Database

“Dangerous use of multiple connections” error on local database (this page)

Duplicate entry 0 for key PRIMARY exceptions in log

Error while reindexing – Java heap space / Object too large, rejecting the pack

Error creating git branches and also using NFS

Fix performance issues for nested cloned repositories with enabled Git Service Permissions mode

Fixing reindex issues using Indexing Queue Viewer

Gitolite integration: Why the Git integration app not see the master branch?

Health Check: Database Collation

Indexing error – Too many open files

Installation fails when installing manually

Jira index error: IndexNotFoundException: no segments* file found

Malformed input or input contains unmappable characters

Personal access token failing Azure DevOps integration with Not Authorized error

Problems with shared home on Azure Storage

Pull request index error: org.json.JSONException

Repositories missing from Azure DevOps integration

“Service proxy has been destroyed” exceptions in log

SQLException ‘Incorrect string value’ in merge requests

SSH key file format is invalid

TFS – Not authorized exception when Jira works thru proxy

Unexpected exception parsing XML document from URL error in log

Why don’t I see the Create Branch or Pull Request features?

Your token has not been granted the required scopes

When a GIJ license expires, it shows up as a session error to the user

edDSA provider not supported WARN in logs