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

Deadlock error on building ACL cache (big DB)

          Details

          • Type: Patch
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 3.3.5
          • Fix Version/s: 3.4.alpha
          • Component/s: Core CiviCRM
          • Labels:
            None

            Description

            We were hitting a deadlock error trying to replace Into civicrm_acl_contact_cache.

            Based on this

            http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-transa

            I tried adding an ORDER BY & the problem went away - patch attached

              Attachments

                Activity

                  People

                  • Assignee:
                    kiran.jagtap Kiran Jagtap
                    Reporter:
                    eileen Eileen McNaughton
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: