• Thirunarayanan Balathandayuthapani's avatar
    MDEV-22890 DEADLOCK of threads detected: row0sel.cc S-LOCK / btr0cur.cc S-LOCK... · 194a720e
    Thirunarayanan Balathandayuthapani authored
    MDEV-22890 DEADLOCK of threads detected: row0sel.cc S-LOCK / btr0cur.cc S-LOCK / row0quiesce.cc X-LOCK
    
    Problem:
    =======
    - Read operations are always allowed to hold a secondary index leaf
    latch and then look up the corresponding clustered index record.
    Flush table operation acquires secondary index latch while holding
    a clustered index latch. It leads to deadlock violation.
    
    Fix:
    ====
    - Flush table operation should acquire secondary index before taking
    clustered index to avoid deadlock violation with select operation.
    194a720e
dict0dict.ic 44.8 KB