CiviCRM Community Forums (archive)

I was wondering how other administrators are scheduling their cron jobs.  I intend to have it run every minute as indicated below but after a few days it caused my DB to crash.  Is this because the previous cron has not completed and is starting a new one?  If so, does anyone have a good strategy on how to send out mailings by the minute?

===

PARAMS= -j -sdefault -u username -p password -e Job -a process_mailing
*/1 * * * *  cd $CIVI_ROOT; $PHP bin/cli.php $PARAMS

===

<p>Initialization Error</p><p><pre>Array
(
   [callback] =&gt; Array
       (
           

• =&gt; CRM_Core_Error
[1] =&gt; simpleHandler
       )

   

[c.ode] =&gt; -24
   [message] =&gt; DB Error: connect failed
   [mode] =&gt; 16
   [debug_info] =&gt;  [nativecode=Too many connections]
   [type] =&gt; DB_Error
   [user_info] =&gt;  [nativecode=Too many connections]
   [to_string] =&gt; [db_error: message=&quot;DB Error: connect failed&quot; code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix=&quot;&quot; info=&quot; [nativecode=Too many connections]&quot;]
)
</pre></p><p></p><p>backTrace</p><p><pre>/usr/local/www/drupal/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/usr/local/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/usr/local/www/drupal/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB/mysqli.php, raiseError, 338
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB.php, connect, 558
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php, connect, 2295
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php, _connect, 2533
/usr/local/www/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php, _build_condition, 411
/usr/local/www/drupal/sites/all/modules/civicrm/CRM/Core/BAO/ConfigSetting.php, find, 203
/usr/local/www/drupal/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 408
/usr/local/www/drupal/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 209
/usr/local/www/drupal/sites/all/modules/civicrm/bin/cli.php, singleton, 151
/usr/local/www/drupal/sites/all/modules/civicrm/bin/cli.php, _bootstrap, 54
/usr/local/www/drupal/sites/all/modules/civicrm/bin/cli.php, initialize, 29</pre></p><p></p>

Turned down the "Mailer CRON job limit" and things seem fine for now.  Thanks Donald!