"A number of comments for issue has breached the limit of 1000" Warning

Jira Development Jira Data Center
1

Hello community,

We are encountering a warning stating:
“A number of comments for issue has breached the limit of 1000, the comment was added. Issue key: XXXX-123344, issue comments count: 9514, comment author: XXXX, logged-in user: XXXXX.”

However, for the specific issue key in question, there are only 5 comments, and the issue was closed 2 years ago.

Could anyone explain why this warning is appearing and under what conditions it occurs?

Jira version: 9.12.x

How can I resolve it?

Thank you in advance for your help!

2

Is it possible the comments are hidden/restricted? You should check the database level with a query like this (written for MSSQL, so you may have to adjust it to work for you RDBMS syntax.)

select concat(project.pkey, '-', jiraissue.issuenum) 'Issue Key'
      ,count(jiraaction.ID) 'Count'
from jiraaction
left join jiraissue on jiraissue.ID = jiraaction.issueid
left join project on project.ID = jiraissue.PROJECT
where concat(project.pkey, '-', jiraissue.issuenum) = 'XXXX-123344'
group by concat(project.pkey, '-', jiraissue.issuenum)
2 Likes
3

Thanks for your response.
The comments are not hidden or restricted.
We are seeing this warning in the logs. We recently upgraded to Jira 9.12 and activated the safeguard.