CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • [SOLVED] Mailings stuck at Scheduled then Running, only send 1000
Pages: [1]

Author Topic: [SOLVED] Mailings stuck at Scheduled then Running, only send 1000  (Read 1363 times)

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
[SOLVED] Mailings stuck at Scheduled then Running, only send 1000
September 03, 2011, 09:24:27 pm
Here is a list of my woes with CiviMail and what I've tried. (version 3.4.5)

Every mailing needs cron too jumpstart it from Scheduled to Running:

https://www.example.org.nz/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=username&pass=password&key=sitekey

This starts the mailing and is successful for mailings to under 1000 people (we think - reporting for open rates looks normal).

Both mailings we've tried over 1000 recipients gets stuck at 1000. Any further jabbing of the cron run above caused another email to send.

Now I can't tell who has had the latest email, as I had to cancel it to stop the multiples sending (or so I thought at the time) and the civicrm_mailing tables in phpmyadmin show 1489 recipients (the total of the mailing).

I have tried the debugging but nothing seems to write to the log file:
http://wiki.civicrm.org/confluence/display/CRMDOC32/Debugging

I'm OK with having to run cron to make it go as it seems I probably haven't set up the crontab properly. But the problem with getting stuck at 1000 is serious and the organisation is angry.

What is causing this?


EDITED: We eventually solved this by moving from shared hosting to VPS. The shared hosting was timing out at 300 seconds, which wasn't enough time to either send the mailing or record who had received it.

Now the mailing to 1200 people goes out in a minute, which is great. :)

Moral of the story: don't install CiviCRM on shared hosting. (It wasn't my decision to do that, by the way!)



« Last Edit: September 26, 2011, 04:00:10 pm by websynapse »

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Mailings stuck at Scheduled then Running, only send 1000
September 04, 2011, 06:36:53 am
Install the cronjob (you need both the one to send and the one to process the bounce emails) and let it run regularly, should work smoothly

-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Mailings stuck at Scheduled then Running, only send 1000
September 04, 2011, 06:48:03 am
Check our CiviMail Mailer settings--you may have it set to send only 1000 per run. Also perhaps confirm manually that none of the emails are duplicates--could be that duplication is in the DB, not in CiviMail...
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: Mailings stuck at Scheduled then Running, only send 1000
September 04, 2011, 06:50:28 am
hi,
also could be related to this issue in 3.4.5 which 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.

hope this helps,
cynthia


websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Re: Mailings stuck at Scheduled then Running, only send 1000
September 04, 2011, 02:03:02 pm
Mailer batch limit is set to 0.

There are no duplicate emails in the system.

Thanks for the patch, I'll try that.

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Re: Mailings stuck at Scheduled then Running, only send 1000
September 13, 2011, 01:30:44 am
Quote from: Hershel on September 04, 2011, 06:48:03 am
Check our CiviMail Mailer settings--you may have it set to send only 1000 per run.


I have checked this with the hosting provider and also in our settings. Neither has this limit set.

Where is the 1000 limit coming from??

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • [SOLVED] Mailings stuck at Scheduled then Running, only send 1000

This forum was archived on 2017-11-26.