Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [deadlocks]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 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" ) : ...
yurg's user avatar
  • 2,050
3 votes
2 answers
99 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 = ...
joegl's user avatar
  • 311
1 vote
1 answer
48 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
Ajay Thakur's user avatar
2 votes
0 answers
207 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 ...
Christia's user avatar
  • 2,457
5 votes
1 answer
84 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 ...
Andrew West's user avatar
  • 2,044