CiviCRM Community Forums (archive)

Greetings,

On a client's site using Authorize.net gateway, we are seeing successful recurring charges randomly not posted to CiviCRM. This evening I tracked one down, and it appears very similar to this bug report:

"CRM-15470 MySQL transaction deadlocks with multiple simultaneous recurring contribution updates"
https://issues.civicrm.org/jira/browse/CRM-15470

Could it be due to data / restraints as this is not a heavily utilized site... no concurrent transactions being processed at the time of this failure.

I will ask our client if the trouble is indeed specific to certain recurring charges, and not random across the recurring charges.

Following is the scrubbed log of the error. The MySQL log never receives a corresponding entry.

Dec 18 04:08:05  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_id ) VALUES ( 15200 ,  31317 ,  2 )  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_id ) VALUES ( 15200 ,  31317 ,  2 )  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_id ) VALUES ( 15200 ,  31317 ,  2 )  [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)


Dec 18 04:08:05  [info] $backTrace = #0 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Core/Error.php(239): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...")
#4 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...")
#5 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...", "DB_Error", TRUE)
#6 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/mysqli.php(929): DB_common->raiseError(-1, NULL, NULL, NULL, "1213 ** Deadlock found when trying to get lock; try restarting transaction")
#7 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...")
#9 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...")
#10 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_activity_contact (activity_id , contact_id , record_type_...")
#11 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Core/DAO.php(455): DB_DataObject->insert()
#12 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Activity/BAO/ActivityContact.php(63): CRM_Core_DAO->save()
#13 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Activity/BAO/Activity.php(370): CRM_Activity_BAO_ActivityContact::create((Array:3))
#14 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Activity/BAO/Activity.php(1915): CRM_Activity_BAO_Activity::create((Array:10))
#15 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Core/Payment/BaseIPN.php(630): CRM_Activity_BAO_Activity::addActivity(Object(CRM_Contribute_BAO_Contribution), NULL, NULL)
#16 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Core/Payment/AuthorizeNetIPN.php(197): CRM_Core_Payment_BaseIPN->completeTransaction((Array:26), (Array:6), (Array:8), Object(CRM_Core_Transaction), Object(CRM_Contribute_BAO_ContributionRecur))
#17 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/CRM/Core/Payment/AuthorizeNetIPN.php(80): CRM_Core_Payment_AuthorizeNetIPN->recur((Array:26), (Array:6), (Array:8), FALSE)
#18 /srv/www/sites/members.orgname.org/www/sites/members.orgname.org/modules/civicrm/extern/authorizeIPN.php(42): CRM_Core_Payment_AuthorizeNetIPN->main()
#19 {main}
Suggestions?

I am thankful,