JIRA stuck with DB connection pool limit

Nexign Team April 15, 2020

Hi!

We have a frequent problem with JIRA. It stucks with a lot of DB Connections. There is a lot of sql queries like

 

select O_S_PROPERTY_ENTRY.id, O_S_PROPERTY_ENTRY.propertytype

from dbo.propertyentry O_S_PROPERTY_ENTRY

with (updlock)

where O_S_PROPERTY_ENTRY.entity_name = @P0 and O_S_PROPERTY_ENTRY.entity_id = @P1 and O_S_PROPERTY_ENTRY.property_key = @P2

order by O_S_PROPERTY_ENTRY.id desc

 

On Zabbix I can see that jira uses all connections from pool (120)

Restart helps but Error may occure at any time.

DB MS SQL

1 answer

0 votes
Nexign Team April 15, 2020

We are planning to add indexes to this table

https://jira.atlassian.com/browse/JRASERVER-65168

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.6.9
TAGS
AUG Leaders

Atlassian Community Events