Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-17554

MySQL transaction deadlocks while creating participant after payment gateway response(Paypal payflow pro)

    Details

    • Type: Bug
    • Status: Won't Do
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: 4.6.2
    • Fix Version/s: Unscheduled
    • Component/s: CiviEvent
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      This issue we are getting after receiving payment gateway response(Paypal payflow pro) before creating participant.
      ----------------------------------------------------------------------------------------------------
      [info] $backTrace = #0 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Error.php(751): CRM_Core_Error::backtrace("backTrace", TRUE)
      #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
      #2 /home/www/mysite/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
      #3 /home/www/mysite/sites/all/modules/civicrm/packages/DB.php(972): PEAR_Error->PEAR_Error("DB Error: a515ac9c2796ca0e23adbe92c68fc9fc", "a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #4 /home/www/mysite/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error("a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #5 /home/www/mysite/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, "a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
      #6 /home/www/mysite/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError("a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, NULL, "1213 ** Deadlock found when trying to get lock; try restarting transaction")
      #7 /home/www/mysite/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
      #8 /home/www/mysite/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #9 /home/www/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #10 /home/www/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
      #11 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
      #12 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(131): CRM_Core_DAO->save()
      #13 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/BAO/CustomField.php(558): CRM_Core_BAO_Cache::setItem((Array:57), "contact fields", "custom importableFields Event_0_0_0_0_00_0_7acce319")
      #14 /home/www/mysite/sites/all/modules/civicrm/api/v3/utils.php(1337): CRM_Core_BAO_CustomField::getFields("Event", FALSE, FALSE, FALSE, NULL, FALSE, FALSE, FALSE)
      #15 /home/www/mysite/sites/all/modules/civicrm/api/v3/utils.php(1309): _civicrm_api_get_custom_fields("Event", (Array:2))
      #16 /home/www/mysite/sites/all/modules/civicrm/api/v3/Generic.php(71): _civicrm_api_get_fields("Event", TRUE, (Array:2))
      #17 /home/www/mysite/sites/all/modules/civicrm/api/api.php(70): civicrm_api3_generic_getfields((Array:7))
      #18 /home/www/mysite/sites/all/modules/civicrm/api/v3/utils.php(1417): civicrm_api("Event", "getfields", (Array:2))
      #19 /home/www/mysite/sites/all/modules/civicrm/api/api.php(52): _civicrm_api3_swap_out_aliases((Array:7))
      #20 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/BAO/Custom.php(45): civicrm_api("Event", "get", (Array:3))
      #21 /home/www/mysite/sites/all/modules/my_custom/civicrm_customlogic/civicrm_customlogic.module(843): CRM_Event_BAO_Custom::getNextRegistrationId("135853")
      #22 /home/www/mysite/sites/all/modules/civicrm/CRM/Utils/Hook.php(156): civicrm_customlogic_civicrm_post("create", "Participant", 375477, Object(CRM_Event_BAO_Participant))
      #23 /home/www/mysite/sites/all/modules/civicrm/CRM/Utils/Hook/Drupal6.php(67): CRM_Utils_Hook->runHooks((Array:58), "civicrm_post", 4, "create", "Participant", 375477, Object(CRM_Event_BAO_Participant), "create")
      #24 /home/www/mysite/sites/all/modules/civicrm/CRM/Utils/Hook.php(222): CRM_Utils_Hook_Drupal6->invoke(4, "create", "Participant", 375477, Object(CRM_Event_BAO_Participant), "create", "civicrm_post")
      #25 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/BAO/Participant.php(143): CRM_Utils_Hook::post("create", "Participant", 375477, Object(CRM_Event_BAO_Participant))
      #26 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/BAO/Participant.php(195): CRM_Event_BAO_Participant::add((Array:15))
      #27 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/Form/Registration.php(1014): CRM_Event_BAO_Participant::create((Array:15))
      #28 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/Form/Registration.php(837): CRM_Event_Form_Registration->addParticipant((Array:118), "230190")
      #29 /home/www/mysite/sites/all/modules/my_custom/civicrm/CRM/Event/Form/Registration/Confirm.php(1031): CRM_Event_Form_Registration->confirmPostProcess("230190", Object(CRM_Contribute_BAO_Contribution), Object(CRM_Core_Payment_PayflowPro))
      #30 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Event_Form_Registration_Confirm->postProcess()
      #31 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
      #32 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Event_Form_Registration_Confirm), "next", "Next")
      #33 /home/www/mysite/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Event_Form_Registration_Confirm), "next")
      #34 /home/www/mysite/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Registration_Confirm), "next")
      #35 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("next")
      #36 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(292): CRM_Core_Controller->run((Array:3), NULL)
      #37 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:15))
      #38 /home/www/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
      #39 /home/www/mysite/sites/all/modules/civicrm/drupal/civicrm.module(354): CRM_Core_Invoke::invoke((Array:3))
      #40 [internal function](): civicrm_invoke("event", "register")
      #41 /home/www/mysite/includes/menu.inc(350): call_user_func_array("civicrm_invoke", (Array:2))
      #42 /home/www/mysite/index.php(19): menu_execute_active_handler()
      #43

      {main}

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sivaunq@gmail.com Siv
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: