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
We are planning to add indexes to this table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.