CiviCRM Community Forums (archive)

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

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]

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.