[JRASERVER-74397] Issue search may cause a high CPU utilization in the database - Create and track feature requests for Atlassian products.

We couldn't load the project sidebar. Refresh the page to try again.
If the problem persists, contact your Jira admin.

Type: Bug
Resolution: Unresolved
Priority: Low (View bug fix roadmap)
Fix Version/s: None
Affects Version/s: 8.13.22
Component/s: Data Center - Archiving, Project - Issues
Labels:
- database-index
- pse-request

Introduced in Version:
8.13
Support reference count:
4
Symptom Severity:
Severity 3 - Minor
UIS:
0
Bug Fix Policy:
View Atlassian Server bug fix policy

Issue Summary

A manual search of all issues in active projects can sometimes causes a high CPU utilization in the database.

Details

The query below seems to be the most active and expensive one in the database:

SELECT COUNT(I.ID) FROM public.jiraissue I WHERE I.PROJECT=$1

Workaround

A workaround will be added when it's available.

relates to

JRASERVER-71567 Archived Issues page automatically performs a count from all active projects

Closed

Form Name

There are no comments yet on this issue.

Assignee:: Unassigned

Reporter:: Alp

Affected customers:: 1 This affects my team

Watchers:: 3 Start watching this issue

Created:: 13/Oct/2022 3:42 PM

Updated:: 21/Dec/2024 4:11 AM