Page MenuHomePhabricator

Coworker fail - not getting unique temp table name
Open, Needs TriagePublic

Description

Queue item from batch_merge with id=6887105 failed with exception="DB Error: already exists", aborted and moved to the dedicated damaged queue

DB Error: already exists CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB  [nativecode=1050 ** Table 'civicrm_tmp_d_dflt_dflt' already exists]  
#0 /srv/org.wikimedia.civicrm/vendor/pear/db/DB.php(1000): PEAR_Error->__construct("DB Error: already exists", -5, 16, (Array:2), "CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB  [nativecod...") 
#1 /srv/org.wikimedia.civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(577): DB_Error->__construct(-5, 16, (Array:2), "CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB  [nativecod...") 
#2 /srv/org.wikimedia.civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(225): PEAR::_raiseError(Object(DB_civirpow), NULL, -5, 16, (Array:2), "CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB  [nativecod...", "DB_Error", TRUE) 
#3 /srv/org.wikimedia.civicrm/vendor/pear/db/DB/common.php(1950): PEAR->__call("raiseError", (Array:7)) #4 /srv/org.wikimedia.civicrm/vendor/pear/db/DB/mysqli.php(991): DB_common->raiseError(-5, NULL, NULL, "CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB  [nativecod...", "1050 ** Table 'civicrm_tmp_d_dflt_dflt' already exists")
 #5 /srv/org.wikimedia.civicrm/vendor/pear/db/DB/mysqli.php(440): DB_mysqli->mysqliRaiseError()
 #6 /srv/org.wikimedia.civicrm/ext/rpow/DB/civirpow.php(75): DB_mysqli->simpleQuery("/* User : unknown PID : 129204 */CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id i...")
 #7 /srv/org.wikimedia.civicrm/vendor/pear/db/DB/common.php(1240): DB_civirpow->simpleQuery("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ")
 #8 /srv/org.wikimedia.civicrm/core/packages/DB/DataObject.php(2696): DB_common->query("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ") 
#9 /srv/org.wikimedia.civicrm/core/packages/DB/DataObject.php(1829): DB_DataObject->_query("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ") 
#10 /srv/org.wikimedia.civicrm/core/CRM/Core/DAO.php(598): DB_DataObject->query("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ") 
#11 /srv/org.wikimedia.civicrm/core/CRM/Core/DAO.php(1862): CRM_Core_DAO->query("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ", FALSE) #12 /srv/org.wikimedia.civicrm/core/CRM/Utils/SQL/TempTable.php(171): CRM_Core_DAO::executeQuery("CREATE TABLE `civicrm_tmp_d_dflt_dflt` (id int(10)) ENGINE=InnoDB ", (Array:0), TRUE, NULL, TRUE, FALSE) #13 /srv/org.wikimedia.civicrm/core/CRM/Dedupe/Finder.php(68): CRM_Utils_SQL_TempTable->createWithColumns("id int(10)") 
#14 /srv/org.wikimedia.civicrm/core/CRM/Dedupe/Finder.php(54): CRM_Dedupe_Finder::getIdTable((Array:101))

Details

Related Changes in Gerrit:

Event Timeline

Change #1214204 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix merge failing on db error

https://gerrit.wikimedia.org/r/1214204

Change #1214204 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix merge failing on db error

https://gerrit.wikimedia.org/r/1214204