Extremely slow sending campaign emails :(

[supperman2k]

Hi,

I am getting some weird behavior on my server when I am sending emails via a campaign.

in 200 seconds it will only send 5 emails, and the server times out, in some templates.php.

Also, when I check the server utilization, the CPU is at 99% for the entire time.

I am sending the emails out via our SMTP server which is located on another server. I dont believe this is a problem because I tested with the localhost mail server and it to was slow.

I am running Sugar 5.1.0a, and prior to this we were running 5.0 and there were no problems.

Any help would be appreciated, thanks.

[supperman2k]

11111111
Fatal error: Maximum execution time of 200 seconds exceeded in ./modules/EmailTemplates/EmailTemplate.php on line 300

it only sent 5 emails in that time?

do you think it might be a problem with the template that is being sent?

[shareaholic]

I am experiencing similar issues
Have figured out that the problem is with specific email template:

# 11/28/08 12:02:42 [2136][1][FATAL] Error retrieving template for the email campaign. template_id = 5dcaa82a-63ea-ae76-b1de-48171e4031f9
# 11/28/08 12:02:42 [2136][1][FATAL] Error verifying templates for the campaign, exiting

Unfortunately I have no clue what to fix in that template to make it work appropriately. With "as is" template Sugar sends campaign at ~ 1 email/min rate

[InfoJPG]

I have this problem over three month. Today, I have found the solution.
I have delete all entry (with PHPMyAdmin) in table: email_templates, email_marketing, campaigns_audit, campaign_log, campaigns.
You lost all campaigns, but now, all new campaigns send emails very fast.

Sorry for my english.
I'm a french canadian

[kbrill]

If someone gets this again, or still has it, please set your log level to 'info' (in Admin->System Settings) and post your sugarcrmlog file after a campaign send. I am interested in the query times during the send.

[mrbarletta]

Hi Kenneth,

I am having the very same situation here... sugarcrm log is attached. CPU goes over 90% when campaign is running.

Let me know if there is something I can do about it and thanks!

CRM Version 5.2.0 (Build 5380)

[fdevink]

Hello everyone,

We are trying now for one week to send our campaign. We have about 3000 mails to send. We have made tests with a sample of 8 mails, to check if everything is going smoothly. However, it takes 12 min to send 8 mails (mail of 30ko), 1min30/mail. The tests are made by planifing the campaign.

It seems that the problem comes not from the SMTP server, as the server process (APACHE on a WINDOWS 2003 SBS server) is running about 1 min for every mail it is sending.

We have done nearly the same campaign 2 months ago, without any problem. The only thing that has changed is the version of Sugar used. We are no using the version 5.2.0k (from the version 5.2.0a).

Has someone any idea to resolve this problem?

Thank you in advance.

P.S: Dear Kbrill, to answer to your post, please find enclosed the log file, hope it gives a reason why it is so slow. What seems to be strange is that the requests are executing very quick, but every time in the log, between the last sentence of a mail and the first sentence of the next mail, nothing happens during 30 seconds.

[jossanvi]

We had de very same issue!..

We just deleted all targets and all campaigns + all email templates and voila ! its working blazing speed now.

I suggest you do first delete email templates, then targets and finally campaigns ... we did this first via the web and then directly in the database to make sure nothing was wrong as in fact its something with an email template and a target list.

Hopes that helps.

cheers

[vstokesjr]

We had de very same issue!..

We just deleted all targets and all campaigns + all email templates and voila ! its working blazing speed now.

I suggest you do first delete email templates, then targets and finally campaigns ... we did this first via the web and then directly in the database to make sure nothing was wrong as in fact its something with an email template and a target list.

Hopes that helps.

cheers

This is a shitty solution. Loosing all the marketing data makes SugarCRM at worthless as a dead rat.



We are using SugarCRM 5.5.0 CE and we are having this problem. In 8 hours it's manage to trickle out 232 emails out of 16000. No, it's not my service provider. They permit 400 emails an hour. We are only doing 100!

Why hasn't this been fixed?

It amazes me that SugarCRM wants me to pay for their product when it DOES NOT WORK as advertised.

[Imaginemm]

Hi,

I am getting some weird behavior on my server when I am sending emails via a campaign.

in 200 seconds it will only send 5 emails, and the server times out, in some templates.php.

Also, when I check the server utilization, the CPU is at 99% for the entire time.

I am sending the emails out via our SMTP server which is located on another server. I dont believe this is a problem because I tested with the localhost mail server and it to was slow.

I am running Sugar 5.1.0a, and prior to this we were running 5.0 and there were no problems.

Any help would be appreciated, thanks.

Just a thought, have you tried tweaking your php.ini file to increase script execution time and have you got all the required php extensions that sugar needs to run properly?