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

Batch email notification not sending email

Hi,

I have upgraded my instance to JIRA Software 8.1.0 and JIRA Service Desk to 4.1.0 last week and it has been running smoothly.

This morning I activated the Batching Notification Emails feature and from that moment, no further notifications have been sent, either from JIRA or JIRA Service Desk.

 

I have in the meantime turned off the setting and notifications are being sent normally.

Is there any setting I should activate for this to work?

Thanks,

Pedro

1 answer

0 votes

Hi Pedro,

Batching notification are sent every 10 minutes because it will get as many notifications as possible during this time and group it to only one notification.
You can find more details here:

Email frequency
Every summary email will contain updates that occurred in a single issue within the last 10 minutes, including changes to any of the issue fields, comments, work logs, and attachments. For example, if 10 changes have been introduced to an issue - 8 in the first 10 minutes and 2 in the following 10, you'll receive 2 emails - one listing 8 and the other listing 2 changes.

Regards,
Angélica

Hi Angelica,

Thanks, but that info I already have. The issue I am trying to understand is if there is any other setting I should look into which might be causing notifications from being sent, totally, once the batch notification is activated?

Thanks,

Pedro

Currently, the only setting is to activate and deactivate the batching emails, there is no other option to configure.
Are the notifications taking longer than 10 minutes to be sent?

Hi Angélica,

The notifications simply stopped being sent.

I activated it around 8:40 and only after I de-activated them, around 1PM, users started receiving them again.

How can I troubleshoot this? Probably better to raise a case with support.

Cheers,

Pedro

I created a ticket with our support to check the logs for a better understanding of what is causing the batching notifications to do not being sent.
You should have received an email and soon someone will contact you.
Once it's resolved, feel free to share the resolution here to help other community members.

Hi,

I have the same issue as Pedro mentioned in Jira Server 8.2.3. Is there already a solution on this topic?

Thanks in advance!

Thomas

Hi Thomas,

I've checked the ticket where our support team is investigating and sending some tests, but it was not resolved yet.
Feel free to raise a ticket on support.atlassian.com adding more details about the issue you are facing and also if you did some test because we still don't know what is causing the issue.

Regards,
Angélica

I'm having the same issue. Batching email notifications does not work. Sending the separate emails is working fine. I did some debugging and my conclusion is that this is due to missing database tables, as I found in the jira log entries like:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'AO_733371_EVENT_RECIPIENT' doesn't exist.

I recently upgraded MariaDB to MySQL. I don't know if this is related.

Existing table:

  • AO_733371_EVENT

Tables that do not exist within the MySQL database:

  • AO_733371_EVENT_RECIPIENT
  • AO_733371_EVENT_PARAMETER

Has anyone a clue how to create these 2 missing tables? -> yes, see next reply

Andy from Atlassian pinpointed the root cause of the missing tables. When using MySQL 5.7 it seems additional (References) persmissions are required.
See: https://community.atlassian.com/t5/Jira-questions/Batch-email-notification-not-sending-email-and-how-to-restore/qaq-p/1164193#M373281

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

978 views 11 25
Read article

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