• Aditya A's avatar
    Bug #32032897 DEADLOCKING WAIT GRAPH ON BUSY SERVER · 72432ec7
    Aditya A authored
    PROBLEM
    -------
    
    1. The customer had presented a stack which had many threads waiting on
       multiple mutexes like LOCK_Status, srv_innodb_monitor_mutex,  ibuf_mutex etc.
    2. The root cause was that the AHI latch was held in S (shared) mode by the a thread which was
       doing a truncate of a large table .
    3. There was another thread which was trying to acquire the AHI latch in X (exclusive) mode
    4. With our lock implementation any thread requesting a X lock ,blocks rest of the threads
       requesting S(shared) locks,this caused many threads to wait for this shared lock.
    5. The main reason why we hold the latches in truncate is to avoid disabling of AHI
       during truncate
    
    FIX
    72432ec7
fil0fil.cc 158 KB