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 https://github.com/discourse/discourse-activity-pub/pull/203

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: https://github.com/discourse/discourse-activity-pub/pull/204

로그에서 데드락 오류가 발생합니다

제품 지원

angus (Angus McLeod) 3월 27, 2025, 6:37오후 5

알겠습니다. 이 변경 사항과 이전 변경 사항이 함께 적용되면 문제가 해결될 것으로 보입니다:

글		댓글	조회수
2 emails rejected by 2026.4.0-latest ( 5f0d95e1f1 ) Self-hosting mail-receiver	4	203	4월 15, 2026
[2.4.0beta9] ActiveRecord::Deadlocked (PG::TRDeadlockDetected: ERROR: deadlock detected) Product Support	3	1697	12월 24, 2019
'Updating Last Seen' and 'hijack topics timings' and 'Track Visit' is still running after 90 seconds Product Support	11	1152	10월 9, 2024
Load average ×2 since last upgrade Bug activitypub	5	367	12월 22, 2025
Remapping fails due to deadlock Product Support	7	598	11월 25, 2020

로그에서 데드락 오류가 발생합니다

Related topics