Questions tagged [deadlocks]
The deadlocks tag has no usage guidance.
5 questions
0
votes
0
answers
34
views
Retrying after Database deadlock encountered hit on attempt 1 at query : INSERT INTO civicrm_mailing_recipients?
Drupal 10.2.3 , CiviCRM 5.70.0, PHP 8.2.13, MySQL: 10.6.16-MariaDB-0ubuntu0.22.04.1, nginx/1.18.0
Got the below in logs after almost each contribution (contributions status="Completed" ) :
...
- 2,186
3
votes
2
answers
103
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
52
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
214
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,457
6
votes
1
answer
91
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 ...
- 2,054