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) »
  • CiviMail Delivers, but for not all Intended Recipients
Pages: [1]

Author Topic: CiviMail Delivers, but for not all Intended Recipients  (Read 1374 times)

Swambala

  • Guest
CiviMail Delivers, but for not all Intended Recipients
December 25, 2008, 01:50:04 am
I am trying to send CiviMail for 585 Email Ids which I have imported to the “Contact” without First Name, Last Names and other contact details. I mean I have imported just the raw email ids. And I have grouped these 585 Email Ids as one group called “Group1”

I created “Message Template” and then scheduled the “New Mailing” with the Mailing Recipients as “Group1”

I invoked the Scheduled Email queue by calling the below link

http://www.XYZnpo.org/administrator/index.php?option=com_civicrm&task=civicrm/mailing/queue&reset=1
 
When I call the above link, after a minute I got the below error

Code: [Select]
backTrace


/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 308
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/Event/BAO/Queue.php, find, 101
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/Event/BAO/Delivered.php, verify, 57
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/Job.php, create, 341
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/Job.php, deliverGroup, 295
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/BAO/Job.php, deliver, 129
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Mailing/Page/Browse.php, runJobs, 103
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 197
/home/XYZnpo/html/administrator/components/com_civicrm/admin.civicrm.php, invoke, 45
/home/XYZnpo/html/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/home/XYZnpo/html/libraries/joomla/application/component/helper.php, require_once, 162
/home/XYZnpo/html/administrator/includes/application.php, renderComponent, 130
/home/XYZnpo/html/administrator/index.php, dispatch, 67


 Sorry. A non-recoverable error has occurred.


--------------------------------------------------------------------------------

DB Error: no database selected

Database Error Code: Lost connection to MySQL server during query, 2013

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -14
    [message] => DB Error: no database selected
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_mailing_event_queue
 
 WHERE (  civicrm_mailing_event_queue.id = 44 )  AND (  civicrm_mailing_event_queue.job_id = 5 ) AND (  civicrm_mailing_event_queue.hash  = '4a52cb4c7c40e548' )
 
 
 
 [nativecode=2013 ** Lost connection to MySQL server during query]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_mailing_event_queue
 
 WHERE (  civicrm_mailing_event_queue.id = 44 )  AND (  civicrm_mailing_event_queue.job_id = 5 ) AND (  civicrm_mailing_event_queue.hash  = '4a52cb4c7c40e548' )
 
 
 
 [nativecode=2013 ** Lost connection to MySQL server during query]
    [to_string] => [db_error: message="DB Error: no database selected" code=-14 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_mailing_event_queue
 
 WHERE (  civicrm_mailing_event_queue.id = 44 )  AND (  civicrm_mailing_event_queue.job_id = 5 ) AND (  civicrm_mailing_event_queue.hash  = '4a52cb4c7c40e548' )
 
 
 
 [nativecode=2013 ** Lost connection to MySQL server during query]"]
)



backTrace


/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 308
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1587
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 885
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/Lock.php, singleValueQuery, 75
/home/XYZnpo/html/administrator/components/com_civicrm/civicrm/CRM/Core/Lock.php, release, 53
, __destruct,


 Sorry. A non-recoverable error has occurred.


--------------------------------------------------------------------------------

DB Error: no database selected

Database Error Code: MySQL server has gone away, 2006

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -14
    [message] => DB Error: no database selected
    [mode] => 16
    [debug_info] => SELECT RELEASE_LOCK( 'civimail.job.5' ) [nativecode=2006 ** MySQL server has gone away]
    [type] => DB_Error
    [user_info] => SELECT RELEASE_LOCK( 'civimail.job.5' ) [nativecode=2006 ** MySQL server has gone away]
    [to_string] => [db_error: message="DB Error: no database selected" code=-14 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT RELEASE_LOCK( 'civimail.job.5' ) [nativecode=2006 ** MySQL server has gone away]"]
)



When Check the Delivery Summary of the Mailing it shows as below
Intended Recipients:  585
Successful Deliveries:  38 (6.50%)
Bounces: 0 (0.00%)
Status: Running

I don’t know why the mail delivery got stopped in the mid. I tried to invoke the Email Queue again and again but I am getting the same error. There is no change in the Delivery Summary too.

I tried the “Send an Email” to the “Contact”, it works fine.

The below SQL query which throws the error in CiviMail, works good in MySql Database when I ran directly in query window of the database.

I am not sure where the problem is? It would be great if someone guide us to solve this issue.
[/code][/code]

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: CiviMail Delivers, but for not all Intended Recipients
December 25, 2008, 07:49:44 am

If you are consistently getting it after one minute or so, most likely it is a mysql connect timeout issue (or something similar). You might want to check with your hosting provider

it does seem like a mysql server issue since the connection seems to be dropping (based on the error message)

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

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: CiviMail Delivers, but for not all Intended Recipients
December 27, 2008, 03:29:55 am
Swambala,

As Lobo suggests, it sounds like the DB server isn't handling the queries from the mail run.

You might try reducing the number of mails per queue run to some small number (eg 5 or 10) and see if it is capable of processing at that level. If that works, then you can gradually increase the number to identify what acceptable batch sizes are on your hosting environment.

Do you see similar DB disconnect issues when working with CiviCRM normally - especially on pages which require a lot of processing? If so, it may be that your hosting environment needs some improvement to function properly with CiviCRM.

Does this behaviour vary from time to time during the day? If so, this may indicate that other services or other sites on the same machine have intensive load periods which are affecting the performance of your site.
@xurizaemon ● www.fuzion.co.nz

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • CiviMail Delivers, but for not all Intended Recipients

This forum was archived on 2017-11-26.