Job exception: PG::TRDeadlockDetected: ERROR: deadlock detected DETAIL: Process 29659 waits for ShareLock on transaction 892416679; blocked by process 29650. Process 29650 waits for ShareLock on transaction 892416541; blocked by process 29659. HINT: See server log for query details. CONTEXT: whi…

This should address it FIX: Delivery tracker thread lock main ← angusmcleod:delivery_tracker_thread_lock merged 03:48PM - 27 Mar 25 UTC (UTC) [صورة] …

Hmm, that doesn’t seem to fix the issue unfortunately @angus . There’s a lot of actors, possibly, in the DB, and the batching is still insufficient. On meta, for example, there are 90k+ rows in that model: discourse(prod)> DiscourseActivityPubActor.where(domain: 'mastodon.social').size => 90264 Do…

I see. Hopefully this, together with the previous changes, will address it: FIX: only update actors to available if they are unavailable main ← angusmcleod:delivery_tracker_fix_2 merged 07:14PM - 2…

ظهور أخطاء deadlock في السجلات

الدعم

angus (Angus McLeod) 27 مارس 2025، 6:37م 5

أتفهم. آمل أن يعالج هذا، جنبًا إلى جنب مع التغييرات السابقة، الأمر:

إعجاب واحد (1)

الموضوع		الردود	مرات العرض
[2.4.0beta9] ActiveRecord::Deadlocked (PG::TRDeadlockDetected: ERROR: deadlock detected) Support	4	1637	18 أكتوبر 2023
'Updating Last Seen' and 'hijack topics timings' and 'Track Visit' is still running after 90 seconds Support	11	977	9 أكتوبر 2024
Load average ×2 since last upgrade Bug activitypub	6	166	26 فبراير 2026
Remapping fails due to deadlock Support	8	518	25 ديسمبر 2020
Very slow Sidekiq issue with large queue due to massive numbers of unread user notifications Self-hosting	69	7459	11 مايو 2020

ظهور أخطاء deadlock في السجلات

الموضوعات ذات الصلة