error when running multiple imports

This is an interesting error. I was running three different processes doing bulk contact imports using FF, Chrome and Safari simultaneously. I think my computer was disk bound because the speed was increasing some but still the CPU usage was below 25% (on a 4 core Mac).

backTrace

#0 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#4 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#5 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...", "DB_Error", TRUE)
#6 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1213 ** Deadlock found when trying to get lock; try restarting transaction")
#7 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#9 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_...")
#10 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->query("INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is...")
#11 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/DAO.php(275): DB_DataObject->insert()
#12 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/BAO/Address.php(162): CRM_Core_DAO->save()
#13 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/BAO/Address.php(126): CRM_Core_BAO_Address::add((Array:18), TRUE)
#14 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(69): CRM_Core_BAO_Address::create((Array:25), TRUE, NULL)
#15 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(352): CRM_Core_BAO_Location::create((Array:25), TRUE)
#16 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(1775): CRM_Contact_BAO_Contact::create((Array:25))
#17 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php(1660): CRM_Contact_BAO_Contact::createProfileContact((Array:41), (Array:34), NULL, NULL, NULL, "Individual")
#18 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/Import/Parser/Contact.php(680): CRM_Contact_Import_Parser_Contact->createContact((Array:41), (Array:34), "16", NULL, TRUE, "")
#19 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/Import/Parser.php(208): CRM_Contact_Import_Parser_Contact->import("16", (Array:132), NULL)
#20 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/Import/ImportJob.php(276): CRM_Contact_Import_Parser->run("civicrm_import_job_343e41368a960198ada86450a60f378c", (Array:129), 8, 1, "_id", "_status", "16", "d323577f2ede1a6c0190d98b79401a73", 30000, NULL, 30, "", "")
#21 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Contact/Import/Form/Preview.php(282): CRM_Contact_Import_ImportJob->runImport(Object(CRM_Contact_Import_Form_Preview))
#22 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Form.php(261): CRM_Contact_Import_Form_Preview->postProcess()
#23 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#24 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Import_Form_Preview), "next", "Next")
#25 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Import_Form_Preview), "next")
#26 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Import_Form_Preview), "next")
#27 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("next")
#28 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Core_Controller->run((Array:3), NULL)
#29 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#30 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#31 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/sites/all/modules/civicrm/drupal/civicrm.module(439): CRM_Core_Invoke::invoke((Array:3))
#32 [internal function](): civicrm_invoke("import", "contact")
#33 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#34 /Users/josephmurray/GoogleDrive/Sites/campaigntool/html/pj.campaigntool.ca/index.php(21): menu_execute_active_handler()
#35

Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Error Details
Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_name , street_type , street_unit , city , state_province_id , postal_code , country_id , manual_geo_code ) VALUES ( 227378 , 1 , 1 , 0 , '2097 Rennie Pl' , 2097 , NULL , 'Rennie Pl' , 'Pl' , NULL , 'Sidney' , 1101 , 'V8L 4J7' , 1039 , 0 ) [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_name , street_type , street_unit , city , state_province_id , postal_code , country_id , manual_geo_code ) VALUES ( 227378 , 1 , 1 , 0 , '2097 Rennie Pl' , 2097 , NULL , 'Rennie Pl' , 'Pl' , NULL , 'Sidney' , 1101 , 'V8L 4J7' , 1039 , 0 ) [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_address (contact_id , location_type_id , is_primary , is_billing , street_address , street_number , street_number_suffix , street_name , street_type , street_unit , city , state_province_id , postal_code , country_id , manual_geo_code ) VALUES ( 227378 , 1 , 1 , 0 , '2097 Rennie Pl' , 2097 , NULL , 'Rennie Pl' , 'Pl' , NULL , 'Sidney' , 1101 , 'V8L 4J7' , 1039 , 0 ) [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)
Return to home page.