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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.6 Release Testing »
  • New mailing - 4.6.alpha4 - database deadlock
Pages: [1]

Author Topic: New mailing - 4.6.alpha4 - database deadlock  (Read 971 times)

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
New mailing - 4.6.alpha4 - database deadlock
February 02, 2015, 09:44:14 pm
When adding groups to the recipient list, in 4.6.alpha4, I noticed the number of recipients doesn't update. I saw log messages complaining about deadlocks and lock timeouts, eg ...

Quote
Feb 03 16:28:59  [info] $backTrace = #0 /sites/all/modules/civicrm/CRM/Core/Error.php(889): CRM_Core_Error::backtrace("back
Trace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "U
PDATE  civicrm_mailing  SET domain_id = 1 , header_id = NULL , footer_id = N...")
#4 /sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "UPDATE  civicrm_mailing  SET d
omain_id = 1 , header_id = NULL , footer_id = N...")
#5 /sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "UPDATE  civicrm_mailing
  SET domain_id = 1 , header_id = NULL , footer_id = N...", "DB_Error", TRUE)
#6 /sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1205 ** Lock wait ti
meout exceeded; try restarting transaction")
#7 /sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("UPDATE  civicrm_mailing  SET domain_id =
 1 , header_id = NULL , footer_id = N...")
#9 /sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("UPDATE  civicrm_mailing  SET domain_id =
1 , header_id = NULL , footer_id = N...")
#10 /sites/all/modules/civicrm/packages/DB/DataObject.php(1345): DB_DataObject->_query("UPDATE  civicrm_mailing  SET domain
_id = 1 , header_id = NULL , footer_id = N...")
#11 /sites/all/modules/civicrm/CRM/Core/DAO.php(444): DB_DataObject->update()
#12 /sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1571): CRM_Core_DAO->save()
#13 /sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1670): CRM_Mailing_BAO_Mailing::add((Array:39), (Array:0))
#14 [internal function](): CRM_Mailing_BAO_Mailing::create((Array:39))
#15 /sites/all/modules/civicrm/api/v3/utils.php(1222): call_user_func_array((Array:2), (Array:1))
#16 /sites/all/modules/civicrm/api/v3/Mailing.php(64): _civicrm_api3_basic_create("CRM_Mailing_BAO_Mailing", (Array:39))
#17 /sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_mailing_create((Array:33))
#18 /sites/all/modules/civicrm/Civi/API/Kernel.php(96): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#19 /sites/all/modules/civicrm/api/api.php(25): Civi\API\Kernel->run("Mailing", "create", (Array:33), NULL)
#20 /sites/all/modules/civicrm/CRM/Utils/REST.php(394): civicrm_api("Mailing", "create", (Array:33))
#21 /sites/all/modules/civicrm/CRM/Utils/REST.php(638): CRM_Utils_REST::process((Array:3), (Array:31))
#22 [internal function](): CRM_Utils_REST::ajax()
#23 /sites/all/modules/civicrm/CRM/Core/Invoke.php(275): call_user_func((Array:2))
#24 /sites/all/modules/civicrm/CRM/Core/Invoke.php(82): CRM_Core_Invoke::runItem((Array:12))
#25 /sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#26 /sites/all/modules/civicrm/drupal/civicrm.module(409): CRM_Core_Invoke::invoke((Array:3))
#27 [internal function](): civicrm_invoke("ajax", "rest")
#28 /includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#29 /index.php(21): menu_execute_active_handler()
#30 {main}

and

Quote
Feb 03 16:29:16  [info] $backTrace = #0 /sites/all/modules/civicrm/CRM/Core/Error.php(889): CRM_Core_Error::backtrace("back
Trace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "R
EPLACE INTO       I_16442 (email_id, contact_id)\n                    SELECT...")
#4 /sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "REPLACE INTO       I_16442 (em
ail_id, contact_id)\n                    SELECT...")
#5 /sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "REPLACE INTO       I_16
442 (email_id, contact_id)\n                    SELECT...", "DB_Error", TRUE)
#6 /sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1213 ** Deadlock fou
nd when trying to get lock; try restarting transaction")
#7 /sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("REPLACE INTO       I_16442 (email_id, co
ntact_id)\n                    SELECT...")
#9 /sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("REPLACE INTO       I_16442 (email_id, con
tact_id)\n                    SELECT...")
#10 /sites/all/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("REPLACE INTO       I_16442 (email_i
d, contact_id)\n                    SELECT...")
#11 /sites/all/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("REPLACE INTO       I_16442 (email_id, contact_i
d)\n                    SELECT...")
#12 /sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(531): CRM_Core_DAO->query("REPLACE INTO       I_16442 (email_id,
 contact_id)\n                    SELECT...")
