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) »
  • Monitoring Civimail Process in the Database?
Pages: [1]

Author Topic: Monitoring Civimail Process in the Database?  (Read 471 times)

britebyte

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 2
  • CiviCRM version: Several 3.4+, 4.1+
  • CMS version: Drupal 6, Drupal7
  • MySQL version: Several 5.1+
  • PHP version: Several 5.2+
Monitoring Civimail Process in the Database?
July 17, 2012, 08:45:44 am
I have a Civimail mailing that went out. We had a server lock up during one of the cron jobs and had to restart mysql.
The mailing report is showing as running and  at about 30%, cron is now running but no more emails are going out.
Is there a way to check in the database tables if the emails are still waiting to be sent?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Monitoring Civimail Process in the Database?
July 17, 2012, 09:25:14 am

check

civicrm_mailing_event_queue
civicrm_mailing_event_delivered
civicrm_mailing_event_bounce

the ones in queue that are not in delivered or bounce are targets for delivery for all active mailing jobs

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

britebyte

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 2
  • CiviCRM version: Several 3.4+, 4.1+
  • CMS version: Drupal 6, Drupal7
  • MySQL version: Several 5.1+
  • PHP version: Several 5.2+
Re: Monitoring Civimail Process in the Database?
July 17, 2012, 11:22:41 am
Lobo,
Thank you for your quick reply! It was really helpful. Still troubleshooting and trying to read a little of the code to get some ideas but in a time crunch there isn't time to read it all.

We ended up cancelling that one mailing and are getting ready to send it to those who didn't receive it.
Does that mean that we should eventually clean out the civicrm_mailing_event_queue table? We actually have a lot of records in there from old mailings as well.
If it gets stuck again can I get any more verbose logging on the email queue run? I suppose the obvious answer would be to add in more CRM_Core_Error::debug_log_message calls.


Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Monitoring Civimail Process in the Database?

This forum was archived on 2017-11-26.