API tools faq
paste
Guest User

Untitled

a guest
Jun 8th, 2017
37
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.17 KB | None | 0 0
raw download clone embed print report
  1. Jun 07 21:50:41 [info] $Fatal Error Details = Array
  2. (
  3. [callback] => Array
  4. (
  5. [0] => CRM_Core_Error
  6. [1] => handle
  7. )
  8.  
  9. [code] => -1
  10. [message] => DB Error: unknown error
  11. [mode] => 16
  12. [debug_info] => INSERT INTO dedupe (id1, weight)
  13. SELECT contact.id as id1, 10 as weight
  14. FROM civicrm_contact as contact
  15. JOIN civicrm_email as email ON email.contact_id=contact.id
  16. WHERE contact_type = 'Individual'
  17. AND email = 'lindynduff@hotmail.com' GROUP BY id1 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1205 ** Lock wait timeout exceeded; try restarting transaction]
  18. [type] => DB_Error
  19. [user_info] => INSERT INTO dedupe (id1, weight)
  20. SELECT contact.id as id1, 10 as weight
  21. FROM civicrm_contact as contact
  22. JOIN civicrm_email as email ON email.contact_id=contact.id
  23. WHERE contact_type = 'Individual'
  24. AND email = 'lindynduff@hotmail.com' GROUP BY id1 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1205 ** Lock wait timeout exceeded; try restarting transaction]
  25. [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, weight)
  26. SELECT contact.id as id1, 10 as weight
  27. FROM civicrm_contact as contact
  28. JOIN civicrm_email as email ON email.contact_id=contact.id
  29. WHERE contact_type = 'Individual'
  30. AND email = 'lindynduff@hotmail.com' GROUP BY id1 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [nativecode=1205 ** Lock wait timeout exceeded; try restarting transaction]"]
  31. )
  32.  
  33. Jun 07 21:50:41 [info] $backTrace = #0 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Error.php(229): CRM_Core_Error::backtrace("backTrace", TRUE)
  34. #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  35. #2 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
  36. #3 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  37. #4 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  38. #5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, NULL, NULL, "INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...", "DB_Error", TRUE)
  39. #6 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
  40. #7 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->__call("raiseError", (Array:7))
  41. #8 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...", "DB_Error", TRUE)
  42. #9 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-1, NULL, NULL, NULL, "1205 ** Lock wait timeout exceeded; try restarting transaction")
  43. #10 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
  44. #11 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  45. #12 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common->query("INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  46. #13 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/DB/DataObject.php(1627): DB_DataObject->_query("INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  47. #14 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/DAO.php(354): DB_DataObject->query("INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  48. #15 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Dedupe/BAO/RuleGroup.php(269): CRM_Core_DAO->query("INSERT INTO dedupe (id1, weight) \n SELECT contact.id as id1, ...")
  49. #16 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Dedupe/Finder.php(149): CRM_Dedupe_BAO_RuleGroup->fillTable()
  50. #17 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Profile/Form.php(949): CRM_Dedupe_Finder::dupesByParams((Array:5), "Individual", "Unsupervised", (Array:0), NULL)
  51. #18 [internal function](): CRM_Profile_Form::formRule((Array:10), (Array:0), Object(CRM_Profile_Form_Edit))
  52. #19 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/HTML/QuickForm.php(1594): call_user_func((Array:2), (Array:10), (Array:0), Object(CRM_Profile_Form_Edit))
  53. #20 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Form.php(501): HTML_QuickForm->validate()
  54. #21 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Profile/Form/Edit.php(334): CRM_Core_Form->validate()
  55. #22 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/StateMachine.php(142): CRM_Profile_Form_Edit->validate()
  56. #23 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Profile_Form_Edit), "next", "Next")
  57. #24 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Profile_Form_Edit), "next")
  58. #25 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Profile_Form_Edit), "next")
  59. #26 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("next")
  60. #27 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
  61. #28 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Profile/Page/Router.php(118): CRM_Utils_Wrapper->run("CRM_Profile_Form_Edit", "Create Profile", (Array:2))
  62. #29 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(310): CRM_Profile_Page_Router->run((Array:3), NULL)
  63. #30 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
  64. #31 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
  65. #32 /home/vhosts/brennancenter.org/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
  66. #33 [internal function](): civicrm_invoke("profile", "create")
  67. #34 /home/vhosts/brennancenter.org/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
  68. #35 /home/vhosts/brennancenter.org/index.php(21): menu_execute_active_handler()
  69. #36 {main}
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!