CiviCRM Community Forums (archive)

After upgrading to 3.2, my mail jobs are taking a very long time.
My run this afternoon for 1068 recipients took 5 1/2 hours to complete.

Every other email run I have ever made on this system, since I set it up, has taken less then 3 minutes to complete.
I call the Civimail cronjob every 30 minutes.

I began another mail run early this morning, and discovered only about 130 emails were being sent each cron run.
I loaded the curl string into my browser and ran it manually, and sure enough, about 130 emails were sent each time.
By repeatedly refreshing the browser window, I was able to force the email run of 1584 in about 30 minutes.

The only entry in my log that looked odd was this one:

Location: http://www.pmicvc.org/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=myusername&pass=mypassword&key=mykey

mysqli_query() [<a href='function.mysqli-query'>function.mysqli-query</a>]: (HY000/2008): MySQL client ran out of memory in /home/virtual/site378/fst/var/www/html/includes/database.mysqli.inc  on line 108.

This was well after beginning the browser forcing of the cron job. (like 15-20 minutes after).

The job itself took just seconds to execute.  It only sent 120-135 emails when it ran.  No problems, overloads, or throttling going on with the ISP.

The function that seems to have triggered high memory use is the token function - what tokens are in your civimail?

That seems really odd - what do you have in the way of Custom hooks? Anything? Do you use ACLs?