• Sachin Setiya's avatar
    MDEV-12398 All cluster nodes stop due to a foreign key constraint failure · e333d829
    Sachin Setiya authored
    Comment from Codership:-
    To fix the problem, we changed the certification logic in galera to treat insert
    on child table row as exclusive to prevent any operation on referenced
    parent table row. At the same time, update and delete on
     child table row were demoted to "shared", which makes it possible to
    update/delete referenced parent table row, but only in a later transaction.
     This change allows somewhat more concurrency for foreign key constrained
     transactions, but is still safe for correct certification end result.
    e333d829
MW-369.test 6.9 KB