It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

An issue with a spammy script

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?

1 answer

0 votes

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you