#13 /sites/all/modules/civicrm/CRM/Mailing/BAO/MailingJob.php(72): CRM_Mailing_BAO_Mailing::getRecipients(16442, "3816", NU
LL, NULL, TRUE, FALSE)
#14 [internal function](): CRM_Mailing_BAO_MailingJob::create((Array:11))
#15 /sites/all/modules/civicrm/api/v3/utils.php(1222): call_user_func_array((Array:2), (Array:1))
#16 /sites/all/modules/civicrm/api/v3/MailingJob.php(46): _civicrm_api3_basic_create("CRM_Mailing_BAO_MailingJob", (Array:1
1))
#17 /sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_mailing_job_create((Array:11))
#18 /sites/all/modules/civicrm/Civi/API/Kernel.php(96): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#19 /sites/all/modules/civicrm/api/api.php(25): Civi\API\Kernel->run("mailing_job", "create", (Array:8), NULL)
#20 /sites/all/modules/civicrm/Civi/API/Subscriber/ChainSubscriber.php(178): civicrm_api("mailing_job", "create", (Array:8)
)
#21 /sites/all/modules/civicrm/Civi/API/Subscriber/ChainSubscriber.php(72): Civi\API\Subscriber\ChainSubscriber->callNested
Api((Array:33), (Array:5), "create", "Mailing", 3)
#22 [internal function](): Civi\API\Subscriber\ChainSubscriber->onApiRespond(Object(Civi\API\Event\RespondEvent))
#23 /sites/all/modules/civicrm/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(164):
call_user_func((Array:2), Object(Civi\API\Event\RespondEvent))
#24 /sites/all/modules/civicrm/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php(53): S
ymfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:4), "api.respond", Object(Civi\API\Event\RespondEvent))
#25 /sites/all/modules/civicrm/Civi/API/Kernel.php(221): Symfony\Component\EventDispatcher\EventDispatcher->dispatch("api.r
espond", Object(Civi\API\Event\RespondEvent))
#26 /sites/all/modules/civicrm/Civi/API/Kernel.php(98): Civi\API\Kernel->respond(Object(Civi\API\Provider\MagicFunctionProv
ider), (Array:9), (Array:5))
#27 /sites/all/modules/civicrm/api/api.php(25): Civi\API\Kernel->run("Mailing", "create", (Array:33), NULL)
#28 /sites/all/modules/civicrm/CRM/Utils/REST.php(394): civicrm_api("Mailing", "create", (Array:33))
#29 /sites/all/modules/civicrm/CRM/Utils/REST.php(638): CRM_Utils_REST::process((Array:3), (Array:31))
#30 [internal function](): CRM_Utils_REST::ajax()
#31 /sites/all/modules/civicrm/CRM/Core/Invoke.php(275): call_user_func((Array:2))
#32 /sites/all/modules/civicrm/CRM/Core/Invoke.php(82): CRM_Core_Invoke::runItem((Array:12))
#33 /sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#34 /sites/all/modules/civicrm/drupal/civicrm.module(409): CRM_Core_Invoke::invoke((Array:3))
#35 [internal function](): civicrm_invoke("ajax", "rest")
#36 /includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#37 /index.php(21): menu_execute_active_handler()
#38 {main}

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: New mailing - 4.6.alpha4 - database deadlock
February 27, 2015, 11:56:39 pm
In 4.6.beta1, this issue is no longer occurring for me, and the recipient count is updating.

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: New mailing - 4.6.alpha4 - database deadlock
March 14, 2015, 11:44:51 pm
In 4.6.beta3 it has happened again ...

Quote
Mar 13 19:12:11  [info] $backTrace = #0 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Error.php(889): CRM_Core_Error::backtrace("back
Trace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/citybibleforum/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "U
PDATE  civicrm_mailing  SET domain_id = 1 , header_id = 36 , footer_id = 16 ...")
#4 /var/www/citybibleforum/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "UPDATE  civicrm_mailing  SET d
omain_id = 1 , header_id = 36 , footer_id = 16 ...")
#5 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "UPDATE  civicrm_mailing
  SET domain_id = 1 , header_id = 36 , footer_id = 16 ...", "DB_Error", TRUE)
#6 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-1, NULL, NULL, NULL, "1205 ** Lock wait ti
meout exceeded; try restarting transaction")
#7 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("UPDATE  civicrm_mailing  SET domain_id =
 1 , header_id = 36 , footer_id = 16 ...")
#9 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("UPDATE  civicrm_mailing  SET domain_id =
1 , header_id = 36 , footer_id = 16 ...")
#10 /var/www/citybibleforum/sites/all/modules/civicrm/packages/DB/DataObject.php(1345): DB_DataObject->_query("UPDATE  civicrm_mailing  SET domain
_id = 1 , header_id = 36 , footer_id = 16 ...")
#11 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/DAO.php(444): DB_DataObject->update()
#12 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1573): CRM_Core_DAO->save()
#13 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1691): CRM_Mailing_BAO_Mailing::add((Array:30), (Array:2))
#14 [internal function](): CRM_Mailing_BAO_Mailing::create((Array:30))
#15 /var/www/citybibleforum/sites/all/modules/civicrm/api/v3/utils.php(1283): call_user_func_array((Array:2), (Array:1))
#16 /var/www/citybibleforum/sites/all/modules/civicrm/api/v3/Mailing.php(67): _civicrm_api3_basic_create("CRM_Mailing_BAO_Mailing", (Array:30))
#17 /var/www/citybibleforum/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_mailing_create((Array:28))
#18 /var/www/citybibleforum/sites/all/modules/civicrm/Civi/API/Kernel.php(96): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
#19 /var/www/citybibleforum/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->run("Mailing", "create", (Array:28), NULL)
#20 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Utils/REST.php(402): civicrm_api("Mailing", "create", (Array:28))
#21 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Utils/REST.php(638): CRM_Utils_REST::process((Array:3), (Array:26))
#22 [internal function](): CRM_Utils_REST::ajax()
#23 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): call_user_func((Array:2))
#24 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:12))
#25 /var/www/citybibleforum/sites/all/modules/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#26 /var/www/citybibleforum/sites/all/modules/civicrm/drupal/civicrm.module(484): CRM_Core_Invoke::invoke((Array:3))
#27 [internal function](): civicrm_invoke("ajax", "rest")
#28 /var/www/citybibleforum/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#29 /var/www/citybibleforum/index.php(21): menu_execute_active_handler()
#30 {main}

rocxa

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 4
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.71
  • PHP version: 5.3.3
Re: New mailing - 4.6.alpha4 - database deadlock
April 08, 2015, 05:01:18 am
This also occurs in the 4.6.0 release.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.6 Release Testing »
  • New mailing - 4.6.alpha4 - database deadlock

This forum was archived on 2017-11-26.