Questions tagged [deadlocks]
The deadlocks tag has no usage guidance.
5
questions
0
votes
0
answers
14
views
Scheduled reminder with multiple activity types causes database deadlock
I set up a scheduled reminder on activity with multiple activity types selected. The dropdown allows this, and it seemed intuitive. Should this work? The result was database deadlock.
Error array in ...
- 1,218
3
votes
2
answers
66
views
Update DB Query fails sporadically when saving contact; nativecode=1205 ** Lock wait timeout exceeded
The exact query and issue is below.
UPDATE civicrm_contact SET contact_type = 'Individual' , contact_sub_type
= NULL , sort_name = 'XXXXXX XXXXXX' , display_name = 'XXXXXX XXXXXX'
, first_name = ...
- 311
1
vote
1
answer
40
views
CiviMail Deadlock Issue
I am facing deadlock on civicrm_acl_cache.
I am sending email to 400,000 users.
Many times, deadlock occur and due to system lock website goes down.
Need help from team
- 11
2
votes
0
answers
145
views
Deadlock when executing job to clear group cache
We have had issues where we can't send a mailing. Trying to send a test mailing gets stuck on "saving".
I attempted to run the job to flush the smart group cache and the job log reports that it ...
- 2,436
5
votes
1
answer
75
views
Deadlocked queries cause an instant error for end-users, but are retried in other circumstances
We have a lot of smart groups, and consequently a lot of deadlocks. There's already code in Civi that detects deadlock Exceptions, and then retries the query a few times. This is really helpful - I ...
- 1,960