An issue with a spammy script

[Viva Bot]

Hello,

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?

[Nic Brough -Adaptavist-]

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.