SELECT ID, notificationtype, SOURCE, emailaddress, MESSAGEID FROM jiraschema.notificationinstance WHERE MESSAGEID= @P0
We located in our server that this Jira script runs 35,000 to 50,000 per minute!
Does anyone know why that happens and/or if it's the reason we are having performance issues in our Jira Server instance?
This is almost certainly mail related, but there's no obvious place to look in mail.
I would check the mail queues, then look at the application and mail logs to see if whatever this is is logging anything there (they are in <jira home>/logs).
Also, try turning up the logging in "profiling and logging" to see if that can gve you more information on it.
I would also want to try restarting Jira with mail turned off with the disable flag, to see if it goes away and where. See step 1 in https://confluence.atlassian.com/adminjiraserver/restoring-data-from-an-xml-backup-938847707.html for how to disable various systems . If the problem stops with every flag disabled, then re-enable them one at a time until it comes back, that will narrow down where it is.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event