Jira data center database connections pool rise up with query on O_S_PROPERTY_ENTRY table

Question

Hi everybody,

We have a Jira Data Center 7.9.2 (3 nodes, each node has 32-core CPU, 30G RAM) and they are installed on CentOS 7. They are configured with Oracle database on same network (local network)

The amount of JVM is 6G on each instance. We have a Nginx as a load balancer.

Also some add-ons installed on Jira such as : jira service desk, structure, power script, script runner , … .

Our problem:

In middle of the day suddenly database connections pool rise up (on all three nodes) and then CPU usage rises up to 100%. Database connections don’t decrease and I must restart Jira.

We have this query on database:

SELECT  O_S_PROPERTY_ENTRY.property_key,

O_S_PROPERTY_ENTRY.propertytype

FROM    propertyentry O_S_PROPERTY_ENTRY

WHERE   O_S_PROPERTY_ENTRY.entity_name   = :1

AND O_S_PROPERTY_ENTRY.entity_id = :2

ORDER BY O_S_PROPERTY_ENTRY.id DESC

Is there any solution about my issue?

Hamid Gholami · Answer

Thank you @Andrew @Andy Heinzer

Our problem was this plugin: "In-App & Desktop Notifications for Jira".

That is really awful plugin. There was many SQL DB errors in its log file.

We removed it and now Jira Data Center works fine.

Best Regards,

Andrew_g4chs4 · Answer

Hi @Hamid Gholami ,

I suppose for plugins it is only deactivate all and them turn on one by one.

B.R.

Hamid Gholami · Answer

Hi @Andrew

thank you for your response. I saw that issue, but our problem is rise up database connection pool without any certain reason.

I checked JIRA log file but couldn't find any error or unusual log about that.

how can I check what happen when database connection pool rise up or how can I find which process or which plugin take many session?

Best regards,