CiviCRM Community Forums (archive)

hey sean:

1. do u have any idea of what operations u did that caused the above. Any chance you can take a look thru the access logs to see the various dedupe / merges that took place. Can u try to recreate on a copy of the database

2. seems like one or more of the 38 dedupe merges caused the issue. So we can potentially try to recreate it and see what merge(s) caused the mass deletion

3. if u have a sizable install, a shared hosting provider is definitely not recommeded

Would be good for you to investigate this a bit more and figure out what happened and why. We'd be happy to help and assist and narrow down the issue.


lobo

After a lot of research I am finally figured out how to reproduce this issue!!!! First off, I'll cut straight to an important point which is that taking the reproduction steps on a 3.0.0 installation does NOT appear to cause the same data loss. Nevertheless, here are the steps to reproduce the process on a 2.2.0 installation. This will pretty much delete the vast majority of your phone numbers, email address, and mailing addresses...

    * go to a de-dupe/merge screen that presents a list of contacts to be merged
    * click the merge link to open in a NEW TAB
    * check all boxes and press the merge button
    * go back to the list of contacts to be merged and click the SAME merge hyperlink
    * observe that a table with now rows is presented to the user as the contacts to merge
    * click the link to flip between contacts
    * observe now that the right side of the merge screen does not have any information (we're merging info INTO a contact that DOESN'T EXIST)
    * check all boxes
    * press the merge button
    * observe that Civi spits out nasty error message, which also appears in the Civi log file as as indicated at the end of this post
    * observe that the number of rows in the following tables have been drastically reduced: civicrm_address, civicrm_email, civicrm_phone


Here is the error message
Oct 01 11:27:53  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [c0de] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => UPDATE IGNORE civicrm_activity SET source_contact_id = 0 WHERE source_contact_id = 1242 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`bnb_crm_civi/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => UPDATE IGNORE civicrm_activity SET source_contact_id = 0 WHERE source_contact_id = 1242 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`bnb_crm_civi/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE IGNORE civicrm_activity SET source_contact_id = 0 WHERE source_contact_id = 1242 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`bnb_crm_civi/civicrm_activity`, CONSTRAINT `FK_civicrm_activity_source_contact_id` FOREIGN KEY (`source_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)


Oct 01 11:27:53  [info] $backTrace = /home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/Error.php, backtrace, 192
, handle,
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/PEAR.php, call_user_func, 912
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB.php, PEAR_Error, 966
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/PEAR.php, DB_Error, 574
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/common.php, raiseError, 1903
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/mysql.php, raiseError, 898
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/mysql.php, mysqlRaiseError, 327
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/common.php, simpleQuery, 1216
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/DataObject.php, query, 2394
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/DB/DataObject.php, _query, 1587
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/DAO.php, query, 144
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/DAO.php, query, 861
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Dedupe/Merger.php, executeQuery, 259
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Contact/Form/Merge.php, moveContactBelongings, 407
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/Form.php, postProcess, 247
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/StateMachine.php, mainProcess, 166
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/HTML/QuickForm/Controller.php, perform, 203
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/packages/HTML/QuickForm/Page.php, handle, 103
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/Controller.php, handle, 245
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Utils/Wrapper.php, run, 114
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/CRM/Core/Invoke.php, run, 177
/home/.tertia/bnbftp/crm.bikesnotbombs.org/civicrm-2.2.0-drupal/drupal/civicrm.module, invoke, 339
, civicrm_invoke,
/home/.tertia/bnbftp/crm.bikesnotbombs.org/drupal-6.9/includes/menu.inc, call_user_func_array, 348
/home/.tertia/bnbftp/crm.bikesnotbombs.org/drupal-6.9/index.php, menu_execute_active_handler, 18