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

merge tags function hangs with unique index conflict

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.8, 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      when we merge tags, we cycle through a series of sql statements (CRM_Core_BAO_EntityTag::mergeTags())

      the first statement updates all entities assigned to tag A to be assigned to tag B
      however – we have a unique index constraint on entity_table, entity_id, tag_id. if a contact is originally tagged with BOTH tag A and B, that first UPDATE statement fails with the index constraint and the merge hangs.

        Attachments

          Activity

            People

            • Assignee:
              pratik.joshi Pratik Joshi
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: