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

                [CRM-7700] Deadlock error on building ACL cache (big DB)
                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Kiran Jagtap
                    Reporter:
                    Eileen McNaughton

                    Dates

                    • Created:
                      Updated:
                      Resolved: