CiviCRM Community Forums (archive)

I got a panicked phone call from a former client. A dreaded MySQL Has Gone Away error occurred during the sending of an important mailing. The mailing report says emails were sent to 100% of contacts. But does this actually mean what it says?

Is this based on an actual tally of emails that were actually sent, meaning we don't need to worry and 100% of emails definitely sent? Or is it simply based on the number of contacts where the email wasn't blocked or deliberately filtered - in which case, an unknown number might not have sent?

Is there any other way of verifying how many actual emails actually definitely sent?

(I know about MySQL Has Gone Away errors and methods to avoid them by the way, and it's something I'll get on to. But the immediate worry is knowing whether this important, time-sensitive mailing actually sent to 100% of the recipients or not, and if not, how to know who on the mailing list we need to send to)

"I know about MySQL Has Gone Away errors and methods to avoid them by the way, and it's something I'll get on to. But the immediate worry is knowing whether this important, time-sensitive mailing actually sent to 100% of the recipients or not, and if not, how to know who on the mailing list we need to send to"

...I'm looking in the source code and so far it's inconclusive.

There's a 'mark_processed' function and a 'mark_ignored' function for each type of mailer in civicrm/CRM/Mailing/MailStore but it's not clear if an individual mail to an individual contact is marked as 'processed' then sent (meaning it might not have actually sent, and the % sent stat is not a reliable measure), or, if they are sent then marked as processed on success (in which case, it must have sent, and the % sent stat is a reliable measure)