• Marko Mäkelä's avatar
    MDEV-22889: Disable innodb.innodb_force_recovery_rollback · 2cd6afb0
    Marko Mäkelä authored
    The test case that was added for MDEV-21217
    (commit b68f1d84)
    should have only two possible outcomes for the locking SELECT statement:
    
    (1) The statement is blocked, and the test will eventually fail
    with a lock wait timeout. This is what I observed when the
    code fix for MDEV-21217 was missing.
    
    (2) The lock conflict will ensure that the statement will execute
    after the rollback has completed, and an empty table will be observed.
    This is the expected outcome with the recovery fix.
    
    What occasionally happens (in some of our CI environments only, so far)
    is that the locking SELECT will return all 1,000 rows of the table that
    had been inserted by the transaction that was never supposed to be
    committed. One possibility is that the transaction was unexpectedly
    committed when the server was killed.
    
    Let us disable the test until the reason of the failure has been
    determined and addressed.
    2cd6afb0
disabled.def 558 Bytes