Pattern
Shared Lock Contention
shared-lock-contention
Shared mutable state guarded by a single lock causes threads/tasks to serialize—despite expected concurrency—leading to deadlocks, stalls, or ineffective async locking when MySQL/Redis/Python primitives contend on the same critical sections.