عرض عملي: فخ سجل التدقيق مع REQUIRES_NEW

خطوة بخطوة

1. An OrderService.place calls AuditService.log annotated REQUIRES_NEW so the audit row survives order failure.
2. Show it works: order fails, audit row persists.
3. Set pool size to 2 and run 5 concurrent requests: each holds one connection and waits for a second; threads time out (pool deadlock).
4. Planned mistake: call the audit method from within the same class; no new transaction starts (proxy bypass). Fix: move it to another bean.
5. Fix the pool problem: record audit events after commit (@TransactionalEventListener(AFTER_COMMIT) or an outbox table) instead of nesting.

اختبر فهمك