• sjaakola's avatar
    MDEV-25551 applying crash with tables without PK · e2124156
    sjaakola authored
    The underlying problem with MDEV-25551 turned out to be that
    transactions having changes for tables with no primary key,
    were not safe to apply in parallel. This is due to excessive locking
    in innodb side, and even non related row modifications could end up
    in lock conflict during applying.
    
    The fix for MDEV-25551 has disabled parallel applying for tables with no PK.
    This fix depends on change for wsrep-lib, where a separate PR allows
    application to modify transaction flags in wsrep-lib.
    
    This commit has also separate mtr test for verifying that transactions
    modifying a table with no primary key, will not apply in parallel.
    This test is a modified version of initial test created by Gabor Orosz,
    the reporterr of MDEV-25551.
    Another mtr test was added in galera_sr suite, for testing if modifying
    tables with no primary key would causes issues for streaming replication
    use cases.
    Reviewed-by: default avatarJan Lindström <jan.lindstrom@mariadb.com>
    e2124156
handler.cc 236 KB