View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
12100Bug reportsSurvey participants (Tokens)public2017-01-31 17:132018-05-23 12:19
Reportermarcgold Assigned ToLouisGac 
PrioritynoneSeveritypartial_block 
Status closedResolutionno change required 
Product Version2.62.x 
Summary12100: System Hangs During Email Sendout
Description

Have created a survey with a large tokenised participant database, 17000 emails.
Emails are being relayed via an commercial SMTP host (elastic-mail) - the service can handle 50+ emails per second and we use this with our normal bulk emailer. As we needed this to be with tokens we have used the participant database capability of LS.

The problem is that when ever I send an email batch - the rest of the LS system becomes totally unresponsive until the send is completed. Have tried this with batch sizes of 1000 and right the way down to 100. the same happens

Any Ideas

Additional Information

Max PHP mem avail to LS is 1Gb
Execute Times: 3000
PHP 7.01

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.62.1+170130
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL 5.5
Server OS (if known)Centos 6.8
Webserver software & version (if known)Apache 2 (plesk 12.5)
PHP Version7.01

Users monitoring this issue

There are no users monitoring this issue.

Activities

marcgold

marcgold

2017-01-31 18:34

reporter   ~42922

This may help, I have downloaded and used the sendMailAjax plugin - https://extensions.sondages.pro/mailing-management/sendmailajax-all-email-in-one-click/

Once installed, the emails went smoothly without choking the system - Maybe something similar can be included to the core - because choking the system at all - even a small send is not good practice.
DenisChenu

DenisChenu

2017-01-31 23:43

developer   ~42923

We need to send email one by one, we need to contact your smtp server, and getr the return information => i don't think this can be really improved.

BUT : sendMailAjax is done for this https://www.limesurvey.org/index.php?option=com_sobipro&pid=89&sid=88:sendMailAjax&Itemid=729 and compatible (and tested) with 2.62.2
DenisChenu

DenisChenu

2017-03-07 16:21

developer   ~43189

PS : must do for 2.64 : move "send batch email to specific page (tools)"

Issue History

Date Modified Username Field Change
2017-01-31 17:13 marcgold New Issue
2017-01-31 18:34 marcgold Note Added: 42922
2017-01-31 23:43 DenisChenu Note Added: 42923
2017-03-07 16:21 DenisChenu Note Added: 43189
2018-05-23 12:19 LouisGac Assigned To => LouisGac
2018-05-23 12:19 LouisGac Status new => closed
2018-05-23 12:19 LouisGac Resolution open => no change required