• Marko Mäkelä's avatar
    MDEV-13606 XA PREPARE transactions should survive innodb_force_recovery=1 or 2 · b8b3ba63
    Marko Mäkelä authored
    When MySQL 5.0.3 introduced InnoDB support for two-phase commit,
    it also introduced the questionable logic to roll back XA PREPARE
    transactions on startup when innodb_force_recovery is 1 or 2.
    
    Remove this logic in order to avoid unwanted side effects when
    innodb_force_recovery is being set for other reasons. That is,
    XA PREPARE transactions will always remain in that state until
    InnoDB receives an explicit XA ROLLBACK or XA COMMIT request
    from the upper layer.
    
    At the time the logic was introduced in MySQL 5.0.3, there already
    was a startup parameter that is the preferred way of achieving
    the behaviour: --tc-heuristic-recover=ROLLBACK.
    b8b3ba63
xa_recovery.result 336 Bytes