CiviCRM Community Forums (archive)

My client is reporting that after upgrading from 3.1.x to 3.4.5 that civimail mailings are going out multiple times.  The interval appears to be the same as my cron jobs - 15 minutes.  I have reports of 3-4 copies before canceling the mailing.  They've canceled every time to stop the repeats.  This is happening on a list of around 14k contacts that they've been using successfully before the upgrade.  I did an export and looked for duplicates, and didn't see any similar to the complaints.

Prior to the upgrade, I had civimail.cronjob.php and CiviMailProcessor.php running via wget.  After the upgrade, I changed to EmailProcessor.php.  Those appear to be working.

Mailings are NOT sent multiple times to a smaller list of 5-10 internal contacts.  This is the best clue I have so far...  I've looked at PHP memory limit and execution times, and I don't see any errors relating to either.  I've looked at the apache and PHP logs and am not seeing any obvious issues.

I know that there are logging and debugging options in Civi, but I'm not sure what to enable so I'm not bombing 14k innocent contacts!  Can anyone point me in the right direction to troubleshoot this?

Thanks!
  Chris Miller

hi,
we just upgraded to 3.4.5 and we are experiencing the same issue as reported here. an email was sent yesterday to a list of around 3,000 people and some received 40 emails!!. We are running drupal 6.22, civicrm 3.4.5 and we also use the uas smtp service.

i have a consultant looking at this but they have not been able to figure out what is wrong. meanwhile we have advised staff not to send any more emails.

any help appreciated or if you can suggest a path for troubleshooting i will ask the consultant to take a look.

thanks,
cynthia

Mailer Batch Limit: 0
Mailer Job Size: 0
Mailer CRON job limit: 0
VERP Separator: .

Drupal is 6.20
Server platform is Plesk-based VPS running Ubuntu 8.04, PHP 5.2.4, and MySQL 5.0.51a

I just changed the batch limit to 2000 but haven't had a chance to test yet.  I wanted to figure out how to not actually send the messages just in case.  Is there a way to simulate sending on a production site if I'm careful?

Thanks!

Thank you, I will try that tomorrow.  Also the client just let me know that it happened today on a "Send immediately" mailing, so that might not be a good clue.

hi criznach,
this is a bug in 3.4.5 and will be fixed in 3.4.6 but there is a patch available now if you want it: http://issues.civicrm.org/jira/browse/CRM-8678.

if you do apply the patch it wold be helpful (to me-us) if you would post back and let us know if it fixed the issue. thanks!

hope this helps,
cynthia

Hi there

I'm experiencing this excact issue on civicrm 4.05 and drupal 7. Sending a few mails everything works fine, but sending to a lot (in my case 2000) causes the mailing to start over at an interval equal to the time set in the cron-job.

Did you figure out what the problem was and did you find a solution?

I've got some additional info though: cron sends me a mail with a mysql error and the backtrace everytime it starts over - here's the mail:
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array
(
    [:db_insert_placeholder_0] => 1242
    [:db_insert_placeholder_1] => civicrm
    [:db_insert_placeholder_2] => $Ignoring exception thrown here = PEAR_Error Object
(
    [error_message_prefix] =>
    [mode] => 16
    [level] => 1024
    [code] =>
    [message] => Invalid response code received from SMTP (outbound mail) server while attempting to send email.  This is often caused by a misconfiguration in the CiviCRM Outbound Email settings. Please verify the settings at Administer CiviCRM >> Global Settings >> Outbound Email (SMTP).
    [userinfo] =>
    [backtrace] => Array
        (
            [0] => Array
... lot's of  stuff follows, including the mail it-self several times and and array with the first 1000 contacts on the list - in this form:

[args] => Array
                        (
                            [0] => Array
                                (
                                    [0] => Array
                                        (
                                            [id] => 10
                                            [hash] => 9104a9b56ab32212
                                            [contact_id] => 102
                                            [email] => mail@domain.com
                                        )

                                    [1] => Array
                                        (... and so it continues until the 1000th element - which makes no sense to me since there's 2000 contacts in the mailinglist (group)
Then at the end of the backtrace:
   [verpSeparator] => .
                                    [mailerPeriod] => 180
                                    [mailerSpoolLimit] => 0
                                    [mailerBatchLimit] => 0
                                    [customPHPPathDir] => /var/www/mysite/sites/default/files/civicrm/custom/
                                    [customTemplateDir] => /var/www/mysite/sites/default/files/civicrm/custom/
                                    [extensionsDir] => /var/www/mysite/sites/default/files/civicrm/extensions/
                                    [importDataSourceDir] => /var/www/mysite/sites/all/modules/civicrm/CRM/Import/DataSource/
                                    [sunlight] =>
                                    [groupTree] =>
                                    [revampPages] => Array
                                        (
                                        )

                                    [profileDoubleOptIn] => 1
                                    [profileAddToGroupDoubleOptIn] =>
                                    [activityAssigneeNotification] => 1
                                    [useIDS] => 1
                                    [mailerJobSize] => 0
                                    [mailerJobsMax] => 0
                                    [useFrameworkRelativeBase] => /
                                )

                        )

                )

        )

    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => nullHandler
        )

)

    [:db_insert_placeholder_3] => N;
    [:db_insert_placeholder_4] => 7
    [:db_insert_placeholder_5] =>
    [:db_insert_placeholder_6] => http://www.mysite.com/bin/civimail.cronjob.php?bin/civimail.cronjob.php
    [:db_insert_placeholder_7] =>
    [:db_insert_placeholder_8] => 127.0.0.1
    [:db_insert_placeholder_9] => 1346266201
)
 i dblog_watchdog() (line 154 of /var/www/mysite/modules/dblog/dblog.module).


Any and all help apreciated